Refresh Task Failure

Which IIQ version are you inquiring about?

8.4p2

Share all details about your problem, including any error messages you may have received.

Refresh task is failing with below error. Disabled all Life Cycle Events also getting same error. In Syslog events also showing the error message only and not showing where its failing.
An unexpected error occurred: java.lang.NullPointerException: Cannot invoke “sailpoint.object.Application.getId()” because the return value of “sailpoint.object.Link.getApplication()” is null

are you using ootb identity refresh task or custom one? also can you share the full logs?

Regards
Ankush

This error specifically means you have a row in your spt_link table where the application column points to an Application ID that no longer exists in the spt_application` table.

can you run the below sql query in your database and find

SELECT l.id as LinkID, l.native_identity, l.identity_id
FROM identityiq.spt_link l
WHERE l.application NOT IN (SELECT id FROM spt_application);

If this returns a row:

-Copy the LinkID , write a small cleanup rule to delete it.

The user associated with identity_id is the one causing the crash.

Hi Ankush

I am using ootb task.

Just showing below in syslog events.

Caused by: org.apache.bsf.BSFException: The application script threw an exception: java.lang.NullPointerException: Null Pointer in Method Invocation BSF info: script at line: 0 column: columnNo

Hi @sivanagi_reddy ,

Could you please share what are the options you have selected in the refresh task?

Check if you have selected ‘Refresh assigned, detected roles and promote additional entitlements’ and check if there any assignment rules for roles causing NullPointerException while calling sailpoint.object.Link.getApplication().

@sivanagi_reddy

Is your issue resolved?

Hi sumit

yes the issue has been fixed.

I used below query to find the list of users who does not have a single application account and fixed those users.
select * from identityiq.spt_link where application is null;