Currently, if you open a Toad file in Toad Data Point 3.0 or later that contains a connection to Sybase ASE and was saved in Toad for Data Analysts 2.7 (or earlier) the file opens in an untitled Editor window. Use the following workaround which is for a Query Builder file, but a similar method can be used for any Toad file.

Workaround 1:

1. If you receive a message stating that the saved file cannot be opened, close the message pop-up. You will see that your Toad Query Builder document is open in an Editor window. Send this document to the Query Builder (Editor | Send to Query Builder).
2. Save the new Query Builder document as a new Toad file.

Workaround 2:

1. Open the Toad file in Notepad.
2. Use Find and Replace to change all instances of "sybase" (all lowercase) to "Sybase" (first character uppercase, with the rest lowercase).

After successfully changing the password or token for a Salesforce connection in Toad, attempting to open a Toad document created in a previous version (3.7 or earlier) using this connection results in a "Could not resolve connection" error.

Workaround: Recreate the Toad document (Import/Export template, Query Builder file, Automation script, etc.) using Toad Data Point 3.8 or later.

N/A

Installation/

Upgrade

All

(MSI installs on Windows 7) If you are using MSI to install Toad on Windows 7 with UAC enabled, you can install a file that adds a "Run as administrator" option when right-clicking the MSI file:

http://www.symantec.com/connect/downloads/msi-run-administrator-context-menu-vista

Toad Data Point does not support installation paths that contain UNICODE characters.

N/A

Currently, you cannot install Toad Data Point to a path that contains non-English characters. By default, Toad Data Point installs IBM DB2 merge modules as part of the standard installation process. These merge modules only support English characters.

Workaround (Stand-alone installation):
In the Destination Folder page of the installer, only use a destination directory that contains English characters

During installation on Windows 8, some users might encounter a prompt from Windows to install .Net Framework 3.5.

Workaround: In the Windows prompt, click Skip this installation to instruct Windows Not to install .Net Framework 3.5.

Currently, for a password-protected Access database, selecting Save password in the Connection Properties dialog does not preserve the password for the next Toad session.

Workaround:

1. To open a password-protected Access connection, right-click the connection in the Navigation manager and select Properties.
2. Select the Advanced tab and enter the password.
3. Select the Save password checkbox and click Connect.

Note: This will allow you to connect to the database and save the password for this session of Toad. Repeat the procedure if you re-launch Toad.

When using the Vertica ODBC driver version 6.1.1, data containing UTE-8 characters does not display correctly.

Workaround: Right-click the Vertica ODBC connection in the Connections Manager and select Properties. In the Connection Properties dialog, in the General tab, enter the following in the ConnectionString field:

ColumnsAsChar=0

When a Redshift connection in Toad is inactive for a period of time, attempting to access the connection can result in an error.

Workaround: Change the Windows TCP/IP timeout settings as recommended by Redshift. See "To change TCP/IP timeout settings" at http://docs.aws.amazon.com/redshift/latest/mgmt/connecting-firewall-guidance.html.

Caution: Editing your Registry incorrectly can cause serious, system-wide problems. It is advised that you back up your registry before modifying it.

N/A

Exported connections: A connection file exported from Toad Data Point 3.6 or later cannot be imported into version 3.5 or earlier.

N/A

TIC-5520

When you use a Set Variable activity with a String type variable for a VARCHAR type column and during its run you input a value that is numerical only you may get a "Error converting data type varchar to numeric." error.

Workaround:

Use a convert function in your query so that Toad uses the correct datatype, e.g.:

SELECT * from table WHERE my_varchar_column = TO_CHAR(:BIND_VAR)

If Toad Data Point 6.1 is launched as administrator on Windows 7 systems with UAC turned on and Outlook running, the auto-populate SMTP server info and contact list in Automation Email and Error Emails does not function properly.

Workaround:

Submit this information manually. Another option is to either run Toad Data Point 6.1 not as administrator, or turn UAC off, or close Outlook when adding the Send Email activity in Automation.

When Toad runs as an application in a Citrix environment, scheduled scripts might not execute if the user who scheduled the tasks is not logged on. In addition, an "Access Denied" error is logged for the scheduled task in the Windows Scheduler.

Workaround: Install and run Toad as a desktop when using Toad with Citrix.

N/A

ODBC - Ingress

In some cases, earlier Ingress ODBC drivers display an "Invalid number of columns or parameters specified" error message when displaying data that has Unicode characters.

Workaround:
Download the latest Ingres 9.3 ODBC driver.

N/A

You cannot generate an estimated execution plan for a local temporary table because the execution plan uses a different connection to generate the plan and does not know about the temp table.

Workaround:
Use the actual execution plan button to generate execution plans for SQL that contains a temp table.

Limitations when exporting fractional seconds:

• When exporting to an Access Database File, exports do not support fractional seconds, so the additional data is not exported.

• When exporting to an Excel instance, exports support only 3-digits for fractional seconds. However, if you export to an Excel file, it supports all fractional seconds.

Excel

Attempting to import data that was exported to an Excel instance where the fractional seconds were truncated results in an error.

N/A

ODBC - DB2 iSeries, Netezza

Currently, the Truncate table checkbox is disabled on the Select Target page when using an ODBC connection to a DB2 iSeries or Netezza database.

ST77986

A UAC setting at the highest level might interfere with the ability to drag a file to the Library window (from Windows Explorer) to add it to the Library.

Workaround: Set UAC to the default level to enable adding a file by dragging it to the Library window.

N/A

Issue: Local Storage is incompatible with previous versions of Toad.

If you upgrade to Toad Data Point 3.6 from a previous version, Local Storage upgrades silently and can no longer be used by the previous version of Toad Data Point (3.5 or earlier).

If you plan to uninstall 3.6 after installing it and then resume using a previous version, backup your Local Storage data prior to installing 3.6.

To backup Local Storage data

1. Navigate to C:\Users\username\AppData\Local\Quest Software\Toad Data Point Hub Data.
2. Make a copy of the Toad Data Point Hub Data folder and save it using a new name (such as Toad Data Point Hub Data 3.5 backup). If you uninstall 3.6, just move this copy back and use the original folder name.

N/A

On the Create/Alter User window, if you are modifying a password, you must enter the password in the proper case. You do not need to surround the password with double quotes.

If you enter the password in lowercase on the Create/Alter User window, and the generated script has a SQL command containing the password in lowercase, you will need to type the password in lowercase to login.

If you enter the password in uppercase on the Create/Alter User window, and the generated script has a SQL command containing the uppercase in lowercase, then you will need to type the password in uppercase to login.

Query/
Query Builder

The copy of the sub-query that contains the Union All operator is created after the connection in the Workflow is changed

QAT-17267

Query/
Query Builder

All

Save As Dialog

(Library)

For some users who enabled the Automatically add files to library on open feature, the Save and Cancel buttons in the "Save As" dialog are disabled. This issue was encountered in a Windows 10 environment. See knowledge base article KB235265.

Workaround 1: Press Enter when the Save As dialog is open to save your file.

Workaround 2: Select Tools | Options | Environment | General and clear the Automatically add files to library on open check box. If you use this workaround, newly-saved files and opened files are no longer automatically added to the Library.

N/A

When data includes high-precision numbers (i.e., those with a large number of decimal places), results from publishing to Intelligence Central may not always be as expected. In some cases, data may be truncated to include not more than 15 significant digits.

Background: In Toad Data Point 3.5 or later, your Intelligence Central user name must be lower-case.

Issue: In Toad Data Point 3.5 (or later), if you attempt to open a previously-saved connection to Intelligence Central 2.2 (or earlier) in which the user name contains upper-case letters, the connection will error.

Solution: Upgrade to Intelligence Central 2.3.

Data Compare cannot be performed on a very large number of tables with many columns. If maximum compilation size is exceeded you will receive a message with a recommendation to lower the number of tables or columns compared

Issue: Toolbar sub-menus and buttons disappear when selected. If you experience this issue, use the following workaround.

Workaround:

1. In Toad, select Help | About and select the Application Data Directory link to open this directory. Then exit Toad.
2. In the App Data directory, open the Session sub-directory and delete the Analyst.tss file. Restart Toad.
3. In Toad, select Tools | Configuration Wizard. Click Finish to close the wizard without selecting an option. The default option will be applied.

When you disconnect in Query Builder Toad may throw an error.

Workaround: Backup your Workbook by clicking Save As and restart Toad Workbook.

Connect to Database

Connect to Database

The following error is encountered when attempting to create a connection to an extremely large Excel file (for example, 20 MB or larger): "Microsoft. ODBC Excel Driver. System resource exceeded."

For more information, see http://www.toadworld.com/products/toad-data-point/f/36/p/20201/40998.aspx.

Workaround: Convert the Excel file to a CSV file.

N/A

Connect to Database

Oracle

(Oracle 10.2.0.1 client only) Attempting to connect to an Oracle database From Toad using the 10.2.0.1 Oracle client results in the following error: “ORA-24909: call in progress. Current operation canceled”. This is a known issue with this Oracle client (http://www.dbmotive.com/oracle_error_codes.php?errcode=24909).

Workaround: Upgrade your Oracle client to a later version and connect to the Oracle database.

N/A

Connect to Database

Oracle 11 only

Automation in Toad Data Point 3.3 or later requires .NET Framework 4.5 (or later). If you are using .NET Framework 4.0 without .NET Framework 4.5 (such as in Windows XP), you may encounter the following:

• After running a scheduled Automation script, Toad generates an error message even though the script executes successfully.
• In a Toad Intelligence Central environment, after running any published Automation script (scheduled or un-scheduled), Toad generates an error message even though the script executes successfully.

Workaround: Upgrade your Windows OS to Windows 7 and install .NET Framework 4.5 or later.

N/A

Data

ODBC- DB2 z/OS

In compatibility mode, the ODBC driver does not return enough information for the CommandBuilder to correctly generate update or insert statements.

N/A

If you experience performance issues using a Teradata connection, especially when using code completion in the Editor, use the Teradata Non-X views (instead of the X views).

To use Teradata Non-X views

• Select Tools | Options | Database | Teradata and select the Use Non-X views in Object Explorer option.

Export Wizard/
One Click Export

All

To export to an Office 2003 or 2007 Excel instance, the Office Primary Interop Assemblies (PIAs) must be installed. You can install the PIAs from one of the following locations:  

2003 PIAs:

http://www.microsoft.com/downloads/details.aspx?FamilyID=3c9a983a-ac14-4125-8ba0-d36d67e0f4ad&DisplayLang=en  

2007 PIAs:

http://www.microsoft.com/downloads/details.aspx?familyid=59DAEBAA-BED4-4282-A28C-B864D8BFA513&displaylang=en  

N/A

Export Wizard/
One Click Export

A view is represented as a table in Impala, so views display as tables in Toad. For more information, see https://issues.cloudera.org/browse/IMPALA-1697.

You may experience issues if you attempt to view object details and your Teradata .Net Data Provider version does not correspond to the Teradata database version to which you are connecting. Issues include:

• Object details for a View containing a DATE data type column do not display.
• Object details for a Table containing a NUMBER data type column do not display.

Workaround: Install the Teradata .Net Data Provider version that corresponds with the Teradata database version to which you are connecting. For example, if connecting to Teradata database version 14, use Teradata .Net Data Provider 14.11.

N/A

Query Builder

Cross-connection query: Sybase has difficulty dealing with numeric literals in queries. You may encounter the following error:

Implicit conversion from datatype 'CHAR' to 'INT' is not allowed. Use the CONVERT function to run this query.

when attempting to execute a cross-connection query such as:

Select * from table where numeric_column = 50

Work-around: Change the query to something similar to the following using the cast function:

Select * from table where numeric_column = CAST(50 AS SIGNED)

Cross-connection query: A query between Cassandra and either Excel 2010 or Access 2010 might fail to execute and display a lost-connection error.

Workaround: Upgrade to Excel 2013 or Access 2013 (or later).

N/A