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:

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:

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.

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

    <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.

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.