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

New Contributor III
New Contributor III

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.jobDescription.replace("'","\'")==user.jobDescription}','${user.employeeid}')"] }



Regular Contributor III
Regular Contributor III


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


Md Armaan Zahir

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