topic Re: tCreateTable error in Talend Studio

tCreateTable error

Anonymous — Tue, 07 Jul 2020 17:53:17 GMT

Hi,

I have a createtable statement in my job with a 'create table if not exists' that works well on its own.

However when I put another trunjob after it, it will give me an error message.

See screenshot for setup.

If I run the job, I get the following error message:

Exception in component tCreateTable_1 (job_load_dim_party_inc)
java.lang.RuntimeException: Creating table failed
at poc_revenue_data_mart.job_load_dim_party_inc_0_1.job_load_dim_party_inc.tCreateTable_1Process(job_load_dim_party_inc.java:980)
at poc_revenue_data_mart.job_load_dim_party_inc_0_1.job_load_dim_party_inc.tDBConnection_1Process(job_load_dim_party_inc.java:805)
at poc_revenue_data_mart.job_load_dim_party_inc_0_1.job_load_dim_party_inc.tChronometerStart_1Process(job_load_dim_party_inc.java:590)
at poc_revenue_data_mart.job_load_dim_party_inc_0_1.job_load_dim_party_inc.runJobInTOS(job_load_dim_party_inc.java:1887)
at poc_revenue_data_mart.job_load_dim_party_inc_0_1.job_load_dim_party_inc.main(job_load_dim_party_inc.java:1632)
Caused by: java.lang.NullPointerException
at poc_revenue_data_mart.job_load_dim_party_inc_0_1.job_load_dim_party_inc.tCreateTable_1Process(job_load_dim_party_inc.java:956)
... 4 more
[FATAL] 12:51:52 poc_revenue_data_mart.job_load_dim_party_inc_0_1.job_load_dim_party_inc- tCreateTable_1 Creating table failed
java.lang.RuntimeException: Creating table failed
at poc_revenue_data_mart.job_load_dim_party_inc_0_1.job_load_dim_party_inc.tCreateTable_1Process(job_load_dim_party_inc.java:980) [classes/:?]
at poc_revenue_data_mart.job_load_dim_party_inc_0_1.job_load_dim_party_inc.tDBConnection_1Process(job_load_dim_party_inc.java:805) [classes/:?]
at poc_revenue_data_mart.job_load_dim_party_inc_0_1.job_load_dim_party_inc.tChronometerStart_1Process(job_load_dim_party_inc.java:590) [classes/:?]
at poc_revenue_data_mart.job_load_dim_party_inc_0_1.job_load_dim_party_inc.runJobInTOS(job_load_dim_party_inc.java:1887) [classes/:?]
at poc_revenue_data_mart.job_load_dim_party_inc_0_1.job_load_dim_party_inc.main(job_load_dim_party_inc.java:1632) [classes/:?]
Caused by: java.lang.NullPointerException
at poc_revenue_data_mart.job_load_dim_party_inc_0_1.job_load_dim_party_inc.tCreateTable_1Process(job_load_dim_party_inc.java:956) ~[classes/:?]
... 4 more

Roland

Re: tCreateTable error

manodwhb — Wed, 08 Jul 2020 05:01:16 GMT

@dev323 ,can you share settings of tCreateTable_1 ?

Re: tCreateTable error

manodwhb — Wed, 08 Jul 2020 05:01:16 GMT

@dev323 ,can you share settings of tCreateTable_1 ?

Re: tCreateTable error

Anonymous — Thu, 09 Jul 2020 15:00:38 GMT

Hi Manohar,

Thanks for the quick reply. Attached some screenshots of the settings (for some reason my earlier reply did not come through)

Roland

Re: tCreateTable error

Anonymous — Thu, 09 Jul 2020 15:00:38 GMT

Hi Manohar,

Thanks for the quick reply. Attached some screenshots of the settings (for some reason my earlier reply did not come through)

Roland

Re: tCreateTable error

David_Beaty — Thu, 09 Jul 2020 17:59:05 GMT

Hi,

Typically a failure on tCreateTable is one of 2 things:

You dont have DDL permission where you're trying to create the table
The schema you are using is incomplete, missing DB data types, column lengths, etc.

Re: tCreateTable error

David_Beaty — Thu, 09 Jul 2020 17:59:05 GMT

Hi,

Typically a failure on tCreateTable is one of 2 things:

You dont have DDL permission where you're trying to create the table
The schema you are using is incomplete, missing DB data types, column lengths, etc.

Re: tCreateTable error

Anonymous — Thu, 09 Jul 2020 18:19:54 GMT

The only thing is that on its own it works fine so, it's able to create the DDL with the permissions and the data types are fine as well.

Roland

Re: tCreateTable error

Anonymous — Thu, 09 Jul 2020 18:19:54 GMT

The only thing is that on its own it works fine so, it's able to create the DDL with the permissions and the data types are fine as well.

Roland