Click HERE to see how Saviynt Intelligence is transforming the industry. |
11/28/2023 03:32 AM
Hi Team,
For Enhanced Query when we execute the query if data not available based condition based it got failed out due null update.
Can you provide solution ?
Ex:
SELECT '3' AS ARSTASKS__STATUS,A.TASKKEY AS ARSTASKS__PRIMARYKEY FROM ARSTASKS A WHERE A.ENDPOINT IN ('1227') AND A.SECURITYSYSTEM IN (10) AND A.ENTITLEMENT_VALUEKEY IN ('49658951') AND A.STATUS=1
As of now , no task available in pending task list with status=1
Getting below :
Thanks,
Raghu
Solved! Go to Solution.
11/28/2023 04:42 AM
Does it work when task exists ?
can you share logs
11/28/2023 04:52 AM
Thanks for Resp @rushikeshvartak ,
Yes if task is exist it working and updating, when task is not available it throwing error with null.
We can't say when request will come prod scenarios case ? job will schedule once .
Thanks,
Raghu
11/28/2023 04:54 AM - edited 11/28/2023 05:32 AM
As per query you are closing task for particular entitlement. Why don’t you complete task using connector instead of query.
If no record’s matched its known defect & idea already in place https://ideas.saviynt.com/ideas/EIC-I-5139
11/28/2023 10:23 AM
I have requirement like Oracle application we need add manually SSO Group(its part of different endpoint like ISC AD ). I created dummy group there was added in other entitlement tab, it will create SSO Group like i done, target system don't have access to add, for dummy group execution i made query build.
11/28/2023 06:32 PM
You can use DB connector or REST connector and close task using Dummy API/ SQL query
11/28/2023 04:58 AM
@Raghu Currently job status will show as failed if there are no records.
Already idea has been raised.
"Enhanced Query Execution" - add option to be a | Saviynt Ideas Portal
If this reply answered your question accept it as a solution.