topic Re: tDBInput not passing all fields in Talend Studio

tDBInput not passing all fields

JayQueue — Fri, 15 Nov 2024 23:16:30 GMT

Hello,

I have a tDBinput query with this schema:

(Also, why are alfrescoId and messageId orange?)

This is connected to a tWriteJsonField.

The connection row has the fields

But when I do a traces debug I only see "messageId" passing. But I need to pass the alfrescoId as well to the end of job

What am I doing wrong?

TIA

Jonathan

Re: tDBInput not passing all fields

Anonymous — Tue, 25 Jan 2022 18:44:52 GMT

What are the DB column types of those orange columns? What DB are you using?

Re: tDBInput not passing all fields

JayQueue — Wed, 26 Jan 2022 08:29:21 GMT

It's MS SQL and those columntypes in the DB are UNIQUEIDENTIFIER.

MessageId passes but AlfrescoId doesn't

Re: tDBInput not passing all fields

Anonymous — Wed, 26 Jan 2022 11:31:01 GMT

OK, I cannot test this myself as at the moment, I have no access to a MS SQL db. But can you try changing the type to byte[] (for the orange "DB Type" issue)? This may not sort that, but a uniqueidentifier is closer aligned to a byte array. With regard to you not getting a value, can you show your SQL query? Obviously hide anything that shouldn't be shown. Also, have you run the same query in a query analyser to see that the result is returned?

Re: tDBInput not passing all fields

JayQueue — Wed, 26 Jan 2022 12:26:27 GMT

The query is:

"SELECT top(5) wanneer, overwie, alfrescoid, messageid FROM table ORDER BY wanneer DESC"

But the question is why alfrescoId is not passing through, messageId is going just fine as a String..

Job should do:

Query db for 3 fields, use 2 of them to create a json and the 3rd is a unid for an object that I use to update this with the 2 other fields.

But I seems to forget the 3rd field. With GlobalVar it only shows me the last one

Re: tDBInput not passing all fields

Anonymous — Wed, 26 Jan 2022 14:36:23 GMT

Have you run the same query using a query analyser and seen that a value is definitely returned? Also, your schema seems to have more columns than your query. Your query should reference the same columns that appear in your schema and in the same order.

This will be an error in configuration somewhere. Can you take a screenshot of your db component showing the query and the schema?

Re: tDBInput not passing all fields

JayQueue — Thu, 27 Jan 2022 07:16:15 GMT

Yes it gets everything.

I tested with a tHashOutput/Input.

And tested with an extra JSON field .

{

---SNIP----

"content": [{

"messageId": "privacyshizzle so removed",

"_alfrescoid": "B7861FC6-4311-41BD-B4FB-B91BC51CB150",

}

and after the writejsonfield alfrescoid is empty

Re: tDBInput not passing all fields

Anonymous — Thu, 27 Jan 2022 14:13:47 GMT

So the value is only missing after the tWriteJsonField component? Why has your alfrescoid field got a leading "_" in the JSON shown above?