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.
Is it possible to include a parameter in the Source Where clause and Target Where clause in a "Compare" module? I tried the ':' and '#*#' way of introducing a parameter/variable but neither were accepted. I'm trying to create an automation with a "Compare" module that is looped, generating a compare report per loop-cycle.
This issue is similar to, but different than, the issue in https://www.toadworld.com/products/toad-data-point/f/36/t/6948?pi11637=2
I'm running TDP 22.214.171.124.18 (64 bit). No matter what Data Compare connections I have, attempting to change the connection results in losing the comparison information. Rebuilding these comparisons takes about a half hour - I have over 200 tables to compare from a 400-table schema.
My comparisons are primarily between Oracle 12 and Postgres 9.5; comparing Oracle to Oracle or Postgres to Postgres (just changing the connection, not the technology) produces the same loss of function. Attempts to hack my way through by editing the XML of the .DCP file have not worked, either.
Thanks for your help!
Using Toad Data Point 126.96.36.1998 (32 bit) and Toad Intelligence Central 188.8.131.52. Long story, but server we installed TIC on does not have access to the same network file share we do as developers, so TIC will have to work with local file mapping, and I am having trouble getting file path mappings to work between running it from my notebook and publishing it to TIC to run there. Note that these scripts load data files into tables (ETL processing).
Is there any way to stop publishing from forcing the uncheck of Use Relative Path to Find Files in the Settings, or to stop steps like Copy File from converting drive letters (like E:) to UNC paths (\\server\share)? I've been trying various schemes, but do not seem to be able to have the script work from my notebook to a network file share and then publish it to TIC and have it work there as well.
Is there a way to change the order of the columns in the Object Explorer? For example in the image below, I want "schema" before "name". (TDP 4.3)
Hey Everyone! I am BRAND NEW to ALL THINGS TOAD, and I have just taught myself how to build a Pivot Grid THREE TIMES.... every time I save it, and go back into Toad later, I see that it has only save the SQL statement. So I have to rebuild the Pivot Grid again... which is PAINFUL, because of several aspects that do not seem to be as intuitive as an Excel Pivot, i.e. ranking the rows in DESCENDING order according to the count, and sorting the columns in reverse chronological order... so when I finally get it back into shape, I want to SAVE this thing... Robert Pound's tutorial shows to save it as a ".tpg" or "pivot grid" file, however that is not a choice in the dropdown when saving. Can anyone help me? Thanks! Below is a shot of what I did (before LOL) and am trying to build again...
Is there a way to automate naming worksheets within sql or a toad option? As of now multiple queries export to Sheet1, Sheet2, Sheet3 etc ? I want to set my worksheet names as CUSTOMER , CONTACT instead of Sheet 1 , Sheet2 etc. Appreciate your quick help.
My company has an Azure database, and I can connect through SSMS with active directory authentication. I cannot connect through TDP 4.3 because as soon as I enter the database, the authentication type changes to sql server authentication. Are future releases going to have active directory authentication? Is there any way I can connect in TDP 4.3?
I am trying to run a script that executes a script inside it (using @) and I am getting errors when the first script tries to execute the second (p5.sql). When I run the script in regular TOAD I get no errors. Thanks for your help!
Script 1 inserts a record into table DPOINT and then executes script p5.sql
insert into dpoint values ('Run Progs--P5');
Script p5.sql inserts another record in DPOINT
insert into dpoint values ('aaaaa');
Hi All, How do I change user password in a saved dcp comare file? I have recently changed my user password to our Oracle DB. Now I need to change it in the saved DCP projects. Thanks, Patrick
Installer is available on the TDA Community website:
The latest list of fixes and enhancements can be found in the Release Notes:
TDP Development Team
I just started using TDP 4.3 and I noticed that the default formatter puts column aliases before the column name in SQL Server. TDP 3.7 put the alias after the column name on the same line. I also see that the custom formatter options are for Oracle, not SQL Server when logged into a SQL Server DB. There is also no vertical scroll bar in the Custom window. How do I get the formatter to format the same as TDP 3.7? How do I view SQL Server formatter options?
I've recently discovered that the code auto-complete feature in Toad Data Point auto-hides (disappears) within a second of popping up when I'm using the program on a monitor in the vertical position. Without changing any settings, if I move/drag the program to a horizontal monitor, it works as intended without issue. I prefer to code on a vertical monitor. Is there anything that I can do to prevent Toad Data Point from auto-hiding the auto-complete feature when using a monitor in the vertical configuration?
I just recently upgraded to Toad Data Point 4.3. When I execute a sql query in query builder there's a a suggestion line that pops up highlighted in green at the top of my query builder that says
"-- Please press Visualize Query context menu item to synchronize query and diagram after editing."
Is there a way to turn off this auto-suggest setting?
Thanks for your time.
I'm looking to view table/field metadata for an oracle database. I do not have access to the tables/content in the tables, but have been granted access to the metadata. How can I go about viewing this in Toad Data Point 184.108.40.2063 (64 bit)?
The DBA said this is possible in Toad for Oracle via schema browser, but having trouble finding it in Toad Data Point.
Thanks for any suggestions you may have!
I have a TDP report that groups figures based on location where I have a summary at the bottom of each group.
In that report there are 2 columns that are percentages calculated by the SQL, but I can't create a summary in the group footer using that it seems.
I have instead tried a calculated field, I can get a report total but I can't limit the scope to just that location for the location total.
My question is how would I do that? Thank you in advance.
The report format is like this
Location (grouped by) | Total Orders | Orders with A | % of Total | Orders with B | % of Total
The problem here is that the buttons for 'Save' and 'Cancel' in the 'Save As' pop-up window do not function. The window otherwise works as intended (but is still useless!). I also discovered that moving the window will blank out these buttons, or blur them (was going to include screenshot, but apparently that is more complicated than I care to bother).
Toad Data Point 220.127.116.113 (32 bit) running on Windows 10 Enterprise (64 bit) version 1703 build 15063.674.
One of my employees noted this issue for the past couple of weeks on versions 4.0 and 4.1, and I could not replicate on 4.2. The problem first occurred for me on Friday (11/3), and is consistent in its behavior (e.g., does not work) now. Work around is to copy query file and change the name prior to opening, but I have not found a method to save changes made to an open file using 'Save As' to avoid overwriting the original query.
Anyone else experiencing a similar issue?
I'm using Toad Data Point 18.104.22.1683 (64 bit) with a teradata
select * from dbc.dbcinfo;
If i create a table and comment on it:
CREATE TABLE xyz
( test number);
comment on xyz
'this is a table comment';
comment on xyz.test
'this is a column comment';
I can see the data in the Data Dictionary
If i use the export from the object explorer (generate sql --> create script --> to editor), i don't get the comments
This is what i get:
CREATE SET TABLE xyz ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT, DEFAULT MERGEBLOCKRATIO ( test NUMBER)PRIMARY INDEX ( test );
Is there a option to get the comments?
I'm having an issue with toad adding quotes to argument when using the Run Program activity.
My variable formula calelled myDate = To_char(Current_date(), 'YYYY-MM-DD') .
my batch test batch command is simple.
@echo > C:\users\myuser\desktop\%1.txtpause
if I run this from cmd line I do test.bat 2018-01-31 and a file with name 2018-01-31 gets created. but If I run this from toad with argument #myDate#
then a file with name '2018-01-31' is created. the issue here is the toad is sending the date surround with single quotes. is there a way to not send these quotes?
on numerous occasions I have successfully created ODBC connections (first through MS ODBC Administrator) then in Toad Data Point (version 4.1) to the multiple PG databases.
I am creating a new one now a PG database. I can successfully create a connection via MS ODBC Admin as well as connect to it via PG Admin. But when I try to create a connection via Toad App (using same exact steps as previously) I am getting an error (see screenshot). Please advise. thank you.