QlikView Expressor: Tracing an ODBC Connection

    When an ODBC database transaction fails, the error messages displayed by expressor Studio and the etask command might indicate that an exception occurred. To get enough information to  diagnose the problem, you may need to turn on ODBC Tracing. That will  capture all error messages. Note, however, that performance will degrade  while ODBC Tracing is turned on.

     

    An erro message might indicate specifically that an ODBC Exception has occurred. For example, the message "Exception 'GenericOdbcOpException"" clearly indicates a problem with an ODBC connection. ODBC Tracing can be  useful, though, even when an ODBC-specific message is not generated. If  Studio crashes while running a dataflow that uses ODBC connections, turning on ODBC Tracing might prove helpful in identifying the specific  problem if is is related to the ODBC connection.

     

    Turn on ODBC Tracing prior to running a dataflow that is generating errors or otherwise failing.

    1. Select the Start > All Programs > expressor > expressor3 > system tools >Data Sources (ODBC) menu item.
    2. Select the Tracing tab in the ODBC Data Source Administrator dialog box.
    3. Change the Log File Path or leave the default path indicated.
    4. Click the Start Tracing Now button.
    5. Click the Apply button.
    6. Rerun the dataflow.
    7. Reopen the ODBC Data Source Administrator dialog box.
    8. Click the Stop Tracing Now button.