cancel
Showing results for 
Search instead for 
Did you mean: 

Trace "validating transformation file"

Former Member
0 Kudos
91

Hello,

In data manager, I'm validating transformation file against the master data hierarchy BW InfoObj, but it fails


[Start validating transformation file]

Validating transformation file format

Validating options...

Validation of options was successful.

Validating mappings...

Validation of mappings was successful.

Validating conversions...

Validation of the conversion was successful

Creating the transformation xml file. Please wait...

Transformation xml file has been saved successfully.

Begin validate transformation file with data file...

[Start test transformation file]

Validate has successfully completed

Validation with data file failed

Using Fiddler I can see the following error:

500 SAP Internal Server Error

ERROR: Invalid access to a string (offset too large) (termination: RABAX_STATE)

How can I find out on which data field it occurs? How can I trace this validation process?

BPC SPS 05 on NW7.40

Transformation file:


*OPTIONS

FORMAT = DELIMITED

HEADER = YES

DELIMITER = ,

AMOUNTDECIMALPOINT = .

SKIP = 1

SKIPIF =

VALIDATERECORDS=YES

CREDITPOSITIVE=YES

MAXREJECTCOUNT=

ROUNDAMOUNT=

SUPPRESSCHARACTER=

*MAPPING

NODENAME=*STR(CC_)+NODENAME

HIER_NAME=HIER_NAME

PARENT=*STR(CC_)+PARENT

ORDER=ORDER

*CONVERSION

HIER_NAME=BW_COST_CENTER_HIER_CONV.XLS!CONVERSION

NODENAME=BW_COST_CENTER_HIER_CONV.XLS!NODENAME

PARENT=BW_COST_CENTER_HIER_CONV.XLS!NODENAME

Conversion file:


Conversion sheet:

EXTERNAL INTERNAL FORMULA
10001000 PARENTH1


Nodename sheet:

EXTERNAL INTERNAL FORMULA
* js:%external%.toString().replace(/%/g,'_').split('/').join('_')


PARENTH1 hierarchy exists in BPC dimension

10001000 is the one from BW

Thanks!

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

so, there is no way to find out what actually failed?

Former Member
0 Kudos

Hi Nerijus,

Can you please try below things

1.DELIMITER = tab ,SKIP=0(not Sure)

2.In *mapping section,please include all dimensions as per UJN_S_HIER_NODE structure.

Regards,

Naresh