Error when posting project transaction

When trying to post a project transaction, we are getting an error log that does not actually show any errors. We are having the same behavior with trying to post project transactions in all other companies.

We were told to adjust the surrogate key table but that did not work & we are now getting a sequence number error on all PA transactions as well as the blank error message after that.

Parents
  • 0

    The suggestion was to find the MAX(intJobLineKey) value in tPA00125 and then add + 1 to this and ensure the tciSurrogateKey - NextKey value for tablename = 'tPA00125' was equal to the MAX + 1 value or greater. The reasoning was because the system was unable to create a project transaction and the SQL Profiler trace was indicating an attempt to create a record which already existed and thus generating an Exception. Support is collecting the database for review as the above solution did not resolve the issue. 

Reply
  • 0

    The suggestion was to find the MAX(intJobLineKey) value in tPA00125 and then add + 1 to this and ensure the tciSurrogateKey - NextKey value for tablename = 'tPA00125' was equal to the MAX + 1 value or greater. The reasoning was because the system was unable to create a project transaction and the SQL Profiler trace was indicating an attempt to create a record which already existed and thus generating an Exception. Support is collecting the database for review as the above solution did not resolve the issue. 

Children
No Data