The "variant" data type is not supported

Identity Security Cloud (ISC) ISC Discussion and Questions
,
1

Hi,

We are getting below error in JDBC account aggregation in production IDN

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The "variant" data type is not supported.
        at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:191)
        at com.microsoft.sqlserver.jdbc.TypeInfo$Builder$16.apply(dtv.java:3143)
        at com.microsoft.sqlserver.jdbc.TypeInfo$Builder.build(dtv.java:3305)
        at com.microsoft.sqlserver.jdbc.TypeInfo.getInstance(dtv.java:3371)
        at com.microsoft.sqlserver.jdbc.StreamColumns.setFromTDS(StreamColumns.java:201)
        at com.microsoft.sqlserver.jdbc.SQLServerResultSet$1CursorInitializer.onColMetaData(SQLServerResultSet.java:225)
        at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:87)
        at com.microsoft.sqlserver.jdbc.SQLServerResultSet.<init>(SQLServerResultSet.java:320)
        at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1666)
        at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:440)
        at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:385)
        at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7505)
        at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2445)
        at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:191)
        at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:166)
        at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:367)
        at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94)
        at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94)
        at sailpoint.connector.JDBCConnector.executeStatement(JDBCConnector.java:2577)
        ... 20 more

It may be driver issue but the same jar is working in Sandbox environment

2

Hi @ashishbhatia
I understand that the same jar is working in the sandbox environment. Can you try once with the latest JDBC Driver for SQL Server in Prod?

3

Yes @rajeshs , we are working on it parallely. Posted here hoping someone else might have encountered the same. I believe the target systems might have upgraded but that too team is yet to confirm.

4

Hi @ashishbhatia

Yes I have seen this issue previously and was able to resolve by latest JDBC Driver. The reason is Sandbox being the lower environment doesn’t have Prod like data.

1 Like
5

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.