You are not logged in.

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.

Li_ode

Professional

  • "Li_ode" started this thread

Posts: 16

Date of registration: Feb 5th 2008

Location: odessa

  • Send private message

1

Monday, September 28th 2009, 11:55am

add project to the server

Hi All
Please, Help to understand

1.I use ETL Comand Line Client(ETL 3.0)
etlclient.bat - a samples\importBiker (for examp.)
- this command add project to the ETL server only.
To transfer on olap server, it is necessary to start jobs.
etlclient.bat - psamples\importBiker --- this command - Error,
How to transfer the project at once on palo olap server?
2.question
After addition on a server ETL server importRelDB, job name "Cubedata" and job name "Default" result is "Warning" or Error.The same when add my own projects.
And in my project on palo olap server "cube" and "dimensions" are not filled.

Thanks

axi

Sage

Posts: 661

Date of registration: Mar 5th 2009

Location: Germany / Bargteheide

Occupation: BI

  • Send private message

2

Monday, September 28th 2009, 2:05pm

You should tell us, where your ETL-server is running.

etlclient -s your-server -ls

lists the projects available.


For the server any datafiles are relative to .../etlserver3b/webapps/etlserver/data/projects/files

Hard to get it right the first time...

Another option might be http://your-server:7775/web-etl/ in your Firefox browser but still: take care where the actual files reside.

Li_ode

Professional

  • "Li_ode" started this thread

Posts: 16

Date of registration: Feb 5th 2008

Location: odessa

  • Send private message

3

Monday, September 28th 2009, 5:09pm

Thanks for answer.
I have moved a file *.csv to a folder ../etlserver3b/webapps/etlserver/data/projects/files
"Another option might be http://localhost:7775/web-etl/" -
- add the project, start jobs,
but on palo olap server "cube" and "dimensions" are not filled yet.
and the command etlclient.bat -p samples\importBiker(Biker - for examp.) does not work - "Failed to execute samples \importBiker.jobs.default: Project samples\importBiker not found"

"etlclient -s localhost -ls
lists the projects available." - works

axi

Sage

Posts: 661

Date of registration: Mar 5th 2009

Location: Germany / Bargteheide

Occupation: BI

  • Send private message

4

Tuesday, September 29th 2009, 9:25am

You have to work the pathnames very carefully - try a fully qualified path.

Li_ode

Professional

  • "Li_ode" started this thread

Posts: 16

Date of registration: Feb 5th 2008

Location: odessa

  • Send private message

5

Monday, October 12th 2009, 3:07pm

thank you, All works, except:
etlclient.bat - p importBiker (for examp.)- ERRor - - "Failed to execute importBiker.jobs.default: Project importBiker not found"
etlclient.bat - a importBiker (for examp.)- works, export to ETL server, all jobs are successful.

It is temporary mistake on a ETL server or it is necessary to do something with "jobs.default"?

I want to transfer the project on palo olap server at once (With the help of 1 command)

thank you for any help

This post has been edited 1 times, last edit by "Li_ode" (Oct 12th 2009, 3:08pm)


Rate this thread