Skip to Content
0
Former Member
Jan 21, 2008 at 04:20 PM

Duplicate Queries and Query Components in BI Production Box

10 Views

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.