Create Account Query failing for a DB connector only from Saviynt

[SUMAIYA_BABU]

Hi Team,

I am trying to provision an account to a Database application using an insert query in the CreateAccountJSON in a DB connector. The query is working when run directly in the application, but from saviynt it fails with an error statement -  Exception occured while Excecuting Query\n.

The error is very generic - does not specify what is the exception exactly. I tried with a simple insert query with hardcoded values to insert. But I am seeing the same error everytime. 

Any suggestions as to what might be the issue here?

[pmahalle]

Hi @SUMAIYA_BABU ,

Share your createaccountjson with dynamic as well as hardcoded value.

[SUMAIYA_BABU]

With hardcoded values: 

{
"createaccountqry": "INSERT INTO USERS (ID,VERSION,FIRSTNAME,SURNAME,LOGIN,LOGGEDIN,STARTDATE,DOMAIN,EMAIL,QUALIFICATION,EMPLOYEE) VALUES(SYS_GUID(),'1','Savtest','user072703','savtest.user072703','SAVIYNT','02-AUG-23 01.09.08.000000000 PM','FR','savtest.user072703@xxxxxxxxxxxxxx.com','ASSISTANT HR','072703');"
}

{"createaccountqry":"INSERT INTO USERS (ID,VERSION,FIRSTNAME,SURNAME,LOGIN,LOGGEDIN,STARTDATE,DOMAIN,EMAIL,QUALIFICATION,EMPLOYEE) 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'),'FR','${user.email}','${user.jobDescription}','${user.employeeid}')"}

[This message has been edited by moderator to mask domain name]

[pmahalle]

Hi @SUMAIYA_BABU ,

Which DB you are using in target? MYSQL or MSSQL or ORACLE or other?

[naveenss]

@SUMAIYA_BABU are you able to get values for SYS_GUID() when you do a select? Also, can you please try with the below query? can you pls share the complete logs?

{
    "createaccountqry": "INSERT INTO USERS (ID,VERSION,FIRSTNAME,SURNAME,LOGIN,LOGGEDIN,STARTDATE,DOMAIN,EMAIL,QUALIFICATION,EMPLOYEE) VALUES(UUID(),'1','Savtest','user072703','savtest.user072703','SAVIYNT','02-AUG-23 01.09.08.000000000 PM','FR','savtest.user072703@xxxxxxxxxxxx.com','ASSISTANT HR','072703');"
}

[This message has been edited by moderator to mask domain name]

[SUMAIYA_BABU]

@naveenss 

This query is also giving the same error - Exception while executing the query\n.

@pmahalle  This is an Oracle DB.

[rushikeshvartak]

{
"createAccountQry": "INSERT INTO USERS (ID,VERSION,FIRSTNAME,SURNAME,LOGIN,LOGGEDIN,STARTDATE,DOMAIN,EMAIL,QUALIFICATION,EMPLOYEE) VALUES(SYS_GUID(),'1','Savtest','user072703','savtest.user072703','SAVIYNT','02-AUG-23 01.09.08.000000000 PM','FR','savtest.user072703@xxxxxxxxxxxxx.com','ASSISTANT HR','072703');"
}

[This message has been edited by moderator to mask domain name]

[SUMAIYA_BABU]

@rushikeshvartak  This is what I originally had. But this is giving the same error - Error while executing query.

[SUMAIYA_BABU]

@naveenss Yes, I am able to use SYS_GUID() directly from the DB. The same query is working directly from the DB.

[pmahalle]

Hi @SUMAIYA_BABU ,

Raise FD ticket and check with Saviynt, is there any issue with calling SYS_GUID() function from Saviynt. Sometime some words are blocked in json, while saving it through UI.

[SUMAIYA_BABU]

I will check this. Thanks Pravin.