[resolved] PALO output

[Anonymous]

Hi,
I try to import data from a MySQL database to PALO, but when I run a test job (with a delimited file instead of MySQL), Talend said :
" Starting job export_palo at 14:15 06/03/2008.
Error paloIXjava.lang.UnsatisfiedLinkError: no paloIX in java.library.path
Exception in thread "main" java.lang.UnsatisfiedLinkError: org.talend.palo.paloIX.initX()I
Error paloIXjava.lang.UnsatisfiedLinkError: no paloIX in java.library.path
at org.talend.palo.paloIX.initX(Native Method)
at org.talend.palo.paloIX.init(paloIX.java:33)
at org.talend.palo.paloIX.initAndConnect(paloIX.java:53)
at overview.export_palo.export_palo.tFileInputDelimited_1Process(export_palo.java:201)
at overview.export_palo.export_palo.runJobInTOS(export_palo.java:1466)
at overview.export_palo.export_palo.main(export_palo.java:1384)
Job export_palo ended at 14:15 06/03/2008. "
I do not know if my job is wrong (I do not have any example to help me because the documentation does not include tPaloOutput component...), so there are some screenshots of my job and my PALO database...
The schema have been propagated to the two components and the configuration of the PALO server is good.
Somebody could help me to make my test job work please?
Thanks.
Fabien

[Anonymous · Accepted solution]

Hi,
It may work : copy paloIX.dll file ( located in the plugins\org.talend.designer.components.localprovider_xxx\components\tPaloOutput ) in your windows/system32 directory.

[Anonymous]

Yes it work, thanks!

[Anonymous]

How will evolve the Palo component?
Its features are limited compared to server possibilities : no hierarchy definition, replacing data only, ... I hope features will be increased soon!

[Anonymous]

Hi,
I work on Windows 2000 and I have the same problem.
I put the "paloIX.dll" in my system32 directory but now I have this message :
Starting job Job_Cube_Palo at 17:20 05/08/2008.
connecting to socket on port 3583
connected
Exception in thread "main" java.lang.UnsatisfiedLinkError: org.talend.palo.paloIX.initX()I
at org.talend.palo.paloIX.initX(Native Method)
at org.talend.palo.paloIX.init(paloIX.java:33)
at org.talend.palo.paloIX.initAndConnect(paloIX.java:53)
at palo.job_cube_palo_0_1.Job_Cube_Palo.tPostgresqlInput_1Process(Job_Cube_Palo.java:1597)
at palo.job_cube_palo_0_1.Job_Cube_Palo.runJobInTOS(Job_Cube_Palo.java:1862)
at palo.job_cube_palo_0_1.Job_Cube_Palo.main(Job_Cube_Palo.java:1770)
Error paloIXjava.lang.UnsatisfiedLinkError: C:\WINNT\system32\paloIX.dll: Can't find dependent libraries
Error paloIXjava.lang.UnsatisfiedLinkError: C:\WINNT\system32\paloIX.dll: Can't find dependent libraries
Job Job_Cube_Palo ended at 17:40 05/08/2008.
I try to put all files from "plugins\org.talend.designer.components.localprovider_xxx\components\tPaloOutput" in system32 and system directory but nothing change
Somebody could help me please ?

[Anonymous]

It seems that you must add the libpalo2.dll in your windows\system32 folder.
This DLL can be found in the directory installed by Palo.

[Anonymous]

Thanks it's work but now I have :
Starting job Job_Cube_Palo at 17:59 29/08/2008.
connecting to socket on port 3731
connected
Exception in component tPaloOutput_1
java.lang.IllegalArgumentException: Libpalo_ng : Database not found : Could not resolve 'test' as Database (Error -34)
at org.talend.palo.paloIXConnection.loadDatabaseX(Native Method)
at org.talend.palo.paloIXConnection.getDatabase(paloIXConnection.java:39)
at palo.job_cube_palo_0_1.Job_Cube_Palo.tPostgresqlInput_1Process(Job_Cube_Palo.java:1602)
at palo.job_cube_palo_0_1.Job_Cube_Palo.runJobInTOS(Job_Cube_Palo.java:1862)
at palo.job_cube_palo_0_1.Job_Cube_Palo.main(Job_Cube_Palo.java:1770)
disconnected
Job Job_Cube_Palo ended at 18:00 29/08/2008.

"Create Element if not exist and Save Cube at end process" are cheked
I try to add other *.dll but it doen't work
Have you got a solution ?

[Anonymous]

I think it's a problem with the configuration of PALO ... have you set up a database named 'test' ?

[Anonymous]

I have set a database call "test" en a cube call "test" too
Now I have :
Starting job Job_Cube_Palo at 15:15 01/09/2008.
connecting to socket on port 3484
connected
Exception in component tPaloOutput_1
java.lang.NullPointerException
at palo.job_cube_palo_0_1.Job_Cube_Palo.tPostgresqlInput_1Process(Job_Cube_Palo.java:1672)
at palo.job_cube_palo_0_1.Job_Cube_Palo.runJobInTOS(Job_Cube_Palo.java:1862)
at palo.job_cube_palo_0_1.Job_Cube_Palo.main(Job_Cube_Palo.java:1770)
disconnected
Job Job_Cube_Palo ended at 15:16 01/09/2008.

[Anonymous]

Run your job in trace mode or debug... I don't have any idea of how PALO works ...