Share
Report
796Hi All,
"Due date alert" batch is giving below error and from error I came to know that we need to change Maximum buffer size under tuning tab.
Can some one suggest me that do we need to take care anything while changing on Production server? Is there any proper way/procedure to do? Alternatively, is something we can ask DB to change on ? some one suggested in Dynamics blog like below :-
"We need to edit the registry key called sqlbuffer
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Dynamics Server\6.0\01\Original (installed configuration)\sqlbuffer"
As it is a production server unable to take a decision and any suggestions would be more helpful.
Error message for reference:-
=====================================
Error Infolog for job Due date alerts (5642091435)\Infolog for task Due date alerts (5642440074) The total, internal size of the records in your joined SELECT statement is 53346 bytes, but Microsoft Dynamics is by default performance-tuned not to exceed 49152 bytes.
Info Infolog for job Due date alerts (5642091435)\Infolog for task Due date alerts (5642440074) It is strongly recommended that you split your table(s) into smaller units.
Info Infolog for job Due date alerts (5642091435)\Infolog for task Due date alerts (5642440074) Alternatively, you have to specify a 'Maximum buffer size' value of 53 Kbytes or higher on the 'Database Tuning' tab page in the Microsoft Dynamics AX Server Configuration Utility. The default value is 24 Kbytes.
Error Infolog for job Due date alerts (5642091435)\Infolog for task Due date alerts (5642440074) Exit Microsoft Dynamics immediately, and follow the directives above. Use of the table(s) will cause unpredictable results.
Error Infolog for job Due date alerts (5642091435)\Infolog for task Due date alerts (5642440074) Microsoft.Dynamics.Ax.Xpp.ErrorException: Exception of type 'Microsoft.Dynamics.Ax.Xpp.ErrorException' was thrown.
at Microsoft.Dynamics.Ax.MSIL.Interop.throwException(Int32 ExceptionValue)
at Microsoft.Dynamics.Ax.MSIL.cqlClassIL.callReturn(Int32 rc, interpret* ip)
at Microsoft.Dynamics.Ax.MSIL.cqlClassIL.Call(IntPtr c, String methodName, Object[] parameters, Type[] types, Object[] varargs, Type[] varargsTypes)
at Microsoft.Dynamics.Ax.Xpp.XppObjectBase.Call(String methodName, Object[] parameters, Type[] types, Object[] varargs)
at Dynamics.Ax.Application.QueryRun.Next()
at Dynamics.Ax.Application.EventProcessorDueDate.Processrule(EventRule _eventRule) in EventProcessorDueDate.processRule.xpp:line 67
at Dynamics.Ax.Application.EventProcessorDueDate.Run(EventRule eventRule) in EventProcessorDueDate.run.xpp:line 14
at Dynamics.Ax.Application.EventJobDueDate.runDueDateEventsForUser(Object[] _args) in EventJobDueDate.runDueDateEventsForUser.xpp:line 48
at EventJobDueDate::runDueDateEventsForUser(Object[] )
at Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeStaticCall(Type type, String MethodName, Object[] parameters)
at Microsoft.Dynamics.Ax.Xpp.PredefinedFunctions.runas(String userId, Int32 classId, String staticMethodName, Object[] parms, String company, String language, String partitionKey)
at Dynamics.Ax.Application.EventJobDueDate.Run() in EventJobDueDate.run.xpp:line 24
at Dynamics.Ax.Application.BatchRun.runJobStaticCode(Int64 batchId) in BatchRun.runJobStaticCode.xpp:line 54
at Dynamics.Ax.Application.BatchRun.runJobStatic(Int64 batchId) in BatchRun.runJobStatic.xpp:line 13
at BatchRun::runJobStatic(Object[] )
at Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeStaticCall(Type type, String MethodName, Object[] parameters)
at BatchIL.taskThreadEntry(Object threadArg)
=====================================
Reference screen as below:-
All responses (
Answers (
