The forum will be unavailable for maintenance at some point from Friday, April 13 at 19:00 EDT until Sunday, April 15 at 23:59 EDT. Downtime will be minimized but the exact timing is unknown.

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

Any advice?

asked 27 Jul '11, 11:36

Martin's gravatar image

accept rate: 14%

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.

permanent link

answered 28 Jul '11, 22:12

Dan%20Farrar's gravatar image

Dan Farrar
accept rate: 80%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 27 Jul '11, 11:36

question was seen: 765 times

last updated: 28 Jul '11, 22:12