Bex analyzer terminating with RFC error

[Former Member]

We have recently migrated our SQL Server database to SQL Server 2008. After the migration we are unable to run Bex analyzer from backend server.

Backend server is a virtual server running via citirx. We have installed SAP Gui 7.20 gui720_15-10007878 with bi patche as bi720sp09p_901-20006596.

We get all the macros in excel 2003 and we are also able to connect to the Bi server but when we open workbook it terminates with the attached error.

We have already tried reinstall SAP Gui and BI patches.

Runtime Errors         CALL_FUNCTION_SEND_ERROR

What happened?
    "CPIC-CALL: 'ThCMSEND' : cmRc=18 thRc=0#Statistics not active "

    An error occurred when executing a Remote Function Call.

What can you do?
    Note which actions and input led to the error.

    For further help in handling the problem, contact your SAP administrator
    .

    You can use the ABAP dump analysis transaction ST22 to view and manage
    termination messages, in particular for long term reference.

Error analysis
    An error occurred when executing a Remote Function Call.

    "CPIC-CALL: 'ThCMSEND' : cmRc=18 thRc=0#Statistics not active "

    Status of connection.... "CODE=CM_DEALLOCATED_NORMAL CM_SEND_RE
     CM_COMPLETE_DATA_RECEIVED SAPCODE=0 CONV=41421699"
    Internal error code.... "RFC_IO5"

Please check and let me know if someone can solve the problem.

[Former Member]

I am having the exact same issue but with Analysis for Microsoft Excel.  Can you tell me how you resolved this issue?

Thanks.

Sandy

[RolandKramer]

have a look here - http://scn.sap.com/docs/DOC-35785

is this helpful for you?

best regards Roland

[hugo_amo]

Hi Jyoti,

The status code 18 means: CM_DEALLOCATED_NORMAL - the connection was deallocated normally - not because a error occured.
This usually happens when the session is terminated by the user when the RFC is still being processed.
CALL_FUNCTION_SEND_ERROR is the cancelling action before the enclosed data was received.

The "Statistics not active" message in the trace this relates to gateway statistics. These statistics can be activated via SMGW  "Goto" ==> "Expert functions" ==> "Statistics".
Ensure you activate the gateway statistics in this landscape.

The general recommendation  with regard to these types of intermittent dumps is to make sure you are using the latest available kernel patch - see SAP note 19466.
And check if there were connectivity problems at the times of the dump or if users were manually killing sessions, and activate the gateway statistics.

Hope this information helps.

Regards,

Hugo

[Former Member]

Hi Hugo,

Thanks for your response. I have activated the statistics and still its the same isssue.

BI communication error in bex and when i open the workbook it get disconnected.

RFC_GET4, GET ID=0305 LINE=1144

Regards,

Jyoti

[RolandKramer]

Hi,

Please ceck, if your Problem is described on the following SCN Page

http://scn.sap.com/docs/DOC-35785

Best Regards Roland