topic Re: Scenario based Question in Talend??? in Talend Studio

Scenario based Question in Talend???

Prasanna3 — Sat, 16 Nov 2024 07:44:45 GMT

I have csv file loading data into oracle data base while loading i am getting below error.

please check the job design and error screen shot.

Re: Scenario based Question in Talend???

iamabhishek — Thu, 30 Aug 2018 13:20:46 GMT

The error clearly states that the table "ACTOR3" doesn't have any column named "actor_id". You need to make sure of the table schema and perform your task.

Re: Scenario based Question in Talend???

brama — Thu, 30 Aug 2018 13:22:42 GMT

The error text clearly tells that there is not actor_id column in the table. Please add this column in the table schema and then run the jobs.

Thanks,

Ram

Re: Scenario based Question in Talend???

TRF — Thu, 30 Aug 2018 13:29:04 GMT

Read the error messages first

Re: Scenario based Question in Talend???

Prasanna3 — Thu, 30 Aug 2018 13:33:34 GMT

Yes

i read the error and i also defined the schema but still i am getting error.

Re: Scenario based Question in Talend???

Prasanna3 — Thu, 30 Aug 2018 13:34:32 GMT

Yes

i read the error and i also defined the schema but still i am getting error.

i am getting this error for only loading oracle database i can able to load data successfully into MySQL database

Re: Scenario based Question in Talend???

iamabhishek — Thu, 30 Aug 2018 14:37:46 GMT

It's not about you have defined the schema or not. It's about the Oracle table that you are referring here in your Talend Job. That table doesn't have the column - so either create the column first in the destination table and load or remove the column from your schema definition and then load.

Re: Scenario based Question in Talend???

Anonymous — Thu, 30 Aug 2018 20:20:27 GMT

Hi,

The Actor3 target table do not have the column you are trying to load. You can verify the table structure in Oracle by

DESCRIBE <tablename>

select * from <tablename>

If you are still facing the issue, could you please share the table structure screen shot and your component details screen shot?

Warm Regards,

Nikhil Thampi

Re: Scenario based Question in Talend???

Anonymous — Thu, 07 Feb 2019 18:39:09 GMT

In tDBBulkExec check for the column actor_ID exists in the table Actor3