We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

Task comment is not getting updated

Mervin
New Contributor
New Contributor

Hi Team,

Am having insert query in create account JSON for DB connection type, while am running the query if the row doesn't insert into the table am not seeing any provisioning comment that no row inserted in the table.

Can I have confirmation in task whether row inserted or not

10 REPLIES 10

RakeshMG
Saviynt Employee
Saviynt Employee

Provisioning comments will not capture the insert query details or it is inserted or not.


​Regards

Rakesh M Goudar

@RakeshMG Regardless of the provisioning comment, if no row has been inserted in the DB side, the task should fail .. right now since task is getting successful, the account shows-up on Saviynt whereas it is not there on endpoint .. how to handle this situation ? 

This looks the very basic use case... how to go around this ? 

RakeshMG
Saviynt Employee
Saviynt Employee

Please check the logs if you are having any response or error, while provisioning job is executing.

Also please share the complete scenario of your use-case.  


​Regards

Rakesh M Goudar

In the logs it does not show anything specific with response message from DB2. It just shows success. 

Would you able to try that insert statement directly on DB and see the response and behaviour whether it is completing or not?


Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.

sk
All-Star
All-Star

Looks like insert statement is not giving any response/errors that saviynt understands as failure. What is the response you are seeing in logs when insert didn't happen?


Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.

abhiupadhyay
New Contributor III
New Contributor III

correct. The query is not giving any error. since it is not inserting any row it's showing "affected rows 0"

I think that is the reason saviynt couldn't understand it is failure hence marking it as complete


Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.

abhiupadhyay
New Contributor III
New Contributor III

right .. what to do ? 

What is the target database type? can't you use create statement instead of insert?

What exactly you trying to insert?


Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.