Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon

getting 'unable to invoke method equalsignorecase on null object' in Enhanced Execution query job

sangitaladi
Regular Contributor II
Regular Contributor II

Hi Team

 

Am trying to Update image of an application for ARS UI, hence writing below Enhanced Execution query but getting below error:

sangitaladi_0-1727085714417.png

Here is the the query am using to update the image:

select 'app.svg' as ENDPOINTS__IMAGE_ID, ENDPOINTS.ENDPOINTKEY as ENDPOINTS__PRIMARYKEY from ENDPOINTS where ENDPOINTS.ENDPOINTKEY in (111)

 

Any idea where am i making mistake?

 

Regards

Sangita Ladi

2 REPLIES 2

rushikeshvartak
All-Star
All-Star

select 'app.svg' as ENDPOINTS__IMAGE_ID, ENDPOINTKEY as ENDPOINTS__PRIMARYKEY from ENDPOINTS where ENDPOINTKEY =111;

OR 

SELECT ENDPOINTKEY AS ENDPOINTS__PRIMARYKEY,'app.svg' AS ENDPOINTS__IMAGE_ID FROM ENDPOINTS where endpointname='Rushi App' limit 1

 


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

stalluri
Valued Contributor II
Valued Contributor II

@sangitaladi 
select 'app.svg' as ENDPOINTS__IMAGE_ID, ENDPOINTKEY as ENDPOINTS__PRIMARYKEY from ENDPOINTS where ENDPOINTKEY =111;
or
select 'app.svg' as ENDPOINTS__IMAGE_ID, ENDPOINTS.ENDPOINTKEY as ENDPOINTS__PRIMARYKEY from ENDPOINTS where ENDPOINTS.ENDPOINTKEY in ('111')


Best Regards,
Sam Talluri
If you find this a helpful response, kindly consider selecting Accept As Solution and clicking on the kudos button.