D365 Finance & Operations and Dynamics AX Forum

 View Only
  • 1.  Customer Aging Snapshot SQL Server errors

    TOP CONTRIBUTOR
    Posted Jun 07, 2022 09:31 AM
    Lately we've been seeing SQL Server errors like below more frequently in the logs for the Customer aging snapshot batch job in AX 2012 R2 CU7.






    The SQL Server error appears to resolve itself the next time the job runs, as it usually doesn't come up on consecutive nights.  However if the error occurs on the same night that the monthly Retail account statements are generated, then the statements won't be accurate for the customers whose open transactions weren't processed by the aging snapshot job.

    Does anyone know what causes these SQL Server errors in this job and how we can avoid them?  We're on AX 2012 R2 CU7.  Thanks in advance.

    ------------------------------
    Rudy Salcedo
    Senior Programmer/Analyst
    LaForce, Inc
    Green Bay WI
    ------------------------------


  • 2.  RE: Customer Aging Snapshot SQL Server errors

    TOP CONTRIBUTOR
    Posted Jun 29, 2022 11:26 AM
    In addition to the above SQL error, we've also seen this error several times recently:



    It seems to happen within the range of customer numbers from 17958 to 18403.

    Any idea how to pinpoint which customer/sales order/job# etc is causing the error?

    ------------------------------
    Rudy Salcedo
    Senior Programmer/Analyst
    LaForce, Inc
    Green Bay WI
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role