How to resolve error message 'DDL support has not been configured.', when a DDL command is being run from a client on a published data source in TIBCO Data Virtualization?
book
Article ID: KB0072733
calendar_today
Updated On:
Products
Versions
TIBCO Data Virtualization
All supported versions
Description
You may come across the below error message while running a DDL command from a client on a published resource in TIBCO Data Virtualization. --------------------------- [Code: 1906510, SQL State: ] An exception occurred when executing the following query: "CREATE TABLE AAKASH(PID BIGINT, EID BIGINT)". Cause: DDL support has not been configured. [Log ID: dc4c41c4-aa53-46aa-a577-e0151b54189a] [jdbc-1906510] ---------------------------
In the above example, the below query was run to create a table in the end database. The query was run from a JDBC client tool - DbVisualizer. --------------------------- CREATE TABLE TEST(PID BIGINT, EID BIGINT); ---------------------------
Environment
All supported environment
Resolution
To get rid of this error and to create a table, you can follow the below steps:
Go to the published resource. e.g. /services/databases/snowflake
Right-click and open the database.
Select the Composite DDL tab from the database page.
Specify the physical data source container paths for which needs to be mapped to published catalogs and schemas.
Browse to select the Database physical container path. e.g. /shared/Test/Snowflake-Div-InHouse/ds_snowflake-Test/TEST_DB/TEST
Be specific while defining the path. If the path does not contain a leaf container then an error message can be seen while running the DDL command. e.g. If the path is specified till the datasource name itself - /shared/Test/Snowflake-Div-InHouse/ds_snowflake-Test
--------------------------- [Code: 1906510, SQL State: ] An exception occurred when executing the following query: "CREATE TABLE TEST(PID BIGINT, EID BIGINT)". Cause: Invalid container path: Container /shared/Test/Snowflake-Div-InHouse/ds_snowflake-Test must be a leaf container. [Log ID: bb8bd2a4-e77c-417d-8703-c95b5bc9794c] [jdbc-1906510] ---------------------------
Once the path has been configured correctly, save the settings and execute the DDL command.
Issue/Introduction
This article explains how to resolve the error message in a client tool like DbVisualizer when you run a DDL command on a published resource in TIBCO Data Virtualization.