SAP Knowledge Base Article - Preview

3169579 - Database issues - The "variant" data type is not supported

Symptom

background:

azure sql provided a read-only replica at premium level. OOTB uses the functionality at below part, please refer to the help page.

https://help.sap.com/viewer/0fa6bcf4736c46f78c248512391eb467/v1905/en-US/1c7d5dde153a45fc9af868244741c32c.html

when generic.search.read-replica.enabled=true by default

kibana log

{"instant":{"epochSecond":1647442785,"nanoOfSecond":20969000},"thread":"StatDaemonThread-master","level":"ERROR","loggerName":"de.hybris.platform.azure.hac.impl.collector.read_only.ReadOnlyDataSourceSecondaryReplicaLagCollector","message":"Failed to obtain secondary lag for read only-replica.","thrown":{"commonElementCount":0,"localizedMessage":"Failed to obtain JDBC Connection; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: The \"variant\" data type is not supported.","message":"Failed to obtain JDBC Connection; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: The \"variant\" data type is not supported.","name":"org.springframework.jdbc.CannotGetJdbcConnectionException","cause":{"commonElementCount":9,"localizedMessage":"The \"variant\" data type is not supported.","message":"The \"variant\" data type is not supported.","name":"com.microsoft.sqlserver.jdbc.SQLServerException","extendedStackTrace":[{"class":"com.microsoft.sqlserver.jdbc.SQLServerException","method":"makeFromDriverError","file":"SQLServerException.java","line":190,"exact":false,"location":"sqljdbc_4.0.2206.100.jar","version":"?"},{"class":"com.microsoft.sqlserver.jdbc.TypeInfo$Builder$16","method":"apply","file":"dtv.java","line":1996,"exact":false,"location":"sqljdbc_4.0.2206.100.jar","version":"?"},{"class":"com.microsoft.sqlserver.jdbc.TypeInfo$Builder","method":"build","file":"dtv.java","line":2158,"exact":false,"location":"sqljdbc_4.0.2206.100.jar","version":"?"},{"class":"com.microsoft.sqlserver.jdbc.TypeInfo","method":"getInstance","file":"dtv.java","line":2221,"exact":false,"location":"sqljdbc_4.0.2206.100.jar","version":"?"},{"class":"com.microsoft.sqlserver.jdbc.StreamColumns","method":"setFromTDS","file":"StreamColumns.java","line":46,"exact":false,"location":"sqljdbc_4.0.2206.100.jar","version":"?"},{"class":"com.microsoft.sqlserver.jdbc.SQLServerResultSet$1CursorInitializer","method":"onColMetaData","file":"SQLServerResultSet.java","line":217,"exact":false,"location":"sqljdbc_4.0.2206.100.jar","version":"?"},{"class":"com.microsoft.sqlserver.jdbc.TDSParser","method":"parse","file":"tdsparser.java","line":77,"exact":false,"location":"sqljdbc_4.0.2206.100.jar","version":"?"},


Read more...

Environment


Product version: SAP Commerce Cloud 1905.39

Product

SAP Commerce Cloud 1905

Keywords

KBA , CEC-SCC-PLA-PL , Platform , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.