EAS|EAS8.5 打补丁时候SQL执行脚本出现错误

0

错误原因:
执行脚本出现错误,请仔细分析[解决方案]中的错误信息,并试图获取具体的错误原因。

解决方案:
请将如下错误信息提单反馈:
[Execute provider[./sql/fdc_repm_0400_table.sql], sql[IF NOT EXISTS (SELECT 1 FROM syscolumns syscol left join sysobjects sysobj on syscol.id = sysobj.id left join systypes systype on syscol.xtype=systype.xtype WHERE (SYSCOL.NAME = 'FVersion' AND SYSOBJ.NAME = 'T_AIM_DynCostShare'))
BEGIN
EXEC('ALTER TABLE T_AIM_DynCostShare ADD FVersion DECIMAL (10, 1)')
END
] failed, sqlcode[4902] sqlstat[S1000],Causedby[找不到对象“T_AIM_DynCostShare”,因为它不存在或者您没有所需的权限。],DBType=[MS SqlServer]
]

异常堆栈:
com.kingdee.eas.tools.admin.framework.database.exception.DBSQLProviderException: Execute provider[./sql/fdc_repm_0400_table.sql], sql[IF NOT EXISTS (SELECT 1 FROM syscolumns syscol left join sysobjects sysobj on syscol.id = sysobj.id left join systypes systype on syscol.xtype=systype.xtype WHERE (SYSCOL.NAME = 'FVersion' AND SYSOBJ.NAME = 'T_AIM_DynCostShare'))
BEGIN
EXEC('ALTER TABLE T_AIM_DynCostShare ADD FVersion DECIMAL (10, 1)')
END
] failed, sqlcode[4902] sqlstat[S1000],Causedby[找不到对象“T_AIM_DynCostShare”,因为它不存在或者您没有所需的权限。],DBType=[MS SqlServer]

        at com.kingdee.eas.tools.admin.domain.impl.PatchManagerServiceImpl.upgradeEASDatacenter(PatchManagerServiceImpl.java:3309)
        at com.kingdee.eas.tools.admin.domain.impl.PatchManagerServiceImpl.processPatchScript(PatchManagerServiceImpl.java:9189)
        at com.kingdee.eas.tools.admin.domain.impl.PatchManagerServiceImpl.runAllInstalledPatchScripts(PatchManagerServiceImpl.java:9158)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at com.kingdee.eas.tools.admin.framework.ssap.dualrpc.SSAPServerRPCHandler.invokeService(SSAPServerRPCHandler.java:46)
        at sun.reflect.GeneratedMethodAccessor11.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        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)