Query Duplicates

[Former Member]

Hi Experts,

We have a situation here with queries having duplicate names.

How can I get rid of the duplicates?

Regards,

Sam

[Former Member · Accepted solution]

Hi Samuel

I do not think that system will allow you to create duplicate queries. If you feel that this is the case with you and you do not want it jst see if you have deletion option or if similar is the case with the dev system transport the deletion request to the required system which will remove the unwanted query

Thanks

Puneet

[Former Member · Accepted solution]

HI Puneet,

Duplicates were created after transporting in our testing box.

[Former Member · Accepted solution]

Hi,

Even though the original query is deleted, there will be M version queries which might be the cause for duplicate queries.

Execute the function RSZ_X_COMPONENT_DELETE with the parameters:

I_COMPUID (can be obtained from RSZCOMPDIR table)

I_ENQMODE E

I_OBJVERS (in this case 'M')

I_DELETE_VARIABLES blank

This will delete 'M' version queries.

Hope this helps.

Best Regards,

Rajani

[Former Member · Accepted solution]

Try running program ANALYZE_RSZ_TABLES and select RSZCOMPDIR to change the duplicate names to some other.

Make sure you change the ones with different Query ID's to the ones in Development system.

[Former Member · Accepted solution]

System will allow Queries with same Technical name but different description and vice versa.

If you think the same query is repeating,you need to manually delete the queries.

assign pts if it is useful,thanks