Skip to content

Troubleshooting

If you encounter any of the following issues or errors, SailPoint recommends that you follow the guidance provided below to resolve the error before contacting SailPoint Support.

For issues or errors that are not addressed in this connector guide, refer to the following resources for troubleshooting information:

Debug Logs

For information about managing additional source settings, including debug logging and downloading connector logs, refer to Managing Additional Settings.

ObjectNotFound Exception During Provisioning Operations

During provisioning, the connector returns an error message similar to the following:

Error : java.lang.Exception: sailpoint.connector.ObjectNotFoundException: Object not found:-- <username>

Resolution: Do one of the following:

  • Recheck the getObject SQL query on the managed system. There may be an error with the single account aggregation SQL query.
  • If you are creating a new account, confirm that there is no delay with the process. Your DB administrator can assist with this resolution.

Attribute Values Are Not Updating After Adding IIQDisabled to the Query

After using IIQDisabled in a query, attribute values aren't populated following account aggregation or provisioning.

Resolution: Ensure that IIQDisabled is written in the query with double quotes: ("")

InvalidConfigurationException

Error occurred before establishing the connection with Server. java.lang.ClassNotFoundException : d}

Resolution:

  • Verify that the driver details are correct.
  • The connector may be missing a required .jar file. Add the required .jar file using the customizer.

Stored Procedure Is Incomplete and Rolled Back

Issue: net.snowflake.client.JDBC Saas.SnowflakeSQLException: Scoped transaction started in stored procedure is incomplete and it was rolled back.

Resolution: Ensure that each stored procedure with a transaction includes a corresponding COMMIT or ROLLBACK.

For example:

CREATE OR REPLACE PROCEDURE my_proc()
RETURNS STRING
LANGUAGE SQL
AS
$$
BEGIN
    BEGIN TRANSACTION;
    -- Your SQL statements
    INSERT INTO my_table VALUES (1, 'Test');
    -- Must commit or rollback before the procedure ends
    COMMIT;
    RETURN 'Success';
END;
$$;

Documentation Feedback

Feedback is provided as an informational resource only and does not form part of SailPoint’s official product documentation. SailPoint does not warrant or make any guarantees about the feedback (including without limitation as to its accuracy, relevance, or reliability). All feedback is subject to the terms set forth at https://developer.sailpoint.com/discuss/tos.