Duplicated key when creating work with SOAP service
We've provided a service to other system which is used to create PRPC work via SOAP data. This service worked very fine with PRPC version 6.1 SP2.
Recently, we upgraded our PRPC from 6.1 SP2 to 7.1.8; after upgrade, we found duplicated work keys which will case work creation failed.
Error message:
Create work failed: ** [jcc][t4][102][10040][4.11.77] Batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch.
Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229, SQLSTATE=null
Time span between two creation is 9 ms:
2017-02-06 00:59:26,893 [fault (self-tuning)'] [ STANDARD] INFO SOAP|MTEKMFService|Services|CreateCAWork|AE07EC2AD9DEC6614C6D86FB08EA3FDB3 - Start create CA work @ 20170205T165926.893 GMT
2017-02-06 00:59:26,902 [fault (self-tuning)'] [ STANDARD] INFO SOAP|MTEKMFService|Services|CreateCAWork|A8C1226FFAB070966BE042BEDDBA2BC41 - Start create CA work @ 20170205T165926.902 GMT
We understand that we can use "Execute asynchronously (queue for execution)" to process SOAP requests; but with this generate ID mechanism, the work keys still could be duplicated anyhow, this is very dangerous. So, please kindly help if anyone has any idea.
Appreciated a lot.
We've provided a service to other system which is used to create PRPC work via SOAP data. This service worked very fine with PRPC version 6.1 SP2.
Recently, we upgraded our PRPC from 6.1 SP2 to 7.1.8; after upgrade, we found duplicated work keys which will case work creation failed.
Error message:
Create work failed: ** [jcc][t4][102][10040][4.11.77] Batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch.
Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229, SQLSTATE=null
Time span between two creation is 9 ms:
2017-02-06 00:59:26,893 [fault (self-tuning)'] [ STANDARD] INFO SOAP|MTEKMFService|Services|CreateCAWork|AE07EC2AD9DEC6614C6D86FB08EA3FDB3 - Start create CA work @ 20170205T165926.893 GMT
2017-02-06 00:59:26,902 [fault (self-tuning)'] [ STANDARD] INFO SOAP|MTEKMFService|Services|CreateCAWork|A8C1226FFAB070966BE042BEDDBA2BC41 - Start create CA work @ 20170205T165926.902 GMT
We understand that we can use "Execute asynchronously (queue for execution)" to process SOAP requests; but with this generate ID mechanism, the work keys still could be duplicated anyhow, this is very dangerous. So, please kindly help if anyone has any idea.
Appreciated a lot.
***Updated by moderator: Lochan to move post from PSC to Pega 7 Upgrade Center***
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.