Null Handing for Enhanced Querys

[Raghu]

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

[rushikeshvartak]

Does it work when task exists ?

can you share logs

[Raghu]

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

[rushikeshvartak · Accepted solution]

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

[Raghu]

@rushikeshvartak,

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.

[rushikeshvartak]

You can use DB connector or REST connector and close task using Dummy API/ SQL query

[SumathiSomala · Accepted solution]

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