【实施问题】创建数据中心失败-列名 'Fid' 不明确
大家在实施过程中,创建数据中心失败,报错信息为如下信息时候
[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' 不明确。]
处理方式如下:
在EAS服务器升级脚本目录下eas\server\properties\upgradescript\eas\8_2_0to8_5_0\8_5_0_feature\eas\fi\fi_cas\放入附件中的标准脚本文件;然后再新建数据中心或升级对应的数据中心即可
标准脚本在这不让上附件,可以私信我给你发,也可以到一个正常环境中拷贝一个即可文件名为:“EAS8.5.0-bs_vc_update_data.ksql”
【实施问题】创建数据中心失败-列名 'Fid' 不明确
本文2024-09-16 22:46:05发表“eas cloud知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-eas-50230.html