账套升级由1.0升级到5.1后,保存凭证报错
金蝶云社区-王宝强经纪人
王宝强经纪人
0人赞赏了该文章 868次浏览 未经作者许可,禁止转载编辑于2015年09月22日 15:41:48

cloud升级,账套升级由1.0升级到5.1后,保存凭证报错。
升级的账套报错,但是新建的数据中心账套不会报错。
最新的5.0的补丁也打了,还是不行。
报错弹出的信息是 对象名‘T_GL_BALANCE_1’无效。
暂时那台服务器不方便截图,报错信息如下:

发生时间: 2015-09-22 10:19:08
错误编号: ExecuteBatch
错误信息: 对象名 'T_GL_BALANCE_1' 无效。
Sql语句: /*dialect*/ MERGE INTO T_GL_BALANCE_1 A USING (SELECT SUM(T.FDEBITFOR) AS FDEBITFOR,SUM(T.FDEBIT) AS FDEBIT,SUM(T.FCREDITFOR) AS FCREDITFOR,SUM(T.FCREDIT) AS FCREDIT,T.FACCOUNTBOOKID AS FACCOUNTBOOKID, T.FYEAR AS FYEAR, T.FPERIOD AS FPERIOD, T.FACCOUNTID AS FACCOUNTID, T.FDETAILID AS FDETAILID, T.FCURRENCYID AS FCURRENCYID,T.FADJUSTPERIOD AS FADJUSTPERIOD FROM #TM_GL_ACCTENDTRASACTOIN T GROUP BY T.FACCOUNTBOOKID, T.FYEAR, T.FPERIOD, T.FACCOUNTID, T.FDETAILID, T.FCURRENCYID, T.FADJUSTPERIOD) D ON (A.FACCOUNTBOOKID=D.FACCOUNTBOOKID AND A.FYEAR=D.FYEAR AND A.FPERIOD=D.FPERIOD AND A.FACCOUNTID=D.FACCOUNTID AND A.FDETAILID=D.FDETAILID AND A.FCURRENCYID=D.FCURRENCYID AND A.FADJUSTPERIOD=D.FADJUSTPERIOD) WHEN MATCHED THEN UPDATE SET A.FDEBITFOR=A.FDEBITFOR+D.FDEBITFOR, A.FDEBIT=A.FDEBIT+D.FDEBIT, A.FCREDITFOR=A.FCREDITFOR+D.FCREDITFOR, A.FCREDIT=A.FCREDIT+D.FCREDIT WHEN NOT MATCHED THEN INSERT(FACCOUNTBOOKID,FYEAR,FPERIOD,FACCOUNTID,FDETAILID,FCURRENCYID,fbeginbalancefor,fbeginbalance,fdebitfor,fdebit,fcreditfor,fcredit,fytddebitfor,fytddebit,fytdcreditfor,fytdcredit,fendbalancefor,fendbalance,FADJUSTPERIOD) VALUES(D.FACCOUNTBOOKID,D.FYEAR,D.FPERIOD,D.FACCOUNTID,D.FDETAILID,D.FCURRENCYID,0,0,D.FDEBITFOR,D.FDEBIT,D.FCREDITFOR,D.FCREDIT,0,0,0,0,0,0,0);

===================================================
调用堆栈:

Server stack trace:
at Kingdee.BOS.App.Data.Sql.SqlDatabase.ExecuteBatch(List`1 sqlArray, Int32 batchSize, Int32 commandTimeout)
at Kingdee.K3.FIN.GL.App.ServicePlugIn.GLVoucher.Save.EndOperationTransaction(EndOperationTransactionArgs e)
at Kingdee.BOS.App.Core.PlugInProxy.OperationServicePlugInProxy.FireEndOperationTransaction(EndOperationTransactionArgs e)
at Kingdee.BOS.App.Core.AbstractOprerationService.CallOperation(DynamicObject[]& objs)
at Kingdee.BOS.App.Core.AbstractOprerationService.CallOperatinTransaction(DynamicObject[] objs)
at Kingdee.BOS.App.Core.AbstractOprerationService.DoExcete()
at Kingdee.BOS.App.Core.AbstractOprerationService.Excute(DynamicObject[] dataEntities)
at Kingdee.BOS.App.Core.SaveService.Save(Context ctx, BusinessInfo info, DynamicObject[] dataEntities, OperateOption option, String operationNumber)

Exception rethrown at [0]:
at Kingdee.BOS.ServiceHelper.BusinessDataServiceHelper.Save(Context ctx, BusinessInfo businessInfo, DynamicObject dataObject, OperateOption option, String operationNumber)
at Kingdee.BOS.Model.Bill.BillModel.Save(OperateOption option)
at Kingdee.BOS.Business.Bill.Operation.Save.ExecuteBillOperation(OperateOption option)
at Kingdee.BOS.Core.DynamicForm.AbstractDynamicFormOperation.Operation(CallBackWfAfterOperation callbackwf, IOperationResult result)