UDI Exhausted Resultset ?

[Former Member]

Hi, we apreciate the help in issues.

We using UDConnect for extract data from ORACLE 10g this working good when filter in selection criteria for reduce volume the data.

When we not use the filters in selection the InfoPacke then get this errors :

<b>S:RSSDK:300 Exhausted Resultset

S:RSSDK:300 Closed Statement: getMetaData</b>

Any idea the parameters in AS JAVA for UDI & Volume the Data in Extractions using UDConnect ?

Very Thank you.

[Former Member · Accepted solution]

1009063 - Please go through this SAP note. We have a ppt which describes the problem.

For paramter configuration see Visual administrator and then UD connect configuration. If nothing seems to work then, you can start with "No Expiration" and leave it that way unless you'll start getting unmanageable number of open connections on your DB server.

Thanks

Subbu

[Former Member · Accepted solution]

Hi, i change the option in special setting "Local Bundle" in JCo RFC Provider parameters.

In the TD RSCUSTV6 i have setting :

5

20000

3.000.000

I have defined the J2EE Server in TD WSADMIN

So in the RFC using SM59 have in specials setting :

qRFC = 1

<b>The problem persist i really apreciate you help.

Some parameters fr check in RZ10 ?</b>

http://help.sap.com/saphelp_nw04/helpdata/en/21/c6a73860bf5f2ce10000009b38f8cf/frameset.htm

[Former Member · Accepted solution]

We check not and make changes but the problem persist,

i complement the post here :

[Former Member · Accepted solution]

Hi, i detect the problem and fix, this was solution :

Change .jar Driver the Oracle, using las version from Oracle WebPage.

Oracle Database 10g Release 2 (10.2.0.3) JDBC Drivers

In RZ10 set values and Applied note 1009063 :

gw/max_conn_per_wp = 200

gw/reg_lb_default = 20

gw/reg_lb_level = 1

gw/cpic_timeout = 20

gw/max_conn = 500

gw/max_sys = 300

gw/max_shm_req_per_conn = 10

gw/max_shm_req = 50

gw/max_overflow_usage = 10

gw/max_overflow_size = 5000000

gw/reg_keepalive = 300

gw/keepalive = 300

login/accept_sso2_ticket = 1

login/create_sso2_ticket = 2

gw/req_stack_size = 30

In transaction RSCUSTV6

Idoc Status = 3

Packet Size = 0

Partition Size = 1.000.000

In J2EE Visual Admin area, Conector Container->SDK_JDBC->Managed Connection Factory->Conection Definition

Set Flag : Expiration

Conection Lifetime set in : 7200

Cleanup Thread : 7200

Maximum Connections : 100

Maximum Time to Wait for Connection : 7200

In J2EE Visual Admin area, HTTP Provider and set values to:

FileBufferSize = 8096

InputBufferMaxSize = 8192

InputBufferMinSize = 1024

In InfoPackage set DataS. Default Data Transfer to:

Maximum size of a data packet = 1000

Frequency with which status Idocs are sent = 3

We using SP12 in AS ABAP and SP9 in J2EE area, Install was SR1.

Good Look.

[Former Member]

Check last post and get good results.