Duplicate Queries and Query Components in BI Production Box

[Former Member]

Hi:

We have a situation where we have duplicate queries and query components in our Production BI box.

The problem was caused by transports. We have a development landscape and a support landscape where both are transporting separately up to the BI Production Box.

For example, query ABC was created in the development landscape and transported up to our production box.

The same query ABC was created in our support landscape and transported up to our production box.

Now in the production box we have 2 queries ABC with the same technical name and description but with different active ELTUIDs.

We have found the program ANALYZE_RSZ_TABLES and it does show us this problem in our production box with many queries and query components.

The question is how do we get rid of the duplicate ELTUIDs in our Production box and how do we stop this from happening during transport?

any suggestions would be helpful.

[Former Member]

Hi JC,

I think you can use Tcode RSZDELETE to delete the duplicate UIDs of elements or any query objects.

Test it in dev box / sandbox before using it in prod.

Thanks