Axapta 2009 database log report error

1
votes

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

2
axaptadynamics-ax-2009

2 Answers

2
votes

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.

0
votes

I just got the same error when modifying the SalesInvoice report in DAX 2009. In our test environment, of course. I tried everything above, but nothing worked. A backup version of the report worked, so I started backing out some custimizations one at a time.

I realized I had commented out a VAR customization in the fetch method, similar to this line of code. I uncommented and this worked.

this.footerEnable(totals,                   showFooter && !taxPrintTaxFreeBalance);