cancel
Showing results for 
Search instead for 
Did you mean: 

Command failed ; end position is out of record index when load hierarchy in SAP BPC from BW

avbravo
Explorer
0 Kudos

Hello

I'm trying to load a hierarchy rom BW to BPc and this error appears when I execute the package

Could you help me please?

Accepted Solutions (0)

Answers (7)

Answers (7)

former_member186338
Active Contributor
0 Kudos

Instead of Transformation file with XXX(x:y) use conversion file with JS string manipulations. In JS you don't need to use fixed positions.

avbravo
Explorer
0 Kudos

Hello,

for the load the base member (p.e P01600101) I use the following TF

And the CF associated is

In the hierarchy, each node appears only once.

Regards

N1kh1l
Active Contributor
0 Kudos

Bravo,

Hierarchy load also depends on the base member load which you would have done before ( to load P01600101 etc. ) Please post that transformation file too. Also show what's there in your conversion file.

Also could you tell if node name appear only once in the hierarchy. You can check this by searching for e.g. P016001 in your hierarchy. You should get only one hit.

-Nikhil

avbravo
Explorer
0 Kudos

Hello, I've tried what you explained, and now the error is different

Any idea?

Thanks

N1kh1l
Active Contributor
0 Kudos

Bravo,

Your node name for e.g. P016001 is of 7 characters only.

NODENAME(1:1) = P

NODENAME(2:3) = 01

NODENAME(4:7) = 6001

NODENAME(8:9) = Error (range out of index)

Try correcting that. I think youe dont need that last NODENAME(8:9)

Regards

Nikhil



avbravo
Explorer
0 Kudos

Ok, thisi is my transformation file

And this is the hierarchy in BW

Thanks a lot!

N1kh1l
Active Contributor
0 Kudos

Bravo,

Kindly post a screenshot of your transformation file being used. This happens when you refer to specific character length of field and that length is not correct. Also may be your nodename length is not consistent in BW

Nikhil