One Star

Netezza Connection

I am trying to connect to a Netezza DB and just do a simple query.
I am getting a successful connection in my tNetezzaInput component, because when I click the Table Name selector, I can choose my table from the database.
When I click "Guess Schema" it spins for a second and then I get an error "Failed to Generate Code".
If I put in my own query: "SELECT COL1 FROM RS_TEST2" and try and run the job, I get an error:
Execution failed : Failed to generate code.


------------------
Any help would be much appreciated!
Frank
16 REPLIES
Four Stars

Re: Netezza Connection

Hi Frank,
Can you query the database using the user through other means? Whether the user has select permissions?
http://dba-valley.blogspot.in/2013/03/basic-user-administration-commands-in.html
Vaibhav
One Star

Re: Netezza Connection

Yes I can query the database just fine with either NZSQL on the host or using the Aginity client.
One Star

Re: Netezza Connection

nzjdbc is also installed, if that is a question too. Same error happens with jre 1.6 and jre 1.8.
Four Stars

Re: Netezza Connection

JDK/JRE may not be an issue, reason is you are able to connect...
You are using BD so - If you are using Talend Open Studio for Big Data, only the Built-in mode is available.
Have you referred to - https://help.talend.com/search/all?query=tELTNetezzaInput&content-lang=en
One Star

Re: Netezza Connection

I don't understand... are you saying that the tNetezzaInput component does NOT work with the BD version of Talend Open Studio and that I have to use the tELTNetezzaInput component instead?
Four Stars

Re: Netezza Connection

Not actually... I gave some sample which was explaining that we need to create matadata for your input... You can also use ELT component as well.
https://help.talend.com/search/all?query=tNetezzaInput&content-lang=en
There also they say that - tNetezzaInput executes a DB query with a strictly defined order which must correspond to the schema definition. Then it passes on the field list to the next component via a Main row link.
One Star

Re: Netezza Connection

There is only a single column in my table and it cannot generate the code for that schema, and I don't know what to do in order to make that work.
I have tried manually creating a schema (using the Edit Schema button) that matches it, but I get the same error. So either way, Talend is not able to use/create the right metadata to use downstream.
Four Stars

Re: Netezza Connection

Can you put the screenshot with metadata for your input and output component along with the sample data in your table?
One Star

Re: Netezza Connection

Here is a snapshot of my job.
Sample data is just a single row with a 1 in it.
One Star

Re: Netezza Connection

Here is the output component.
Four Stars

Re: Netezza Connection

Port number is integer column and not a string... remove double quotes
Is there any specific reason for having double quotes around col1??
Can you bring a query on single line and test again?
One Star

Re: Netezza Connection

Removed double quotes from port number.
Removed double quotes from COL1 and put all all same line.
I still get the same error message.
One Star

Re: Netezza Connection

Is Talend BD compatible with Java JRE 1.8?
Four Stars

Re: Netezza Connection

See if instructions in following post helps you.
http://www.talendforge.org/forum/viewtopic.php?id=35832
Vaibhav
One Star

Re: Netezza Connection

The simple answer for anyone else following...
Talend BD is not compatible with Java 1.8. Uninstall all other versions of Java and Re-install 1.7 and this now works fine.
Frank
Four Stars

Re: Netezza Connection

Thanks for BIG conclusion Frank.