Toad Data Point Forum

Danny Torres
Follow / 14 Sep 2016 at 7:04pm / Toad Data Point
Latest post by on 10 May 2017 at 6:59pm

How to get the most out of this forum – Best practices for what information...

Expand content
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...

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)

-          http://documents.software.dell.com/toad-data-point/4.0/release-notes/release-notes/new-features

 -          Link to Download & Documentation

-          https://support.software.dell.com/toad-data-point/4.0

-          Link to Trial

-          https://software.dell.com/register/54955/

 -          Overview of new feature(s) (with link to the release notes)

http://documents.software.dell.com/toad-data-point/4.0/release-notes/release-notes/new-features

http://documents.software.dell.com/toad-data-point/4.0/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)

https://support.software.dell.com/toad-data-point/kb/195645

 2. Common Oracle connection problems (7712)

https://support.software.dell.com/toad-data-point/kb/7712

 3. Error, "ORA-12170: TNS:Connect timeout occurred" when connecting to Oracle (105610)

https://support.software.dell.com/toad-data-point/kb/105610

 4. Error connecting to database after installing on Windows 64-Bit OS: "ORA-12154" (12495)

https://support.software.dell.com/toad-data-point/kb/12495

 5. "ERROR [08001] [IBM] SQL30081N A communication error has been detected." when connecting to DB2 (47041)

https://support.software.dell.com/toad-data-point/kb/47041

Feel free to browse them. Remember to sign in to your account to view.

 

4248 4 / Create an account to join the discussion.
ArjenLissenberg
Follow / 19 Feb 2018 at 4:21pm / Toad Data Point

parameter in Where clause in Data Compare

Expand content
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...

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.

19 0 / Create an account to join the discussion.
dascott
Follow / 19 Feb 2018 at 3:53pm / Toad Data Point

Change of Compare connection resets comparisons

Expand content
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 4.3.0.7.18 (64 bit). No matter what Data Compare...

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 4.3.0.7.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.

Please advise.

Thanks for your help!

36 0 / Create an account to join the discussion.
hharwood
Follow / 15 Feb 2018 at 7:17pm / Toad Data Point
Latest post by on 19 Feb 2018 at 1:11am

File path issue with publishing automation scripts to Intelligence...

Expand content
Using Toad Data Point 4.3.0.718 (32 bit) and Toad Intelligence Central 4.3.0.126. Long story, but server we installed TIC on does not have access to the same network file share we do as developers, so...

Using Toad Data Point 4.3.0.718 (32 bit) and Toad Intelligence Central 4.3.0.126. 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.

232 5 / Create an account to join the discussion.
amlloyd
Follow / 13 Feb 2018 at 7:00pm / Toad Data Point
Latest post by on 17 Feb 2018 at 12:48am

Way to change column order on Object Explorer?

Expand content
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)

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)

182 1 / Create an account to join the discussion.
JohnCovelli
Follow / 15 Feb 2018 at 7:51pm / Toad Data Point
Latest post by on 16 Feb 2018 at 10:20pm

Brand New! Save The Pivot Grid! Tutorial Mentions .tpg

Expand content
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...

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...

John

301 5 / Create an account to join the discussion.
siva_pp
Follow / 12 Nov 2015 at 5:52pm / Toad Data Point
Latest post by on 16 Feb 2018 at 7:03pm

TOAD DATA POINT - Multiple queries export to Sheet1, Sheet2, Sheet3...

Expand content
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...

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.

Thanks,Siva

5300 4 / Create an account to join the discussion.
andy.corson
Follow / 15 Feb 2018 at 3:21pm / Toad Data Point
Latest post by on 15 Feb 2018 at 6:40pm

TDP Azure Connection

Expand content
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...

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?

Unanswered 154 1 / Create an account to join the discussion.
ALS82GT
Follow / 8 Feb 2018 at 3:34pm / Toad Data Point
Latest post by on 15 Feb 2018 at 5:10pm

Executing a script that executes another (using @)

Expand content
Hi, 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...

Hi,

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');

commit;

@p5.sql

 

Script p5.sql inserts another record in DPOINT

insert into dpoint values ('aaaaa');

commit;


 

579 8 / Create an account to join the discussion.
Patrick R
Follow / 14 Oct 2011 at 9:04pm / Toad Data Point
Latest post by on 14 Feb 2018 at 11:13pm

How do I change user password in a saved dcp comare file?

Expand content
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

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

7865 22 / Create an account to join the discussion.
Aleksey Bazhenov
Follow / 14 Feb 2018 at 10:45pm / Toad Data Point

Toad Data Point Beta 4.5.0.159 is now available

Expand content
Installer is available on the TDA Community website: https://www.toadworld.com/products/toad-data-point/toad_data_point_beta_program The latest list of fixes and enhancements can be found in the Release...

Installer is available on the TDA Community website:

https://www.toadworld.com/products/toad-data-point/toad_data_point_beta_program

The latest list of fixes and enhancements can be found in the Release Notes:

http://dev.toadfordataanalyst.com/releasenotes/beta/ToadforDataAnalystsRNBeta.htm

TDP Development Team

170 0 / Create an account to join the discussion.
andy.corson
Follow / 9 Feb 2018 at 4:02pm / Toad Data Point
Latest post by on 13 Feb 2018 at 5:28pm

SQL Formatter

Expand content
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...

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?

Unanswered 360 1 / Create an account to join the discussion.
jmwatson
Follow / 12 Feb 2018 at 2:20pm / Toad Data Point
Latest post by on 13 Feb 2018 at 1:57pm

Toad Data Point on Vertical Monitor

Expand content
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...

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?

Unanswered 325 3 / Create an account to join the discussion.
DavidFrisch
Follow / 12 Feb 2018 at 9:05pm / Toad Data Point
Latest post by on 13 Feb 2018 at 2:58am

how do I remove auto-suggest from query builder

Expand content
Hi, 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...

Hi,

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.

229 1 / Create an account to join the discussion.
christina.dasilva@nyumc.org
Follow / 7 Feb 2018 at 8:21pm / Toad Data Point
Latest post by on 9 Feb 2018 at 9:04pm

How do I view table metadata without direct access to tables/content...

Expand content
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...

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 4.2.1.303 (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!

Unanswered 692 5 / Create an account to join the discussion.
tom_60844
Follow / 5 Feb 2018 at 1:26pm / Toad Data Point
Latest post by on 8 Feb 2018 at 6:00pm

Summary Grouping With A Calculated Field

Expand content
Hello, 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...

Hello,

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

Unanswered 383 2 / Create an account to join the discussion.
-Wes-
Follow / 6 Nov 2017 at 7:18pm / Toad Data Point
Latest post by on 6 Feb 2018 at 8:32pm

'Save As' Window Not Working

Expand content
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...

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 4.2.1.303 (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?

Answered 1547 7 / Create an account to join the discussion.
joschmidt
Follow / 29 Jan 2018 at 9:32am / Toad Data Point
Latest post by on 6 Feb 2018 at 6:49pm

Comments not exported in in Create scripts on Teradata

Expand content
I'm using Toad Data Point 4.2.1.303 (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...

I'm using Toad Data Point 4.2.1.303 (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

 

select tablename,columnname,commentstring

from dbc.columnsv

where tablename='XYZ'

select tablename,commentstring

from dbc.tablesv

where tablename='XYZ'

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?

520 4 / Create an account to join the discussion.
cesar.zapata
Follow / 31 Jan 2018 at 3:11pm / Toad Data Point
Latest post by on 31 Jan 2018 at 3:33pm

String variable send as arguments adding single quotes

Expand content
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...

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.txt
pause

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? 

500 1 / Create an account to join the discussion.
tennis_champion
Follow / 24 Jul 2017 at 7:56pm / Toad Data Point
Latest post by on 31 Jan 2018 at 3:07pm

Issue with creating connection to PostgreSQL

Expand content
Hello 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...

Hello

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. 

3218 24 / Create an account to join the discussion.