Question Re: Query Status - In active in Technology Q&A

Query Status - In active

Former Member — Wed, 19 Jan 2011 15:26:42 GMT

In table RSRREPDIR if query is inactive then does it mean query is deleted and cannot be accessed, When does the query turn to inactive(INA) status.

Is GEN1TIME = the last used time of the query, or do i need to get this info(last used time) from RSZCOMPDIR

Is there any link from where i will get the explanation for the fields in the table.

Cheers,

Re: Query Status - In active

Former Member — Wed, 19 Jan 2011 16:10:50 GMT

Could you please also give the procedure on how do identify unused queries and delete it from the system.

Re: Query Status - In active

Former Member — Wed, 19 Jan 2011 18:23:26 GMT

Use Tcode RSZDELETE to delete the queries and to see whaich queries are least used I think above tables are enough to analyis the last used timestamp of the queries.

For deletion of Queries Pls use REP in type field

Edited by: N S on Jan 19, 2011 1:23 PM

Re: Query Status - In active

Former Member — Thu, 20 Jan 2011 02:14:22 GMT

Thanks NS,

Could you also indicate the scenarios in which the query turns to inactive ?

Re: Query Status - In active

Former Member — Thu, 20 Jan 2011 15:12:49 GMT

Didn't had this kind of situationbut might be due to wrong definationa nd incorrect formulas

Also you can activate the same using RSRT.

Remember generation of queries will always help