Toad Data Point 5.6 - User Guide

Error Msg: "Invalid data source definition: 400 Bad Request: Invalid_grant (expired access/refresh token)"

This error may occur if the connection's authentication token is expired.

Solution: In the Publishing dialog, click the Authentication link, then click Reauthorize to re-enter your credentials and grant access to Toad.

Error Msg: "Invalid data source definition: Data source name not found and no default driver specified"

Solution 1: TIC uses only System DSNs. Make sure that you have specified a System DSN and not a User DSN.

Solution 2: The DSN on the TIC server must match the DSN you are using. Ensure that the DSN installed on the TIC server is the same as the one you are using to publish.

Note: This only applies when the connection you are publishing from uses ODBC connectivity.

You are missing the MySQL ODBC driver. You can download the driver from the following site: http://dev.mysql.com/downloads.

Use MySQL ODBC driver versions 3.51 or 5.0.

You are missing the Teradata ODBC driver. You can download the driver from the following site: http://www.teradata.com.

In addition to the Teradata ODBC driver, you must also install the Teradata .Net Provider.

The Intelligence Central server you are publishing to is missing the matching ODBC driver. Install the required ODBC driver listed in the error message, or contact the administrator responsible for the Intelligence Central server.

You might also want to specify an ODBC driver to use when publishing from this database type to this particular TIC server.

To specify an ODBC driver

1. In the Navigation Manager, right-click the Intelligence Central connection and select Properties.
2. Select the Advanced tab and then select an ODBC driver (from the drop-down list) to use for that database type.

Note: Specify an ODBC driver to use only if you are having difficulty publishing from that particular database to the TIC instance.

General issue: The Microsoft-supplied ODBC driver for Oracle is included in a standard Windows install and has limited functionality. To insure that the TIC server is using the Oracle ODBC driver instead of the Microsoft-supplied driver, you can specify a driver to use when publishing to that TIC instance.

Suggestion: Specify driver to use when publishing.

1. Right-click the TIC connection in the Navigation Manager and select Properties.
2. Select the Advanced tab. Open the drop-down list next to Oracle and select the Oracle ODBC driver.

General issue: The TIC TNS names file may have a data service name that does not match the name in the TNS names file on the publishing workstation.

Suggestion: Modify one of the files to ensure the names match.

The Oracle ODBC driver does not support subtracting from TIMESTAMP. This is a known Oracle ODBC issue. If attempting to publish SQL such as the following:

Select Date_Col, Timestamp_Col - sysdate from Table

remove "Timestamp_Col - sysdate."

Error Msg: "Out of sort memory, consider increasing server sort buffer size."

This error might be encountered when attempting to publish a query or when querying a published snapshot/view containing a GROUP BY or ORDER BY clause.

Solution 1: Add “ORDER BY NULL” to the end of the query.

Solution 2: Increase the value of the sort_buffer_size variable by adding "sort_buffer_size=2M" to the Intelligence Central configuration file found here:

C:\Program Files\Quest Software\Toad Intelligence Central\datahub.cnf

Error Msg: "Duplicate column name '<column name>'. Add a differentiating column alias."

Your query includes two columns with the same name and the columns do not have unique aliases.

Solution: Add unique alias names for the columns.

Error Msg: "Incorrect key file for table 'C:\WINDOWS\TEMP\<myi file name>'; try to repair it."

Solution: The server is low on disk space. Increase available disk space.