Troubleshooting
Problem
This happens when the table name contains a dot (
.) between the table name. For example, a table namedtest.demowill trigger this issue.The JDBC Multitable Consumer origin does not support reading from tables that have dots in their names because it incorrectly interprets the dot as a schema separator rather than part of the table name.
Symptom
When attempting to validate or start a pipeline that reads records from a database table using the JDBC Multitable Consumer origin, below error message is encountered:
An exception occurred while running the pipeline, com.streamsets.datacollector.runner.PipelineRuntimeException: CONTAINER_0800 - Can't start pipeline due 1 validation error(s). First one: JDBC_641 - Could not retrieve the columns for table 'schema='<schema-name>',table='<table-name>'
Resolving The Problem
As a workaround, avoid using the JDBC Multitable Consumer origin for tables with dots in their names. Instead, use JDBC Query Consumer stage, which allows to explicitly query tables, including those with dots in their names.
Document Location
Worldwide
Was this topic helpful?
Document Information
Modified date:
15 March 2025
UID
ibm17186200