Execute BEx queries at the same time

[michael_vk]

Dear Guru's,

May be you help me with the very strange situation. I'm not a specialist in SAP BW.

Situation:

In some of the workstations in the same window in different tabs of Google Chrome executing two different BEx query and on the second tab BEx query is waiting while query on the first tab is not finished and only after that is executing! In one of the workstations this situation is not repeat - the second query on the second tab executed regardless of the execution of the first query. What is the possible causes of this situation?

Thank you in advance.

[Savio_Dmello]

"In the workstations where the second query on the second tab executed regardless of the execution of the first query.", Sometime, the earlier result is saved in bex cache so Can you try changing the input variable values so that data is not picked from cache. You can also try deleting the cache before you reproduce the scenario. To delete cache try from WAD, menu tools -> setting -> delete cache -> delete cache. or transaction rsrt -> cache monitor -> delete.

[michael_vk]

Dear Savio_D,

What is the features I must disabled?

The video shows how I run BEx queries.

I've deleted the cache, but situation is the same.

Why on other workstation this problem doesn't appear?

[Savio_Dmello]

I saw the demo. I see that Ztest1 does not have any input variable. can you try by running Ztest first and then the DAYREPORT_... query simultanously in another tab with different selection dates . When these are getting executed, you can monitor the activity in tcode SM51 , It will show whether both queries are getting executed or something else is happening.

[Savio_Dmello]

is it only 1 workstation that has the issue or many workstation. Accordingly, You may have to open an incident with SAP product team to debug it

[michael_vk]

This issue occurs on few workstations. On my WS this situation is floating - sometimes it shows up, sometimes it doesn't.

[michael_vk]

Dear Savio,

In sm50 I see running only first query, running second query not showing. As second query I can use absolutely any other query and situation will be the same.

[michael_vk]

Ztest is executing very fast and I cannot repeat the situation vice versa. At the moment when queries are running, in sm50 I see only one working process:

[michael_vk]

Now, on one of the workstation where second BEx query was executing without delay, it's running incorrect (with delay).

No settings have been changed either in the system or in the browser!

[Savio_Dmello]

for Ztest query, can youadd more fields in row/columns and/or an input variable or to make it slow so that you get time to debug and check in sm50 . Also Did you try replication after disabling the cache option.

[Savio_Dmello]

Not sure if I understand your issue correctly, but you can try this. Chrome has feature called "Background Timer Throttling" that slows down the execution of background JavaScript processes (such as those running BEx queries) to conserve CPU usage.

Steps to Disable Background Timer Throttling:

1. Open Chrome and type chrome://flags/ in the address bar.
2. Search for "Throttle Javascript Timers in Background".
3. Set the feature to "Disabled".
4. Relaunch Chrome to apply the changes.

This ensures that timers in background tabs aren't throttled, allowing them to keep running as if they were in the foreground.

The disadvantage is that the background tab will keep consuming resources

[michael_vk]

Dear Savio_D,

Thank you for your feedback.

Unfortunately, in my Chrome I didn't find this feature:

[michael_vk]

In addition,

I can demonstrate this situation, see the video file on the link: https://dropmefiles.com/EqPj0

[Savio_Dmello]

I see the option as default in your screenshot. Can u try disabling it. Also, how are you running the BEx queries on web browser? by default you can't. Are these queries attached to portal or used in BO webi?