Records not getting inserted in tOracleOutput

[Anonymous]

Hi Team,

I am trying to insert records in Oracle database and have developed a job. Upon running it is success and showing the number of records but in the database it is empty and no records loaded. Please need your advice and attached the screen shots .

Thanks in advance,

Kind regards,

Sathish

[Anonymous]

Hi Sathish,

     I would recommend two minor changes in your job.

a)  Select Die on Error option to make sure that the data is loading correctly without any error.

b) Another step you will have to do is to add a tOracleCommit and connect it to tOracleOutput using On Component Ok.

These changes should give you better results.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

Thanks Nikhil, it is working now after adding tOracleCommit, but out of 4 records only 3 records getting inserted but in the job it is showing 4 records, your advice will be very helpful.

Thanks in advance,

Kind regards,

Sathish

[Anonymous]

Hi,

    Could you please check whether the key columns are same for two records? Also could you please share the component screen shot to verify whether you are using only insert or both insert+update?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

Hi Nikhil,

1|Sathish|BUSS_ATTR1
2|Prasad|BUSS_ATTR2
3|Shashin|BUSS_ATTR3
4|Sharwin|BUSS_ATTR4
5|Suresh|BUSS_ATTR5
6|Shiva|BUSS_ATTR6

This is my data, and whenever I am adding new records with a new key the last record is not getting inserted. Attaching the screenshot of the tOracleOutput properties.

Thanks in advance,

Kind regards,

Sathish

Untitled.jpg

[Anonymous]

Hi Nikhil,

And upon running the job it is showing the actual number, but in the DB the last record is missing. Attached the screen shot for details.

Thanks in advance,

Kind regards,

Sathish 

Job details.jpg

[Anonymous · Accepted solution]

Hi Sathish,

     You have added tOracleCommit before tOracleOutput. Could you please add the Commit component either using "On SubJob Ok" or "On Component Ok" like shown below?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

Hi Nikhil,

Thanks very much for your input, it is working fine now. 

Kind regards,

Sathish