cancel
Showing results for 
Search instead for 
Did you mean: 

BEx queries not running after reloading of currency exchange rates.

Former Member
0 Kudos

Hello,

I am facing issues when running BEx queries across the system since the time I reloaded the currency exchange rates. Anyone has any idea about this? Am I correct in thinking that is what is causing the problem. The few queries that I have looked at, all have some kind of a key figure within the cube/ods that has currency. When I execute them, they either hang or immediately pop up the "Disconnecting from the Server" message. At the same time, there are queries in the system that are working.

A couple of the users got an CX_RSR_CACHE ERROR.

We are on BW 3.5

Any assistance will be deeply appreciated as people are not able to access a lot of reports.

Thank you so much in advance!

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Menaz,

Go to transaction RSRT and select Cache Monitor. Try to delete both Local and Global Cache by selecting Delete All Cache Types.

Then, on RSRT screen again select Query menu and Generate Report.

Hope this fixes your problem.