You will no longer receive e-mail notifications from this forum.
Log-In to post
Contact Support on Twitter
The better a problem is described, the better the assistance tends to be.
In order to better assist with your issue at hand, please include the following information in your initial post:
- Product, Version, and relevant environment details.
- Include a screenshot of the problem
- Describe the problem fully. What result was expected?
- Can the issue be created on demand or is it intermittent?
- If the problem can be generated faithfully, what are the exact steps to recreate the problem?
- Any other pertinent information (see below)
Create Support Bundles
You can create a support bundle and send it to Dell Support or to the Toad Data Point community Web site (peer-to-peer support). The support bundle provides information (about your application and the database) that is used to help troubleshoot problems.
Select Help | Support Bundle. It may take time for Toad to generate the support bundle depending on your system configuration.The file name of the generated support bundle is ToadSupportBundleToad Data Point.zip.
Create Support Bundle for a SQL Query Issue
If your issue is a SQL query or cross-connection query issue, it is helpful if additional log files are included in the support bundle. These log files are automatically included if you generate a support bundle immediately after executing the query in either the Editor or Query Builder.
Use the following procedure to ensure that the SQL log files are generated and included in the support bundle. These additional log files (proxy.log located in the DataHubSupportBundle.zip and SQLAnalyze.log) are important to assist Support in troubleshooting the issue.
For issues related to SQL or cross-connection query optimization, use the following procedure as well. These logs are also helpful for optimization issues.
To create a support bundle for a SQL query or cross-connection query issue
In the Editor or Query Builder, reproduce the error or issue.
After reproducing the error, immediately select Help | Support Bundle to generate a support bundle.
Toad asks if you want to log the row count for each table used in the query. If you select Yes, Toad determines the size of each table used in the query. This adds additional time to the generation process, but also provides additional information about your issue.
When Toad is finished generating the support bundle, attach it.
Note: For best results, always send the entire support bundle.
*Note: Please refrain from including private data in your posts
Be as thorough as you can with the provided info. We will reply to you as quick as possible.
We are glad to assist you.
Latest Release Information:
This announcement includes information on our latest releases, links to our downloads and documentation and overview of new features. This way you can stay as informed as possible:
- What’s New Section (why they would want to pay attention to this new version)
- Link to Download & Documentation
- Link to Trial
- Overview of new feature(s) (with link to the release notes)
Top 5 Knowledge Base Articles:
On this post, you can find our top trending knowledge articles that other customers are inquiring about and popular solutions.
This month’s Top Knowledge Base Articles
1. This month’s Top Knowledge Base ArticlesVideo - Making Effective Use of Data with Toad Data Point (195645)
2. Common Oracle connection problems (7712)
3. Error, "ORA-12170: TNS:Connect timeout occurred" when connecting to Oracle (105610)
4. Error connecting to database after installing on Windows 64-Bit OS: "ORA-12154" (12495)
5. "ERROR  [IBM] SQL30081N A communication error has been detected." when connecting to DB2 (47041)
Feel free to browse them. Remember to sign in to your account to view.
I recently migrated from TDP Pro 3.8 to TDP Pro 4.2 64-bit.
I find that when I have query results from a Hive query, and I click the Profiling tab, I see the summary data, but when I click the "Full Profiling" link on top-right, nothing happens.
Full profiling works OK in 4.2 when I had results from an Oracle query, however.
This worked perfectly fine in 3.8, for Hive queries (32-bit driver), I did it a lot. But now 4.2, Hive result sets are not sending to full profiling. ?? any advice?
Best I can determine, I get this exception, when I click the link:
New exception: 4/17/2018 7:17:42 PM
Quest.Toad.Exceptions.IgnoredException: Could not resolve connection for TRL: odbc://1A+Hive+IT+KERB+BW3/
at Quest.Toad.Trl.TrlScheme.ResolveConnection(String trl, String xml, Boolean allowOpen, Boolean visible) at Quest.Toad.Profiling.ToadProfileSource.GetConnection() at Quest.Toad.Profiling.FullProfileOptionForm.set_ProfileSource(ToadProfileSource value) at Quest.Toad.Profiling.FullProfileOptionForm.ProfileData(FastTable table, ToadDataAdapter adapter) at Quest.Toad.Profiling.ProfileOverviewControl.fullProfileItem_ItemClick(Object sender, ItemClickEventArgs e) at DevExpress.XtraBars.BarItem.OnClick(BarItemLink link) at DevExpress.XtraBars.BarButtonItem.OnClick(BarItemLink link) at DevExpress.XtraBars.BarItemLink.OnLinkClick() at DevExpress.XtraBars.BarButtonItemLink.OnLinkAction(BarLinkAction action, Object actionArgs) at DevExpress.XtraBars.ViewInfo.BarSelectionInfo.UnPressLink(BarItemLink link) at DevExpress.XtraBars.Controls.CustomLinksControl.OnMouseUp(MouseEventArgs e) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at DevExpress.XtraBars.Controls.DockedBarControl.WndProc(Message& msg) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
I create a dcp file for automation, which has connections to two Excel spreadsheets that has different values. Toad properly shows the differences, but when I save the dcp file, and reload, the differences do not get shown - I have to recreate the connection and mapping again. I have tried the auto connect on and off, but the only way this works is to recreate the entire mapping, which is of course no use for automation scripts. What is the solution please ?
I thought that his was fixed in an earlier version of TDP, but this gremlin has struck me again. I have created a calculated column that is a very simple formula for Gross Margin Dollars ( table1.Revenue - table1.COGS ). I ran this query several times throughout the day, and now it has decided that the result will be string value instead of a numerical value. This means that when I send the results to a Pivot Grid, the column will NOT behave as expected with an aggregation...no summing, averaging, etc....just a zero. How can this be fixed?
Here is a screen shot showing how the values are left aligned (as one would expect for text/strings), instead of right-aligned.
Toad Data Point 18.104.22.1688 (32 bit)
I've written my SQL query and want to export it to a QVD file so that I can load it directly into Qlik Sense, is this possible? I only see options to export to Excel or csv.
Hello, I am trying to build a simple query connecting a SQL server table and an Oracle table. I've found many items in the help and videos saying this can be done. However, I am unable to find the option to build a cross connection query. We are using TOAD Data point version 22.214.171.124. Any guidance is greatly appreciated. Thank you!
When creating a template we have the option to choose a character as a column delimiter. In most case is the pipe character |
We'd like to use an ASCII special character to keep in pace with our Informatica exports. It is the ASCII character 30, AKA RS - Record Separator, which looks like this ^^. Is it possible in TDP to use this special character as a column delimiter?
I have a project in Toad Data Point 4.3 that runs find when I run it manually. I'm trying to schedule it and it acts like it kicks off but it doesn't do anything. It gets to the "Created Task Process" in task Scheduler and then just sits there. It doesn't even get far enough to create any logging in Data Point. I've checked the path and everything looks fine.
In automation I am running queries against an excel file, Teradata, local storage and hive, I need to close these connections after the automation is complete. TOAD makes the excel file read only, so maintaining the connection prevents any changes to the source data or a new file to be saved. I have a limit on concurrent connections to Teradata and hive and would just prefer local storage be disconnected.
I have migrated to a new computer and I am in the process of reinstalling TOAD. I was able to get my tsnname file load but now when I try to connect to the database it shuts down with out giving and error. Any help with this would be greatly appreciated.
Hi, is there a way to adjust the date field like in sql developer? I would like mm/dd/yyyy with on date/time stamp.
We are exploring Toad Data Point for enterprise data project, which involves comparing target tables that reside in MySQL database. Data for each of these tables are sourced by joining multiple tables in MS SQL Server database. To compare the enrichment process of target tables, we are using TOAD Data Point to run the source and target queries in separate Query Editor windows and then use the "Compare To" option of the result set to do the actual data comparison. It works very well for us so far, but given the manual nature of it we would like to automate it. The "Compare Data" within the automation wizard expects us to provide a data compare file (*.dcp), which only allows table to table comparison. Is there a way to compare two SQL queries executed against two separate database and compare the results through automation wizard? Please let us know.
Hello, Can you tell me can TDP 4.3 work on Microsoft Server 2016?
Is there a way to sort the output of a results set, dimensional View table or transform consecutively by different columns in TDP? Like: first by column A, then column B then Column C etc.. Is there a way to have these columns, used for sorting, being hidden?
Related question, what is the difference between "hiding" a column and "removing" a column in a Dimensional View table, I can't seem to find how to "unhide" a "hidden" column.
I am working on a report and the Filed List which should be like a small window is disappeared and All day I was trying to bring it back but I was not able to do that.
Does anyone know how I can dock it back to my window?
I would appreciate your advice and help.
I use a Excel template to update data and then a script within to refresh pivots. The sliders are deleted after a refresh if done via TDP 4.3.
Does anyone know what this error message means? The user is getting multiple pop up error windows when opening TOAD, and this is from the window where it says 'Copy to Clipboard"
Exception occurred in other process
at Dell.NamedPipeRPC.MessagePumpClient.Invoke(Delegate target, Object parameters)
Internal error: cannot remove IDbConnection in IConnection: 'P1MAXTRAN (VIEWALL), VIEWALL'
at Quest.Toad.Db.Connection.Dispose(Boolean inDispose)
at Quest.Toad.Db.Connection.Dispose(Connection connectionThis, Boolean bNotFromFinalizer)
at Dell.Common.LiveTime.DisposingHelper`1.Dispose(T tobject, Boolean bNotFromFinalizer)
at Quest.Toad.Gui.MainForm.OnFormClosing(FormClosingEventArgs e)
I am trying to connect to Hive Using ODBC connector.
1. I downloaded ODBC driver 2.5 from Cloudera website
2. Fill in all the information
getting Error : [Cloudera][ThriftExtension] (2) Error occured during authentication.
I can connect to HIVE successfully using Web Link
I have a simple pivot table (in the Query Builder area, not an independent Pivot Grid tab). How can I sort on the data values? I see that I can sort on the rows or columns by clicking on those, but how to sort on the count of or sum of something?
Example, how to sort on the "Count of Line"?