#1 2011-03-05 05:07:05

LC
Guest

[resolved] tDenormalize depends on missing tArrayIn?

Hi,

I keep getting the following errors when attempting to use tDenormalize in TOS 4.0 (and also 4.1):

"This component depend on component tArrayIn, but it's not exist."  (The error message really is grammatically incorrect.)
"OnRowsEndStructtDenormalize_1 cannot be resolved."

I thought it was the fact that I was trying to use a tMysqlInput as the input into the tDenormalize, but even when I switched to a very simple tFileInputDelimited and set everything up like the RG example, I get the same error.  Upgrading to the latest TOS didn't fix anything either.

What am I missing?

Please advise ASAP.

Best regards,
LC

#2 2011-03-07 07:02:03

shong
Talend team
Registered: 2007-08-29
Posts: 10357
Website

Re: [resolved] tDenormalize depends on missing tArrayIn?

Hi LG
I test it on v4.1.x and it works, please upload some screenshots of your job.

Best regards
Shong


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!

Offline

#3 2011-03-07 19:16:29

LC
Guest

Re: [resolved] tDenormalize depends on missing tArrayIn?

Content of Text File:
[img]http://o.aolcdn.com/os/testing/temp/fathersAndSons-Text[/img]

Job Design (tFileInputDelimited --> tDenormalize --> tLogRow):
[img]http://o.aolcdn.com/os/testing/temp/tFileInputDelimited-tDenormalize-Design[/img]

Component View for tFileInputDelimited:
[img]http://o.aolcdn.com/os/testing/temp/tFileInputDelimited-Component[/img]

Component View for tDenormalize:
[img]http://o.aolcdn.com/os/testing/temp/tDenormalize-Component[/img]

Schema for tDenormalize:
[img]http://o.aolcdn.com/os/testing/temp/tDenormalize-Schema[/img]

#4 2011-03-07 21:15:56

LC
Guest

Re: [resolved] tDenormalize depends on missing tArrayIn?

By the way, the "This component depend on component tArrayIn, but it's not exist." error shows up as soon as I drag the tDenormalize component from the Palette to the Design grid.  So I get a red X that never goes away on the tDenormalize component.

The "This component should have input link(s)." warning goes away as soon as I connect the tFileInputDelimited.

#5 2011-03-07 23:21:25

LC
Guest

Re: [resolved] tDenormalize depends on missing tArrayIn?

Ugh. 
I solved it. 
Restarting didn't fix it.
Upgrading didn't fix it.
There was nothing wrong with how I set up the job.

I decided to see what would happen if I created a new project and tried using tDenormalize there.  It worked fine, so I determined there must be something wonky within the current project I was using.

I then went back to my current project and compared the Project properties.  I noticed that under File > Edit Project Properties > Designer > Palette Settings, the new Project had Technical/tArrayIn, etc. under the Hide Column, while my current Project had it under the Show column.  I don't actually see the Technical component group in my Palette anyway, so I moved it to the Hide column as well to see if it made a difference.  It did not.  I moved it back to the Show column, and the Generation Engine started re-running itself, the Technical folder actually did show in my Palette, and the red X next to my tDenormalize finally disappeared.

I tried to run my basic tFileInputDelimited --> tDenormalize --> tLogRow job, but then tFileInput Delimited suddenly had an error about "org.talend" being undefined or something.  I moved some more folders back and forth in Palette Settings, and next time I ran the job, it was finally successful.

I don't really know why the Generation Engine wouldn't have picked up the correct Palette settings from the beginning.  I do know the project has been upgraded through a few TOS versions under both Mac and PC.
 
In any case, thanks anyway,
LC

Board footer

Powered by FluxBB