tCreateTable error

[Anonymous]

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

[manodwhb]

@dev323 ,can you share settings of tCreateTable_1 ?

[manodwhb]

@dev323 ,can you share settings of tCreateTable_1 ?

[Anonymous]

Hi Manohar,

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

Roland

[Anonymous]

Hi Manohar,

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

Roland

[David_Beaty]

Hi,

Typically a failure on tCreateTable is one of 2 things:

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

[David_Beaty]

Hi,

Typically a failure on tCreateTable is one of 2 things:

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

[Anonymous]

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

[Anonymous]

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