Hi We just a week ago had similar errors in several tables - record cannot be made because it already exists.
In our case it was because recId count started to end ( from minus side went to zero ) There was about -1000 record IDs left and most of them already used - thats because the errors We deleted sysDatabaseLog table oldest records (about 11 millions unneccessary records) and did recId recoding - Administration / Periodic / SQL Administration / Check record IDs p.s. without SqlDatabaseLog data it went about 3 hours With SqlDatabaseLog table - 3 days --- In [email protected], "staffuwa" <[EMAIL PROTECTED]> wrote: > > We are experiencing problems generating print archive documents. > > The standard Axapta code in RestorePrinting - setPrintJobTables (used to > insert values into the PrintJobPages table) is executed, but an SQL > database > error occurs stating that a record in the PrintJobPages table could not be > inserted (duplicate record error). > > We have tried deleting the values in the PrintJobHeader and PrintJobPages > tables, but the error keeps occurring (usually after 2 print archive > documents have been created successfully). > > Does anyone know about this problem and/or a possible fix? > > Regards, > Daniele. >
