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?

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:
  1. Go to the published resource. e.g. /services/databases/snowflake
  2. Right-click and open the database.
  3. Select the Composite DDL tab from the database page.
  4. Specify the physical data source container paths for which needs to be mapped to published catalogs and schemas.
  5. Browse to select the Database physical container path. e.g. /shared/Test/Snowflake-Div-InHouse/ds_snowflake-Test/TEST_DB/TEST
  6. 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.