Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
@dev323 ,can you share settings of tCreateTable_1 ?
@dev323 ,can you share settings of tCreateTable_1 ?
Hi Manohar,
Thanks for the quick reply. Attached some screenshots of the settings (for some reason my earlier reply did not come through)
Roland
Hi Manohar,
Thanks for the quick reply. Attached some screenshots of the settings (for some reason my earlier reply did not come through)
Roland
Hi,
Typically a failure on tCreateTable is one of 2 things:
Hi,
Typically a failure on tCreateTable is one of 2 things:
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
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