on 03-10-2015 7:55 PM
I am getting below error in RWB.
Attempt to process file failed with java.lang.Exception: Exception in XML Parser (format problem?):'java.lang.Exception: Message processing failed in XML parser: 'java.lang.Exception: Column value too long (>3 for 2. column) - must stop', probably configuration error in file adapter (XML parser error)'.
Thanks
Vanga
Hi Praveen,
Your XSD seems to be right.
Right we can figure out if you configuration fits with your file, regarding the help.sap documentation:
If you made an entry for NameA.fieldFixedLengths, the length of the separator is not added to this length.
Have you taken into account that you don't have to count the tab separator in your fieldFixedLenghts parameter?
You must make an entry for at least NameA.fieldFixedLengths or NameA.fieldSeparator.
If you have a fieldSeparator, why are you using fieldFixedLenghts?
Finally, without count the tab character, are you really sure all records in the file have the length that you are setting in FCC?.
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Praveen,
Check that the file fits in all the records with fixed lengths that you have defined.
Check your XSD or DT sender schemas fits with you fixed lengths.
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Iñaki Vila,
I have checked in XSD of data type, I can see the below XML code with all fields length.
<xsd:complexType name="DT_Suppllier_Sync_Receiver">
<xsd:annotation>
<xsd:documentation xml:lang="EN">
Data Type for Supplier Sync
</xsd:documentation>
</xsd:annotation>
<xsd:sequence>
<xsd:element name="Records" minOccurs="0">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="PlantCode" minOccurs="0">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="4" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="SupplierCode" minOccurs="0">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="10" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="SupplierName" minOccurs="0">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="35" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="Address1" minOccurs="0">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="35" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="Address2" minOccurs="0">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="35" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="Address3" minOccurs="0">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="35" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="City" minOccurs="0">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="35" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="State" minOccurs="0">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="3" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="Zip" minOccurs="0">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="10" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="Country" minOccurs="0">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="3" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:schema>
Thnaks
vanga
Other option is to add below parameter -
xml.fixedLengthTooShortHandling=<handling>
Specify how you want the system to respond when column widths in the actual document exceed those defined in xml.fieldFixedLengths. The following values are permitted:
■ xml.fixedLengthTooShortHandling=Error
Error means that processing of the document is terminated.
■ xml.fixedLengthTooShortHandling=Cut
Cut means that a value is shortened to the maximum permitted length.
■ xml.fixedLengthTooShortHandling=Ignore
Ignore means that the system copies the value completely, regardless of it being too long. Subsequent columns are moved accordingly.
The default value is Error.
Configuring the Receiver File/FTP Adapter - SAP NetWeaver Exchange Infrastructure - SAP Library
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Hareesh,
I have checked both points which you mentioned in the previous thread.
a) Check the target payload after mapping and make sure all the fields are generated. In case any field is not created the FCC for fixed length files will fail.
b) Check the value being generated at the mentioned column value. Verify if its length matches the length of the field in that position.
In scenario , I am using Idoc to File .... source IDOC and in the target side I am using structure with 10 fields, all of them are strings....
In FCC, the below are my parameters.
Records.fieldFixedLengths 4,10,35,35,35,35,35,3,10,3
Records.fieldNames PlantCode,SupplierCode,SupplierName,Address1,Address2,Address3,City,State,Zip,Country
Records.endSeparator 'nl'
Records.fieldSeparator '0x09'
ignoreRecordsetName true
We are using Java stck and Adaptor AAE_IDOC.
Name of Idoc Cremas.
Thanks
Praveen
Hi Praveen
After to check Hareesh suggestion, you can check the question 7 in this wiki http://wiki.scn.sap.com/wiki/display/XI/Troubleshooting+the+File+Adapter
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Are you doing any content conversion? If so please validate your configuration.
As per your configuration there is a filed whose length should not be greater than 2 but it has got "3".
check your input payload
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.