error after altering sample project

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

weissenborn

Trainee

Posts: 3

Date of registration: Aug 24th 2009

Monday, August 24th 2009, 7:10pm

error after altering sample project

Hi,
I am new to Palo, but experienced with ETL. My first choice was to import a sample project, I choose importBiker. Running etlclient finished with:
Completed successfully. Fine!

So I want to see what data went into the server. In the connections I found the palo server configured. I changed it to SqlServer and insert the necessary data to link a newly created database. Hit Test -> fine! Save changes ok. But rerunning etlclient finishes with:
ERROR [main] (RemoteClient.java:327) - Failed to execute importBiker.jobs.default: null

What is wrong? What has to be altered too? Why the error message is meaningless?

I using latest versions downloaded today, August 24th.
Greets,
weissenborn

This post has been edited 2 times, last edit by "weissenborn" (Aug 24th 2009, 7:12pm)

Go to the top of the page

axi

Sage

Posts: 661

Date of registration: Mar 5th 2009

Location: Germany / Bargteheide

Occupation: BI

Monday, August 24th 2009, 7:31pm

sqlserver is a completely different animal than Palo.

You almost certainly have to change (offer table) the way the export is structured.

There should be more error messages ...
You might post the full output here or in pastebin

You can also save the whole project as XML and post the diff here so we know more what you are talking about.

Go to the top of the page

weissenborn

Trainee

Posts: 3

Date of registration: Aug 24th 2009

Monday, August 24th 2009, 7:48pm

Hi axi,

Quoted

Originally posted by axi
You almost certainly have to change (offer table) the way the export is structured.

I thought the (built in) example ran with Palo and therefore also runs with every connectable/available "thing".

Quoted

Originally posted by axi
There should be more error messages ...
You might post the full output here or in pastebin

I am sorry, but no.
Here the full lines from client/logs/etlclient.log:
2009-08-24 18:54:10,501 INFO main com.jedox.etl.client.CLIClient - Options: -p importBiker
2009-08-24 18:54:11,579 ERROR main com.jedox.etl.client.RemoteClient - Failed to execute importBiker.jobs.default: null

I also add the exported project.

Regards,
weissenborn

Go to the top of the page

axi

Sage

Posts: 661

Date of registration: Mar 5th 2009

Location: Germany / Bargteheide

Occupation: BI

Tuesday, August 25th 2009, 11:04am

here is your diff:

Source code

9c9
<     <connection name="biker" type="Sqlserver">
---
>     <connection name="biker" type="Palo">
11,14c11,14
<       <port>1433</port>
<       <database>paloBiker</database>
<       <user>sa</user>
<       <password encrypted="true">dI2QCxvvWB8CiTvan8x7hg==</password>
---
>       <port>7777</port>
>       <user>admin</user>
>       <password encrypted="true">cFju7JN3KyVmTPxIbDA/1w==</password>
>       <database>Biker_ETL</database>

As I wrote: you have to "speak" (T-)SQL to sqlserver.

The jobs/ETL-server speak Palo-API which cannot work.

You have to change the jobs. Can be done.
Starting point: ETL-Server 1.3 documentation in the commercial packages from the Jedox website.