Search code examples
axaptadynamics-ax-2009

Axapta 2009 database log report error

While generating Db log report in production with several table id's as parameter and createdDateTime > 8-Aug-2016. I am getting the below error.

Cannot create a record in Print job information (page-level) (PrintJobPages). pageNo: 1. The record already exists.

As the issue is in PROD i cannot restart services/AOS. Please help

Solution

  • Do you use the Print Archive? If you do, try to disable it.

    This could be RecId generation error, if there are records in the PrintJobPages table with id higher than new generated ids.

    This may be corrected be setting the next record id to a higher value in the SystemSequences system table (using SQL Enterprise Manager). See this and that blog.