This website is not affiliated with, sponsored by, or approved by SAP AG.

JDBC Adapter and XI adapter cannot get large record

All postings related to SAP XI

Moderators: Snowy, thx4allthefish

JDBC Adapter and XI adapter cannot get large record

Postby robbyrnm » Fri Jan 21, 2011 2:34 am

Hi expert,

I get a problem after I upgrade SAP PI 7.0 to SAP PI 7.11

my scenario JDBC -> sap pi -> sap bw in asynchronous mode.

Before upgrade to EHP1, JDBC adapter can achieve 10.000 recode without any problem. Either get data from data warehouse or send to destination (SAP BW).

The problem arise when EHP1 installed in production machine, connection between SAP BW disturbed. I only can get 1000 record from data warehouse and repeatedly hang up in inbound processing (SMQ2) before the message send to BW.

I was makes some tuning on abap stack, for http timeout in smicm to 1200 (default value is 600), the record successfully increase to 2000 but still I'm in a problem because too many data in data warehouse to be transferred to it destination. How can I get back the large amount of adapter call like the old one? please help.. :(

note : I got HTTPIO_PLG_CANCELED in sxmb_moni when the message failed to process (>2000 records)

Thanks
Robby
robbyrnm
 
Posts: 3
Joined: Fri Jan 21, 2011 1:50 am

Re: JDBC Adapter and XI adapter cannot get large record

Postby Baz » Fri Jan 21, 2011 5:10 am

it is not so much as the time out that could be causing this problem, run RSPFPAR in each system and check the icm/HTTP/server_cache_0/memory_size_MB as this can also cause problems with large records....
Baz

AsPiRiNg tUlY iDiOt Image

http://www.catb.org/~esr/faqs/smart-questions.html

Image

check out my Podcasts http://dj-baz.podomatic.com
Baz
 
Posts: 4736
Joined: Fri Nov 08, 2002 5:54 am
Location: He's out there! somewhere!!!!

Re: JDBC Adapter and XI adapter cannot get large record

Postby robbyrnm » Mon Jan 24, 2011 4:14 am

Baz wrote:it is not so much as the time out that could be causing this problem, run RSPFPAR in each system and check the icm/HTTP/server_cache_0/memory_size_MB as this can also cause problems with large records....


Hi Baz,

Thanks for your quick reply, I just check on Tcode RSPFPAR and look at icm/HTTP/server_cache_0/memory_size_MB parameter.

The value is 50 (default value). Can you describe what the default value for memory_size_MB is and what the best setting for large records of data is?

Thanks in advance,

Robby
robbyrnm
 
Posts: 3
Joined: Fri Jan 21, 2011 1:50 am

Re: JDBC Adapter and XI adapter cannot get large record

Postby Baz » Mon Jan 24, 2011 4:39 am

how big is the file you are trying to send? if it is bigger than 50mb then you need to increase the file size on all your ABAP stacks (ECC, PI and BIW)
Baz

AsPiRiNg tUlY iDiOt Image

http://www.catb.org/~esr/faqs/smart-questions.html

Image

check out my Podcasts http://dj-baz.podomatic.com
Baz
 
Posts: 4736
Joined: Fri Nov 08, 2002 5:54 am
Location: He's out there! somewhere!!!!

Re: JDBC Adapter and XI adapter cannot get large record

Postby robbyrnm » Mon Jan 24, 2011 11:02 pm

Baz wrote:how big is the file you are trying to send? if it is bigger than 50mb then you need to increase the file size on all your ABAP stacks (ECC, PI and BIW)


I already check size of file, that isn't bigger than 50 mb, the file size is 4 mb. I think icm/HTTP/server_cache_0/memory_size_MB set default is enough.Any other solution?

thank
robby
robbyrnm
 
Posts: 3
Joined: Fri Jan 21, 2011 1:50 am


Return to SAP Process Integration (SAP PI/XI)

Who is online

Users browsing this forum: No registered users and 1 guest





loading...


This website is not affiliated with, sponsored by, or approved by SAP AG.