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 ?
Article ID: KB0071398
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) [?:?]
=========
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) [?:?]
=========
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.
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
(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
Additional Information
Below Link explains the Type Detection Scheme property in detail:
http://cdn.cdata.com/help/CKE/jdbc/RSBCouchbase_p_TypeDetectionScheme.htm
http://cdn.cdata.com/help/CKE/jdbc/RSBCouchbase_p_TypeDetectionScheme.htm
Feedback
Yes
No
Powered by
