Quest has been named as an ASP "Ten Best Web Support Sites" award winner. Learn more.

Toad Data Point - Knowledge Base

Filter Your Results
Search All Products

Self Service Tools
Knowledge Base
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
Featured Content
What's new in TDP 4.2
Making Effective Use of TDP
How to query Salesforce data
How to use Data Profiling
How to find the license number
Contact Support
Contact Support

Search Knowledge Base by keyword

(Choose different product)



Sort By Last Updated
Displaying 1-25 of 2113
Error "Cannot create a file when that file already exists" in automation script, after upgrading (232208)

After upgrading to 4.2/4.2.1 an automation task, that has run successfully in previous versions, no longer works. The following error shows in the log file. "Cannot create a file when that file already exists". The task has 3 activities that write to the same file (different tabs). ...

Product(s): Toad Data Point
Last Updated On: 8/18/2017
(0 Ratings) 6 views
Impala CHAR datatype length not showing up correctly in Object Explorer (231091)

Connecting to Impala CDH v5.8.3, using ODBC v2.5.39 driver. After making a successful connection to Impala, many of the datatypes show up correctly. However, the Impala CHAR datatype length is not showing up correctly in Object Explorer. ...

Product(s): Toad Data Point
Last Updated On: 8/18/2017
(0 Ratings) 104 views
HIVE connection doesn't show all databases / schemas (229251)

Toad Data Point (TDP) is successfully connecting to Hive, but it only shows a small list of databases / schema in the Object Explorer, And there are more than four hundred databases that should be listed. Toad only pulls the ...

Product(s): Toad Data Point
Last Updated On: 8/18/2017
(0 Ratings) 5 views
ODBC connection to HIVE lists all tables regardless of the database they come from (232176)

Connecting to HIVE using a ODBC connection Toad Data Point (TDP) connects successfully but in the object explorer one may see all tables from all databases in one single list, it's too hard to remember to what database they belong to, they should be listed separately ...

Product(s): Toad Data Point
Last Updated On: 8/18/2017
(0 Ratings) 4 views
Task / Srcipt scheduling issue (232158)

Operation completed with errors. Click the button for more details. Server: DESKTOP-EQR0KL2. Exception: (1,1306):WnfStateChangeTrigger: When Toad Data Point (TDP) changed the job manager to use version 2 of the windows task scheduler, it started having some issues. ...

Product(s): Toad Data Point
Last Updated On: 8/17/2017
(0 Ratings) 4 views
Toad installation gives a privilege or group policy error (69739)

The Toad installation may encounter one of the following errors: 1. ERROR: "You don't have the privilege to perform the installation. Please login as administrator to install the product.". or. 2. "The installation can't be completed. ". or. ...

Product(s): Toad Data Point, Toad for DB2 ZOS, Toad for DB2, Toad for SQL Server...
Last Updated On: 8/16/2017
(2 Ratings) 8024 views
Toad for DB2 6.0 and newer, DB2 client requirements. Error: "Toad did not find a default DB2 client" (128114)

On launch of Toad for DB2, the error "Toad did not find a default DB2 client" is given. Toad will continue to open after clicking OK to this message, but there may be further issues connecting to the database. (Considering Toad ...

Product(s): Toad Data Point, Toad for DB2 ZOS, Toad for DB2, Spotlight on DB2
Last Updated On: 8/16/2017
(0 Ratings) 8593 views
Are multibyte character sets, like Kanji, supported? (232122)

Are multibyte character sets, like Kanji, supported? In general, we support unicode. However, each provider type has different requirements on setting this up for server and client. The one area where we do not support unicode, yet, is Cross-Platform execution. ...

Product(s): Toad Data Point
Last Updated On: 8/16/2017
(0 Ratings) 6 views
Unable to create connection to HBase in Toad Data Point (231801)

How to configure connection to HBase in Toad Data Point. As a first step it is necessary to have Stargate host, what is HBase Rest server. In eg Cloudera, it means to have started HBase REST Server role. Then type the hostname ...

Product(s): Toad Data Point
Last Updated On: 8/16/2017
(0 Ratings) 1 views
ERROR:"This property is supported only in doughnut chart types" when exporting to an Excel file (229205)

In automation, when doing the export to an Excel spreadsheet that contains doughnut charts using Toad Data Point 3.8, the following error is received: "This property is supported only in doughnut chart types". WORKAROUND: Upgrade Toad Data Point to the latest release. ...

Product(s): Toad Data Point
Last Updated On: 8/15/2017
(0 Ratings) 15 views
When using Export to File activity in automation, pivot table lose format (228281)

An export to file activity is created in automation. The exported data will be saved in an existing Excel file that contains a pivot table. The Excel file contains two sheets: - Sheet DATA: It contains the data to be exported. - Sheet B: It contains a pivot table created from Sheet DATA. ...

Product(s): Toad Data Point
Last Updated On: 8/15/2017
(0 Ratings) 13 views
ERROR: "Maximum number of trial keys exceeded" when launching Toad Data Point (227144)

When launching Toad Data Point, the following error is received: "Maximum number of trial keys exceeded". Internal system for tracking licenses will not allow to use the license key. WORKAROUND: Contact the Sales representative ...

Product(s): Toad Data Point
Last Updated On: 8/14/2017
(0 Ratings) 5 views
Is there a way to copy or export the Describe information of an object using Salesforce connection? (230481)

The Describe information of an object (for example: a table) can be copied or exported using an Oracle connection. But, when using a Salesforce connection, there is no possibility to copy this data. Ctrl + C or select all does not work either. ...

Product(s): Toad Data Point
Last Updated On: 8/14/2017
(0 Ratings) 142 views
TDP can not execute a BULK INSERT in SQL-Server, can not load the file (230889)

Can't execute "BULK INSERT" in Toad Data point ( TDP ) but can outside TDP in SQL Server Management Studio ( SSMS ). TDP and SSMS were in different coputers, once TDP was intalled in the same computer as SSMS it worked. ...

Product(s): Toad Data Point
Last Updated On: 8/14/2017
(0 Ratings) 2 views
Row size too large. The maximum row ... (230236)

Connecting to HIVE, one may see the error: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns ...

Product(s): Toad Data Point
Last Updated On: 8/14/2017
(0 Ratings) 2 views
Execute Script button disabled (232006)

Having an Editor open, and working fine, after finishing the current connection (DEV) and starting another connection (PROD) the Execute Script button was disabled. The Editor does not automatically recognizes the new connection ...

Product(s): Toad Data Point
Last Updated On: 8/10/2017
(0 Ratings) 4 views
Common Oracle connection problems (7712)

How to troubleshoot connection errors when logging into a supported Oracle database Common Oracle connection errors: * ORA-12154: TNS: could not resolve service name * ORA-12505 TNS: listener could not resolve SID given in connect descriptor * Error: 1.0 [Load ...

Product(s): Toad Data Point, Toad for Oracle, SQL Navigator for Oracle
Last Updated On: 8/10/2017
(0 Ratings) 31288 views
Should the Explain Plan tab be available when connected to Vertica? (231992)

TDP 4.2 and older don't implement any explain plans for connection types that uses ODBC. WORKAROUND. Typing "EXPLAIN" at the top of the query shows a PLAN that may help. STATUS. Will possibly be included in the 4.4 commercial release of Toad Data Point.

Product(s): Toad Data Point
Last Updated On: 8/10/2017
(0 Ratings) 5 views
Active Directory (AD) group is empty (0) or AD users missing from drop down list when doing Add User (Active Directory) (211316)

When trying to add Active Directory (AD) users to Toad Intelligence Central (TIC) via the Web Server or the TIC Admin Console, there are many users missing from the drop down list. Similarly, when adding an AD group, the Group is empty ie (0) users in the group. ...

Product(s): Toad Intelligence Central, Toad Data Point
Last Updated On: 8/9/2017
(0 Ratings) 1176 views
Only able to see default database in dropdown of Object Explorer or Query Editor (231981)

After trying to turn off/on multi-threading, my Impala connection no longer shows the correct databases when connected. It only shows the "default" database anymore. There are not any other databases in the drop-down. Queries ...

Product(s): Toad Data Point
Last Updated On: 8/9/2017
(0 Ratings) 3 views
How to find out who is using what license key in order to deactivate the user from the license? How to track the license keys? (105289)

How to find out who is using what license key in order to deactivate the user from the license. In the event of a Toad user leaving, how can the licensed key be tracked down and deactivated from the user. It is the responsibility ...

Product(s): Toad Data Point, Toad Data Modeler, Toad for DB2, Toad for SQL Server...
Last Updated On: 8/9/2017
(1 Ratings) 4890 views
Netezza table flagged as Invalid database object name in Cross connection query (231947)

Cross-Connection query set up to combine data from DB2 and Netezza and list order numbers that are only on Netezza. Pop-up error message says that: "NZSQL (e328545), NZMK_PRD1_HUB'.ADMIN. ORDERHEADER is an invalid database object name.". ...

Product(s): Toad Data Point
Last Updated On: 8/8/2017
(0 Ratings) 5 views
Errors when editing Teradata data in TDP. (231884)

Errors trying to edit Teradata data in Toad Data Point 4.0. When editing with .NET Data Provider for Teradata, get the following error: [.NET Data Provider for Teradata] {122007] TdCommandBuilder only support single table select ...

Product(s): Toad Data Point
Last Updated On: 8/5/2017
(0 Ratings) 14 views
When using the import wizard with Excel files and an Oracle connection, the process do the import every 5-7 rows (226781)

The Oracle database connection can be configured as a Direct connection or as an Oracle client (OCI) connection. When the Oracle connection has been configured as a Direct connection, the import wizard of big Excel files do the process every 5-7 rows. ...

Product(s): Toad Data Point
Last Updated On: 8/3/2017
(0 Ratings) 4 views
Not able to see all the schema listed in the Object Explorer (231830)

Unable to see other schema in the Object Explorer, besides the one being connected to and maybe one or two other schema, and all their associated objects. However, tables in the schema that cannot be seen can have queries run on them with no problems, in the editor. ...

Product(s): Toad Data Point
Last Updated On: 8/3/2017
(0 Ratings) 6 views