# 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:

- [SailPoint Identity Services Documentation](<https://documentation.sailpoint.com/saas/help/index.html>)
- [SailPoint Support Knowledge Base](<https://support.sailpoint.com/csm?id=kb_view2&amp;kb_id=05ff44289f011200550bf7b6077fcfa3>)
- [SailPoint Developer Community](<https://developer.sailpoint.com/>)

## Debug Logs

For information about managing additional source settings, including debug logging and downloading connector logs, refer to [Managing Additional Settings](<https://documentation.sailpoint.com/saas/help/sources/managing_additional_settings.html>).

## ObjectNotFound Exception During Provisioning Operations

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

```text
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

```text
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:

```sql
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;
$$;
```