How to resolve "Server Error: [Canary Labs][DSI] (20029) Function not supported" error in TIBCO Data Virtualization?

book

Article ID: KB0073486

calendar_today

Updated On:

Products	Versions
TIBCO Data Virtualization	All supported versions

Description

After upgrading the TIBCO Data Virtualization (TDV) Server from 7.0.x version to 8.x, the introspection to Canary Labs data warehouse using the ODBC-JDBC bridge adapter may encounter the below error:

***cs_server.log***

ERROR [introspect-resourceids-82639-1] 2021-02-24 20:39:05.914 +0000 AbstractIntrospector2 - Error during introspection of child resources for data source / [DATA_SOURCE/RELATIONAL_DATA_SOURCE]
java.sql.SQLException: [Canary Labs][DSI] (20029) Function not supported.
    at cdata.jdbc.jdbcodbc.OdbcSql.checkSQLError(Unknown Source)
    at cdata.jdbc.jdbcodbc.OdbcSql.checkSQLError(Unknown Source)
    at XcdataXjdbcodbcX190X7362.mec.checkError(Unknown Source)
    at XcdataXjdbcodbcX190X7362.mec.getProcedures(Unknown Source)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    at XcdataXjdbcodbcX190X7362.flc.invoke(Unknown Source)
    at com.sun.proxy.$Proxy148.getProcedures(Unknown Source)
    at com.cdata.cis.jdbcodbc.JDBCODBCMetadata.getProcedures(Unknown Source)
    at com.compositesw.cdms.datasource.extensions.relational.ExtensionJdbcIntrospector2.getIntrospectableResourceChildIds(ExtensionJdbcIntrospector2.java:867)
    at com.compositesw.cdms.datasource.introspect.AbstractIntrospector2$1.run(AbstractIntrospector2.java:231)
    at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
    at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
    at java.base/java.lang.Thread.run(Thread.java:834)