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.

holke

Trainee

  • "holke" is male
  • "holke" started this thread

Posts: 2

Date of registration: Jan 25th 2009

  • Send private message

1

Tuesday, January 27th 2009, 2:52pm

4001 cirular reference found parent in list of children

I am trying out Palo and the Palo Kettle plugin. I get the following error:

Failed to add dimension rows
failed to create consolidation: Onbekend
4001 cirular reference found parent in list of children

I get this message when I try to import data into a Palo Dimension using the Palo Kettle plugin. Does anybody have an idea what this message means or what is going wrong. A link to an error reference manual would be welcome aswell.

I suppose something is wrong with the data but I don't know which record is given the problem. So if somebody knows something about error handling for the Kettle Palo plugin, please let me know.

Any help is welcome

thanx in advance

Holke

csae1603

Intermediate

Posts: 15

Date of registration: Jun 28th 2008

  • Send private message

2

Tuesday, January 27th 2009, 4:34pm

RE: 4001 cirular reference found parent in list of children

hi holke,

your problem record is: Onbekend

this element already exists as a child element.

@error reference: the kettle plugin shows you every time what is wrong. you have to read the error message carefully!!


greats
csae1603

holke

Trainee

  • "holke" is male
  • "holke" started this thread

Posts: 2

Date of registration: Jan 25th 2009

  • Send private message

3

Tuesday, January 27th 2009, 11:07pm

RE: 4001 cirular reference found parent in list of children

Thanks for the response.

I prefixed the values so now the values are unique.

Why must the child values be different from the parent values ? Is this something specific for MOLAP ? In ROLAP I never met this restriction.

csae1603

Intermediate

Posts: 15

Date of registration: Jun 28th 2008

  • Send private message

4

Wednesday, January 28th 2009, 8:44am

RE: 4001 cirular reference found parent in list of children

hi holke,

because molap has to know in which cell (please notice that palo is cell-based) the data should be stored. if it is not unique.....where should it be stored ?? (yes, i think this is molap specific)

greats
markus

Posts: 85

Date of registration: Sep 25th 2008

Location: Oakville, ON

  • Send private message

5

Wednesday, January 28th 2009, 8:58am

Hi,

it is not actually the value that has to be different, you need a unique hierarchy. Parent element can't be the childs child element:

Quoted


- Element1
-- Element2
--- Element 1

Rate this thread