Hierarchy doesn't get updated

I have noticed that enough a hierarchy (in this instance a Cost Centre Mapping) update is uploaded, they don't get reflected or at least not all of them get reflected.

There were no rejected rows
Most (out of the 600+) of the Cost Centre mapping updates get applied but a few don't
I tried normalising the tree
executing the "fix" hierarchy as well

What could be the reason and how can i troubleshoot.

Find more posts tagged with

Accepted answers

All comments

Graeme Whorrall

Hi Chris,

There are a couple of reasons I can think of which may cause this:-

1) Is the feed might be overwriting it for example you may have a later line in which the hierarchy is missing in the feed. if it is SQL View that you are loading maybe try doing the view looking at one of the Cost centers causing you the issue might return multiple rows one with a missing hierarchy could cause the issue ( would probably be an issue with a join).

2) when normalising ensure the boxes are ticked to do the normalisation on the hierarchy in question.

Also noted you said you used the "fix" hierarchy is this the fix relationship in the relationship have known this to cause major issues when run and the child entities come out with >> signs in them, might be worth checking out if you have run this as a restore may be required.

Regards

Graeme

Previous Member

Hi Graeme,

I checked the file and all the rows are unique at CC level (which is the lowest level in the hierarchy). I use the DataView to check the hierarchy mapping.

Did try running the normalisation on all relevant trees but still no luck.

Regards

Chris

Graeme Whorrall

Hi Chris,

Just a few questions:-

Have you seen if any of the rows are rejected on the data reader?

On the data reader are you enabling an append on the codes?

Have you looked at the field to see if the code has spaces in it, maybe at the end?

Just trying to get to the bottom of this also does the code have any symbols? like ' etc

Regards

Graeme

Previous Member

No records rejected
Yes, append is enabled
No spaces and none with symbols like ' etc

Graeme Whorrall

Hi Chris,

Odd, so if you run the data reader only which sets the relationship the relationship is not set correctly?

How is the tree formed that it is trying to populate can you give me the entities and the ones which are been set by the file upload.

Is it just simple as in "Cost centre"--> "cost Center group" or is it multi layered like "Cost centre"--> "cost Center group" --> "cost center group sum"

maybe a picture of the structure and the file been upload may help identify what is causing the issue, if you can provide them?

Regards

Graeme