FCC Receiver Error :Column value ' ' too long

[Former Member]

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

[Former Member · Accepted solution]

---

>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 · Accepted solution]

Hi

I dont need these fields on target file.

Thanks & Regards

Sowmya

[Former Member · Accepted solution]

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 · Accepted solution]

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 · Accepted solution]

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 · Accepted solution]

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 · Accepted solution]

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 · Accepted solution]

Hi,

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

Have u tried using it?

Thanks,

Mahi

[Former Member · Accepted solution]

Hi Maheswari,

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

I have resolved it finally

Regards

Sowmya

[Former Member · Accepted solution]

Its good that ur problem is solved

Thanks,

Mahi

[Former Member]

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