False NULL values

Highlighted
Six Stars

False NULL values

Hi everyone

I come here with a problem I can't seem to solve no matter what i do.

I have a job in which i save data in a file (csv with "|" separator).

When i try to insert the data in my database (in the same job), i get the following error:

"ORA-01400: cannot insert NULL into ("MYDB"."ETABLISSEMENT"."ID_PMO")
Exception in component tDBOutput_1 (TransfertC_INIT_IEL_RG_TRT_09)
java.sql.SQLRecoverableException: Connexion interrompue"

But i checked my file and it does not contain a NULL value for this column, and it cannot contain one because it's a value i get from an inner join.

I've attached pictures of my job and map,

thanks for reading this and helping me.


Accepted Solutions
Nine Stars

Re: False NULL values

Hi,

 

I would adjust your job flow around about first of all to help see whats going on. remove the "On Component OK" between tFileOutputDelimited_1 and tFileInputDelimited_1, and drop this later section down under the larger subjob - instead, put an "On Subjob OK" between tDBInput_1 and tFileInputDelimited_1.

 

To trace the null insert problem, I'd deactivate tDBOutput_1 and all later steps and add in a tLogRow and see what is actually coming out of tMap_6

 

Hope this helps

 

Thanks

 

David

Regards David
Dont forget to give Kudos when an answer is helpful or mark the answer as the solution.

All Replies
Nine Stars

Re: False NULL values

Hi,

 

I would adjust your job flow around about first of all to help see whats going on. remove the "On Component OK" between tFileOutputDelimited_1 and tFileInputDelimited_1, and drop this later section down under the larger subjob - instead, put an "On Subjob OK" between tDBInput_1 and tFileInputDelimited_1.

 

To trace the null insert problem, I'd deactivate tDBOutput_1 and all later steps and add in a tLogRow and see what is actually coming out of tMap_6

 

Hope this helps

 

Thanks

 

David

Regards David
Dont forget to give Kudos when an answer is helpful or mark the answer as the solution.
Six Stars

Re: False NULL values

Thank you very much, actually adding the "onSubJobOk" solved my problem.

I think the tFileOutput2 didn't had the time  to close before lauching the subjob and this solved it.

Thanks again

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Downloads and Trials

Test drive Talend's enterprise products.

Downloads