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.

 

6302 4 / Create an account to join the discussion.
marcia.m
Follow / 18 Apr 2018 at 1:25am / Toad Data Point
Latest post by on 20 Apr 2018 at 5:53pm

Full Profiling on Hive generic ODBC result set not working since migration...

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

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/

Stack trace:

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)

Thanks

143 5 / Create an account to join the discussion.
rmdat2003
Follow / 16 Apr 2018 at 9:17pm / Toad Data Point
Latest post by on 20 Apr 2018 at 12:13pm

Automate dcp file does not remember connection

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

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 ?

170 3 / Create an account to join the discussion.
InfoMan
Follow / 19 Apr 2018 at 9:54pm / Toad Data Point
Latest post by on 19 Apr 2018 at 10:05pm

Calculated Column returns as a string instead of a number value

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

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 4.3.0.718 (32 bit)

Unanswered 82 1 / Create an account to join the discussion.
MR BARKER
Follow / 17 Apr 2018 at 10:59pm / Toad Data Point
Latest post by on 19 Apr 2018 at 6:24pm

How to export SQL script to Qlik Sense QVD

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

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.

Thanks

Unanswered 137 3 / Create an account to join the discussion.
tracy.bakowski
Follow / 18 Apr 2018 at 4:08pm / Toad Data Point
Latest post by on 18 Apr 2018 at 8:43pm

Cross Connection Queries

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

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 4.1.0.226.  Any guidance is greatly appreciated. Thank you!

Unanswered 124 1 / Create an account to join the discussion.
netezzatdp
Follow / 16 Apr 2018 at 7:13pm / Toad Data Point
Latest post by on 17 Apr 2018 at 7:19pm

Special character as column delimiter ASCII 30 - 01E - RS: Record...

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

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?

175 4 / Create an account to join the discussion.
angie.freeman_52846
Follow / 16 Apr 2018 at 8:04pm / Toad Data Point
Latest post by on 16 Apr 2018 at 9:37pm

Scheduled Toad Data Point process kicks off but doesn't error...

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

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.

149 1 / Create an account to join the discussion.
tm3561
Follow / 25 Jan 2018 at 5:26am / Toad Data Point
Latest post by on 16 Apr 2018 at 6:06am

Need a method to disconnect database connections once automation is...

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

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.

Thanks

1662 10 / Create an account to join the discussion.
clcham
Follow / 13 Apr 2018 at 5:11pm / Toad Data Point
Latest post by on 13 Apr 2018 at 6:51pm

Toad Data Point 3.8 - Crashes when connecting to Oracle Database ...

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

Hello, 

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.

Thanks

-Clay

236 2 / Create an account to join the discussion.
AleemCh
Follow / 12 Apr 2018 at 11:17pm / Toad Data Point
Latest post by on 13 Apr 2018 at 6:25pm

Toad Data Point 4.3.0.718: Using variables for dynamic filename

Expand content
Hi, I am trying to use a variable in an automation script to generate dynamic filenames and then use the variable in "Select to File" activity to export data. Using "Set Variable"...
Hi,
I am trying to use a variable in an automation script to generate dynamic filenames and then use the variable in "Select to File" activity to export data.
Using "Set Variable" activity I have defined a variable like so:
       

Next in "Select to File" activity I am trying to assign a dynamic value like so:
         

Next I have a "Log Comment" activity to display the value like so:
          
But when I run it the value is not displayed. The second last line where I expect a value
            
I must missing something very simple here!
Thank you for your help!
Aleem
280 3 / Create an account to join the discussion.
smattiko83
Follow / 13 Apr 2018 at 4:05pm / Toad Data Point
Latest post by on 13 Apr 2018 at 6:04pm

date field

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

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.

Thanks.

223 1 / Create an account to join the discussion.
Guru Krishnan
Follow / 30 Oct 2017 at 8:40pm / Toad Data Point
Latest post by on 13 Apr 2018 at 3:55am

Automate data compare of queries executed against two different d...

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

Hello,

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.

Thanks,

Guru

2112 5 / Create an account to join the discussion.
ilijatoad87
Follow / 11 Apr 2018 at 9:38am / Toad Data Point
Latest post by on 12 Apr 2018 at 12:58pm

Toad Data Point

Expand content
Hello, Can you tell me can TDP 4.3 work on Microsoft Server 2016?

Hello, Can you tell me can TDP 4.3 work on Microsoft Server 2016?

323 4 / Create an account to join the discussion.
ArjenLissenberg
Follow / 11 Apr 2018 at 5:04pm / Toad Data Point
Latest post by on 12 Apr 2018 at 12:55pm

Consecutive sorting in results, dimensional view or Transform

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

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.

282 1 / Create an account to join the discussion.
Azybanoous
Follow / 11 Apr 2018 at 8:32pm / Toad Data Point

Filed List , (Report) - Toad For Data Analyst

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

Hi everyone,

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

Does anyone know how I can dock it back to my window?

I would appreciate your advice and help.Yes

Azzy

164 0 / Create an account to join the discussion.
peter.d.maxwell
Follow / 9 Apr 2018 at 3:56pm / Toad Data Point
Latest post by on 10 Apr 2018 at 8:14am

XLSM in Script - Sliders deleted

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

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.

Pete

351 1 / Create an account to join the discussion.
jennifer.mccolley_000
Follow / 6 Apr 2018 at 6:18pm / Toad Data Point
Latest post by on 9 Apr 2018 at 8:51am

Error upon logging in

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

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"

---------------------------------------------

TargetInvocationException

Exception occurred in other process

 

Stack Trace:

   at Dell.NamedPipeRPC.MessagePumpClient.Invoke(Delegate target, Object[] parameters)

   at Quest.Toad.Db.ConnectionProxy.ProxyConnectionParameter.Finalize()

 

Quest.Toad.Exceptions.BaseException

Internal error: cannot remove IDbConnection in IConnection: 'P1MAXTRAN (VIEWALL), VIEWALL'

Stack Trace:

   at Quest.Toad.Db.Connection.ForceClose()

   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)

   at System.Windows.Forms.Form.RaiseFormClosingOnAppExit()

438 2 / Create an account to join the discussion.
NikhilP
Follow / 5 Apr 2018 at 8:35pm / Toad Data Point
Latest post by on 6 Apr 2018 at 7:09pm

Connecting to HIVE Using ODBC Connector

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

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

505 5 / Create an account to join the discussion.
InfoMan
Follow / 4 Apr 2018 at 3:56pm / Toad Data Point
Latest post by on 5 Apr 2018 at 4:54pm

Pivot Grid - How to Sort by Data Area values

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

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"?

478 2 / Create an account to join the discussion.