Exception during aggregation. Reason: java.lang.RuntimeException: sailpoint.connector.ConnectorException: The TDS protocol stream is not valid. Unexpected token unknown token (0xA3)

IdentityIQ (IIQ) IIQ Discussion and Questions
,
1

We are integrated MSSQL application with SailPoint IIQ using JDBC connector. We are getting following error when trying to do the account aggregation.
Exception during aggregation. Reason: java.lang.RuntimeException: sailpoint.connector.ConnectorException: The TDS protocol stream is not valid. Unexpected token unknown token (0xA3).

IIQ version :
8.0p4

Test connection is working successful and account preview also getting same error.

3

Hi @jchinnapareddy,

which version of MSSQL have you integrated? maybe is no supported by sp8.0p4 Comp. Matrix

Also, you can try to update the library of mssql. MSSQL driver

4

It was worked previously , After upgraded to SQL2019. It started this error.

5

I am not sure SP 8.0 support MSSQL 2019.

Did you try to update the library?

6

Yes i tried different JDBC driver jar still getting same issue.

7

We are also getting same error, please let us if any update.

8

@sampathdamera This could be possibly due to encryption mismatch between iiq and mssql. You might want to try setting the explicitly encryption parameters in your application configuration. Try appending it in the URL : jdbc:sqlserver://:;databaseName=;encrypt=true;trustServerCertificate=true; I know this works when define in iiq.properties to connect with IIQ’s MSSQL Db but never tried it in application configuration. Please see if it helps.

Note: Found a fix? Help the community by marking the comment as solution. Feel free to react(:heart:, :+1:, etc.) with an emoji to show your appreciation or message me directly if your problem requires a deeper dive.