Data Transformation Engine Database Interface Designer Reference Guide

Chapter 10 - Debugging and Viewing Results Database Trace Files
Database Interface Designer Reference Guide
146
Producing the Database Trace in the Database Interface
Designer
Click the Trace tool or select Trace from the File menu to enable a database trace
file (.dbl). If trace is enabled, a database trace file is automatically created when
you generate a type tree. This file is placed in the same directory as the currently
open .mdq file. The newly created database trace file is named using the full name
of the .mdq file plus a .dbl extension. For example, if your .mdq file is named
Orders.mdq, the trace file is named Orders.dbl and is located in the same
directory. If your .mdq file is not yet named, the trace file is named
Database_QueryFile1.dbl and resides in the same directory, typically the default
installation directory.
Most problems encountered in the Database Interface Designer are relayed to the
user in message dialog boxes. For example, if an incorrect user-ID or password is
specified for a database, a dialog box appears when attempting to generate type
trees for tables in that database. The following example dialog box reports an
Oracle error ORA-01017 with the following message as returned by the database
driver to the database adapter:
invalid username/password; logon denied
Note If trace is enabled when the message in this dialog box appears, a corresponding
message is also written to the database trace file (.mdq_file_name.dbl).
The following is a sample of a database trace file when generating a type tree that
describes two tables in an Oracle database.
Note The contents of any trace file are database platform-specific.
<1776-940>: Datalink: bocadb2\\Northwind
<1776-940>: UserId : test
<1776-940>: Password:****
<1776-940>: No existing connection was found.
<1776-940>: Local transaction usage: Transaction ID 0x019287F4
<1776-940>: Transaction started - ISOLATIONLEVEL_READCOMMITTED
<1776-940>: Connection to SQL Server bocadb2 has been established.
<1776-940>: Retrieving 1 rows per fetch.
<1776-940>: The columns are of the following types: