Encountered this error recently and this had bought the complete environment to a stand still as the implementation was making extensive use of database logs.
We did a full compile of the application but that did not help. Ultimately had to resolve to code debugging. I found this issue to be that of a duplicate RECID being generated for a record insertion into the sysDatabaseLog table
As we know that the seed value for RecID generation for a table is done using SystemSequences table. I hence found the max(RecID) from the SysDatabaseLog table and updated this value (incremented by 1) into the NextVal column of the systemsequences.
PS: Any changes to the systemSequences Table were only visible to the AOS post a restart.
We did a full compile of the application but that did not help. Ultimately had to resolve to code debugging. I found this issue to be that of a duplicate RECID being generated for a record insertion into the sysDatabaseLog table
As we know that the seed value for RecID generation for a table is done using SystemSequences table. I hence found the max(RecID) from the SysDatabaseLog table and updated this value (incremented by 1) into the NextVal column of the systemsequences.
PS: Any changes to the systemSequences Table were only visible to the AOS post a restart.
No comments:
Post a Comment