升级报错Causedby[ORA-01702: 视图不适用于此处


1.报错;
[com.kingdee.eas.tools.admin.domain.DomainException: Upgrade datacenter error, dcNum=A01
cause by java.lang.Exception: com.kingdee.eas.tools.admin.domain.DomainException: Upgrade index error, subSystemName=bos-base-account
cause by com.kingdee.eas.tools.admin.framework.database.exception.DBSQLProviderException: Execute provider[./eas/7_5_0to8_0_0/./7_5_0_patch/./bos/./base/./account/.\PT067434_base_account_index.ksql], sql[DECLARE CNT PLS_INTEGER;
BEGIN
SELECT COUNT(*) FCOUNT INTO CNT FROM USER_INDEXES WHERE INDEX_NAME = 'IX_GL_ASSBALGRPACC';
IF CNT = 0 THEN
EXECUTE IMMEDIATE 'CREATE INDEX IX_GL_ASSBALGRPACC ON t_gl_assistbalance (FACCOUNTID, FASSISTGRPID)';
END IF;
END;] failed, sqlcode[1702] sqlstat[42000],Causedby[ORA-01702: 视图不适用于此处
2.修复方案
PT067434 t_gl_assistbalance 此视图不应该创建索引 按照附件里的 脚本替换对应路径下的脚本即可
3.替换完成还有插入数据重复的报错
[com.kingdee.eas.tools.admin.domain.DomainException: Upgrade datacenter error, dcNum=A01
cause by java.lang.Exception: com.kingdee.eas.tools.admin.domain.DomainException: Upgrade data error, subSystemName=eas-sem-pubdata
cause by com.kingdee.eas.tools.admin.framework.database.exception.DBSQLProviderException: Execute provider[./eas/7_5_0to8_0_0/./8_0_0_beta1/./eas/./sem/./csl/.\EAS800_sem_csl_portalmenu.sql], sql[INSERT INTO T_JP_Page (FId, FCreateTime, FCreator, FLastUpdateTime, FLastUpdater, FHidden, FNodeLevel, FNodeOrder, FNodePath, FParentNodeId, FPageNumber, FDisplayName, FNodeType, FNodeExt, FDescription, FSettingInfo, FStatus, FIcon, FPermViewCtrl, FPermEditCtrl, FResLevel, FUserId, FPreferences, FDefaultPageId, FControlParam, FShowPltButton, FFirstSpell, FAllSpell, FCanSearch, FCanAddF
升级报错Causedby[ORA-01702: 视图不适用于此处
声明:除非特别标注,否则均为本站原创文章,转载时请以链接形式注明文章出处。如若本站内容侵犯了原著者的合法权益,可联系本站删除。



