创建组织间结算超时
客户这边的跨组织业务分2块,一块是跨组织调拨,一块为跨组织领料,生成组织间结算清单的也是根据业务类型分开创建
跨组织调拨的没有问题
大部分组织跨组织领料的分录数量都在8000条左右,但是有一个组织数量近17000条,创建结算清单超时
是性能问题,望研发关注
环境:
K3Cloud_V2.0_SP3_补丁PT088190
错误信息:
序号 关键字 状态 信息
1 核算组织:通用事业部 失败 "会计核算体系【责任中心会计核算体系】,Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
语句已终止。 .Net SqlClient Data Provider
Server stack trace:
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Kingdee.BOS.App.Data.AbstractDatabase.ExecuteNonQuery(DbCommand command, IEnumerable`1 listParam)
at Kingdee.BOS.App.Data.DBUtils.ExecuteWithTime(Context ctx, String strSQL, IEnumerable`1 paramList, Int32 commandTimeout)
at Kingdee.K3.SCM.App.IOS.ServicePlugIn.SettleTranService.ReceiveSave.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 System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Kingdee.BOS.Contracts.ISaveService.Save(Context ctx, BusinessInfo info, DynamicObject[] dataObject, OperateOption option, String operationNumber)
at Kingdee.K3.SCM.App.Core.AbstractCreateOverOrgAccount.SaveSettlement(FormMetadata meta, DynamicObject[] dyObjArray)
at Kingdee.K3.SCM.App.Core.AbstractCreateOverOrgAccount.SaveData(IOSCreateResult iosCreateResult)
at Kingdee.K3.SCM.App.Core.OverOrgAccountService.CreateSettle(Context ctx, IOSSettleParams iosParams)"
推荐阅读