s-HR8.5 新建数据中心报执行脚本错误，哪位大佬知道？

栏目：s-hr cloud知识作者：金蝶来源：金蝶云社区发布：2024-09-16浏览：1

错误日志如下：
错误原因：
异常信息

解决方案：
请将如下错误信息提单反馈
[com.kingdee.eas.tools.admin.domain.DomainException: Upgrade datacenter error, dcNum=
cause by java.lang.Exception: com.kingdee.eas.tools.admin.domain.DomainException: Upgrade data error, subSystemName=eas-fi-fi_cas
cause by com.kingdee.eas.tools.admin.framework.database.exception.DBSQLProviderException: Execute provider[./eas/8_2_0to8_5_0/./8_5_0_feature/./eas/./fi/./fi_cas/.\EAS8.5.0-bs_vc_update_data.ksql], sql[UPDATE T_VC_VCRESULT SET FCurrencyID = tab2.FCurrencyID, FAccountBankID = tab2.FAccountBankID, FCompanyID = tab2.FCompanyID, FVoucherTypeID = tab2.FVoucherTypeID, FSettleTypeID = tab2.FSettleTypeID FROM T_CAS_BANKSTATEMENT tab2 WHERE FBIZOBJECTID = Fid AND (FBIZOBJECTFULLNAME = 'com.kingdee.eas.fi.cas.app.BankStatement' AND (FCurrencyID IS NULL))] failed, sqlcode[209] sqlstat[S1000],Causedby[列名 'Fid' 不明确。]--------------------------------------------Execute provider[./eas/8_2_0to8_5_0/./8_5_0_feature/./eas/./fi/./fi_cas/.\EAS8.5.0-bs_vc_update_data.ksql], sql[UPDATE T_VC_VCRESULT SET FCurrencyID = tab2.FCurrencyID, FAccountBankID = tab2.FAccountBankID, FCompanyID = tab2.FCompanyID, FVoucherTypeID = tab2.FVoucherTypeID, FSettleTypeID = tab2.FSettleTypeID FROM T_CAS_Journal tab2 WHERE FBIZOBJECTID = Fid AND (FBIZOBJECTFULLNAME = 'com.kingdee.eas.fi.cas.app.Journal' AND (FCurrencyID IS NULL))] failed, sqlcode[209] sqlstat[S1000],Causedby[列名 'Fid' 不明确。]--------------------------------------------Execute provider[./eas/8_2_0to8_5_0/./8_5_0_feature/./eas/./fi/./fi_cas/.\EAS8.5.0-bs_vc_update_data.ksql], sql[UPDATE T_VC_VCRESULT SET FBizDate = tab2.FBizDate, FCreateDate = tab2.FCreateDate, FCreditAmount = tab2.FCreditAmount, FDebitAmount = tab2.FDebitAmount, FDescription = tab2.FDescription, FBillNumber = tab2.FBillNumber, FVoucherNumber = tab2.FVoucherNumber, FSettleNumber = tab2.FSettleNumber, FBillType = tab2.FBillType FROM T_CAS_BANKSTATEMENT tab2 WHERE FBIZOBJECTID = Fid AND (FBIZOBJECTFULLNAME = 'com.kingdee.eas.fi.cas.app.BankStatement' AND (FCreateDate IS NULL))] failed, sqlcode[209] sqlstat[S1000],Causedby[列名 'Fid' 不明确。]--------------------------------------------Execute provider[./eas/8_2_0to8_5_0/./8_5_0_feature/./eas/./fi/./fi_cas/.\EAS8.5.0-bs_vc_update_data.ksql], sql[UPDATE T_VC_VCRESULT SET FBizDate = tab2.FBizDate, FCreateDate = tab2.FCreateDate, FCreditAmount = tab2.FCreditAmount, FDebitAmount = tab2.FDebitAmount, FDescription = tab2.FDescription, FBillNumber = tab2.FBillNumber, FVoucherNumber = tab2.FVoucherNumber, FSettleNumber = tab2.FSettleNumber, FBillType = tab2.FBillType FROM T_CAS_Journal tab2 WHERE FBIZOBJECTID = Fid AND (FBIZOBJECTFULLNAME = 'com.kingdee.eas.fi.cas.app.Journal' AND (FCreateDate IS NULL))] failed, sqlcode[209] sqlstat[S1000],Causedby[列名 'Fid' 不明确。]--------------------------------------------
at com.kingdee.eas.tools.admin.framework.database.impl.AbstractDB.execute(AbstractDB.java:901)
at com.kingdee.eas.tools.admin.domain.upgrade.UpdateDCParser.run(UpdateDCParser.java:659)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.updateDataCenter(DataCenterServiceImpl.java:4145)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.upgradeDataCenter(DataCenterServiceImpl.java:3527)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.createNewDataCenter(DataCenterServiceImpl.java:2248)
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.GeneratedMethodAccessor29.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)

at com.kingdee.eas.tools.admin.domain.upgrade.UpdateDCParser.run(UpdateDCParser.java:663)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.updateDataCenter(DataCenterServiceImpl.java:4145)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.upgradeDataCenter(DataCenterServiceImpl.java:3527)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.createNewDataCenter(DataCenterServiceImpl.java:2248)
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.GeneratedMethodAccessor29.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)

at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.upgradeDataCenter(DataCenterServiceImpl.java:3543)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.createNewDataCenter(DataCenterServiceImpl.java:2248)
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.GeneratedMethodAccessor29.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)

at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.upgradeDataCenter(DataCenterServiceImpl.java:3544)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.createNewDataCenter(DataCenterServiceImpl.java:2248)
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.GeneratedMethodAccessor29.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)
]

异常堆栈：
com.kingdee.eas.tools.admin.domain.DomainException: Upgrade datacenter error, dcNum=
cause by java.lang.Exception: com.kingdee.eas.tools.admin.domain.DomainException: Upgrade data error, subSystemName=eas-fi-fi_cas
cause by com.kingdee.eas.tools.admin.framework.database.exception.DBSQLProviderException: Execute provider[./eas/8_2_0to8_5_0/./8_5_0_feature/./eas/./fi/./fi_cas/.\EAS8.5.0-bs_vc_update_data.ksql], sql[UPDATE T_VC_VCRESULT SET FCurrencyID = tab2.FCurrencyID, FAccountBankID = tab2.FAccountBankID, FCompanyID = tab2.FCompanyID, FVoucherTypeID = tab2.FVoucherTypeID, FSettleTypeID = tab2.FSettleTypeID FROM T_CAS_BANKSTATEMENT tab2 WHERE FBIZOBJECTID = Fid AND (FBIZOBJECTFULLNAME = 'com.kingdee.eas.fi.cas.app.BankStatement' AND (FCurrencyID IS NULL))] failed, sqlcode[209] sqlstat[S1000],Causedby[列名 'Fid' 不明确。]--------------------------------------------Execute provider[./eas/8_2_0to8_5_0/./8_5_0_feature/./eas/./fi/./fi_cas/.\EAS8.5.0-bs_vc_update_data.ksql], sql[UPDATE T_VC_VCRESULT SET FCurrencyID = tab2.FCurrencyID, FAccountBankID = tab2.FAccountBankID, FCompanyID = tab2.FCompanyID, FVoucherTypeID = tab2.FVoucherTypeID, FSettleTypeID = tab2.FSettleTypeID FROM T_CAS_Journal tab2 WHERE FBIZOBJECTID = Fid AND (FBIZOBJECTFULLNAME = 'com.kingdee.eas.fi.cas.app.Journal' AND (FCurrencyID IS NULL))] failed, sqlcode[209] sqlstat[S1000],Causedby[列名 'Fid' 不明确。]--------------------------------------------Execute provider[./eas/8_2_0to8_5_0/./8_5_0_feature/./eas/./fi/./fi_cas/.\EAS8.5.0-bs_vc_update_data.ksql], sql[UPDATE T_VC_VCRESULT SET FBizDate = tab2.FBizDate, FCreateDate = tab2.FCreateDate, FCreditAmount = tab2.FCreditAmount, FDebitAmount = tab2.FDebitAmount, FDescription = tab2.FDescription, FBillNumber = tab2.FBillNumber, FVoucherNumber = tab2.FVoucherNumber, FSettleNumber = tab2.FSettleNumber, FBillType = tab2.FBillType FROM T_CAS_BANKSTATEMENT tab2 WHERE FBIZOBJECTID = Fid AND (FBIZOBJECTFULLNAME = 'com.kingdee.eas.fi.cas.app.BankStatement' AND (FCreateDate IS NULL))] failed, sqlcode[209] sqlstat[S1000],Causedby[列名 'Fid' 不明确。]--------------------------------------------Execute provider[./eas/8_2_0to8_5_0/./8_5_0_feature/./eas/./fi/./fi_cas/.\EAS8.5.0-bs_vc_update_data.ksql], sql[UPDATE T_VC_VCRESULT SET FBizDate = tab2.FBizDate, FCreateDate = tab2.FCreateDate, FCreditAmount = tab2.FCreditAmount, FDebitAmount = tab2.FDebitAmount, FDescription = tab2.FDescription, FBillNumber = tab2.FBillNumber, FVoucherNumber = tab2.FVoucherNumber, FSettleNumber = tab2.FSettleNumber, FBillType = tab2.FBillType FROM T_CAS_Journal tab2 WHERE FBIZOBJECTID = Fid AND (FBIZOBJECTFULLNAME = 'com.kingdee.eas.fi.cas.app.Journal' AND (FCreateDate IS NULL))] failed, sqlcode[209] sqlstat[S1000],Causedby[列名 'Fid' 不明确。]--------------------------------------------
at com.kingdee.eas.tools.admin.framework.database.impl.AbstractDB.execute(AbstractDB.java:901)
at com.kingdee.eas.tools.admin.domain.upgrade.UpdateDCParser.run(UpdateDCParser.java:659)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.updateDataCenter(DataCenterServiceImpl.java:4145)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.upgradeDataCenter(DataCenterServiceImpl.java:3527)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.createNewDataCenter(DataCenterServiceImpl.java:2248)
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.GeneratedMethodAccessor29.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)