validation with data failed

[Former Member]

Hello Gurus,

I'm trying to load master data through flat file in BPC front end  getting below error while doing validate and Process Transformation file

"validation with data failed"  and the file format,Transformation options , Mapping  and error screen shots are below.

If any one know please help me where it went wrong.

Regards,

Sriram

[former_member186338 · Accepted solution]

Sorry, but the details are missing!

Vadim

[Former Member · Accepted solution]

Hello Vadim,

The details are below,

*OPTIONS

FORMAT= DELIMITED

HEADER=YES

DELIMITER=TAB

AMOUNTDECIMALPOINT=

SKIP=0

SKIPIF=

VALIDATERECORDS=YES

CREDITPOSITIVE=YES

MAXREJECTCOUNT=

ROUNDAMOUNT=

*MAPPING

ID=*COL(1)

EVDESCRIPTION=*COL(2)

CURRENCY=*COL(3)

while doing validate&process transformation file

Validate has successfully completed

ValidateRecords=YES

Invalid header name: "RICHBLOOMINC.,SAN DIEGO,CA,"

Validation with data file failed

Regards,

Sriram

[former_member186338 · Accepted solution]

Where is the import file format?

Do you have header in this file?

Please provide COMPLETE info!

Vadim

[Former Member · Accepted solution]

Hello Vadim,

The file format is below

20	RichBloomInc.,San Diego,CA	USA	USD
22	RichBloom Corporartion Inc., Philadelphia,PA	USA	USD
23	Rich Bloom New Marketsn Inc., Huston, Tx	USA	USD
25	Rich Bloom Ltd,London	UK	GBP
30	Rich Bloom AG,Frankfurt	Germany	EUR

Regards,

Sriram.

[Former Member · Accepted solution]

Hello Vadim,

No header for the above format.

Regards,

Sriram

[former_member186338 · Accepted solution]

Sorry, but you have incorrect line in transformation:

*OPTIONS

FORMAT= DELIMITED

HEADER=YES

Have to be replaced to:

HEADER=NO

Vadim

[former_member186338 · Accepted solution]

P.S.

Also this line is strange:

CURRENCY=*COL(3)

May be:

CURRENCY=*COL(4)

Please read help for data conversion and transformation (for BPC NW 7.5)

Vadim

[Former Member · Accepted solution]

Hello Vadim,

I have changed HEADER=NO  now getting below error message

	ValidateRecords = YES
	Master data (dealt by table level) has errors
	Invalid value of 'CURRENCY' within dimension member 22
	Invalid value of 'CURRENCY' within dimension member 23
	Invalid value of 'CURRENCY' within dimension member 25
	Invalid value of 'CURRENCY' within dimension member 30
	Reject count: 5
	Record count: 5
	Skip count: 0
	Accept count: 0

Regards,

Giri

[former_member186338 · Accepted solution]

Have you corrected this: CURRENCY=*COL(4)?

[Former Member · Accepted solution]

Hello Vadim,

I have changed currency as CURRENCY=*COL(4)

and getting below  warring message.

	ValidateRecords = YES
	Reject count: 1
	Record count: 5
	Skip count: 0
	Accept count: 4
	Warning: Some records were rejected
	Rejected records reference either calculated members or invalid members

Rejected record is below

20 RichBloomInc.,San Diego,CA,USA   USD

Line1 :Command failed *COL(4); column index is out of range

Success records

2 ,22,RichBloom Corporartion Inc., Philadelphia,PA,,USD

3 ,23,Rich Bloom New Marketsn Inc., Huston, Tx,,USD

4 ,25,Rich Bloom Ltd,London,,GBP

5 ,30,Rich Bloom AG,Frankfurt,,EUR

Regards,

Giri

[former_member186338 · Accepted solution]

Looks like there is no TAB between CA and USA...

"column index is out of range" means that this line has only 3 columns separated by TAB.

Please analyze the text file and attach the original text file to the message - then I can see what is the difference between line with id 20 and other lines!

Vadim

[Former Member · Accepted solution]

Thanks Vadim now issue is got solved.

I appreciate your quick response.

Regards,

Sriram.