topic Re: Problem with RFC_READ_TABLE in Application Development and Automation Discussions

Problem with RFC_READ_TABLE

Former Member — Tue, 02 Aug 2011 07:41:10 GMT

I am using two functions which are exposed as webservice and consumed in .NET

RFC_READ_TABLE - to read username from USR02 table

bapi_user_get_detail - to fetch detail of each user.

there are total of 10 thousand records to be imported from SAP system.

I first call RFC_READ_TABLE for 150 records. then for each record i call BAPI_USER_GET_DETAIl.

But when i call RFC_READ_TABLE for second set of 150 records, HTTP 503 error comes and service gets disconnected.

Please help me to solve the issue.

Thanks,

Anshul.

Re: Problem with RFC_READ_TABLE

former_member209703 — Tue, 02 Aug 2011 08:06:57 GMT

Have you checked if any dumps have been generated in the SAP side?

Re: Problem with RFC_READ_TABLE

Former Member — Tue, 02 Aug 2011 09:25:38 GMT

Yes i have checked st22 transaction... there is no dump generated.

only no more request to http protocoal is allowed.

this error is coming in dev_icm

ERROR => IcmSendRq: No more ABAP contexts available for protocol: HTTP (90%) [icxxif.c 941]
ERROR => Server overload [icxxthr.c 1716]

Re: Problem with RFC_READ_TABLE

Former Member — Tue, 02 Aug 2011 09:31:05 GMT

why would you read on usr02 if BAPI_USER_GET_DETAIL gets you same information?

The call of your RFC_READ_TABLE is redundant. And your error message even states that you just made it overflow.

Re: Problem with RFC_READ_TABLE

Former Member — Tue, 02 Aug 2011 10:03:09 GMT

I am only reading list of username using RFC_READ_TABLE. only Field BNAME from table USR02

And then for detail i am calling BAPI_USER_GET_DETAIL.

Re: Problem with RFC_READ_TABLE

SuhaSaha — Tue, 02 Aug 2011 10:08:44 GMT

Hello Anshul,

You can use 'BAPI_USER_GETLIST' to get the list of users & then use BAPI_USER_GET_DETAIL to fetch the users' details.

BR,

Suhas

Re: Problem with RFC_READ_TABLE

Former Member — Tue, 02 Aug 2011 10:23:36 GMT

Hi Suhas,

Thanks for the reply.... actually our requirement is to fetch the userlist in pages.

eg starting from index 5 to next 150 users

so for this reason i am using RFC_READ_TABLE.

Is there any problem using this rfc

Re: Problem with RFC_READ_TABLE

SuhaSaha — Tue, 02 Aug 2011 10:40:20 GMT

Hello,

Only difference i find is that RFC_READ_TABLE is not released & is not a BAPI

As you might be knowing, BAPIs have a stable interface & they are kind of "future-proof"! BAPIs should always be preferred over unreleased RFMs.

BR,

Suhas

Re: Problem with RFC_READ_TABLE

Former Member — Tue, 02 Aug 2011 11:22:46 GMT

So the above error i am getting could be because of using RFC_READ_TABLE.

Re: Problem with RFC_READ_TABLE

Sandra_Rossi — Tue, 02 Aug 2011 11:43:07 GMT

Hi Anshul,

that would surprise me a lot that the cause if RFC_READ_TABLE. It's just not advised to use this generic RFC as it could be a security breach.

HTTP 503 means "Service Unavailable. The server is currently unavailable (because it is overloaded or down for maintenance)" (see http://en.wikipedia.org/wiki/List_of_HTTP_status_codes). It's probably a system configuration issue, ask your admins. Read also SAP note 959866 HTTP error message: Server Overload

Do you close your RFC connection between each RFC_READ_TABLE call? If you could keep it alive, that would maybe avoid this issue.

Sandra

Re: Problem with RFC_READ_TABLE

Former Member — Tue, 02 Aug 2011 11:48:54 GMT

Hi,

I am calling this RFC_READ_TABLE using webservice