Query on deleted cube not deleteable

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Hi Maxim,

thank you very much. I missed the entries in RSZELTDIR. After I deleted those entries I was able to save the query with the old name again.

Best regards

Sven

[Former Member]

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

[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

[Former Member]

Hi

First RSZDELETE tcode to delete

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

Regards

N Ganesh

[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

[Former Member]

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

[Former Member]

Hi Ankit,

I tried this but can not find my original query as I already deleted the corresponding InfoCube.

Greetings Sven

[Former Member]

Hi Sven

Use Tcode of RSZDELETE for deleting existing queries.

RSZC is used for copying queries.

Hope this helps ..

Let me know details if you still facing.

Reg

Pra

[Former Member]

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

Regards

Sankar

[Former Member]

Hi Sankar,

as far as I know this transaction is used for coping queries from one cube to another and not for deleting queries.

But thanks anyway.

Sven