The following is a list of issues known to exist at the time of this release.
Feature |
Platform |
Known Issue |
Defect ID |
---|---|---|---|
General | n/a | Highlighting style options in Editor settings cannot be migrated or applied | QAT-19434 |
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:
Workaround 2:
|
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): |
ST66330 | ||
Installation | n/a |
Previous installations cannot be uninstalled using TDP 6.2 Base & Professional Installer (for 32-bit or 64-bit) Workaround: Removing Toad Data Point using the Control Panel |
QAT-19245 |
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:
|
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:
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.:
|
QAT-16234 |
Automation | All |
If Toad Data Point 6.3 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.3 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: |
N/A |
Data Report Wizard |
N/A |
Report tab does not appear when clicking the Finish button in Toad Data Report Wizard Workaround: |
QAT-19068 |
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: |
N/A |
Export Wizard/ One Click Export | Access, Excel
|
Limitations when exporting fractional seconds:
|
N/A
|
Export Pivot Grid |
CSV
|
When the "Use current regional settings" option is enabled in CSV settings, it doesn't apply to the exported Pivot Grid |
QAT-18992 |
Export Pivot Grid |
CSV
|
Title: When exporting a Pivot Grid, if the "Always quote strings/char" option is checked, it is applied to all data types in the exported CSV file |
QAT-18981
|
Export Pivot Grid |
Excel/CSV
|
When exporting a Pivot to an Excel or CSV file without any suffix and without overwriting the existing file, three successive messages about file existence appear |
QAT-18990 |
Export Dimensional View |
CSV
|
SQL code is not included in the exported CSV file if the "Include SQL statement in output file" option is checked when exporting Dimensional View |
QAT-19033
|
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
|
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/ |
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/ |
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:
|
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 |
The following is a list of third party issues known to exist at the time of release of Toad Data Point 6.3.
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:
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
|
N/A |
Export Wizard/ |
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: 2007 PIAs: |
N/A |
Export Wizard/ |
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:
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 |
The Toad release package contains the following products:
See the Toad Data Point Installation Guide for more information.
Toad Data Point with offline license keys
To activate a trial:
Accept the license terms.
Download the trial file.
To activate a purchased commercial licensel:
In the Licensing dialog, enter your license (Authorization) key.
Toad Data Point Subscription with online licensing
Toad Data Point Subscription requires you to sign in with your Quest.com account.
Licenses are tied to your account giving you the flexibility to use Toad from multiple computers without having to move your license.
Sign in with existing Quest.com account:
Enter your account email address and password when prompted.
Create a new Quest.com account:
Enter your account details and select Sign Up.
Enter the code from the email and select Verify.
Activating a new license:
To purchase a new license, click Buy Now from Toad's title bar.
After completing your transaction, restart Toad and your license is automatically detected.
To manage licenses, select Manage licenses online beneath your account shown at the top-right of Toad.
NOTE: You can view your licenses from within Toad by selecting Help | About
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Nutzungsbedingungen Datenschutz Cookie Preference Center