topic Re: [resolved] PALO output in Talend Studio

[resolved] PALO output

Anonymous — Sat, 16 Nov 2024 14:26:20 GMT

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

Re: [resolved] PALO output

Anonymous — Thu, 06 Mar 2008 14:51:31 GMT

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.

Re: [resolved] PALO output

Anonymous — Thu, 06 Mar 2008 15:30:56 GMT

Yes it work, thanks!

Re: [resolved] PALO output

Anonymous — Wed, 26 Mar 2008 15:30:43 GMT

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!

Re: [resolved] PALO output

Anonymous — Tue, 05 Aug 2008 16:51:36 GMT

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 ?

Re: [resolved] PALO output

Anonymous — Thu, 21 Aug 2008 11:19:54 GMT

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.

Re: [resolved] PALO output

Anonymous — Fri, 29 Aug 2008 17:03:41 GMT

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 ?

Re: [resolved] PALO output

Anonymous — Mon, 01 Sep 2008 09:25:05 GMT

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

Re: [resolved] PALO output

Anonymous — Mon, 01 Sep 2008 14:17:37 GMT

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.

Re: [resolved] PALO output

Anonymous — Mon, 01 Sep 2008 14:35:35 GMT

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

Re: [resolved] PALO output

_AnonymousUser — Mon, 11 May 2009 12:58:56 GMT

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)

Re: [resolved] PALO output

vladika — Fri, 11 Jun 2010 14:37:34 GMT

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

Re: [resolved] PALO output

Anonymous — Wed, 16 Jun 2010 07:37:26 GMT

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

Are you sure ?

Re: [resolved] PALO output

_AnonymousUser — Thu, 24 Jun 2010 08:29:28 GMT

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

Re: [resolved] PALO output

Anonymous — Wed, 04 Jul 2012 09:04:18 GMT

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