none
**urgent**Transaction Register RRS feed

  • Question

  • Hi,

    I am adding a unique key(senderId + Transaction set +date) in transaction register so that i can set a flag value to true or false.when a document 1st come from a particular TP on a particular date & of particular transaction set flag will be set as false and from next time it will be set as true.But when more than one documents are processing at the same time one document got errored out while all other processed successfully.Error is like "Error trying to add a transaction register entry. This transaction register already exists in the database"..when i restarted the errored BP it processed successfully.

    for example if 100 documents comes with the same value in transaction register then out of 100 only 1 get errored out while 99 will process successfully and the errored one will also process succesfully after restart.

    This problem is coming only when all 100 are coming at the same time.If one document comes early and after one if 99 comes later then none ofd them will get errored out.

    Exact error is

    "Report Entry:
           Section:        Severity: ERROR
           SyntaxSpecific: false       Syntax: -1        Code: 140 Standard Rule Error
           Info:
                  10006: Exception
                  Cannot insert duplicate key row in object 'dbo.TRANSACT_REGISTER' with unique index 'SCI_IDX_135'.
    Report Entry:

    "

    Please let me know how to resolve this problem.I am facing a lot of problem in production bcoz of this.
    • Edited by Alterego05 Friday, July 22, 2011 9:42 AM in production need reply
    Thursday, July 21, 2011 9:08 PM

All replies