New tasks are failing with DB connector, but jsons are working at the application end

[SUMAIYA_BABU]

We are using a DB connector to provision account and access to an oracle DB application. The create account and add access tasks are marked in error state, even when the account is actually created and access is added at the backend and when we reconcile accounts, the accounts are reconciled to saviynt and the tasks are marked as 'No Action Required' when we run the wsretry again.

{ "createAccountQry":["INSERT INTO USERS (ID,TECHNICAL_VERSION,FIRSTNAME,SURNAME,LOGIN,AUDIT_INITIAL_USER,AUDIT_INITIAL_DATE,DOMAIN,EMAIL,QUALIFICATION,EMPID) VALUES(SYS_GUID(),'1','${user.firstname}','${user.lastname}','${user.customproperty1}','SAVIYNT',TO_TIMESTAMP(TO_CHAR(SYSTIMESTAMP, 'DD-MON-RR HH.MI.SS.FF9 AM'), 'DD-MON-RR HH.MI.SS.FF9 AM'),'TT','${user.email}','${user.jobDescription.replace("'","\'")==user.jobDescription}','${user.employeeid}')"] }

[armaanzahir]

@SUMAIYA_BABU 

Can you provide the error snippet from the logs while provisioning?

[adityachadde]

Hi @armaanzahir,

Please find the below snippet from the logs.

This is intermittent issue sometimes tasks are getting completed sometimes now.

Best Regards,

Aditya Chadde