Chat now with support
Chat with Support

Toad Data Point 5.3 - Release Notes

Troubleshoot Publishing to Toad Intelligence Central

Troubleshoot Publishing to Toad Intelligence Central

Use this section to troubleshoot publishing errors.

To troubleshoot issues when publishing an Automation script, see Troubleshoot Scripts on Intelligence Central.

Issue or Error Message Solution or Workaround
Google Analytics or Salesforce - expired access/refresh token

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.

"Data source name not found" error msg when using ODBC connectivity

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.

missing MySQL ODBC driver on TIC

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.

missing Teradata ODBC driver on TIC

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.

missing driver on TIC

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 problems publishing from an Oracle connection

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.
ORA: 1242

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 ODBC driver does not support the data type."

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."

"Out of sort memory" error

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

Columns with the same name

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.

"Incorrect key file" error msg

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.

Specified key was too long

Error Msg: "Specified key was too long; max key length is 1000 bytes"

This error may occur if you selected columns to index on the Indexing Options tab (applies to snapshots and datasets only). There is a limitation in the TIC database: The maximum index size (key length) is 1000 bytes.

  

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating