Skip to Content

This document explains about how to resolve an error in RSRT,when the query executed in the RSRT screen is directed to debugging screen and further an output with an error.

One of the reasons is the query you are executing is referring to old query which is already deleted from system.Deletion of BEx query is due to different requirements, one of the reason is query deleted in BW system to decommission the old query and need to create new query with the same name.

After creating new query with old technical name,we were not able to execute the query and it is dispalying an error as shown below.

1.JPG

2.JPG

when searched in Query designer with query technical name,found only one entry.

3.JPG

And also in Table: RSZCOMPDIR,there is only one entry with same timestamp as Query designer.

4.JPG

The Query element name matching with RSZCOMPDIR table record.

5.JPG

But in Table: RSRREPDIR,there are two entries for the same query.

And as you see in the error screen,the element referring to first entry in the below screen.

6.JPG

To resolve this error you need to delete the error entry in the table: RSRREPDIR,as it is not required any more.7.JPG

After deleting you will find only one entry in the table: RSRREPDIR.

8.JPG

9.JPG

Now you can execute the query in RSRT without any error.

10.JPG

11.JPG

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. Vineet Gupta

    SAP provides a standard solution as described in OSS Note 907025, which takes care of not only query duplication but all other BEx related objects such as variables, restricted and calculated Key figures etc. I am sure SAP doesn’t support directly deleting a row from RSRREPDIR table

    (0) 

Leave a Reply