EAS8.1创建ORACLE数据中报错
金蝶云社区-戴哲峰
戴哲峰
0人赞赏了该文章 1,028次浏览 未经作者许可,禁止转载编辑于2016年01月27日 09:32:46

错误原因:
执行脚本[./eas/7_5_0to8_0_0/./8_0_0_beta1/./eas/./sem/./csl/./PT087031_sem_csl_addnew.sql]出现错误,脚本所在路径[D:/Kingdee/server/eas/server/properties/upgradescript/eas]

解决方案:
请将如下错误信息提单反馈:
[Execute provider[./eas/7_5_0to8_0_0/./8_0_0_beta1/./eas/./sem/./csl/.\PT087031_sem_csl_addnew.sql], sql[DECLARE CNT PLS_INTEGER;
BEGIN
SELECT COUNT(*) FCOUNT INTO CNT FROM USER_TAB_COLUMNS WHERE (COLUMN_NAME = 'FEXECUTETASKID' AND TABLE_NAME = 'T_CSL_FORMULACALCLOG');
IF CNT = 0 THEN
EXECUTE IMMEDIATE 'ALTER TABLE T_CSL_FormulaCalcLog ADD (FExecuteTaskId VARCHAR2 (36) DEFAULT '''' NOT NULL)';
END IF;
END;] failed, sqlcode[600] sqlstat[60000],Causedby[ORA-00600: 内部错误代码, 参数: [kkdlSetColDTypeDfltProps0], [], [], [], [], [], [], [], [], [], [], []
ORA-06512: 在 line 5
]]

异常堆栈:
com.kingdee.eas.tools.admin.framework.database.exception.DBSQLProviderException: Execute provider[./eas/7_5_0to8_0_0/./8_0_0_beta1/./eas/./sem/./csl/.\PT087031_sem_csl_addnew.sql], sql[DECLARE CNT PLS_INTEGER;
BEGIN
SELECT COUNT(*) FCOUNT INTO CNT FROM USER_TAB_COLUMNS WHERE (COLUMN_NAME = 'FEXECUTETASKID' AND TABLE_NAME = 'T_CSL_FORMULACALCLOG');
IF CNT = 0 THEN
EXECUTE IMMEDIATE 'ALTER TABLE T_CSL_FormulaCalcLog ADD (FExecuteTaskId VARCHAR2 (36) DEFAULT '''' NOT NULL)';
END IF;
END;] failed, sqlcode[600] sqlstat[60000],Causedby[ORA-00600: 内部错误代码, 参数: [kkdlSetColDTypeDfltProps0], [], [], [], [], [], [], [], [], [], [], []
ORA-06512: 在 line 5
]
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:597)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.updateDataCenter(DataCenterServiceImpl.java:3652)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.upgradeDataCenter(DataCenterServiceImpl.java:3106)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.createNewDataCenter(DataCenterServiceImpl.java:1950)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:94)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
at java.lang.reflect.Method.invoke(Method.java:619)
at com.kingdee.eas.tools.admin.framework.ssap.dualrpc.SSAPServerRPCHandler.invokeService(SSAPServerRPCHandler.java:46)
at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
at java.lang.reflect.Method.invoke(Method.java:619)
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)