列名 'Fid' 不明确,T_VC_VCRESULT
455次浏览
编辑于2020年01月20日 09:49:15
【附件中包含缺失的文件】
报错信息
-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' 不明确。]
找一个相同的eas环境,根据以下路径把正常的环境的EAS8.5.0-bs_vc_update_data.ksql进行替换道有问题的环境
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。
报错信息
-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' 不明确。]
找一个相同的eas环境,根据以下路径把正常的环境的EAS8.5.0-bs_vc_update_data.ksql进行替换道有问题的环境
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。
EAS8.5.0-bs_vc_update_data.ksq …(0.72KB)
推荐阅读