cancel
Showing results for 
Search instead for 
Did you mean: 

FCC Receiver Error :Column value ' ' too long

Former Member
0 Kudos
166

Hi Experts

I am getting data from SAP for which i should create a file which is fixed length on the target side

My structure is :

File----


1.....Unbound

----->Header --- -


1..1

-


>RecordType

-


>Transcode

-


>PO_Num

-


>Vend_ID

-


>Crea_date

-


>WHS_ID

-


>POM_Status

-


>Cancel_date

-


>Delv_date

-


>Ord_type

-


>POM_Char

---->Record_Detail---1..Unbound

-


>Record_typ

-


>PO_Num

-


>Line_no

-


>Itm_no

-


>Sch_No

-


>QTY

-


>UOM

-


>Vend_itm_no

-


>Delv_Date

-


>Buyer_name

-


>WHS_ID

---->var1-0..1

---->var2-0..1

var1 and var2 I am using for variable substitution.

I have configured the receiver FCC as below

Record Structure HeaderRecord,Record_Detail

HeaderRecord.fieldFixedLengths 1,1,30,10,8,2,1,8,8,8,1

Record_Detail.fieldFixedLengths 1,30,5,30,3,8,2,20,8,25,2

And I have given var1 and var2 in varaible substitution.

But I am getting the following error when recevier receiving the file

Could not process due to error: java.lang.Exception: Exception in XML Parser (format problem?):'java.lang.Exception: Message processing failed in XML parser: 'java.lang.Exception: Column value '0811200613.WAPONUM' too long (>1 for 0. column) - must stop', probably configuration error in file adapter (XML parser error)'

Please help me

Regards

Sowmya

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

>var1---0..1

-


>var2---0..1

This is your problem. Have these fields defined in a new node, say trailer and define the Recordset Structure as HeaderRecord,Record_detail,trailer.

Former Member
0 Kudos

Hi

I dont need these fields on target file.

Thanks & Regards

Sowmya

Former Member
0 Kudos

If you dont need them, disable the fields in mapping. (Right click on the field and say "disable")

Edited by: Jaishankar on Nov 20, 2008 8:37 PM

Former Member
0 Kudos

Hi

I have created one more node - VarSub under that i have created var1 and var2 but still facing the same problem.

I want to use var1 and var2 at varaible substitution if i disable these fields at receiver side i am getting the following error : The following variable was not found in the message payload: var1

Any Suggestions?

Thanks & Regards

Sowmya

former_member183908
Active Contributor
0 Kudos

Hi Sowmya,

I think u pls check the File Content Conversion Parameters once again and also the resultset name and resultset namespace.

Thanks

pavan

Former Member
0 Kudos

Hi,

If u have added Trailer Node ( And Var1 & Var2 inside it) then try adding this:

Trailer.fieldFixedLengths 0,0

Trailer.fixedLengthTooShortHandling Cut

Hope it will solve ur problem.

For reference check:

http://help.sap.com/saphelp_nw04/helpdata/en/14/80243b4a66ae0ce10000000a11402f/frameset.htm

Check ur final structure is like this:

Recordset Structure: File,Header,Record_Detail,Trailer

Header.fieldFixedLengths: 1,1,30,10,8,2,1,8,8,8,1

Header.fieldNames: RecordType,Transcode,PO_Num,Vend_ID,Crea_date,WHS_ID,POM_Status,Cancel_date,Delv_date,Ord_type,POM_Char

Record_Detail.fieldFixedLengths: 1,30,5,30,3,8,2,20,8,25,2

Record_Detail.fieldNames: Record_typ,PO_Num,Line_no,Itm_no,Sch_No,QTY,UOM,Vend_itm_no,Delv_Date,Buyer_name,WHS_ID

Trailer.fieldFixedLengths: 0,0

Trailer.fieldNames: var1,var2

Trailer.fixedLengthTooShortHandling: Cut

File.fieldSeparator: 'nl'

Thanks,

Mahi

Edited by: Maheshwari Morbale on Nov 21, 2008 6:33 AM

Former Member
0 Kudos

Hi

But i this case I will get var1 and var2 in receiver file. But i dont want thest two fields on receiver file these two fields i am just using for changing the file name and path dynamically.

Please give some suggestions

Regards

Sowmya

Former Member
0 Kudos

Hi,

No......... Trailer.fixedLengthTooShortHandling: Cut will not add var1 var2 to ur output file.

Have u tried using it?

Thanks,

Mahi

Former Member
0 Kudos

Hi Maheswari,

Thanks a lot. I am struggling with this from long time..

I have resolved it finally

Regards

Sowmya

Former Member
0 Kudos

Its good that ur problem is solved

Thanks,

Mahi

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Sowmya,

It seems the length of '0811200613.WAPONUM' string is bigger than the defined fixed length in FCC.

Secondly in your FCC make sure you have defined the fixed length for all fields which exists in target structure otherwise you will get an error in RWB.

Regards,

Sarvesh