Problem with RFC_READ_TABLE

[Former Member]

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.

[former_member209703]

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

[Former Member]

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]

[Former Member]

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.

[Former Member]

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.

[SuhaSaha]

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

[Former Member]

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

[SuhaSaha]

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

[Former Member]

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

[Sandra_Rossi]

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.

BR

Sandra

[Former Member]

Hi,

I am calling this RFC_READ_TABLE using webservice