Drill Through error: "[WARNING] Unable to start drill-through.[STEP Profiler[Profiling]]"

Edit Subject

Hi,

First, let me explain how the Drill-through recording is implemented in DQA. Since we cannot rely directly on the source data (it may be from a database, file, or even a result of a complex transformation), DQA creates a new database table to hold the drill-through data. Another reason for this is that we calculate a number of additional fields during profiling (such as masks) which have to be stored as well.
If you select the drill-through option, you chose a database (can be completely different from the DB with the source data) and a table prefix (you can safely keep it empty, PROF prefix will be used in that case).

The problem you are experiencing is that you don't have permission to write data to your default tablespace (in your case, USER_DATA) in that Oracle database. It may be also possible that you have only a read-only access to the data (since database name is DLQ_PRD, it probably holds production data).

I can see three possible solutions: (1) ask your DBA to change your default tablespace to a tablespace where you have permission to write (alter user ... default tablespace ...), or (2) ask your DBA to give you permission to write to that tablespace, or (3) select a different database to store the results - either configure a new database connection or use the database that comes with DQ Analyzer (should be named DB). At the moment, DQA does not support creating drill-through tables on non-default tablespaces.

If the database is a production one, I would recommend using approach (3), so that the database stays intact.