s-HR8.5 新建数据中心报执行脚本错误，哪位大佬知道？
金蝶s-HR-用户体验
金蝶云社区-不想说再见006
不想说再见006
0人赞赏了该文章 815次浏览 未经作者许可，禁止转载编辑于2020年02月13日 08:41:06


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

解决方案：
请将如下错误信息提单反馈
[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)

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)

推荐阅读

S-HR新建数据中心问题

新建数据中心提示脚本错误，提示的可能错误原因是：1.当前登陆的数据库用户，没有创建新数据库/新用户的权限； 2.数据库对象(表/表空间/视图）等在目标数据库中意 …

    文章

    1,206

EAS s-hr 8.2 新建数据中心报 …

shr2.0升级shr8.2 测试环境搭建了8.2环境 安装了oracle数据库 并且数据库可以正常使用 包括都做了导库也没有遇到问题 在新建数据中心的时候 提 …

    文章

    2,125

S-HR在电脑上装完新建数据中心时报错

图片及错误代码已上传。 自己回复一下，问题已解决，好像是数据库名字出问题了，新建数据库名字改为shr后成功，疑是“-”的问题。 ,数据库名字哪有用中文的;P

    文章

    453