PostgresDB: Provision of Account & entitlement in same request is failing but separately works fine

[sk]

Team,

I am trying to provision new database account and entitlement in same request which is failing but if I do account and entitlement requests separately then it is working fine.

Am I missing any config?

Task Hierarchy is set to default.

Automatic Provision Enabled and Instant Provision Disabled

CreateAccountJSON: {"createAccountQry": "CREATE USER ${accountName} WITH PASSWORD '${randompassword}'"}

GrantAccessJSON: {"Roles": "ALTER GROUP ${task.entitlement_valueKey.entitlement_value} ADD USER ${accountName}"}

[rushikeshvartak · Accepted solution]

Please add AccountExistsQry in connection

[sk]

Thanks for the response Rushi your suggestion helped to solve the issue

[sk · Accepted solution]

Just to close the thread, We were able to resolve the issue by making following changes.

1. Modified the Create Task Action to Entitlement Only on the security system
2. Added AccountExistsQry in connection