Turn off parallel processing for BEx Queries

[Former Member]

Hi,

I have few queries which are running fine in BW QA System but in Production system throwing to dump.

In QA they are executing in BW QA because the query is not running on parallel processing.

How can I turn off parallel processing for a single query and  turn off parallel processing for all the queries.

Thanks in advance

[Former Member]

Hi,

You can turn off parallel processing for one query using Execute and debug in RSRT. Select no parallel processing in the data manager section. I'd test this for one query and see if you no longer get a dump as this message is very common and can be due to other errors

Regards,

Denise

[Former Member]

Hi,

Thanks for the update...turned off the parallel processing but still getting the dump due to the new user exit variable in the query

The user exit variable is being tested in QA System...as QA is recent copy of production volume of the data is same between QA and Prod.

What a query which could be able to successfully run in QA can't able to run in BWP....

In the BW Prod the query execution is terminated with dump

Please help

Dump2.txt.zip

Dump1.txt.zip

[mohd_abdullah]

Hi,

This error is due to long running query which exceed the maximum runtime maintained in RZ11 for profile rdisp/max_wprun_time

By default it is 10 mins.

You can either run the query to fetch smaller data  or  increase the maximum w8 time for the above mentioned paramerter.

Kindly refer Note 25528 - Parameter rdisp/max_wprun_time   for more info.

Regards.

[Former Member]

Thanks for the update.

But the same query with the same amount of data in QA system executed successfully without any issues but in production i am getting dump

[mohd_abdullah]

Is the maximum wait time in the parameter I mentioned above are same or different in QA and PROD ?

[Former Member]

no its the same