Chat now with support
Chat with Support

Toad Data Point 6.0.5 - Release Notes

Known Issues

The following is a list of issues known to exist at the time of this release.

Feature

Platform

Known Issue

Defect ID

General SAP ASE Using SAP ADO.NET client and SAP ODBC driver it is not possible to convert any character set to all other character sets. TMB-1850
General Sybase ASE

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).
N/A
General Excel If an Excel file is open in Toad, you cannot open the same file in a separate Excel instance. To review this and other limitations when using Excel in the Web Browser, see "Considerations When Using the WebBrowser Control" at: http://support.microsoft.com/kb/304662. ST42486
General Salesforce

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

 

N/A

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

N/A

Toad Data Point 3.0 or later doesn’t support User IDs that contain Unicode characters. ST90367, ST90372
The Toad Data Point Read Only installation is read-only for all databases, with the exception of MySQL. If you are using a Read Only installation of Toad Data Point, you will be able to modify a MySQL (and only MySQL) database. 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

ST66330
Installation n/a

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.

N/A

Connections

ODBC

Currently, Toad does not support ODBC connections to the following databases:

  • Sybase Advantage

  • Oracle RDB

  • Progress OpenEdge

  • MySQL ODBC (The ODBC 3.51.17.0 driver is not supported, and attempting to connect using this driver results in columns not displaying for tables.)

    Workaround:

    Upgrade the MySQL ODBC driver to 3.51.27.00 or later to display table columns.

ST69744

Connections Azure SQL Database You need to install Microsoft Active Directory Authentication Library (adalsql.msi) to connect to Azure SQL Database using Active Directory Password Authentication. QAT-14556
Connections Access

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.

ST94125
Connections Vertica ODBC

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

ST109484
Connections Amazon Redshift You might experience problems after a Redshift connection is unexpectedly dropped. QAT-2194
Connections Amazon Redshift After canceling a Redshift query it might continue to run on the server. QAT-2195
Connections Amazon Redshift

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

Connections 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

Connections MongoDB For a MongoDB 3.0 (or later) connection, the user must have Read/Write privileges in the MongoDB database in order to view sub-tables (MongoDB embedded documents).

TIC-5520

Automation All

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)

QAT-16234
Automation   All

If Toad Data Point 6.0.5 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.0.5 not as administrator, or turn UAC off, or close Outlook when adding the Send Email activity in Automation.

  ST80857
Automation All

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

Automation All An 'System.Windows.Automation.Peers.AutomationPeer' sometimes occurs during application start. QAT-14566
Data

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

Execution Plan SQL Server

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.

N/A
Export Wizard/ One Click Export Access, Excel

 

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.

N/A

 

Import Wizard

Excel

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

N/A

Attempting to import data from a template that contains multiple worksheets results in an error.

 

ST77978

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

Oracle, DB2 When importing data using the Add Query feature, BLOB data is not imported even though the dialog and log indicate that the import was successful. ST77255
Library N/A

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

Local Storage 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.
QAT-3812
Object Explorer/ Database Explorer Sybase ASE When viewing a table that contains a BIGTIME data type column, attempting to select the Data tab causes Toad to unexpectedly quit.

N/A

Object Explorer/ Database Explorer Sybase ASE Currently, only foreign key constraints can be added or modified for existing Sybase ASE tables. ST55111
Oracle 11g

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.

ST66705
Publishing Wizard N/A Users with Active Directory authentication and with TIC 4.0.3 and TDP 5.0.3 will not be able to see automation logs. This issue does not occur when TIC and TDP are the same versions. QAT-14578

Query/
Query Builder

All

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

The Query Builder currently uses a 24-hour format for timestamps. Attempting to run a query with a date range that includes a 12-hour timestamp format results in incorrect formatting of the timestamp. ST78729
Query/
Query Builder
Local Storage Currently, in a cross-connection query using Local Storage, Toad does not support quoted table alias names (example, the table alias "foo bar"). Quoted column names are supported. ST86483

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

Toad Intelligence Central All

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.

N/A
Toad Intelligence Central N/A

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.

N/A
Data Compare N/A

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

QAT-14218
User Interface N/A

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.
QAT-6045
Workbook N/A

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

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

N/A

Third Party Known Issues

The following is a list of third party issues known to exist at the time of release of Toad Data Point 6.0.5.

Feature      Platform Known Issue ID

Connect to Database

DB2 If you are using the DB2 Client version 9.5, 9.7, or 10.1 in a Windows 8 or Windows Server 2012 environment, follow the instructions in IBM DB2 Technote 1618434: http://www-01.ibm.com/support/docview.wss?uid=swg21618434. N/A

Connect to Database

Excel

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

When connecting to Oracle 11, you must enter the password in the proper case because passwords are case-sensitive. N/A
Toad Data Point Automation All

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

Editor Teradata

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.
N/A

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

Excel Avoid using Excel for exporting if your data has numeric values that require a high precision because Excel's precision is limited to 15 digits. If you export numbers with more precision, the values are rounded. If you export boundary numbers (max, min), rounded numbers will exceed the data type limit. N/A
Import Wizard DB2 When importing data using the Add Query feature and selecting a Single new table, TIMESTAMP data types are mapped to DATETIME data types. N/A
Object Explorer Cloudera Impala

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.

N/A
Object Explorer/ Database Explorer Teradata

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

Object Explorer/ Database Explorer DB2 iSeries The primary Key column of an iSeries table displays as Nullable in the Database Explorer even though the Not Null checkbox was not selected when creating the table. N/A

Query Builder

Sybase ASE

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)

ST96868
Query Builder Cassandra and Excel/Access

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

Getting Started

Contents of the Release Package

The Toad release package contains the following products:

  1. Toad Data Point 6.0.5
  2. Product Documentation, including:
    • Installation Guide
    • Online Help
    • Release Notes
    • User Guide
    • Getting Started Guide

Installation Instructions

See the Toad Data Point Installation Guide for more information.

Product Licensing

Product Licensing

To activate a purchased commercial license

  1. In the Licensing dialog, enter your license (Authorization) key.
  2. Enter the site message included with the license key.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating