CODEWITHSUNDEEP
axaptadynamics-ax-2009
piku
piku

Reputation: 613

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

Upvotes: 1

Views: 705

Answers (2)

manderson
manderson

Reputation: 891

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);

Upvotes: 0

Jan B. Kjeldsen
Jan B. Kjeldsen

Reputation: 18051

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.

Upvotes: 2

Related Questions