Duplicate kep exception in table VIRSA_AE_RQD_WPCLD

[Former Member]

Dear Experts,

Thanks for your attention.

Background

u2022We are using Role Mapping function, the configuration is as following:

o Role 001 and Role 002 are the main role; Role 003 is the dependent role

o Role 003 is mapping to Role 001

o Role 003 is also mapping to Role 002

u2022We are using CAD to determine the approver for these roles, such as:

o Role 001 should be approved by people A

o Role 002 should be approved by people B

o Role 003 should be approved by people C

u2022We configure the work flow containing 3 stages: [Direct manager]->[Controller]->[Administrator]

o At the [Direct manager] stage, there will be only one approver for each request, he/her can approve or reject the whole request or specific roles. (approval level = request)

o At the [Controller] stage, there will be several approvers for each request based on the role selected, they only can approve or reject the specific roles under their management. ( approval level = role)

Which case the issue will come out?

u2022When the user select the Role 001 and Role 002 in one request, the issue will come out

What will be impacted?

u2022The request cannot go to the [Controller] stage. Error message 1016 will come out.

How about system log?

Here is the error message in system log

2011-02-21 02:48:37,470 [SAPEngine_Application_Thread[impl:3]_23] DEBUG  WorkFlowBOHelper.java@1353:handleApproversTransactions() : dtoApprover : com.virsa.ae.workflow.dto.WorkFlowApproversListDTO@34713471[approversList=[],subStageApproversList=[com.virsa.ae.workflow.dto.WorkFlowSubStageApproverDTO@5e105e10[approveRejectLevel=Role,attributeValue=106974|||||QEDCLNT410|||||0,approversList=[com.virsa.ae.workflow.dto.WorkFlowApproverWithAltDTO@5e095e09[approverId=VSAHOO,alternateApproverId=TTANG5,approverType=1,altApproverType=1,key=<null>]]], com.virsa.ae.workflow.dto.WorkFlowSubStageApproverDTO@56ee56ee[approveRejectLevel=Role,attributeValue=102744|||||QEDCLNT410|||||0,approversList=[com.virsa.ae.workflow.dto.WorkFlowApproverWithAltDTO@56e756e7[approverId=VSAHOO,alternateApproverId=TTANG5,approverType=1,altApproverType=1,key=<null>]]], com.virsa.ae.workflow.dto.WorkFlowSubStageApproverDTO@4b994b99[approveRejectLevel=Role,attributeValue=106971|||||QEDCLNT410|||||0,approversList=[com.virsa.ae.workflow.dto.WorkFlowApproverWithAltDTO@4b924b92[approverId=VSAHOO,alternateApproverId=TTANG5,approverType=1,altApproverType=1,key=<null>]]], com.virsa.ae.workflow.dto.WorkFlowSubStageApproverDTO@7ec87ec8[approveRejectLevel=Role,attributeValue=106971|||||QEDCLNT410|||||0,approversList=[com.virsa.ae.workflow.dto.WorkFlowApproverWithAltDTO@7ec17ec1[approverId=VSAHOO,alternateApproverId=TTANG5,approverType=1,altApproverType=1,key=<null>]]], com.virsa.ae.workflow.dto.WorkFlowSubStageApproverDTO@343a343a[approveRejectLevel=Role,attributeValue=106972|||||QEDCLNT410|||||0,approversList=[com.virsa.ae.workflow.dto.WorkFlowApproverWithAltDTO@34333433[approverId=VSAHOO,alternateApproverId=TTANG5,approverType=1,altApproverType=1,key=<null>]]]],approverGroupApproversList=[]]
2011-02-21 02:48:37,470 [SAPEngine_Application_Thread[impl:3]_23] DEBUG  WorkFlowBOHelper.java@1364:handleApproversTransactions() : list of approvers is empty, checking for substage approvers
2011-02-21 02:48:37,470 [SAPEngine_Application_Thread[impl:3]_23] DEBUG  WorkFlowSubStageTransactionHelper.java@48:insertApprovers() : INTO the method : INTO the method with reqNo : 419, reqPathId : 861, stageName : CE APPROVAL
2011-02-21 02:48:37,472 [SAPEngine_Application_Thread[impl:3]_23] ERROR com.virsa.ae.dao.sqlj.RequestWFTransChildDAO : insert(IAETransaction transactionRequestWFTransChildDTO dto) Exception occured while inserting(com.virsa.ae.dao.dto.RequestWFTransChildDTO@5fc85fc8[reqNo=419,userId=VSAHOO,reqPathId=861,stageName=CE APPROVAL,attributeType=Role,attributeValue=106971|||||QEDCLNT410|||||0,lastUpdate=<null>,status=OPEN,alternateApproverId=TTANG5,approverType=1,altApproverType=1]) :   :  Exception: DB2 SQL error: SQLCODE: -803, SQLSTATE: 23505, SQLERRMC: 1;SAPQGDDB.VIRSA_AE_RQD_WPCLD
com.sap.sql.DuplicateKeyException: DB2 SQL error: SQLCODE: -803, SQLSTATE: 23505, SQLERRMC: 1;SAPQGDDB.VIRSA_AE_RQD_WPCLD

Thanks a lot if you can provide any adivce!

Edited by: tang dark on Feb 28, 2011 5:08 PM

[Former Member]

Dear Experts,

This issue impact us quite a lot...

Thanks a lot for your patience for analyzing this issue.

If you have any idea, please kindly share with us. Much appreciate!

[Former Member]

Did you ever get a resolution for this? I just ran into the same problem.

Thanks.