File Adapter: Initialization error: Conversion initialization failed

[Former Member]

Hi all,

I'm trying to establish a file adapter (FTP, File Content Conversion).

In the adapter monitor I' ve got the following error:

Sender Adapter v1325 for Party '', Service 'BS_ACN_PCS_A':

Configured at 14:49:34 2005-08-29

Initialization error: Conversion initialization failed with java.lang.Exception: java.lang.Exception: java.lang.Exception: Error(s) in XML conversion parameters found:

Format error in 'xml.recordset' argument: incomplete structure (name,number) pair

My content conversion parameters are:

BP_BusinessPartnerMasterData_IncomingData.fieldFixedLengths:

20,50,50,1,10,50,10,50,5,20,20,15,15

BP_BusinessPartnerMasterData_IncomingData.fieldNames: Number,Name2,Name1,Gender,Birthdate,City,Postcode,Street,

HouseNo,PhoneNumber,Fax,BankId,BankAccount

BP_BusinessPartnerMasterData_IncomingData.fieldContentFormating:

trim

BP_BusinessPartnerMasterData_IncomingData.keyFieldInStructure:

ignore

What could be the error or where I have to look for it?

Thanks,

Fabian

[Former Member · Accepted solution]

Hi Fabian,

Have you provided Recordset Name and Recordset structure in your configuration ?

Regards

Anand

[Former Member · Accepted solution]

Yes,

Recordset name: BP_BusinessPartnerMasterData_IncomingData

Recordset structure: BP_BusinessPartnerMasterData_IncomingData

The corresponding Message Type:

<?xml version="1.0" encoding="ISO-8859-1"?>

<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://pcs.acn.com/basicdata" targetNamespace="http://pcs.acn.com/basicdata">

<xsd:element name="BP_MasterDataIncomingFil" type="BP_BusinessPartnerMasterData_IncomingData" />

<xsd:complexType name="BP_BusinessPartnerMasterData_IncomingData">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

f323a4b018a911da9fd9000bcd69ce64

</xsd:appinfo>

</xsd:annotation>

<xsd:sequence>

<xsd:element name="Number">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

7679e8500fe111da89f2d1210a87220d

</xsd:appinfo>

<xsd:documentation xml:lang="EN">

Id from Sender for BP

</xsd:documentation>

</xsd:annotation>

<xsd:simpleType>

<xsd:restriction base="xsd:string">

<xsd:maxLength value="20" />

</xsd:restriction>

</xsd:simpleType>

</xsd:element>

<xsd:element name="Name2">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

7679e8510fe111dacfd7d1210a87220d

</xsd:appinfo>

<xsd:documentation xml:lang="EN">

Last name or Company name

</xsd:documentation>

</xsd:annotation>

<xsd:simpleType>

<xsd:restriction base="xsd:string">

<xsd:maxLength value="50" />

</xsd:restriction>

</xsd:simpleType>

</xsd:element>

<xsd:element name="Name1">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

7679e8520fe111da94bad1210a87220d

</xsd:appinfo>

<xsd:documentation xml:lang="EN">

First name or Company name 2

</xsd:documentation>

</xsd:annotation>

<xsd:simpleType>

<xsd:restriction base="xsd:string">

<xsd:maxLength value="50" />

</xsd:restriction>

</xsd:simpleType>

</xsd:element>

<xsd:element name="Gender">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

7679e8530fe111da99add1210a87220d

</xsd:appinfo>

<xsd:documentation xml:lang="EN">

m or f or blank

</xsd:documentation>

</xsd:annotation>

<xsd:simpleType>

<xsd:restriction base="xsd:string">

<xsd:maxLength value="1" />

</xsd:restriction>

</xsd:simpleType>

</xsd:element>

<xsd:element name="Birthdate">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

7679e8540fe111dab156d1210a87220d

</xsd:appinfo>

</xsd:annotation>

<xsd:simpleType>

<xsd:restriction base="xsd:string">

<xsd:maxLength value="10" />

</xsd:restriction>

</xsd:simpleType>

</xsd:element>

<xsd:element name="City">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

7679e8550fe111daa58cd1210a87220d

</xsd:appinfo>

</xsd:annotation>

<xsd:simpleType>

<xsd:restriction base="xsd:string">

<xsd:maxLength value="50" />

</xsd:restriction>

</xsd:simpleType>

</xsd:element>

<xsd:element name="Postcode">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

7679e8560fe111dac0c2d1210a87220d

</xsd:appinfo>

</xsd:annotation>

<xsd:simpleType>

<xsd:restriction base="xsd:string">

<xsd:maxLength value="10" />

</xsd:restriction>

</xsd:simpleType>

</xsd:element>

<xsd:element name="Street">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

7679e8570fe111dabbd3d1210a87220d

</xsd:appinfo>

</xsd:annotation>

<xsd:simpleType>

<xsd:restriction base="xsd:string">

<xsd:maxLength value="50" />

</xsd:restriction>

</xsd:simpleType>

</xsd:element>

<xsd:element name="HouseNo">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

7679e8580fe111dab63fd1210a87220d

</xsd:appinfo>

</xsd:annotation>

<xsd:simpleType>

<xsd:restriction base="xsd:string">

<xsd:maxLength value="5" />

</xsd:restriction>

</xsd:simpleType>

</xsd:element>

<xsd:element name="PhoneNumber">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

7679e8590fe111dac782d1210a87220d

</xsd:appinfo>

</xsd:annotation>

<xsd:simpleType>

<xsd:restriction base="xsd:string">

<xsd:maxLength value="20" />

</xsd:restriction>

</xsd:simpleType>

</xsd:element>

<xsd:element name="Fax">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

7679e85a0fe111daa9ebd1210a87220d

</xsd:appinfo>

</xsd:annotation>

<xsd:simpleType>

<xsd:restriction base="xsd:string">

<xsd:maxLength value="20" />

</xsd:restriction>

</xsd:simpleType>

</xsd:element>

<xsd:element name="BankId">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

7679e85b0fe111dace1ed1210a87220d

</xsd:appinfo>

</xsd:annotation>

<xsd:simpleType>

<xsd:restriction base="xsd:string">

<xsd:maxLength value="15" />

</xsd:restriction>

</xsd:simpleType>

</xsd:element>

<xsd:element name="BankAccount">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

7679e85c0fe111da8801d1210a87220d

</xsd:appinfo>

</xsd:annotation>

<xsd:simpleType>

<xsd:restriction base="xsd:string">

<xsd:maxLength value="15" />

</xsd:restriction>

</xsd:simpleType>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:schema>

[Former Member · Accepted solution]

Hello Fabian,

your Recordset Structure is - as the error message says - incomplete as it does not contain the cardinality of your structure.

Regards,

Thilo

[Former Member · Accepted solution]

Thanks,

but where I have to add which cardinality?

Thanks,

Fabian

[Former Member · Accepted solution]

Hello Fabian,

it's all written in the documentation [1]: "Recordset Structure: Enter the sequence and the number of substructures as follows: <NameA,nA,NameB,nB,...>, where nA=1,2,3,... or * (for a variable, unlimited number, including 0)."

HTH,

Thilo

[1] http://help.sap.com/saphelp_nw04/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/frameset.htm

[Former Member · Accepted solution]

Hi Fabian,

Your recordsetname is teh name of the structure and document name is the name of xml document ie the mesage type name.

chk this link in help.sap.com

http://help.sap.com/saphelp_erp2004/helpdata/en/0b/9a50465ccf84479e39a6d50c90fb3f/frameset.htm

Regards

Priyanka

[Former Member · Accepted solution]

Hi

Looking into ur xsd of mesg type i got to know tht ur file structure is like something like this:

BP_MasterDataIncomingFil (Message Type)

-Number

-Name2

-Name1

and <b>BP_BusinessPartnerMasterData_IncomingData</b> is Sender Data Type.

Thus U r not following the file structure as given in help.sap.It is given tht "<b>The system expects a file with one or more logical structures (recordsets)</b>."

The file structure shd look as given in the link

http://help.sap.com/saphelp_nw04/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm

Thengive the parameters for content conversion.

Hope it helps.

Regards

Arpit Seth

[Former Member · Accepted solution]

Thanks for your help, especally for the hint with the cardinalities.

Thanks,

Fabian

[Former Member]

Your Recordset Name = BP_BusinessPartnerMasterData_IncomingData