topic Re: Gets strange errors when trying to load table in Talend Studio

Gets strange errors when trying to load table

Anonymous — Wed, 13 Nov 2019 20:37:46 GMT

Hi!

When running the job without a target table and only us tlogrows as targets, the job works fine (as seen below)

But when I connect a target table I get some strange error, which seems to point at the extract from the source table (see below) What am I doing wrong? I use the same connection in source as in target. Anyone?

Re: Gets strange errors when trying to load table

Anonymous — Thu, 14 Nov 2019 04:14:44 GMT

Hi
Can you upload a screenshot of the basic settings of tDBInput and tDBOutput?

Regards
Shong

Re: Gets strange errors when trying to load table

Anonymous — Thu, 14 Nov 2019 20:53:49 GMT

Sorry for the late replay. Here are the source and target connections

DBInput Basic

DBOutput

What have I done wrong?

Regards

Patrik

Re: Gets strange errors when trying to load table

Anonymous — Fri, 15 Nov 2019 20:16:15 GMT

Anyone? Any idea?

Re: Gets strange errors when trying to load table

Anonymous — Sun, 17 Nov 2019 01:45:40 GMT

Hi PatrikLager
if you are using the same connection, why don't you select the same DB metadata connection in Repository list? I see one is localSQLServer, and another one is localMSServer. For testing, try to select the same DB metadata connection?

Regards
Shong

Re: Gets strange errors when trying to load table

Anonymous — Tue, 19 Nov 2019 03:11:55 GMT

Hi,

Its a good idea to have the connections ready first and then use those connection components in the subsequent DB components like Input and Output.

This will make sure that your connection to DB is fine at an earlier stage.

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