升级报错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, FCanAddFav) VALUES ('6eb91890-1630-4c18-a298-4a4365c6cad2', TO_DATE('2014-05-15 16:12:43', 'YYYY-MM-DD HH24:MI:SS'), 'administrator', TO_DATE('2014-06-10 10:28:53', 'YYYY-MM-DD HH24:MI:SS'), 'administrator', 0, 3, 9, '/2f9ef722-255b-4e4b-8d07-5277e353a321/2b7f4215-aa17-4d89-952e-efc97833cee6/6709d072-8251-489b-a762-1eb4ecd03b5b/6eb91890-1630-4c18-a298-4a4365c6cad2', '6709d072-8251-489b-a762-1eb4ecd03b5b', 'P-140014156301849', '{"zh_CN":"报表共享","en":"报表共享","zh_TW":"报表共享"}', 'EXTERNAL_LINK_G', '{"url":"","externalId":"35BPjXK1d67gQwEAAH/VDRdCz6U=","leaf":false,"target":"WIN"}', NULL, NULL, 'ENABLE', NULL, 1, 1, 'EXT', 'portal_template_user', '{"uiClassParam":"","openMethod":"0","uiOprt":""}', NULL, NULL, 0, 'bbgx', 'baobiaogongxiang', 0, 1)] failed, sqlcode[1] sqlstat[23000],Causedby[ORA-00001: 违反唯一约束条件 (KINGDEE.PK_T_JP_PAGE)
4.修复方案
--查询
select * from T_JP_Page where fid='6eb91890-1630-4c18-a298-4a4365c6cad2'
--备份
select * into bak_2022051101 from T_JP_Page where fid='6eb91890-1630-4c18-a298-4a4365c6cad2'
--删除
delete from T_JP_Page where fid='6eb91890-1630-4c18-a298-4a4365c6cad2'
升级报错Causedby[ORA-01702: 视图不适用于此处
本文2024-09-22 18:26:43发表“eas cloud知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-eas-100813.html