Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tCreateTable error

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.

0683p000009MaLq.png

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

Labels (2)
8 Replies
manodwhb
Champion II
Champion II

@dev323 ,can you share settings of tCreateTable_1 ?

manodwhb
Champion II
Champion II

@dev323 ,can you share settings of tCreateTable_1 ?

Anonymous
Not applicable
Author

Hi Manohar,

 

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

 

Roland

0683p000009MaMe.png0683p000009MaMt.png

Anonymous
Not applicable
Author

Hi Manohar,

 

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

 

Roland

0683p000009MaMe.png0683p000009MaMt.png

David_Beaty
Specialist
Specialist

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
Specialist
Specialist

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
Not applicable
Author

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
Not applicable
Author

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