Skip to Content
author's profile photo Former Member
Former Member

Query on deleted cube not deleteable

Hi Experts,

I've made a mistake and deleted a cube before I deleted the queries on this cube. Now I want to use this query name again but got the msg. "Query name already exists".

I tried report "ANALYZE_RSZ_TABLES" and deleted the inconsistent table entries but without result.

Any ideas in which table this entries could still exist and should be deleted or what else could cause the problem?

Regards

Sven

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2007 at 10:26 AM

    Hi Sven,

    If you have deleted all 'M' entries only from RSZCOMPDIR, this was not a good solution. You may have problems with transport and aslo this is the reason why RSZDELETE can not find anything in 'M' anymore.

    But anyway, the last place to check is RSZELTDIR. Here there is the field MAPNAME which probably still keeps old names of your queries. You will need to delete also the records in 'M' object version...

    Regards,

    Maxim

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 29, 2007 at 09:51 AM

    Dear Sven

    Please use the transaction RSZDELETE and check if you are able to delete the queries.

    Assign points if it helps.

    Regards,

    Ankit Agrawal

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 29, 2007 at 12:18 PM

    Hi

    First RSZDELETE tcode to delete

    Check the table RSZCOMPDIR in SE16 to make sure your query is deleted

    Regards

    N Ganesh

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi together,

      as I mentioned before I can not use transaction RSZDELETE because the selection screen does not find my Query because I already deleted the InfoCube in Backend before I deleted the query.

      I used report ANALYZE_RSZ_TABLES and cleaned all entries belonging to the deleted InfoCube in the tables RSRREPDIR, RSZCOMPIC, RSZCOMPDIR and RSZELTXREF manually with transaction se11.

      I'm not able to find any other entry belonging to the deleted cube or to the former query name, but the system still does not allow to use the old query name.

      Any other ideas?

      Thanks Sven

  • author's profile photo Former Member
    Former Member
    Posted on Nov 30, 2007 at 03:21 PM

    Hi Sven,

    You have the following problem: when you deleted queries based on non-existing

    InfoProviders from ANALYZE_RSZ_TABLES, only active version were actually deleted (this issue is already fixed in the latest versions of this report).

    But 'M' version of the same queries are still in the tables. Name check scans also 'M' versions, therefore you are getting 'Name already used' message...

    To solve this run RSZDELETE with the set of parameters:

    Type: REP

    Object version: 'M'

    InfoCube: you delete Cube.

    Select all queries listed and delete then.

    After that you will be able to use the names you can not use now...

    Best regards,

    Maxim

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Maxim,

      I'm not able to select the version in RSZDELETE and I can not find the former query name with this transaction.

      I already deleted the M-Version entries in the RSZ-tables but I must missed some entries or something like that.

      regards

      Sven

  • author's profile photo Former Member
    Former Member
    Posted on Nov 29, 2007 at 09:45 AM

    Try to delete the query from RSZC and use the same query name for other queries.

    Regards

    Sankar

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.