on 08-17-2007 7:09 PM
Hi, guys.
I not can extract big volume the data, only when using filters in Selection the Package is ok.
Get errors :
<b>S:RSSDK:300 Closed Statement: getMetaData
S:RSSDK:300 Io exception: Socket closed
S:RSSDK:300 Exhausted Resultset
S:RSSDK:300 statement handle not executed</b>
Any idea for detect the problem, Logs in J2EE Admin not show specify the problem.
Maybe some parameter in RZ10, JCo RFC, J2ee Visual Admin, RFC in ABAP, etc ?
This post is complement to thread:
Thank you.
Hi, i detect the problem and fix, this was solution :
Change .jar Driver the Oracle, using las version from Oracle WebPage.
<b>Oracle Database 10g Release 2 (10.2.0.3) JDBC Drivers</b>
In <b>RZ10</b> set values :
<b>gw/max_conn_per_wp</b> = 200
<b>gw/reg_lb_default</b> = 20
<b>gw/reg_lb_level</b> = 1
<b>gw/cpic_timeout</b> = 20
<b>gw/max_conn</b> = 500
<b>gw/max_sys</b> = 300
<b>gw/max_shm_req_per_conn</b> = 10
<b>gw/max_shm_req</b> = 50
<b>gw/max_overflow_usage</b> = 10
<b>gw/max_overflow_size</b> = 5000000
<b>gw/reg_keepalive</b> = 300
<b>gw/keepalive</b> = 300
<b>login/accept_sso2_ticket</b> = 1
<b>login/create_sso2_ticket</b> = 2
<b>gw/req_stack_size</b> = 30
In transaction <b>RSCUSTV6</b>
<b>Idoc Status =</b> 3
<b>Packet Size =</b> 0
<b>Partition Size =</b> 1.000.000
In J2EE Visual Admin area, <b>Conector Container->SDK_JDBC->Managed Connection Factory->Conection Definition</b>
Set Flag : <b>Expiration</b>
Conection Lifetime set in : <b>7200</b>
Cleanup Thread : <b>7200</b>
Maximum Connections : <b>100</b>
Maximum Time to Wait for Connection : <b>7200</b>
In J2EE Visual Admin area, HTTP Provider and set values to:
FileBufferSize = <b>8096</b>
InputBufferMaxSize = <b>8192</b>
InputBufferMinSize = <b>1024</b>
In InfoPackage set DataS. Default Data Transfer to:
Maximum size of a data packet = <b>1000</b>
Frequency with which status Idocs are sent = <b>3</b>
We using SP12 in AS ABAP and SP9 in J2EE area, Install was SR1.
Good Look.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi, the pricipal error is :
<b>S:RSSDK:300 Closed Statement: getMetaData</b>
The volumen when use .csv from ORACLE table is 500.000 Rows, so i using customizing in Package the UDConnect DataSource but errors not is fixed.
Maybe in J2EE area exist some customizing for define the Rows in volumen the extraction or petition in J2EE to ORACLE.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.