Database error 50000: Cannot insert object in PWOHelperPWO because the associated object in Person does not exist.

Hi,

We are getting the error message below when order a new request:

GEN_T1FC7AFB917D10028E5A1D8BA2 Line 75
[810143] Database error 50000: Cannot insert object in PWOHelperPWO because the associated object in Person does not exist.

I checked the workflow and it can calculate the approvers but it can not insert approvers into PWOHelperPWO.

GEN_T1FC7AFB917D10028E5A1D8BA2 that is also a trigger which I found under PWOHelperPWO.

https://prnt.sc/n1sExjkm8MAf

Full error message:
https://prnt.sc/Jls3TSNayCaz

Parents Reply
  • I have asked to the dba about transaction log size and he said everything looks normal.

    https://prnt.sc/ddRvPsOZ_zZd

    https://prnt.sc/DTS5vzFt9ZrL

    Actually,  I have manually delete 3000 identities from OneIM db. Because they have flagged as outstanding. They didn't exist in HR system. 

    But before deletion I cleaned the AD account relations with this identities and I deleted all records in PWO table which is related with these identities. After all that I was able to delete the identities. I assume that the issue started from that actions. Does it make any sense? Why the error says "associated object in person does not exist". Why approver calculation has to calculate the existing employee and should try to insert it in PWOHelperPWO..

    Can System use some predefined functions like "GEN_*******" and this function still try to catch identities that are not exist in the database.. It can be some cache  issue? Or is there any relation left in some tables about I have deleted in Person table. 

Children