Query giving run time error.

[Former Member]

Hi BW Experts,

Here goes my question :

There is a query which is giving runtime error as time limit exceeded. This query is based on an infoset which is based on 4 ODS's.

Is there any way we can do performance tuning for this query?

Many Thanks in advance,

Sudip.

[Former Member]

hi,

check in these Tcodes. DB02 and RSRV

[Former Member]

Hi Dass,

Thanks for your help.

Can you please tell me how to use the RSRV transaction for a query which is based on an infoset?

Regards,

Sudip

[Former Member]

Hi

Check in RSRV and execute+debug in RSRT to get the exact reason for the error

Check whether your joins are compatible with SAP stipulations

Regards

N Ganesh

[Former Member]

Hi Ganesh,

Thanks for your help.

Can you please tell me which option to select for the infoset query as i'm seeing a lot of options on the left hand side of the screen like master Data, Transaction data, ODS objects,PSA tables etc for the RSRV transaction?

Also to add-on from my first post...this particular query is executing for an hour after which the error message comes an "System Failue, Time limit exceeded".

Regards,

Sudip.