Share
ReportHi,
I got this error in a batch that i ran
"Cannot delete a record in table lines1 (TableLine1 ). order: XX-00, 55. A time-out occurred in the database while the query was executing".
what would cause this error to happen?
So i cancelled this batch job and ran it again. Then i got this error below: what does this error mean?
Error in collecting infolog Microsoft.Dynamics.Ax.Xpp.TransientSqlConnectionError at Microsoft.Dynamics.Ax.MSIL.Interop.throwException(Int32 ExceptionValue, interpret* ip) at Microsoft.Dynamics.Ax.MSIL.cqlCursorIL.DeleteAll(IntPtr table) at Microsoft.Dynamics.Ax.Xpp.Common.DeleteAll() in D:\dbs\sh\l23t\0503_210906\cmd\7\Source\Kernel\xppil\XppSupport\Common.cs:line 659 at Dynamics.AX.Application.DeleteOrderService.`deleteOrder() in xppSource://Source/XX\AxClass_DeleteOrderService.xpp:line 20 at Dynamics.AX.Application.DeleteOrderService.deleteOrder() at DeleteOrderService::deleteOrder(Object , Object[] , Boolean& ) at Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeInstanceCall(Object instance, String MethodName, Object[] parameters) in D:\dbs\sh\l23t\0503_210906\cmd\7\Source\Kernel\xppil\XppSupport\ReflectionCallHelper.cs:line 2056 at Microsoft.Dynamics.Ax.Xpp.DictClass.Callobject(String _methodName, XppObjectBase _Called, Object[] varArgs) in D:\dbs\sh\l23t\0120_000230\cmd\7\Source\Kernel\xppil\XppSupport\DictClass.cs:line 183 at Dynamics.AX.Application.SysOperationServiceController.runOperationInstance(SysOperationServiceController controller) at Dynamics.AX.Application.SysOperationServiceController.runOperationSynchronously() at Dynamics.AX.Application.SysOperationServiceController.`run() at Dynamics.AX.Application.SysOperationServiceController.run() at Dynamics.AX.Application.BatchRun.runJobStaticCodeFromBuffer(Batch buffer) at Dynamics.AX.Application.BatchRun.runJobStaticFromBuffer(Batch buffer) at Microsoft.Dynamics.AX.Batch.BatchRunAction.Run() at Microsoft.Dynamics.AX.Batch.Batch.ExecuteOneBatchJobTask(BatchTaskInfoWrapper taskInfo).
i cancelled this batch job, and it's stuck at cancelling -- how can i delete this batch job record? or make it cancelled instead of cancelling
I got this error in a batch that i ran
"Cannot delete a record in table lines1 (TableLine1 ). order: XX-00, 55. A time-out occurred in the database while the query was executing".
what would cause this error to happen?
So i cancelled this batch job and ran it again. Then i got this error below: what does this error mean?
Error in collecting infolog Microsoft.Dynamics.Ax.Xpp.TransientSqlConnectionError at Microsoft.Dynamics.Ax.MSIL.Interop.throwException(Int32 ExceptionValue, interpret* ip) at Microsoft.Dynamics.Ax.MSIL.cqlCursorIL.DeleteAll(IntPtr table) at Microsoft.Dynamics.Ax.Xpp.Common.DeleteAll() in D:\dbs\sh\l23t\0503_210906\cmd\7\Source\Kernel\xppil\XppSupport\Common.cs:line 659 at Dynamics.AX.Application.DeleteOrderService.`deleteOrder() in xppSource://Source/XX\AxClass_DeleteOrderService.xpp:line 20 at Dynamics.AX.Application.DeleteOrderService.deleteOrder() at DeleteOrderService::deleteOrder(Object , Object[] , Boolean& ) at Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeInstanceCall(Object instance, String MethodName, Object[] parameters) in D:\dbs\sh\l23t\0503_210906\cmd\7\Source\Kernel\xppil\XppSupport\ReflectionCallHelper.cs:line 2056 at Microsoft.Dynamics.Ax.Xpp.DictClass.Callobject(String _methodName, XppObjectBase _Called, Object[] varArgs) in D:\dbs\sh\l23t\0120_000230\cmd\7\Source\Kernel\xppil\XppSupport\DictClass.cs:line 183 at Dynamics.AX.Application.SysOperationServiceController.runOperationInstance(SysOperationServiceController controller) at Dynamics.AX.Application.SysOperationServiceController.runOperationSynchronously() at Dynamics.AX.Application.SysOperationServiceController.`run() at Dynamics.AX.Application.SysOperationServiceController.run() at Dynamics.AX.Application.BatchRun.runJobStaticCodeFromBuffer(Batch buffer) at Dynamics.AX.Application.BatchRun.runJobStaticFromBuffer(Batch buffer) at Microsoft.Dynamics.AX.Batch.BatchRunAction.Run() at Microsoft.Dynamics.AX.Batch.Batch.ExecuteOneBatchJobTask(BatchTaskInfoWrapper taskInfo).
i cancelled this batch job, and it's stuck at cancelling -- how can i delete this batch job record? or make it cancelled instead of cancelling
All responses (
Answers (
291,622
