Creating a tracing db fails on a materialized view with a key join. The materialzed view in normal db works as expected. The related tables have a foreign key relation, so a key join is normally no problem.
Anyway the creation of the tracing db fails with: there is no way to join x and z.
Problem exists also in earlier versions like 2550
asked 27 Jul '11, 11:36
That sounds like a bug; I'll create an issue number pending reproducibility.
Note however that you don't need to create a tracing database to do tracing. You can send tracing information to any database; the only catch is that you will not be able to run some of the Recommendations if you don't have either a tracing database or a copy of the original database.
In fact, if you are in development, you can send tracing to either the local database, or to a copy of the local database that you have created.
answered 28 Jul '11, 22:12