Performance Issue

[Former Member]

Hi,

System:BI-ABAP + Java

I am running one report on Portal. Some times for larger selection I am getting the output but even for smaller selection I am not getting the output and also getting Dump TIME_OUT. We can not change the parameter rdisp/max_wp_runtime.

Started the trace on user

Output of trace:

111.662 ciSID Server 1 0 Servernamej. ciSID Server BICS_PROV_GET_MEMBERS 4.305 1.465

Server BICS_PROV_GET_INITIAL_STATE

Server BICS_PROV_GET_RESULT_SET

Server RSOD_BIRM_QUERY

Server BICS_CONS_CREATE_PLANNING_SEQU 1

Server BICS_PROV_VAR_GET_VARIABLES 305.618 997

BICS_PROV_SUBMIT_VARIABLES

Server BICS_PROV_GET_MEMBERS 1.

Above all are also taking more time.

138.402 UPC_AREA FETCH 1 0

8 UPC_AREAT READ SI 0 256 P 24 172EZSEMC18

982 UPC_AREAT PREPARE 0 SELECT WHERE "MANDT" = :A0 AND "LANGU" = :A1 AND "AREA" = :A2

6 UPC_AREAT OPEN 0 SELECT WHERE "MANDT" = '172' AND "LANGU" = 'E' AND "AREA" = 'ZSEMC18'

163.385 UPC_AREAT FETCH 1 0

Client OLE_FLUSH_CALL

Client RSDRP_EXECUTE_AT_QUERY_RFC 108.652 7.249

Client OLE_FLUSH_CALL is taking most time

Please help me...

[Former Member]

Issue at functional end.

[Former Member]

Hi ManMohan,

We are facing the same issue.

Could you please tell how you solved it.

Thanks

Lalit

[Former Member]

Hi ManMohan,

We are also facing the same issue.

Please tell us how you solved the problem.  It would be great!!

Thanks

Pablo

[Former Member]

This note correction is already delivered in SP-6

Currently we are at SP-8

[Former Member]

Hi,

Please check the note again, It's clearly say that "You have to perform this manual pre-implementation step manually and separately in each system before you import the Note to implement."

Just check if you face same problem in the standard program also. If so then you can go for the note.

And if its customized program then you can take help from your developer...

Regards

Bhuban

RKFL

[Former Member]

Hi,

Can you please provide your BI Version?

Regards

Bhuban

RKFL

[Former Member]

SAP_BW-701-0008-SAPKW70108

[Former Member]

Hi,

Please check this note. Maybe this will help you....

Note 1399816 - Task name - prefix - RSDRP_EXECUTE_AT_QUERY_DISP

Regards

Bhuban

RKFL

[Former Member]

One more thing I want to add here is...It is customized program.

Is it some thing related to program tuning.