One Star

[resolved] PALO output

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
1 ACCEPTED SOLUTION

Accepted Solutions
Employee

Re: [resolved] PALO output

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.
14 REPLIES
Employee

Re: [resolved] PALO output

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.
One Star

Re: [resolved] PALO output

Yes it work, thanks!
One Star

Re: [resolved] PALO output

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! Smiley Happy
One Star orn
One Star

Re: [resolved] PALO output

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 ?
One Star

Re: [resolved] PALO output

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.
One Star orn
One Star

Re: [resolved] PALO output

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 ?
One Star

Re: [resolved] PALO output

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

Re: [resolved] PALO output

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.
One Star

Re: [resolved] PALO output

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

Re: [resolved] PALO output

Hi,
If you are interested in this topic and want to learn more on the interactions between talend and Palo solutions, attend one of the following webinars!
Open Source Data Analysis with Talend and Palo
This one-hour Webinar will present:
- How to extract your heterogeneous data with Talend and prepare it for reporting and multidimensional analysis
- How to centralize and manage high-performance Excel-based reporting and analysis with Palo
- How to get quick results and optimize your return on investment
- Why open source is the right solution for data analysis
in English : https://www2.gotomeeting.com/register/374537444 (19th of May 2009)
in French : https://www2.gotomeeting.com/register/624420639 (19th of May 2009)
in German : https://www2.gotomeeting.com/register/666108473 (13th of May 2009)
Four Stars

Re: [resolved] PALO output

What if I'm running it on Ubuntu 10.4 64bits ?
Tried to put:
/home/db/Documents/talendOS/plugins/org.talend.designer.components.localprovider_4.0.1.r41260/components/tPaloOutput/ PaloIX.jar
into
/usr/lib/jvm/java-6-sun/jre/lib
and
/usr/lib/jvm/java-6-sun/lib
as well, but I'm still getting the same error:
Exception in thread "main" java.lang.UnsatisfiedLinkError: org.talend.palo.paloIX.initX()I
One Star

Re: [resolved] PALO output

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

Are you sure ?
One Star

Re: [resolved] PALO output

How can I make hierarchies in Palo by using Talend? With tFixedFlowInput I can make some but I can't fill them with data from a database...
One Star

Re: [resolved] PALO output

Hello,

Exception in thread "main" java.lang.Error: java.lang.UnsatisfiedLinkError: org.talend.palo.paloIX.initX()I
at bdd_heg.test2_0_1.test2.tMysqlInput_1Process(test2.java:1421)
at bdd_heg.test2_0_1.test2.runJobInTOS(test2.java:1579)
at bdd_heg.test2_0_1.test2.main(test2.java:1471)
Caused by: 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 bdd_heg.test2_0_1.test2.tMysqlInput_1Process(test2.java:1275)
... 2 more

Error paloIXjava.lang.UnsatisfiedLinkError: C:\Windows\System32\paloIX.dll: Can't find dependent libraries
Error paloIXjava.lang.UnsatisfiedLinkError: C:\Windows\System32\paloIX.dll: Can't find dependent libraries
Job test2 terminé à 10:00 04/07/2012.

I have this error when i do exactely what is write on this site.
http://blog.developpez.com/talend/p5238/talend/tips-news/alimenter-un-cube-palo-avec-talend-open/
I need help please,
WillArrive
NB: I put already copy paloIX.dll in C:\Windows\System32