topic Records not getting inserted in tOracleOutput in Talend Studio

Records not getting inserted in tOracleOutput

Anonymous — Sat, 16 Nov 2024 05:41:09 GMT

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

Re: Records not getting inserted in tOracleOutput

Anonymous — Sun, 02 Jun 2019 17:38:09 GMT

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 🙂

Re: Records not getting inserted in tOracleOutput

Anonymous — Mon, 03 Jun 2019 14:48:58 GMT

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

Re: Records not getting inserted in tOracleOutput

Anonymous — Mon, 03 Jun 2019 18:28:32 GMT

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 🙂

Re: Records not getting inserted in tOracleOutput

Anonymous — Mon, 03 Jun 2019 18:58:00 GMT

Hi Nikhil,

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

Re: Records not getting inserted in tOracleOutput

Anonymous — Mon, 03 Jun 2019 19:08:43 GMT

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

Re: Records not getting inserted in tOracleOutput

Anonymous — Tue, 04 Jun 2019 03:57:08 GMT

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 🙂

Re: Records not getting inserted in tOracleOutput

Anonymous — Wed, 05 Jun 2019 15:45:06 GMT

Hi Nikhil,

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

Kind regards,

Sathish