Skip to Content
author's profile photo Former Member
0
Former Member

Error when loading data from R3

Posted on Aug 19, 2016 at 07:41 AM 206 Views

Hi everyone,


we have extracted a very big Table BSEG from R3 to SQL BI. However there is an Error when loading:


ERPConnect.ERPException:CPIC-CALL: MRCV: rc= ...

LOCATION CPIC (TCP/IP) on local host

ERROR ilegal parameter value (function=SAP_CMTIMEOUT2/parameter=conversation_ID/value=.....)

TIME:....

RELEASE ....

COMPONENT CPIC

VERSION...

MOUDLE

LINE

COUNTER

-RFClisten failed: RFC_FAILURE

at ERPConnect.RFCAPI.ReceiveFunctionResult(Ulnt32 connectionhandle,RFC_PARAMETER importing,RFC_PARAMETER changing,RFC_TABLE,encoding apiendcoding)

at ERPconnect.RFCFunction.REceiveFunctionArguments(RFC_Table&apiTables)

at ERPconnect.RFCFunction.CallclassicAPI

.......



after checking SQL BI system, there is no Error with the System, so we think there is something wrong with the RFC Connection between ERP and SQL BI. i have checked the connection but i couldn't find any Problem with it.

Can you please help me how to solve this Error?

Thankyouvery much!


Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 20, 2016 at 08:16 AM
    1

    Hi,

    ERPConnect.ERPException:CPIC-CALL: MRCV: rc= ...

    LOCATION CPIC (TCP/IP) on local host

    TCP/IP is the sign of network loss, in your case it might be temporary loss, that is why when you did a connection test between BW and source system, you couldn't find any issue.

    change the info package QM status to red and repeat the load.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member
      Aug 22, 2016 at 09:46 AM
      function=SAP_CMTIMEOUT2

      see, it is timeout

      We need to splitt the bid table BSEG before loading to BI rights?

      yes , split the loads .

      regarding I/O error, its a data in and out of the database, google to know more about this.

    Comment on This Answer
  • author's profile photo Aparajit Banik
    Aparajit Banik
    Posted on Aug 19, 2016 at 11:32 AM
    0

    Restrict the data and run a small load.
    see if thats successful.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 19, 2016 at 02:35 PM
    0

    Hi Pha,

    Please go through this link and test your RFC.

    I think this can help you.

    http://www.guru99.com/how-to-configure-and-test-rfc.html

    Regards from Mexico.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 22, 2016 at 10:28 AM
    0

    Former Member

    i have read your comment about this Type of Error. Can you please help me to have a look at this Issue?

    Thankyou very much

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 23, 2016 at 11:29 AM
    0

    Hi Former Member

    i have split the dataload. But we still have the same Problem.

    The load process runs only 2 hours, the data come in to SQL BI, but after 2 hours, there is always the Error.

    Add a comment
    10|10000 characters needed characters exceeded

    Comment on This Answer

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.