Skip to Content
Author's profile photo Former Member

BEx Delete Duplicate queries

Applies to:

SAP BW 3.5x / Business Intelligence 7.3x, Business Explorer (BEx).

Summary:

This document is intended to a specific case where Multiple Queries gets created with Same Technical Name.

Author(s)     :  Ganesh Wathare

Created on  :  11 November 2013

Author Bio:

Ganesh Wathare works as Technology Lead in Infosys Limited. He has 7 years of experience in IT Consulting Industry during this time he has worked majorly on SAP NetWeaver BW and relational databases together with different BI reporting tools. He has worked on Various Support and implementation Projects.

Summary:

While transporting query to further landscape some time multiple entries gets created for a same query (Technical Name). This happens in a special cases like  we delete query in development which is already sent in landscape and then we create new query with same technical name. But while transport we just send a Transport for newly created query. In such a cases sometime system creates new query with same technical name and previous query will be still present. Because of this when we execute query it will execute old query itself. Even multiple time transport does not help.

This blog is to those specific cases where such a scenario gets created. Some times when we execute query system takes new query sometimes it takes old query, in such a case this blog will help to clear orphan queries.

Steps to Delete Queries:
1) Check if multiple queries present with same technical name

Query elements are stored in table RSZCOMPDIR i.e. Directory of reporting components. We can check if there are multiple entries for same query technical name. For each query there will be 2 version’s so to check if there are multiple queries with same technical name, provide query technical name in Query filter and Provide Version as ‘A’ to check active records. Below screen shows a selection for table. ( We can see table data in se11 or se12 or se16)

If there are multiple queries present then in table there will be two or multiple entries in the table. These entries will be having different UUID hence it is possible to have such a entries in table.

/wp-content/uploads/2013/11/1_322640.jpg

When we execute query if old query is still getting executed then it is because of multiple entries in tables, which we need to clean, so that system will recognize new query. We can identify the entries for respective queries by using Changed by, Changed At, etc fields as below.

2)Delete Entries from table using RSZDELETE

We can delete these entries from table using t-code RSZDELETE for deletion of entry of a query we need to provide UUID for query. Query is identified by Type field, so provide input as a REP in Type field. Select Version Transport System Based on Process related to your system.

Dependent Objects like Workbooks, Query Views and BBS Sender/Recipient we need to delete before we run this transaction individually.


If there are no dependent Objects in the system, transaction will show output as below. You can identify dependent Objects from this screen also, so that you can delete those objects also from system.

Once we click on Execute button prompt will come to confirm for deletion. Select Yes to delete the query from system.

Confirmation screen will pop-up once query is deleted as below.

To confirm deletion in the system we can go back to table RSZCOMPDIR and see entries, we can see one entry got deleted from system and only one entry is present in the table.

Also as we start executing query then system will not find any query, as query is deleted.

3)Remove inconsistency in tables using program “ANALYZE_RSZ_TABLES”

Once we delete the query using a transaction RSZDELETE then it creates a inconsistency in tables which can be identified and correct using a program ANALYZE_RSZ_TABLES (we can execute Program using se38 transaction).

This Program has selection screen as below, where we can select tables where the program should check inconsistency,

Once we click on execute, program will give a output with all inconsistencies. Icon shows Inconsistencies which need to be fixed. As we have delete one query we can see count 1 in front of RSRREPDIR table.

If we click on button in front of count we can see the query as below.

/wp-content/uploads/2013/11/1_322640.jpg

Once we confirm and click on Execute Button system ask for confirmation, click on Yes.

Once program gets executed below screen comes which will shows 0 count for RSRREPDIR table. This shows that inconsistency got corrected.

For ANALYZE_RSZ_TABLES check reference attached to this blog.

Now if we execute query we can see that new query is getting executed without any error.

Suggestions for using these steps

Its better to avoid problem than solve problems, so always transport Query deletion request in system. Don’t use this program if correct query is getting executed.

References:

https://scn.sap.com/thread/10671

https://scn.sap.com/thread/1997950

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/602074dd-bcc9-2e10-4eb5-8107050066bc?QuickLink=index&overridelayout=true

Assigned tags

      42 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Anshu Lilhori
      Anshu Lilhori

      Hi Ganesh,

       

      Images are broken can you check it again..

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Anshu,

       

      I can see images in Firefox as well as in IE, i have removed some of the confidential data in paint.

       

      Regards,

      Ganesh

      Author's profile photo CH Raman
      CH Raman

      No ganesh, not visible even single pic. may be scn team need to check. please clear your cache and recheck from your end.

      Author's profile photo bl vijaykumar
      bl vijaykumar

      i am able to see friends...

      Author's profile photo Anand K
      Anand K

      Yes...No picture visible as said Raman

      Author's profile photo Former Member
      Former Member

      Hi Ganesh,

       

      Copy your pics and paste them in paint; then copy them from paint to use. So that they may work fine in all the places. We are yet to see your paints.

      Author's profile photo Former Member
      Former Member

      Hey Ganesh, Just a quick question

      is this possible to create multiple queries with same technical name? i didn't try this but i assume that SAP will not allow to create query with same technical name.

      Author's profile photo CH Raman
      CH Raman

      Not bex query, any objects with same technical name not possible to create multiple times in sap.

      Author's profile photo Anshu Lilhori
      Anshu Lilhori

      It is not possible but the scenario which Ganesh shared with us is that sometimes we create query directly in production and then with the same name we create the query in development and the system allows us to create with that tech,name because that entry is not in development.

       

      Hope this gives an idea.

       

      @  Ganesh Wathare Images are still not visible.Please check the same.

       

      Regards,

      AL

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Om,

       

      It is not allowed if you try to create manually, but in case when you already have one query present in system (specially cases where people transport query to U systems and then as it is not required delete it in Dev and don't transport delete request to U) and you transport new query with same technical name, then you will get multiple entries in RSZ* tables this is because in these tables we don't have a only Query technical name as a Key, System itself creates a ID for a BEx query and that is a Key for a Tables.

       

      I guess this is clear now.

       

      @ Anshu, i guess something went wrong with images, i will update it, I have only one example in my current system i will capture and keep a backup with me also...

       

      Regards,

      Ganesh

      Author's profile photo Anshu Lilhori
      Anshu Lilhori

      Ok Ganesh please do that..Eagerly waiting to see the images..

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Done

      Author's profile photo Former Member
      Former Member

      No images. I really like to see

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi All,

       

      I am also not able to see images today .

      I will update it again.

       

      Thanks for input.

       

      Regards,

      Ganesh

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Anshu, Raman, Arshiyan, Kumar, Anand,

       

      I have updated images again, seems to be some issue with Firefox when i have inserted from insert option it is working.

       

      Looking forward for your feedback.

       

      Regards,

      Ganesh

      Author's profile photo CH Raman
      CH Raman

      Yes Ganesh. looks pretty.

      Thanks for sharing in detailed level and easy to understand.

       

      Thank You.

      Author's profile photo seshu P
      seshu P

      Hi Ganesh,

       

       

      Helpful Document, Thanks For Making & Sharing.

       

      Yes Done, Now Its showing images.

       

      Regards,
      Seshu.P

      Author's profile photo Anshu Lilhori
      Anshu Lilhori

      Finally we are able to see the images..Indeed great document.Thanks ganesh for sharing this and appreciate the efforts you put it.

       

      This might come handy anytime and good to know the tables and program behind it.

       

      Regards,

      AL

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Anshu, Raman and Seshu for your feedback.

       

      Regards,

      Ganesh

      Author's profile photo Former Member
      Former Member

      Good piece of doc, really useful. Thanks for sharing

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Arshiyan,

       

      For your Feedback.

       

      Regards,

      Ganesh

      Author's profile photo Krishna Chaitanya
      Krishna Chaitanya

      Hi Ganesh,

       

      Thanks for sharing..Appreciate your efforts..Great job..keep going

       

      Regards,

      Krishna Chaitanya.

      Author's profile photo Former Member
      Former Member

      Good Doc Ganesh...Thanks for sharing..:)

      Author's profile photo Former Member
      Former Member

      Very Helpful Document

       

      Regards,

      Sushant

      Author's profile photo Former Member
      Former Member

      Thanks for sharing the doc..

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Krishna, Vijay, Naveen, Sushant, Prerna for valuable comments.

      Author's profile photo Former Member
      Former Member

      Hi Ganesh...Good to see all the pics now.

       

      You might have copied all urls from some where, it is appearing as a single link at the bottom. Copy them individually to access.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Kumar for your valuable comments. I have updated links correctly.

      Author's profile photo Satendra Mishra
      Satendra Mishra

      Thanks for this lovely document.........

       

      Regards,

      SM

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Sarendra.

      Author's profile photo Former Member
      Former Member

      Very well presented document .Learning new things day by day 

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Sanyukta.

      Author's profile photo Former Member
      Former Member

      Good one Ganesh.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Venkatesh.

       

      Regards,

      Ganesh

      Author's profile photo Former Member
      Former Member

      Nice one,

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Giri

      Author's profile photo Former Member
      Former Member

      Thanks for Sharing, Ganesh !

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Siva for comment.

      Author's profile photo Former Member
      Former Member

      Thanks Ganesh. Nice Effort.

       

      Best Regards,

      Venu Gopal

      Author's profile photo JAI GUPTA
      JAI GUPTA

      good document sir

      Author's profile photo Former Member
      Former Member

      Thanks for Sharing, sir.

      Author's profile photo Former Member
      Former Member

      nice one ,sir.