BEx Query Error in RSRT due to duplicate query element
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.
when searched in Query designer with query technical name,found only one entry.
And also in Table: RSZCOMPDIR,there is only one entry with same timestamp as Query designer.
The Query element name matching with RSZCOMPDIR table record.
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.
To resolve this error you need to delete the error entry in the table: RSRREPDIR,as it is not required any more.
After deleting you will find only one entry in the table: RSRREPDIR.
Now you can execute the query in RSRT without any error.
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