# 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/>)

## During Aggregation, New Columns Are Added, but the Value Doesn't Update

**Resolution**: Update the aggregation query with the newly added column name.

## Spaces Are Added to CSV and Text Files During Provisioning

**Resolution**: To avoid adding spaces into the CSV or text files while performing provisioning operations, add the following query in the corresponding rule:

```java
String query1 ="pack table table_name";
stmt.execute(query1);
```

## Table Error

The following error message displays:

`Failed to load table EMP: java.io.FileNotFoundException: /home/sailpoint/data/EMP.csv (Read-only file system)`

**Resolution**: Ensure that the file has the required permissions.

## Provisioning Error

The disabled account was deleted from the managed accounts after running performance maintenance task.

**Resolution**: You must add the `getObjectSQL` query because the source fetches the provisioned account again from the CSV file using the `getObjectSQL` query after the provisioning operation.

## Provisioning Rule Error

In the absence of a provisioning rule, when you start the Create Account operation, the following error displays:

`Rule: jdbcProvisionRule not found`

**Resolution**: Configure a provisioning rule for the source.

## Aggregation Error

The following message displays during aggregation:

`Error - Exception during aggregation. Reason: Missing group schema for application SQLLoaderCSV [source-ID]`

**Resolution**: Check if a group schema is present. Contact the SailPoint services for validation.

## Test Connection Fails for an Incorrect Text File

The following error message displays for an incorrect text file:

`Driver is not valid The table structure of Text Table Directory_path\test_file.txt is unknown. Please use CREATE TABLE to define a table structure once.`

**Resolution**: Ensure that the following additional properties are used:

- `csvfileExtension=txt`
- Text in the `jdbc:text/ftp://<directory_path>` string.

## Timeout Error During Aggregation or Test Connection

During aggregation processes or test connections, the connector returns the following error, or something similar:

`Error: Timeout Interrupted Exception: beyond 1000 ms to open a table`

**Resolution**: Add the `lockTimeout` attribute to the SQL Loader source configuration as an Additional Connection Parameter. Refer to [Connection Settings](<https://documentation.sailpoint.com/connectors/sql_loader/va/help/connecting.html#connection-settings>).

1. Go to **Source Setup \> Query Settings \> account \> Connection Settings**.
2. In the **Additional Connection Parameter** field, enter the following:

   `lockTimeout=30000`

   > **Note**
   >
   > SailPoint recommends a setting of at least 30000 ms for remote connections. For more information, refer to the [HXTT document](<https://www.hxtt.com/text/installation.html#load:~:text=60-,lockTimeout,-To specify HXTT>) regarding the `lockTimeout` attribute.
3. Select **Save**.

## SFTP Server Test Connection Fails with Incorrect Data Files URL Error

Error message:

`[ ConnectionFailedException ] [ Possible suggestions ] Verify that location provided in Data Files URL is correct`

**Resolution**: Confirm that the data files URL entry is correct. If the data files are in the default folder, be sure to provide the complete path. If it is a relative folder, specify the path as a relative path. The URL is in the following format:

`jdbc:csv:/sftp://<domain/ip>>/<default folder>/<path to csv file>`

For example:

`jdbc:csv:/sftp://awsnedcidm091.na.corp.ipgnetwork.com/home/applications/test/`

`jdbc:csv:/sftp://awsnedcidm091.na.corp.ipgnetwork.com/../../opt/isc/applications/test/`

## Account Aggregation Fails for Connection Parameters Being Cached in Pool

**Resolution**: By default, pooling is disabled for test connections. For all other operations add the `pool.disablePooling` attribute and set the value to `true` using REST APIs.

## When Merging Is Enabled, the SQL Loader Connector Skips Unstructured Data When Aggregating from the Source File

When merging is enabled, the SQL Loader connector skips unstructured data when aggregating from the source file or displays the following error message even after data is sorted in the CSV file:

`Exception during aggregation. Reason: java.lang.RuntimeException: sailpoint.connector.ConnectorException: Data out of order exception. Data should be sorted in ascending order`

**Resolution**: Do one of the following:

- Add the following entry in the SQL Loader source XML file:

  ```xml
  <entry key="supportUnstructuredData">
      <value>
          <Boolean>true</Boolean>
      </value>
  </entry>
  ```
- The CSV file must be sorted.
- Order by clause is required in the query for aggregation as follows:

  `"select index_column,* from <csv file name> order by COLLATE(index_column,'GERMAN')"`

## Special Characters Like Ü, €, ö, ä, 管理 Don't Display Properly After Aggregation

**Resolution**: Ensure the encoding type of the CSV file is set to UTF-8. If not, change the encoding type to UTF-8, save it, and retry aggregation.