You are not logged in.

CSV to Palo; error message

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.

lesuere

Professional

  • "lesuere" started this thread

Posts: 22

Date of registration: Nov 10th 2009

  • Send private message

1

Tuesday, November 10th 2009, 2:11pm

CSV to Palo; error message

Hi.

I'm using PALO ETL Server and i've got a error message while trying import data by flat file into the Olap Server.


See error message below:

2009-11-10 12:16:04,800 INFO [job NeuJob] (ExecutionState.java:125) - Starting execution of job NeuJob
2009-11-10 12:16:04,800 INFO [job NeuJob] (ExecutionState.java:130) - Parameter failOnError: true
2009-11-10 12:16:04,800 INFO [job NeuJob] (ExecutionState.java:130) - Parameter logLimit: 100
2009-11-10 12:16:04,831 INFO [job NeuJob] (CubeLoad.java:445) - Starting load NeuerLoad of Cube Hauptbuch
2009-11-10 12:16:04,831 INFO [job NeuJob] (TableSource.java:208) - Data retrieval from extract Extract_a_csv
2009-11-10 12:16:07,987 INFO [job NeuJob] (Processor.java:161) - Committing datastore Import_csv.connections.Connect_CSV
2009-11-10 12:16:09,487 INFO [job NeuJob] (CubeLoad.java:429) - Loading data to datastore Neu.Hauptbuch
2009-11-10 12:16:09,534 WARN [job NeuJob] (MessageHandler.java:91) - Coordinate Vorgang not found in dimension vorgang
2009-11-10 12:16:12,550 INFO [job NeuJob] (Processor.java:161) - Committing datastore Neu.Hauptbuch
2009-11-10 12:16:15,706 INFO [job NeuJob] (CubeLoad.java:117) - Data vectors loaded: 0
2009-11-10 12:16:15,722 INFO [job NeuJob] (CubeLoad.java:450) - Finished load NeuerLoad of Cube Hauptbuch. Filled cells changed from 0 to 0.
2009-11-10 12:16:15,722 INFO [job NeuJob] (ExecutionState.java:147) - Finished execution of job NeuJob with status: Completed with Warnings

Does anyone have any experience with this?

Thanks.

lesuere

Professional

  • "lesuere" started this thread

Posts: 22

Date of registration: Nov 10th 2009

  • Send private message

2

Tuesday, November 10th 2009, 2:15pm

RE: CSV to Palo; error message:Coordinate Vorgang not found in dimension vorgang

Hi.

I'm using PALO ETL Server and i've got a error message while trying import data by flat file into the Olap Server.


See error message below:

2009-11-10 12:16:04,800 INFO [job NeuJob] (ExecutionState.java:125) - Starting execution of job NeuJob
2009-11-10 12:16:04,800 INFO [job NeuJob] (ExecutionState.java:130) - Parameter failOnError: true
2009-11-10 12:16:04,800 INFO [job NeuJob] (ExecutionState.java:130) - Parameter logLimit: 100
2009-11-10 12:16:04,831 INFO [job NeuJob] (CubeLoad.java:445) - Starting load NeuerLoad of Cube Hauptbuch
2009-11-10 12:16:04,831 INFO [job NeuJob] (TableSource.java:208) - Data retrieval from extract Extract_a_csv
2009-11-10 12:16:07,987 INFO [job NeuJob] (Processor.java:161) - Committing datastore Import_csv.connections.Connect_CSV
2009-11-10 12:16:09,487 INFO [job NeuJob] (CubeLoad.java:429) - Loading data to datastore Neu.Hauptbuch
2009-11-10 12:16:09,534 WARN [job NeuJob] (MessageHandler.java:91) - Coordinate Vorgang not found in dimension vorgang
2009-11-10 12:16:12,550 INFO [job NeuJob] (Processor.java:161) - Committing datastore Neu.Hauptbuch
2009-11-10 12:16:15,706 INFO [job NeuJob] (CubeLoad.java:117) - Data vectors loaded: 0
2009-11-10 12:16:15,722 INFO [job NeuJob] (CubeLoad.java:450) - Finished load NeuerLoad of Cube Hauptbuch. Filled cells changed from 0 to 0.
2009-11-10 12:16:15,722 INFO [job NeuJob] (ExecutionState.java:147) - Finished execution of job NeuJob with status: Completed with Warnings

Does anyone have any experience with this?

Thanks.

Phil_Ro

Master

  • "Phil_Ro" is male

Posts: 39

Date of registration: Aug 24th 2009

Location: Frankfurt, Germany

Occupation: BI Consulting

Hobbies: Flying, Biking

  • Send private message

3

Tuesday, November 10th 2009, 2:19pm

he can't find the coordinate "vorgang" in your dimension, so it seems the value doesn't exist. Maybe it's named differently in the dimension ?

lesuere

Professional

  • "lesuere" started this thread

Posts: 22

Date of registration: Nov 10th 2009

  • Send private message

4

Tuesday, November 10th 2009, 2:46pm

@Phil Ro

First, thanks for your answer.

No it doesn't, the dimension named vorgang, but the value is empty.
Can you tell me how the change the settings in the ETL Server for a successfull import?

Phil_Ro

Master

  • "Phil_Ro" is male

Posts: 39

Date of registration: Aug 24th 2009

Location: Frankfurt, Germany

Occupation: BI Consulting

Hobbies: Flying, Biking

  • Send private message

5

Tuesday, November 10th 2009, 3:44pm

actually, this is just a warning, the job did complete. It should return all other rows which do have correct coordinates, which is in your case none :)

So it found a dimension named "vorgang" and there it looks for the value "Vorgang" in the key column.

Can you tell us more about your dimension "vorgang" ?

axi

Sage

Posts: 661

Date of registration: Mar 5th 2009

Location: Germany / Bargteheide

Occupation: BI

  • Send private message

6

Tuesday, November 10th 2009, 4:25pm

Just add the element "Vorgang" to your dimension "Vorgang".

And like Phil_Ro wrote - tell us a little about your desired outcome and the design of your cube.
Rate this thread