Task comment is not getting updated

[Mervin]

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

[RakeshMG]

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

[abhiupadhyay]

@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]

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.  

[abhiupadhyay]

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

[sk]

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

[sk]

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?

[abhiupadhyay]

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

[sk]

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

[abhiupadhyay]

right .. what to do ? 

[sk]

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

What exactly you trying to insert?