You are not logged in.

PaloException: (1007)... what is the problem?

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.

DominikP

Intermediate

  • "DominikP" is male
  • "DominikP" started this thread

Posts: 12

Date of registration: Jan 4th 2011

Location: Stuttgart

  • Send private message

1

Wednesday, February 2nd 2011, 10:41am

PaloException: (1007)... what is the problem?

Hello everybody,

I always get this warning when I try to load my jobs.

2011-02-02 10:23:59,878 WARN : Failed to load Cube Auswertung DiVerSBI: com.tensegrity.palojava.PaloException: (1007) error converting a string to a number, string has illegal characters

The only thing I changed is, that a column who used to be a dimension (I deleted the TreeFH, the Load and the Job of it) is now a consolidated element of another dimension.

For example, I have 2 dimensions "Arbeitspaket" and "Aufgabe", "Aufgabe" is no longer a dimension itself, it is now a consolidated element of "Arbeitspaket".

Where is my mistake? Do I have to provide you with more informations so you can help me?

Regards

DominikP

tish1

Sage

Posts: 761

Date of registration: Jul 13th 2009

Location: Vienna / Austria

Occupation: Senior Consultant @ Vector SW DV GmbH

  • Send private message

2

Wednesday, February 2nd 2011, 1:41pm

Hi,

do you import data from a flat file? If so, you might get problems if you have thousand delimiters in your values.

Regards.
Robert Tischler
Senior Consultant Vector SW DV GmbH

DominikP

Intermediate

  • "DominikP" is male
  • "DominikP" started this thread

Posts: 12

Date of registration: Jan 4th 2011

Location: Stuttgart

  • Send private message

3

Wednesday, February 2nd 2011, 1:56pm

I import my data from 2 *csv documents.

What I did change now, I "transformed" all my TreeHC to TreePC Transforms, I think this is also an improvement, isn't it?

(In the most cases I have a Parent Element, for example "Alle Jahre" which is static and a consolidated Element "Jahr".... only in one case I have 2 non-static elements which get their value from the *csv)


My guess is, according to the problem descritpion from palo, there is somewhere a string defined value which should be an "integer"... ?

tish1

Sage

Posts: 761

Date of registration: Jul 13th 2009

Location: Vienna / Austria

Occupation: Senior Consultant @ Vector SW DV GmbH

  • Send private message

4

Wednesday, February 2nd 2011, 3:37pm

Hi,

I think your problem starts when you import data to a cube, not during dimension creation.

Regards.
Robert Tischler
Senior Consultant Vector SW DV GmbH

DominikP

Intermediate

  • "DominikP" is male
  • "DominikP" started this thread

Posts: 12

Date of registration: Jan 4th 2011

Location: Stuttgart

  • Send private message

5

Thursday, February 3rd 2011, 1:56pm

Is it maybe possible that I upload the *xml of my project and you could take a quick look at it?

Cause im frustrating right now... I tried so many things the last 2 days and nothing worked :(

DominikP

Intermediate

  • "DominikP" is male
  • "DominikP" started this thread

Posts: 12

Date of registration: Jan 4th 2011

Location: Stuttgart

  • Send private message

6

Friday, February 4th 2011, 4:47pm

I guess I know what the problem is...

The 2 *csv datas contain different columns which create my dimensions... for example: "Projekt", "Arbeitspaket", "Aufgabe"...

The consolidation is like this "Projekt" -> "Arbeitspaket" -> "Aufgabe"

But... the first *csv, called "Buchung" contains more elements in the dimension "Arbeitspaket" then the other *csv "Schaetzung"... it is the same with the dimension "Arbeitspaket"...

How can I solve this problem? Do I have to make an aggregation somewhere or anything else???
Rate this thread