Urgent : Getting Error on Sailpoint : Request execution failed for the sys_id 'null'. Target record

[jigyasa]

This is a very urgent and high burning issue for our Project. It will very helpful if someone can support us in this. There is an already existing Sailpoint Servicenow integration to populate User Table using a Transform Map. Sailpoint User data is passed onto a Staging Table through Sailpoint connector. There is 1 more custom Table created which also needs to populate data through this staging table, so we created 1 more Transform map for it but we are getting intermittent errors (Errors: sailpoint.connector.ConnectorException: [ ConnectorException ] [ Error details ] Request execution failed for the sys_id 'null'. Target record not found)for the existing User Integration if we add this second transform map. When this second Transform map is made active false then this error resolves.

If someone faced a similar issue please help us in resolving this.

[Abhay Kumar1]

@jigyasa The error sailpoint.connector.ConnectorException with Request execution failed for the sys_id 'null'. Target record not found indicates that the SailPoint connector is attempting to update a user record in ServiceNow, but it is unable to find the target record (sys_id is null).

This could happen if the second Transform Map interferes with the processing of the first map, causing it to fail to retrieve the correct user record from the target table.

[Naresht2]

@jigyasa does your issue resolved? What is the root cause? I am also facing the same issue. Could you please help on this issue?