cancel
Showing results for 
Search instead for 
Did you mean: 

Program for unused queries

Former Member
0 Kudos
94

Hi Gurus,

i am looking for any program which will point out unattached queries- queries fro which infoproviders/infoobjects donot exist.....so that i could delete them....

Southie

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Not in the office a tthe moment, but there is a utility pgm that catches a variety of inconsistencies like this. I'll post the program and the realted OSS note tomorrow.

Pizzaman

Former Member
0 Kudos

Thank You...please send me the note link

Former Member
0 Kudos

Take a look at Note 792779

https://websmp201.sap-ag.de/~form/sapnet?_FRAME=CONTAINER&_OBJECT=012006153200001604712004

From the Note

<i>2.3 Components based on non-existing InfoProviders

Queries or query components are assigned to the InfoProviders which do not exist anymore in the system. Queries without InfoProvider are not available in Open Dialogs of frontend applications, but can be executed in RSRT. The execution will return the error message 'InfoProvider not found'. The recommended solution is to delete the unnecessary components. Deletion of these queries or query components can be done directly from the list using corresponding procedure similar to RSZDELETE transaction.

2.4 Components based on non-active InfoProviders

Queries or query components which are assigned to the InfoProviders which do not exist in the system in the active version. Queries without active InfoProvider are not available in Open Dialogs of frontend applications. In case, an affected query is technically consistent, an attempt to execute it in transaction RSRT will return the message 'Activate the XXX InfoCube / InfoProvider again. Message #BRAIN 056'. Quite often this error is combined with other errors like missing GENUNIID in the RSRREPDIR or other inconsistencies. Each case has to be investigated in order to get the current status of this object. If the affected query is useless, it can be deleted from the system using transaction RSZDELETE.

The check is available only for the query elements in object version 'A' (active).</i>

You run this program in reporting only mode, and the result allows you the option then of deleting the queries.

Pizzaman

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

You will not be able to delete any infoproviders without deleting the queries attached to it.

regards,

ravi