Error in RFC Adapter

[dipen_pandya]

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.

[suman_saha · Accepted solution]

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

[dipen_pandya · Accepted solution]

Hi Suman,

Thanks for a quick prompt.

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

Please advice.

[suman_saha · Accepted solution]

Don't put fullstop(.) after recordset structure

[dipen_pandya · Accepted solution]

Okay Alright.

Removed the full stop.

Anything else if I am missing or any thing incorrect?

Please Advice.

[suman_saha · Accepted solution]

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.

[dipen_pandya · Accepted solution]

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.

[Zahid_Murtaza · Accepted solution]

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

[dipen_pandya · Accepted solution]

Hey.

I solved above error.

But now this one is coming.

???

[azharshaikh · Accepted solution]

Hi,

Pls add the following config:

DT_ZPO_UPLOAD.missingLastFields

= ignore

DT_ZPO_UPLOAD.keepIncompleteFields = YES

Regards,

Azhar

[azharshaikh · Accepted solution]

Hi,

Also,  In your Screenshot u have given the Document Name = csvpoupdate.csv

Instead of File Name it should refer the Message Type that you have created for your Structure = MT_ZPO_UPLOAD

The File name you need to define in the First tab (Source)...

You can refer to sample conversion as given in the link:

SAPTechnical.COM - File Content Conversion

Regards,

Azhar

[dipen_pandya · Accepted solution]

Hi Azhar,

It worked and payload generated as below which is not proper.

<?xml version="1.0" encoding="utf-8"?>
<ns:csvpoupdate.csv xmlns:ns="urn:podemo:b2b:purchaseorder:create">
<Recordset>
    <DT_ZPO_UPLOAD>
        <BSART>NB,3</BSART>
        <LIFNR>0001,1000,</LIFNR>
        <EKORG>01,1</EKORG>
        <EKGRP>00,</EKGRP>
        <BUKRS>1301</BUKRS>
        <MATNR>100,NOS,1500,INR,1</MATNR>
        <MENGE>00,V0</MENGE>
    </DT_ZPO_UPLOAD>

???

[dipen_pandya · Accepted solution]

Okay I replaced the name.

Even my Mapping Program in ESR working fine.

But the generated payload is the proper.

???

Any guesses!

[Former Member · Accepted solution]

AFAIK - By default, <recordset> will be added if you don't mention anything under recordset name.

Try adjusting the configuration like below and see if that helps.

Recordset Structure: DT_ZPO_UPLOAD,*(change 1 to *)

in the table add below parameter.

ignoreRecordsetName true

[azharshaikh · Accepted solution]

Hi,

As suggested by Hareesh, pls update ur config as follows:

Also the payload that you gave looks Incorrect...Seems that you have defined the Data Type : DT_ZPO_UPLOAD with default lengths.....

Kindly remove the Lengths from your Data Type property for each field....as this is a csv file that you using.

Regards,

Azhar