BW 7.0 system response time is slow during some time

[Former Member]

Hi all,

We have WAS 6.20 portal as front end for users for accessing reports from R/3 4.6c and BW 7.0.

We have ITS 620 which is using for communication between WAS and R/3 4.6c and from WAS to BI 7.0 as we know ICM in Bi is taking care of that.

We are facing issues some times means twice in 4 weeks of time as all the users requests which come as dialog from WAS to BI 7.0 for acessing reports are hanging and causing all the apps servers to respond very slow and some time no respond at all.

We have 7 apps and BIA 7 blades which will come in to for load balancing and BIA for faster accessing the reports.

I have checked the gateway and dev_icm,Dev_w0 not able to find the traces of any issues.. we are still analyzing the WAS and BI ..

Please suggest whether we can check any other log files or traces in BI , BIA or WAS .

Env:

Oracle 10.2.0.4, SUn solaris 5.9,BW 7.0,BIA -v 50.

Thanks,

Subhash.G

[Former Member]

You should locate the contension

is your servers sized big enough to handle 7 apps ?

Check the setting of the message server queue.

Check the RFC load (has RFC queueing been setup ? parallele server set tx rz12 ?)

what are the CPU, RAM & SWAP requirements for each of them ?

How many CPU core do you have ?

With how mauch RAM ?

how much SWAP ?

Is your solaris a 64 bits version ? (run isainfo -b) (i suppose you do since i think it is a requirement for oracle 10)

Is your oracle parameter sga_target set ? 0 < sga_target < sga_max_size

Check your SGA and PGA are correctly set (or make it check by a dba guy).

Check your Oracle alert<SID>.log, and look for "ORA-" pattern, you might see if you have processes number issue or session number issue or other clue .

By the way you can also see if your current oracle settings (processes, sessions) have been reached by having a look :

select * from gv$resource_limit

check the SAP buffer synchronization between DB and AS by checking the rdisp/bufrefmode parameter.

http://help.sap.com/saphelp_sm32/helpdata/en/3d/ad5b8e4ebc11d182bf0000e829fbfe/content.htm

What is slow : one AS ? all AS ? the DB serv ?

please give more clue (run an AWR report and check it : the top wait events ? top SQL statement ? physical read ? ...)

How many work process did you configure on each of your AS ?

Do you have logon group ?

how many concurrent user do you have?

[Former Member]

Hi Subash,

Try the SAP Note 1341459 - Choosing "Refresh" in ITS. It may help.

Thank you,

Tilak

[Former Member]

Thanks

[Former Member]

Hi all,

I have observed the below error info in dev_icf in one of the apps server .

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

<ErrorInfo URL="http://usbw.nam.xxxinternal.com:/sap/bw/BEx">

<ErrorMessage>HTTPIO_PARSE_REQUEST_ERROR</ErrorMessage>

<Date>20090618</Date>

<Time>145720</Time>

<Client>200</Client>

<User>00300086771</User>

<TerminationType>UNKNOW_TERMINATION_NR</TerminationType>

<ABAP-CallStack>

<Module>

<Name>%_HTTP_START</Name>

<Program>SAPMHTTP</Program>

</Module>

</ABAP-CallStack>

</ErrorInfo>

<ErrorInfo URL="http://usbw.nam.xxxinternal.com:/sap/bw/BEx">

<ErrorMessage>HTTPIO_PARSE_REQUEST_ERROR</ErrorMessage>

<Date>20090618</Date>

<Time>163735</Time>

<Client>200</Client>

<User>00300215451</User>

<TerminationType>UNKNOW_TERMINATION_NR</TerminationType>

<ABAP-CallStack>

<Module>

<Name>%_HTTP_START</Name>

<Program>SAPMHTTP</Program>

</Module>

</ABAP-CallStack>

</ErrorInfo>

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Thanks,

Subhash.G