Question Re: Error in RFC Adapter in Technology Q&A

Error in RFC Adapter

dipen_pandya — Tue, 11 Nov 2014 11:56:42 GMT

Dear Experts,

I have a File to RFC Scenario & We are running on Single Stack (JAVA only) Process Orchestration ( 7.4).

Where my FTP Server is running fine. Communication Channels for Sender(File) and Receiver(RFC) both are GREEN in Monitoring, But still RFC is not able to find the file data.

I have configured all part of ESR, ID & iFlow. There are not any inconsistencies found.

The Error is as per below attached Screenshot.

(MP: exception caught with cause com.sap.engine.interfaces.messaging.api.exception.MessagingException: com.sap.aii.adapter.rfc.afcommunication.RfcAFWException: error while processing message to remote system:com.sap.aii.adapter.rfc.core.client.RfcClientException: could not get functionname from XML requst: com.sap.aii.adapter.rfc.RfcAdapterException: failed to read funtionname from XML document: missing namespace declaration(1)

Please give your helpful suggestions.

Thanks & Regards,

Dipen.

Re: Error in RFC Adapter

Former Member — Tue, 11 Nov 2014 12:04:44 GMT

It seems your mapping output is not conforming to the XML structure for the RFC you are trying to call. Check the payload in the comm channel and compare once again just to be sure.

Regards

Varun

Re: Error in RFC Adapter

Zahid_Murtaza — Tue, 11 Nov 2014 12:24:33 GMT

Seems like the XML generated by your file adapter is not correctly mapping to your RFC structure. To verify it, you can copy the generated xml from message monitoring and paste it in message mapping test in Integration repository to verify if mapping gets executed successfully, hopefully you should be able to determine exact cause from there.

Re: Error in RFC Adapter

dipen_pandya — Tue, 11 Nov 2014 12:47:50 GMT

Hi Zahid,

I tried to find generated XML in Message Monitoring but it is not yet generated as the message is lying in Waiting state.

My RFC Structure is as below.


<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://po:update" 
targetNamespace="http://po:update">
   <xsd:element name="MT_PO_UPLOAD_EXCEL" type="DT_PO_UPLOAD_EXCEL" />
   <xsd:complexType name="DT_PO_UPLOAD_EXCEL">
      <xsd:sequence>
         <xsd:element name="PURCHASING_DOCUMENT" type="xsd:string" default="4" />
         <xsd:element name="VENDOR_ACC_NUMBER" type="xsd:string" default="10" />
         <xsd:element name="PURCHASING_ORG" type="xsd:string" default="4" />
         <xsd:element name="PURCHASING_GROUP" type="xsd:string" default="3" />
         <xsd:element name="COMPANY_CODE" type="xsd:string" default="4" />
         <xsd:element name="MATERIAL" type="xsd:string" default="18" />
         <xsd:element name="QUANTITY" type="xsd:string" default="13" />
         <xsd:element name="UOM" type="xsd:string" default="3" />
         <xsd:element name="NET_PRICE" type="xsd:string" default="13" />
         <xsd:element name="CURRENCY" type="xsd:string" default="5" />
         <xsd:element name="PLANT" type="xsd:string" default="4" />
         <xsd:element name="TAX_CODE" type="xsd:string" default="2" />
      </xsd:sequence>
   </xsd:complexType>
</xsd:schema>

And my File XML structure is as follow.


<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://po:update" 
targetNamespace="http://po:update">
   <xsd:complexType name="DT_PO_UPLOAD_EXCEL">
      <xsd:sequence>
         <xsd:element name="PURCHASING_DOCUMENT" type="xsd:string" default="4" />
         <xsd:element name="VENDOR_ACC_NUMBER" type="xsd:string" default="10" />
         <xsd:element name="PURCHASING_ORG" type="xsd:string" default="4" />
         <xsd:element name="PURCHASING_GROUP" type="xsd:string" default="3" />
         <xsd:element name="COMPANY_CODE" type="xsd:string" default="4" />
         <xsd:element name="MATERIAL" type="xsd:string" default="18" />
         <xsd:element name="QUANTITY" type="xsd:string" default="13" />
         <xsd:element name="UOM" type="xsd:string" default="3" />
         <xsd:element name="NET_PRICE" type="xsd:string" default="13" />
         <xsd:element name="CURRENCY" type="xsd:string" default="5" />
         <xsd:element name="PLANT" type="xsd:string" default="4" />
         <xsd:element name="TAX_CODE" type="xsd:string" default="2" />
      </xsd:sequence>
   </xsd:complexType>
</xsd:schema>

Please Help me to resolve this issue.

I am on urgent assignment.

Thanks & Regards,

Dipen.

Re: Error in RFC Adapter

dipen_pandya — Tue, 11 Nov 2014 12:53:41 GMT

Hi Varun,

My Mapping output is working appropriately.

Payload is also bringing the File Data.

But the message remains in Waiting state.

Please Advice.

Thanks.

Re: Error in RFC Adapter

Former Member — Tue, 11 Nov 2014 12:59:20 GMT

Okay, now your RFC structure definitely does not adher to standard BAPI XMLs. Now the question is, what is your scenario? What RFC are you trying to call? Are you intending to call a BAPI in SAP or some external RFC?

Regards

Varun

Re: Error in RFC Adapter

dipen_pandya — Tue, 11 Nov 2014 13:03:43 GMT

Hi varun,

Yes I am tending to give the data to the Customized ABAP Remote Enabled Function Module(RFC) which also include BAPI function module of Purchase Order Create.

My Scenario is File to RFC.

I am picking file from FTP Server which is working perfectly.

And I am giving this file (.csv) to SAP system.

Please Advice.

Thanks.

Dipen.

Re: Error in RFC Adapter

Zahid_Murtaza — Tue, 11 Nov 2014 13:06:27 GMT

The issues seems to be at mapping level, hence sender message (Outbound) message is probably received at PI and should be in log. Go through message monitoring of adapter engine instead of integration engine.

Are you expecting an xml file from FTP or content conversion is being used?

does the mapping test in integration repository with some dummy data gets executed succesfully?

The fact that your communication channel status is green, the problem seems to be during mapping after file has been picked up (File does gets picked up from your ftp directory, right ?)

Re: Error in RFC Adapter

dipen_pandya — Tue, 11 Nov 2014 13:21:15 GMT

Yes Zahid.

You are right file is still there on FTP directory, its not deleted yet.

I am using Content Conversion too.

But what I am suppose to write in Recordset Structure?

Thanks in advance.

Re: Error in RFC Adapter

Zahid_Murtaza — Wed, 12 Nov 2014 06:15:48 GMT

usually, the structure is defined as following hierarchy:

<Mt_anyfileRec>

< Record>
< Row>

Then this sequence is used to correctly define the content conversion.

If we take above example, the sender adapter will be populated as follow for content coversion:

Document name: MT_anyfileRec
Record Set name: Record
Record set structure: Row,*

Re: Error in RFC Adapter

suman_saha — Wed, 12 Nov 2014 07:50:48 GMT

Hi,

It seems your content conversion is not proper.

For debugging purpose, remove content conversion and put .xml file directly fetching from message mapping and test. If this works,then do the content conversion taking help from the link:

SAPTechnical.COM - File Content Conversion

http://wiki.scn.sap.com/wiki/display/XI/Basic+File+Adapter+Content+Conversion

Suman

Re: Error in RFC Adapter

dipen_pandya — Wed, 12 Nov 2014 11:50:40 GMT

Thanks every one.

Still I am struggling to achieve File Content Conversion.

Please help.

My file is as below (.csv).

And my XML structure is as below.

Please advice me how can i finish this.

This would be a great help.

Thanks a lot.

Re: Error in RFC Adapter

suman_saha — Wed, 12 Nov 2014 12:11:00 GMT

Hi,

Use the following settings:

Recordset Structure: DT_ZPO_UPLOAD,1.

DT_ZPO_UPLOAD.filedNames BSART,LIFNR,.....

DT_ZPO_UPLOAD.fieldSeparator ,

DT_ZPO_UPLOAD.endSeparator 'nl'

DT_ZPO_UPLOAD.additionalLastFields ignore

Suman

Re: Error in RFC Adapter

dipen_pandya — Wed, 12 Nov 2014 12:23:17 GMT

Hi Suman,

Thanks for a quick prompt.

Please check & confirm me whether I am right or wrong?

Please advice.

Re: Error in RFC Adapter

suman_saha — Wed, 12 Nov 2014 12:26:33 GMT

Don't put fullstop(.) after recordset structure

Re: Error in RFC Adapter

dipen_pandya — Wed, 12 Nov 2014 12:33:28 GMT

Okay Alright.

Removed the full stop.

Anything else if I am missing or any thing incorrect?

Please Advice.

Re: Error in RFC Adapter

suman_saha — Wed, 12 Nov 2014 12:38:54 GMT

Try and let us know if it is working fine.

You may create a receiver file channel and use that instead of RFC receiver just to check the output file

Otherwise you need to configure logging and staging to check whats happening step by step.

Re: Error in RFC Adapter

dipen_pandya — Wed, 12 Nov 2014 12:44:10 GMT

Hey Suman.

Below error I am getting.

Conversion initialization failed: java.lang.Exception: java.lang.Exception: java.lang.Exception: Error(s) in XML conversion parameters found:
Parameter 'DT_ZPO_UPLOAD.fieldFixedLengths' or 'DT_ZPO_UPLOAD.fieldSeparator' is missing
Mandatory parameter 'DT_ZPO_UPLOAD.fieldNames': no value found

Transfer Mode should be kept "Binary" or "Text" ?

Please advice.

Re: Error in RFC Adapter

Zahid_Murtaza — Wed, 12 Nov 2014 12:58:45 GMT

atleast some progress:) ... put fieldSeparator as first parameter in list, and then fieldNames.

Re: Error in RFC Adapter

dipen_pandya — Wed, 12 Nov 2014 13:04:47 GMT

Hey.

I solved above error.

But now this one is coming.

???