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.

User or Role Filter Error

The following error message displays:

Exception during aggregation of Object Type account on Application OracleERP. Reason: Unable to create iterator sailpoint.connector.ConnectorException: { "Errors" : [ { "description" : "PER_IIP_209:Page Mode not supported when querying against database and OID attributes", "code" : "501" } ] }

Resolution: Update the filter query to use the Oracle-supported filter combinations with pagination support. For more information on pagination and filters, refer to the Oracle SaaS documentation. In the search box, type Financials REST API manage collection, this will provide documentation related to filters and pagination in the manage collection link.

Delete account fails with an error message

The following error message displays:

java.lang.UnsupportedOperationException: Delete operation is not supported. For details or troubleshooting, refer to the connector documentation.

Resolution: Set the enableDeleteUserAccount connector attribute to true on the source with the Update Source (Partial) API:

[
  {
    "op": "add",
    "path": "/connectorAttributes/enableDeleteUserAccount",
    "value": true
  }
]

Error message appears for Test Connection, Aggregation or Provisioning operations

The following error message displays:

Exception: sailpoint.connector.ConnectorException: [ ConnectorException ] [ Error details ] javax.net.ssl.SSLPeerUnverifiedException: peer not authenticated

Resolution: Update the openJDK version to 11.0.3 or later.

An error message appears when assigning data access to user

The following error message displays:

openconnector.InvalidRequestException: Role <Role Name> is not assigned to a user, cannot process data access: <Role Name>$<Security Context>$<Security context value>

Resolution: To assign the Data Access, ensure that the corresponding role is assigned to a user.

For example, to assign the Accounts Payable ManagerBusiness unitAccount_BU user Data Access, you need to assign the Accounts Payable Manager role to it.

Create/Modify operation fails with an error message when passing the personNumber in the provisioning plan

The operation fails with the following error message:

Another user has changed the row with primary key oracle.jbo.Key[300000027193775 ].

OR

Applying List binding LOV_PersonNumber with given set of values

Resolution: Add the following attribute using REST API - Update Source (Partial) in SailPoint and then, try creating a user with personNumber.

  • Key= retryWaitTime Value= 60000 in ms, default: 30000 ms
  • Key=maxRetryCount Value=3, default: 3
  • Key=retryableErrors Value=[error messages]

Note

The default error messages are, Applying List binding LOV_PersonNumber with given set of values and Another user has changed the row with primary key. If you do not specify any other error message, the connector will use the default error messages and retry.

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.