升级报错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