Error Failed parse transformation file:only whitespace allowed

[Former Member]

Hi Experts,

Could you help to solve this issue ,I am getting the following error when I run the transformation file to load data from my DSO in SAP BW to my application in BPC .

[Start validating transformation file]

Validating format of transformation file

Validating optionsu2026

Validation on options was successful

Validating mappingsu2026

Validation on mappings was successful

Validating conversionsu2026

Validation on conversions was successful

Creating the transformation xml file; wait a moment

Transformation xml file saved successfully

Connecting to server...

Begin validate transformation file with data fileu2026

[Start test transformation file]

Validate has successfully completed

Failed parse transformation file:only whitespace allowed;

Error: Validate with data file failed

Thanks

[krishna_priya1]

Cross check technical names of each dimension & DSO . Do copy paste of technical names instead of typing by yourself .All technical names should be in capitals.

[Former Member]

Hi,

This is the script that I am using :

*OPTIONS

FORMAT = DELIMITED

HEADER = YES

DELIMITER =

AMOUNTDECIMALPOINT = .

SKIP = 0

SKIPIF =

VALIDATERECORDS=YES

CREDITPOSITIVE=YES

MAXREJECTCOUNT=

ROUNDAMOUNT=

SELECTION=/CPMB/LQD4Q4Z,PRC_INDEX001

*MAPPING

P_Category=/CPMB/LQD5CKB

P_Entity=*NEWCOL(QG)

P_Snapshot=/CPMB/LQD6T01

Time=ZPRCDATE

P_Index=/CPMB/LQD4Q4Z

/CPMB/SDATA=ZMEPPRICE

*CONVERSION

[krishna_priya1]

I can see that VALIDATERECORDS=YES .When this option is enabled,If the import file has an extra field that is not mapped, all records are rejected during validation. http://help.sap.com/saphelp_bpc75/helpdata/en/5A/69200C88AA40C9B18844A25259F147/frameset.htm

Try with VALIDATERECORDS=NO

Edited by: pkrishnas on Oct 27, 2011 5:41 PM

[Former Member]

Hi ,

I tried with VALIDATERECORDS=NO but stll have the same error

Regards

[former_member208963]

Old post, but i had same situation with coworker some time ago...

I was writing the tranformation file name, when saving it, with invalid characters.

example:

tranfor_2014.01.xls

should be for exmaple:

tranfor201401.xls

hope someone find helpful this, searched this message and found this unsolved post!

[NVChaitanya]

failed parse transformation file: only white space allowed.

This error also appearing in case you are not connected to correct environment.

I was connected to consolidation environment and was getting similar error. When i logged in to planning environment error disappeared.

Also make sure when saving transformation file do not add any space or special character in name.

[Former Member]

Hi ,

Can you please check if there are any spaces before dimension names in transformation file.

If yes pls remove the spaces and save them and then start validating. Thanks.

Regards,

Sanjeev