Page 1 of 1

JDBC Adapter and XI adapter cannot get large record

Posted: Fri Jan 21, 2011 2:34 am
by robbyrnm
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

Re: JDBC Adapter and XI adapter cannot get large record

Posted: Fri Jan 21, 2011 5:10 am
by Baz
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....

Re: JDBC Adapter and XI adapter cannot get large record

Posted: Mon Jan 24, 2011 4:14 am
by robbyrnm
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

Re: JDBC Adapter and XI adapter cannot get large record

Posted: Mon Jan 24, 2011 4:39 am
by Baz
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)

Re: JDBC Adapter and XI adapter cannot get large record

Posted: Mon Jan 24, 2011 11:02 pm
by robbyrnm
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