topic Re: TCreateTable error in Talend Studio

TCreateTable error

Anonymous — Tue, 16 Apr 2019 11:35:41 GMT

Hi,

I wanted to create a table with the script if the table doesn't exist. I didn't know how to give the script instead I used TCreateTable Component and edited the schema manually and gave "Drop table if exists and Create" for Table Action.

When I tried to run, the following error occurred:

Exception in component tCreateTable_1 (create_table)
java.lang.RuntimeException: Creating table failed
at local_project.create_table_0_1.create_table.tCreateTable_1Process(create_table.java:399)
at local_project.create_table_0_1.create_table.runJobInTOS(create_table.java:832)
at local_project.create_table_0_1.create_table.main(create_table.java:681)
Caused by: java.lang.NullPointerException
at local_project.create_table_0_1.create_table.tCreateTable_1Process(create_table.java:385)
... 2 more

Am I missing out anything? Kindly advice on this further. Thanks in advance.

Thanks,

Sowmiya R

Re: TCreateTable error

David_Beaty — Tue, 16 Apr 2019 11:40:56 GMT

Hi,

You might have a couple of things to check here:

The user you're connecting as has permission to create tables in the required DB schema
The schema within Talend for the Create Table is complete (all data types and field lengths are entered).

Re: TCreateTable error

Anonymous — Tue, 16 Apr 2019 11:45:22 GMT

Hi @dsoulalioux ,

Yes, Instead of using the existing connection I manually entered the connection credentials and created the table. Kindly let me know how to create an index for the created table by using Script. I used TDBRow and its throwing null pointer exception error.

Thanks,

Sowmiya R

Re: TCreateTable error

manodwhb — Tue, 16 Apr 2019 11:48:23 GMT

@sowmi333 ,is that script is working form outside of Talend?

Re: TCreateTable error

Anonymous — Tue, 16 Apr 2019 11:51:54 GMT

Hi @manodwhb ,

Yes it's working perfectly fine while executing in the front end tool.

Thanks,

Sowmiya R

Re: TCreateTable error

manodwhb — Tue, 16 Apr 2019 11:59:44 GMT

@sowmi333 ,can you show me the job design and the component of tDBRow?

Re: TCreateTable error

manodwhb — Tue, 16 Apr 2019 12:21:53 GMT

@sowmi333 ,I believe you might have not provided schema name or some other parameter in tDBrow