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

Resolution: Run the data extraction process before proceeding with the single aggregation. For more information, refer to Manually Updating MS SQL Database with Imprivata EAM Data.
Test Connection Failure
If a test connection fails, it may be due to one of the following errors:

Resolution: Ensure the Provisioning Systems Adaptor Name is correct and exists in the Imprivata EAM managed system. For more information, refer to Provisioning System Adaptor Settings Requirements.

Resolution: Ensure the Provisioning Systems Adaptor is enabled. For more information, refer to Provisioning System Adaptor Settings Requirements.

The following error message occurs during the test connection:
[ ConnectionFailedException ] [ Possible suggestions ] Ensure that the host is accessible. [ Error details ] Failed to connect to the Imprivata EAM System. Connect to <Imprivata Server Ip>:443<IPAddress> failed: Connection refused (Connection refused)
Resolution: Ensure the host URL is correct and the host is running.

The following error message occurs:
Error - encrypt" property is set to "true" and "trustServerCertificate" property is set to "false" but the driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption
Resolution: Append the following in your Database URL: ;encrypt=true;trustServerCertificate=true

The following error message occurs:
Error - [ ConnectorException ]
[ Possible suggestions ] Please check the SQL syntax and database connection.
[ Error details ] Failed to execute the database query. 'STRING_AGG' is not a recognized built-in function name.
Resolution: Verify the Microsoft SQL Server version. The supported versions for the Imprivata EAM integration are Microsoft SQL Server 2017 and later. The STRING_AGG
function is not recognized as a built-in function in versions of Microsoft SQL Server prior to 2017. Microsoft SQL Server 2016 and earlier versions do not support this function. For more information on supported MS SQL versions, refer to Supported Managed Systems.
Single Account Aggregation Failure

Resolution: Run the Data Extraction process before proceeding with the single aggregation.
Enabling Account Failure

When the userDisabled
attribute is not specified or its value is set to false, the new user is treated as enabled in the SPML request. Imprivata EAM integration further checks the domain user setting and user license availability. If both the SPML request and the Imprivata EAM domain user setting enable the new user, but the user license limit is exceeded, the new user is created but disabled.
Resolution: Check if the license limit is exceeded and try again.