CreateApprovalRecords: Approval record was not created correctly for user

[tahnalos]

I'm getting this error when trying to diagnose a missing approval issue:

Does anyone know what this error means and how this could have happened?

[Murthy Ch]

Hi @tahnalos 

Looks like he doesn't have approval (approver_user) role. 

(not tested)

[AshishKM]

Hi @tahnalos , 

The the user profile of that user for active, locked status and role. You can get the user's sys_is from log.

-Thanks,

Ashish

[Nandhu1704]

Hi @tahnalos,

Did you get a solution for this issue? I'm also facing the same. Kindly provide the solution if you have fixed the issue

Regards,

Nandhini

[Vishal Jaswal]

Hello @tahnalos and @Nandhu1704 

Old thread however I am replying for everyone to leverage the solution I found:

1. In the flow exection, under logs click on the timestamp for error "Approval record was not created". This way you can see the complete error messasge.

2. If the error message is "Unique Key violation detected by database ((conn=331993) Duplicate entry" then find out the table. For example "Duplicate entry 'GAPRV0011111' for key 'task_U1')"

3. Navigate to All > System Definition > Number Maintenance (Table: sys_number_list.LIST) and search for Table Group approval or prefix from above (like GAPRV) and increase the number value. For example from 10,000 to 15,000