topic Re: [resolved] Exception in component tPostgresqlOutput_1 java.lang.NullPointerExcept in Talend Studio

[resolved] Exception in component tPostgresqlOutput_1 java.lang.NullPointerExcept

_AnonymousUser — Fri, 29 Nov 2013 09:15:19 GMT

Hello,
I have a strange error when i deploy my job to linux server:
Exception in component tPostgresqlOutput_1
java.lang.NullPointerException
at dpma.unit_test_export_postgresql_0_1.unit_test_export_postgresql.tSybaseInput_1Process(unit_test_export_postgresql.java:582)
at dpma.unit_test_export_postgresql_0_1.unit_test_export_postgresql.runJobInTOS(unit_test_export_postgresql.java:1118)
at dpma.unit_test_export_postgresql_0_1.unit_test_export_postgresql.main(unit_test_export_postgresql.java:986)
It work in local mode on win32 but not in the server
It take one field one table from sybase and dump it to postgresql, same schema, same table. (work on win32 localhost)
How can i handle that error

Re: [resolved] Exception in component tPostgresqlOutput_1 java.lang.NullPointerExcept

Anonymous — Fri, 29 Nov 2013 19:22:45 GMT

You have not enough info provided to get help. Your stack trace is understandable only if the reader knows the job.
If you want help, show use a screen shot of your job and the properties of the component tPostgresqlOutput_1.

Re: [resolved] Exception in component tPostgresqlOutput_1 java.lang.NullPointerExcept

_AnonymousUser — Mon, 02 Dec 2013 08:30:34 GMT

Here some pics for the job:

Re: [resolved] Exception in component tPostgresqlOutput_1 java.lang.NullPointerExcept

Anonymous — Mon, 02 Dec 2013 08:33:50 GMT

Hi davchx,
You'd better register and log in as a Community member first, then you'll get a Image upload box that allows to upload screen captures ( 20 images per post, each image must be less then 1024x768 pixels and 200 KB).
The screenshots link are unavailable for us.
Best regards
Sabrina

Re: [resolved] Exception in component tPostgresqlOutput_1 java.lang.NullPointerExcept

Anonymous — Mon, 02 Dec 2013 08:45:03 GMT

Here some pics for the job:
So i repeat, this is just a POC to test if i can get data from Sybase to PostgreSQL, win32 OK, but on the server KO

Re: [resolved] Exception in component tPostgresqlOutput_1 java.lang.NullPointerExcept

Anonymous — Mon, 02 Dec 2013 08:56:55 GMT

Hi,
If you use tSybaseConnection and t PostgreSQLConnection, why there is no connection type(connector) between them?
That means:tSybaseConnection PostgreSQLConnection
| |
OnComponentOK OnComponentOK
| |
tSybasetInput----->tPostgresqlOutput
That probably cause the java.lang.NullPointerException. Please see scenario in tMysqlConnection how to link component.
Best regards
Sabrina

Re: [resolved] Exception in component tPostgresqlOutput_1 java.lang.NullPointerExcept

Anonymous — Mon, 02 Dec 2013 09:20:34 GMT

It work, my mistake, design error...
Thanks!

Re: [resolved] Exception in component tPostgresqlOutput_1 java.lang.NullPointerExcept

Anonymous — Tue, 03 Dec 2013 02:43:15 GMT

Hi,
Thanks for your feedback. Feel free post your issue on forum.
Best regards
Sabrina