JCO_ERROR_CONVERSION:

[Former Member]

Hi,

I am pulling data from a DB2 table using JDBC adapter and inserting into sap R3 using RFC adapter. The DB2 table has a field pay_ref with integer 4 value. In design / RFC I have tried all combinations of data types but it gives me the following error message -

-

---

Exception caught by adapter framework: error while processing message to remote system:com.sap.aii.af.rfc.core.client.RfcClientException:could not convert request from XML to RFC:com.sap.mw.jco.JCO$ConversionException: (122) JCO_ERROR_CONVERSION: Integer '167080' has to many digits at field.

-

---

This integer 167080 is pay_ref at DB2.

Could anybody help as to how I can map it ??

Thanks.

[Former Member · Accepted solution]

Preeti,

What type u have in RFC? If ur using some numeric types then try using FormatNumber builtin function in the map for this value.Sometimes it helps.

SourceField->FormatNumber->TargetRFCField.

regards

rajeev

[Former Member]

Thankyou Udo and Rajeev for a prompt reply.

The cache is clear and after applying number formatting also I am getting the same error.

What data type should be ideally maintained in resultset if we are picking integer value .

[Former Member]

xsd:int or xsd:long should be good enough.

regards

Shravan

[Former Member]

Hi Preeti,

check if there is any conversion routine for the field in the BAPI. there may be issues, if the import param type & conversion routine type are different.

Regards

Vishnu

[udo_martens]

Hi Preeti,

i suppose a cache problem (adapter metadata). May be you can refresh them (SXI_Cache oder IB/Administration) or you copy your function to new name.

Regards,

Udo