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.

 

2202 4 / Create an account to join the discussion.
armand_charest_31540
Follow / 14 Aug 2017 at 6:14pm / Toad Data Point
Latest post by on 16 Aug 2017 at 2:49am

Data Point Version 4.2.1.303 (64 bit) Object Explorer Filter

Expand content
If you have a filter created in the Object explorer, how do you delete it? There also does not seem to be a SQL button to view the underlying code so you can modify it. Does anyone know how to do these...

If you have a filter created in the Object explorer, how do you delete it?  There also does not seem to be a SQL button to view the underlying code so you can modify it.  Does anyone know how to do these?  This is using an Oracle ODBC connection.  The section of Data Point the connect is in  ODBC Generic.

87 4 / Create an account to join the discussion.
jp3206
Follow / 15 Aug 2017 at 11:28pm / Toad Data Point
Latest post by on 16 Aug 2017 at 2:45am

The table *** can not be mapped (Cross-Connection)

Expand content
Hello, Im running a cross connection query between multiple servers and I wasnt having a problem until I added a few more servers to my query. Now I keep getting an error message stating the new table...

Hello,

Im running a cross connection query between multiple servers and I wasnt having a problem until I added a few more servers to my query.   Now I keep getting an error message stating the new table cannot be mapped,   If I delete the new stuff,  the query runs fine.  Its having an issue mapping the tables on the servers I just added I guess.  These are DB2 databases if that helps. 

As a trial I created an new cross-connection query builder and tried just adding one of the newer DB2 databases to this only, and I still get the error.  If I run a single query against the db it runs no problem.    Is there a way to fix this or go around this type of error. I need to run a query across 17 connections which is insane, but only get a handful to work. 

33 1 / Create an account to join the discussion.
regi.bron
Follow / 5 Aug 2014 at 4:16pm / Toad Data Point
Latest post by on 12 Aug 2017 at 1:33am

Hints in Query Builder

Expand content
Hi, Been using Data Point for a while now and have a question: Is there a way to add Hints in the Query Builder? My work around is to use Query Builder to generate SQL, then I cut and paste in a...

Hi,

Been using Data Point for a while now and have a question:

Is there a way to add Hints in the Query Builder?

My work around is to use Query Builder to generate SQL, then I cut and paste in a new Editor window and add my Hints there. Inefficient as all getout, but I haven't been able to find anywhere I can put in Hints in the Query Builder.

10825 5 / Create an account to join the discussion.
hharwood
Follow / 27 Jul 2017 at 11:28pm / Toad Data Point
Latest post by on 10 Aug 2017 at 12:28am

Return value from procedure into bind variable

Expand content
Using Toad Data Point 4.1.0.226 (32 bit) Working on Automation flow, have the variable Load_Success defined as Boolean earlier in the flow. Using the Execute Script activity, trying to capture the out...

Using Toad Data Point 4.1.0.226 (32 bit) Working on Automation flow, have the variable Load_Success defined as Boolean earlier in the flow. Using the Execute Script activity, trying to capture the out Boolean parameter of a package.procedure call into my variable but keep getting Oracle errors. Here is the last attempt:

DECLARE
  OUT_SUCCESS BOOLEAN;
BEGIN
  CONTACT_FEED.LOAD_VCAST_ACCTS_TO_CONTACT(OUT_SUCCESS);
  :Load_Success := OUT_SUCCESS;
END;

When I run, I get:

ORA-06550: line 5, column 34:
PLS-00382: expression is of wrong type
ORA-06550: line 5, column 3:
PL/SQL: Statement ignored

Any help is appreciated.

118 3 / Create an account to join the discussion.
AlexBl
Follow / 2 Aug 2017 at 6:06pm / Toad Data Point
Latest post by on 9 Aug 2017 at 2:43pm

Toad automation - Export Wizard

Expand content
Hello, I'm trying to export query from my local storage . I would need to create an automation process to be done each week for this query. After 10 min run I get Error:" Timeout expired....

Hello,

I'm trying to export query from my local storage . I would need to create an automation process to be done each week for this query.

After 10 min run I get Error:" Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.'

I tried to run the query in editor and it is done after 5 min. 

I tried to increase timeouts times to 9999 at Tools->option->database->Timeouts. - still received the same error

I also restarted the computer - still received the same error.

I tried to export with "Select to File" and the query populated the file correctly. 

would you please advice and additional action that can be done.

Thanks,

AlexBl

Answered 153 5 / Create an account to join the discussion.
mercier104_000
Follow / 2 Jul 2017 at 2:20pm / Toad Data Point
Latest post by on 9 Aug 2017 at 3:36am

TDP 4.2 Set Variable with date into string

Expand content
Hi all I have a problem with set variable activity, when i try to put a formatted date from a dataset to a string variable : I'm using Oracle 11GR2 example : -execute script activity : select...

Hi all

I have a problem with set variable activity, when i try to put a formatted date from a dataset to a string variable :

I'm using Oracle 11GR2

example :

-execute script activity :

select to_char(trunc(sysdate, 'month'), 'DD/MM/YYYY') as date_deb

from dual return '01/07/2017'

save result set in variable VROD

-set variable 

variable name : test

variable type : string

variable value : #VROD.date_deb# (quoted or not)

result : Variable "test" set to '0.0021956229194702174374955733' (the slashes seems to be interpreted as "divide")

work around is to change variable type as SQL but  "prompt during run" become unavalaible...

I have to create specific SQL for setting each variable needed...

Another way ??

Regards.

Franck

449 12 / Create an account to join the discussion.
sbiggs
Follow / 2 Aug 2017 at 7:28pm / Toad Data Point
Latest post by on 5 Aug 2017 at 2:51am

Toad DataPoint and Windows 10

Expand content
Hello, We are currently using Toad Datapoint V3.3.0.1526 on Windows 7. We are upgrading Windows 7 to Windows 10. Does anyone know if V3.3 is supported on Windows 10? (Also...is there a matrix showing...

Hello,

We are currently using Toad Datapoint V3.3.0.1526 on Windows 7. We are upgrading Windows 7 to Windows 10.  Does anyone know if V3.3 is supported on Windows 10?  (Also...is there a matrix showing which Toad versions are supported on each version of Windows)

Thank you.

116 1 / Create an account to join the discussion.
sbiggs
Follow / 28 Jul 2017 at 2:30pm / Toad Data Point
Latest post by on 29 Jul 2017 at 1:03am

Toad Data Point (V3.3.0.1526)

Expand content
We've been using this version of Toad for several months to run scheduled jobs (.TAS jobs) successfully. This week, for some strange reason, Toad has been running jobs at a time that is not scheduled...

We've been using this version of Toad for several months to run scheduled jobs (.TAS jobs) successfully.  This week, for some strange reason, Toad has been running jobs at a time that is not scheduled. The job is set to run Sunday only at 8Pm in the evening, but we get an email sent every day at 8Am in the morning.  We also get a job set at 6:30AM, and there is not a even a job scheduled for 6:30 am (or pm).

Using Windows 7, SP1

We've done the following to try to solve this:

- Rebooted the PC

- Powered off/on the PC

- verified the jobs do not show in Windows Job Scheduler. What we see in Windows Job scheduler, matches the Toad Job Manager Task list.

Unanswered 84 1 / Create an account to join the discussion.
jerestat
Follow / 28 Jul 2017 at 9:04pm / Toad Data Point
Latest post by on 29 Jul 2017 at 12:43am

What happened to all the tools at the top?

Expand content
I had to downgrade to Toad Data Point 32-bit due to connectivity issues/drivers etc. Yesterday I uprgraded to Toad 4.2.1 on 64-bit but still had problems. So, now I have downgraded to the same version...

I had to downgrade to Toad Data Point 32-bit due to connectivity issues/drivers etc. Yesterday I uprgraded to Toad 4.2.1 on 64-bit but still had problems. So, now I have downgraded to the same version but for 32-bit even though I have a 64-bit machine.

However, this version appears not to have the functionality as previous versions I have had. 

Where did the other tools go that used to be at the top?

Jeremiah

70 3 / Create an account to join the discussion.
vrosasch
Follow / 28 Jul 2017 at 6:07pm / Toad Data Point
Latest post by on 28 Jul 2017 at 10:25pm

How do I disable the Lookup Search tab in Toad Data Point

Expand content
Hi, Im wondering if there is a way to disable the annoying "Lookup Search" tag that appears on every query error in the SQL Editor. Thanks for your support. VRCC

Hi,

Im wondering if there is a way to disable the annoying "Lookup Search" tag that appears on every query error in the SQL Editor.

Thanks for your support.

VRCC

Unanswered 93 2 / Create an account to join the discussion.
michael.webb
Follow / 27 Jul 2017 at 7:56pm / Toad Data Point
Latest post by on 27 Jul 2017 at 11:33pm

How to convert old .tas files from Toad for Data Analysts 2.6 to Toad...

Expand content
Hello we are using Toad for Data Analysts 2.6, and have multiple scripts that were created in that program for data validation. We are in the process of updating our database from Oracle 11 to Oracle 12...

Hello we are using Toad for Data Analysts 2.6, and have multiple scripts that were created in that program for data validation. We are in the process of updating our database from Oracle 11 to Oracle 12 and found that Toad for Data Analysts isn't compatible, so we are utilizing a trial version of Toad Data Point 4.2. The problem is that when we try to open our old automated .tas scripts in Data Point, they aren't working.  We get a notification that if we run the old script in the new program that it will no longer be compatible in the old program, and that's OK.  But then all we're able to see is instructions on how to Build a new Automation Script.  Our old script is not viewable.  Is there a way to convert our old 2.6 scripts to Data Point 4.2?

Thank you!

Unanswered 118 4 / Create an account to join the discussion.
hharwood
Follow / 27 Jul 2017 at 4:21pm / Toad Data Point

Disabled SaveLog option in Import Wizard

Expand content
Using Toad Data Point 4.1.0.226 (32 bit) Working on Automation flow, have a Import Wizard activity (import folder), and for some reason it has grayed out/disabled the SaveLog filename textbox, and will...

Using Toad Data Point 4.1.0.226 (32 bit)

Working on Automation flow, have a Import Wizard activity (import folder), and for some reason it has grayed out/disabled the SaveLog filename textbox, and will not save the name if I click on the SaveLog check box and provide a path for the file. Regardless of whether I do Import Data Now or Import Data Later, when I return to the activity, the textbox is empty, and if I chose Import Data Now, there is no log file. Any ideas why it doesn't want me to have a SaveLog?

Unanswered 48 0 / Create an account to join the discussion.
djenkinson
Follow / 12 Mar 2012 at 6:42pm / Toad Data Point
Latest post by on 27 Jul 2017 at 2:08pm

Help with creating your own From and To dates

Expand content
I have an SQL script (database is SQL Server) that filters four weeks of data by including the following in the Where clause ([PLTC].[Week Ending] BETWEEN dateadd (wk, - 6 , GetDate ()) AND dateadd (wk...

I have an SQL script (database is SQL Server) that filters four weeks of data by including the following in the Where clause

([PLTC].[Week Ending] BETWEEN dateadd (wk, -6, GetDate ())

AND dateadd (wk, -2, GetDate ()))

Group By used to return one row of data, so a date is not included in the output.

To display a From and To dates in my report I thought of creating two calculated fields.

FromDate - with expression

dateadd (wk, -6, GetDate ())

ToDate - with expression

dateadd (wk, -2, GetDate ())

However when I tried creating the FromDate calculated field I received the error message "The specified expression contains invalid symbols (line 1, character 22)."

Which is the closing bracket of the GetDate...

I have even tried changing GetDate() to Today().

dateadd (wk, -6, Today ())

This saved OK in the Expression Editor with no error message. But after placing this calculated field at ReportHeaderBand1 level in my report nothing is displayed when Previewed.

Any help and advise welcome.

Thank you in advance.

David

10348 3 / Create an account to join the discussion.
tennis_champion
Follow / 24 Jul 2017 at 7:56pm / Toad Data Point
Latest post by on 26 Jul 2017 at 6:03pm

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. 

158 6 / Create an account to join the discussion.
searchlumin70
Follow / 26 Jul 2017 at 8:57am / Toad Data Point
Latest post by on 26 Jul 2017 at 5:06pm

Attempting to connect to remote Oracle12c DB results in invalid username...

Expand content
Toad Data Point Version: 4.2.0.207 (64 bit) Oracle12c Version: 12.2.0.1.0 Initially, I was getting a "...no matching authentication protocol" message, but after updating sqlnet.ora with SQLNET...

Toad Data Point Version: 4.2.0.207 (64 bit)

Oracle12c Version: 12.2.0.1.0

Initially, I was getting a "...no matching authentication protocol" message, but after updating sqlnet.ora with  SQLNET.ALLOWED_LOGON_VERSION_SERVER=8, I got an invalid username/password message.

I managed to connect to the same database with the same credentials via SQL Developer.

I then switched to Oracle12c version 12.1.0.2.0 and managed to connect successfully with the same credentials without having to update sqlnet.ora.  I will stick with this version for now.

Has anyone in the TFP Community had any success with connecting to Oracle12c version 12.2.0.1.0 ?

Thanks.

58 1 / Create an account to join the discussion.
Shankspony
Follow / 3 Apr 2017 at 8:44pm / Toad Data Point
Latest post by on 26 Jul 2017 at 2:53pm

Export to Excel Sheet Breaks Slicers

Expand content
Good afternoon all... Many reports I run are produced by using the export to file component in TDP. We export to Excel worksheets that source pivot tables. Recently I have been trying to update some...

Good afternoon all...

Many reports I run are produced by using the export to file component in TDP. We export to Excel worksheets that source pivot tables. Recently I have been trying to update some older approaches to populating these worksheets to this export to file method and these reports use slicers. These slicers in the workbook break after TDP is done inserting the result set into the worksheet.. Where ever a slicer was is replaced by a placeholder image stating that slicers are supported in Excel 2010 and beyond. Has anyone else experienced this? 

Using Toad Data Point 4.0.1 and Excel 2013

Dave

Unanswered 333 3 / Create an account to join the discussion.
jun.li
Follow / 21 Jul 2017 at 5:31am / Toad Data Point
Latest post by on 21 Jul 2017 at 8:51am

export / import Java_Class and Java_Resource

Expand content
Hello, Is there a way to export / import Java_Class and Java_Resource? Thanks.

Hello,

Is there a way to export / import Java_Class and Java_Resource? Thanks.

84 1 / Create an account to join the discussion.
chris.kanu
Follow / 17 Jul 2017 at 5:46pm / Toad Data Point
Latest post by on 21 Jul 2017 at 7:23am

Exception Error opening saved query

Expand content
I have been getting this errors in the past and sometimes it goes away but I still could not figure why it is happening. Does anyone have an idea how to fix this.... New exception: 7/17/2017 9:33...

I have been getting this errors in the past and sometimes it goes away but I still could not figure why it is happening. Does anyone have an idea how to fix this....

New exception: 7/17/2017 9:33:18 AM

System.IO.IOException: This file is currently not available for use on this computer.


Stack trace:

   at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
   at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
   at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy)
   at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize)
   at System.Xml.XmlUrlResolver.GetEntity(Uri absoluteUri, String role, Type ofObjectToReturn)
   at System.Xml.XmlTextReaderImpl.OpenUrlDelegate(Object xmlResolver)
   at System.Threading.CompressedStack.runTryCode(Object userData)
   at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
   at System.Threading.CompressedStack.Run(CompressedStack compressedStack, ContextCallback callback, Object state)
   at System.Xml.XmlTextReaderImpl.OpenUrl()
   at System.Xml.XmlTextReaderImpl.Read()
   at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean preserveWhitespace)
   at System.Xml.XmlDocument.Load(XmlReader reader)
   at System.Xml.XmlDocument.Load(String filename)
   at Quest.Toad.QueryBuilder.QueryBuilder.OpenFile(String file)
   at Quest.Toad.QueryBuilder.QueryBuilder.timerDelayFileLoad_Tick(Object sender, EventArgs e)
   at System.Windows.Forms.Timer.TimerNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

146 3 / Create an account to join the discussion.
jraguse
Follow / 10 Jul 2017 at 10:46pm / Toad Data Point
Latest post by on 21 Jul 2017 at 1:56am

Value cannot be null error message.

Expand content
I have been getting the following error message box when I open queries in TDP 4.0.0.396. This just began today - I don't believe that I made any setting changes on Friday (7/7/17), nor did I make...

I have been getting the following error message box when I open queries in TDP 4.0.0.396.  This just began today - I don't believe that I made any setting changes on Friday (7/7/17), nor did I make any setting changes today (7/10/17).

When this box pops up, the query is open in the background.  Upon clicking on the "OK" button, the box goes away and the query appears to be normal and I can run it normally.  I also believe that I can edit the query without any issues.  Thus the error box, once closed, does not appear to prevent any Toad functionality, but is concerning nonetheless.

Does anyone have an idea on how to prevent this box from appearing?

Unanswered 144 2 / Create an account to join the discussion.