Copied query running indefinitely.

[Former Member]

Dear All,

I am facing a strange issue. I have a query say A. On execution of the query it works fine and displays the results. When I save this query as B and execute it, it does not display any result. The query executes indefinitely.

In SM50 the status is displayed as running with report CL_SQL_RESULT_SET=============CP. The action is Sequential Read.

Does anyone have faced simillar issue?

Regards,

Niraj

[Former Member]

Hi All,

Please let me know the solution for the problem,

As i am facing the same issue, our system will be working fine but suddenly single day it will become slow and when we monitor in sm50 it will be showing CL_SQL_RESULT_SET=============CP Sequential read.

After some time performance will increase automaticaly.

Please let me know the solution or the trouble shoot the problem.

Thanks & Regards,

Balaji.S

[Former Member]

Hello,

Did you find a solution about your problem ?

I have the same situation on an instance.

Many thanks in advance for your answer.

Best Regards

Vincent

[Former Member]

Has there been a solution to this? We're experiencing the same problem. It started when we made a change to a Profit Center Hierarchy Node. Reporting on that node makes queries run forever with CL_SQL_RESULT_SET=============CP in SM50 Process overview. Reporting on a higher-level node (that includes the bad node) actually runs fine.

[Former Member]

Cganged query properties in the RSRT not to read all data.

[Former Member]

Hi,

The query A may be having cache and this is being used so it might be getting output. Check if the query A has cache in RSDCACHE tcode. create cache for Query B and try it.

Regards

Akhan

[Former Member]

Hi Akhan,

Transaction RSDCACHE does not exist? Could you let me know correct tx code.

Regrds,Niraj

[Former Member]

Hi Niraj,

You can change it in the t-code RSRT.

Open RSRT and select your query, you will see query properties. you can change the cache mode of query from this screen. you can try different modes and observe the performance.

check the "Update cache objects in delta process" option from the properties of query in RSRT.

For more info..

cache is a temporary storage for recently access data.

Used to enhance query performance.

Use t-code RSRT to vew more on cache.

Cache helps to improve query performance. As it can save data in memory, flatfile, cluster table or BLOB.

You can remove cache per query or inactivate it for perticular info provider or inactivate it overall.

But which is not recommended. Yes if u know that certain queries you dont use often and its not accessing large number of records then you can inactivate it for those queries. you can manage cache via three t-codes RSRT or RSRCACHE or SPRO>SAP Reference IMG>SAP Busines Wearhouse--> Reporting relevent setting -->General Reporting Setting in BEX -->Global Cache Setting.

Hope this helps,

Sri...