How to resolve error: "Resource CIS/Couchbase [TABLE/DATABASE_TABLE] does not have columns" when introspecting new resources in TIBCO Data Virtualization with Couchbase adapter ?
book
Article ID: KB0071398
calendar_today
Updated On:
Products
Versions
TIBCO Data Virtualization
All Supported versions
Description
After establishing a successful connection to the Couchbase adapter in TIBCO Data Virtualization (TDV) Studio, you may encounter the following error when attempting to introspect new tables from the database:
---------------------------- WARNING - CIS/Couchbase/xigp Error occurred introspecting new resource. Resource not introspected ---------------------------- ERROR - CIS/Couchbase/xigp ADD Failed: java.lang.Exception: Resource CIS/Couchbase/xigp [TABLE/DATABASE_TABLE] does not have columns ---------------------------
While introspecting new resources from the Couchbase adapter in TIBCO Data Virtualization (TDV) Studio we see the below entries in the cs_server.log: ========= ERROR [WorkerThread-Low-598] 2022-07-19 16:52:58.996 +0000 IntrospectionStatus - null java.lang.Exception: Resource CIS/Couchbase/xigp [TABLE/DATABASE_TABLE] does not have columns at com.compositesw.cdms.datasource.extensions.relational.ExtensionJdbcIntrospector2.introspectTables(ExtensionJdbcIntrospector2.java:429) ~[csmodule_datasource.jar:?] at com.compositesw.cdms.datasource.introspect.AbstractIntrospector2.introspectResources(AbstractIntrospector2.java:425) ~[csserver.jar:?] at com.compositesw.cdms.datasource.introspect.IntrospectionDriver.processResourceBatchToAddInternal(IntrospectionDriver.java:905) [csserver.jar:?] at com.compositesw.cdms.datasource.introspect.IntrospectionDriver$1.call(IntrospectionDriver.java:776) [csserver.jar:?] at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?] at java.lang.Thread.run(Thread.java:834) [?:?] =========
Environment
All Supported Environments
Resolution
To address the encountered issue, follow the solution provided below:
(1) From TDV studio, open the Couchbase data source connection. (2) Change the configuration 'Type Detection Scheme' property to 'Infer' instead of 'DocType' in the Advanced tab.
(3) Save changes and re-introspect the new resources
Issue/Introduction
This article provides steps to resolve the error message "Resource CIS/Couchbase [TABLE/DATABASE_TABLE] does not have columns" that occurs when attempting to introspect new resources in TIBCO Data Virtualization using the Couchbase adapter.