EAS6.0升级到8.0报错
金蝶云社区-云社区用户1kgJ1234
云社区用户1kgJ1234
0人赞赏了该文章 828次浏览 未经作者许可,禁止转载编辑于2015年09月10日 11:50:29

EAS6.0在升级到8.0时报错

错误原因:
执行脚本出现错误,脚本所在路径[C:/Kingdee/eas/server/properties/upgradescript/eas/6_0_1to7_0_1/PTM036507/PT034390_fi_gr_cslrpt_update.sql]

解决方案:
[Execute provider[.\eas\6_0_1to7_0_1\PTM036507\PT034390_fi_gr_cslrpt_update.sql], sql[IF NOT EXISTS (SELECT * FROM sysindexes sysind WHERE NAME = 'UX_CSL_INTCHK')
BEGIN
EXEC('CREATE UNIQUE INDEX UX_CSL_INTCHK ON T_CSL_INTERDATACHECKAGE (FORGUNITID, FNUMBER, FPERIOD, FYEAR, FPERIODTYPE, FORGBOUNDID, FDATACOLLECTNUMBER)')
END
] failed, sqlcode[1505] sqlstat[23000],Causedby[因为发现对象名称 'dbo.T_CSL_InterDataCheckage' 和索引名称 'UX_CSL_INTCHK' 有重复的键,所以 CREATE UNIQUE INDEX 语句终止。重复的键值为 (o0rLEBmCUk6sH2v1RjpNysznrtQ=, 10, 12, 2013, 3, rHHORyqAQfKucGwwWh7oH08oJ/0=, ACTUALDATA)。]]

异常堆栈:
com.kingdee.eas.tools.admin.framework.database.exception.DBSQLProviderException: Execute provider[.\eas\6_0_1to7_0_1\PTM036507\PT034390_fi_gr_cslrpt_update.sql], sql[IF NOT EXISTS (SELECT * FROM sysindexes sysind WHERE NAME = 'UX_CSL_INTCHK')
BEGIN
EXEC('CREATE UNIQUE INDEX UX_CSL_INTCHK ON T_CSL_INTERDATACHECKAGE (FORGUNITID, FNUMBER, FPERIOD, FYEAR, FPERIODTYPE, FORGBOUNDID, FDATACOLLECTNUMBER)')
END
] failed, sqlcode[1505] sqlstat[23000],Causedby[因为发现对象名称 'dbo.T_CSL_InterDataCheckage' 和索引名称 'UX_CSL_INTCHK' 有重复的键,所以 CREATE UNIQUE INDEX 语句终止。重复的键值为 (o0rLEBmCUk6sH2v1RjpNysznrtQ=, 10, 12, 2013, 3, rHHORyqAQfKucGwwWh7oH08oJ/0=, ACTUALDATA)。]
at com.kingdee.eas.tools.admin.framework.database.impl.AbstractDB.execute(AbstractDB.java:628)
at com.kingdee.eas.tools.admin.domain.db.UpdateDCParser.run(UpdateDCParser.java:495)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.updateDataCenter(DataCenterServiceImpl.java:3646)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.upgradeDataCenter(DataCenterServiceImpl.java:3106)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.upgradeDataCenter(DataCenterServiceImpl.java:3290)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:600)
at com.kingdee.eas.tools.admin.framework.ssap.dualrpc.SSAPServerRPCHandler.invokeService(SSAPServerRPCHandler.java:46)
at sun.reflect.GeneratedMethodAccessor7.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:600)
at com.kingdee.eas.tools.admin.framework.dualrpc.core.common.RpcWorker.processRpcCallMessage(RpcWorker.java:237)
at com.kingdee.eas.tools.admin.framework.dualrpc.core.common.RpcWorker.run(RpcWorker.java:81)