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.

 

3015 4 / Create an account to join the discussion.
bill.staley
Follow / 11 Dec 2017 at 7:37pm / Toad Data Point
Latest post by on 12 Dec 2017 at 8:11am

Source of Connection credentials

Expand content
When Data Point connects to SharePoint does it use the credentials from the connection, or, does it use the credentials from the computer logon? We need to use a generic SharePoint login with credentials...

When Data Point connects to SharePoint does it use the credentials from the connection, or, does it use the credentials from the computer logon?

We need to use a generic SharePoint login with credentials that are different from the computer logon.  It doesn't seem to work.

Unanswered 34 1 / Create an account to join the discussion.
bill.staley
Follow / 11 Dec 2017 at 12:55pm / Toad Data Point
Latest post by on 12 Dec 2017 at 4:15am

2 users executing the same automation script?

Expand content
We need to have 2 different people execute the same automation scripts. We are a one person shop with a back up person for when the primary person is ill or on vacation. TIC is overkill, so wondered how...

We need to have 2 different people execute the same automation scripts.  We are a one person shop with a back up person for when the primary person is ill or on vacation.  TIC is overkill, so wondered how to accomplish this.

50 4 / Create an account to join the discussion.
ArjenLissenberg
Follow / 6 Dec 2017 at 3:19pm / Toad Data Point
Latest post by on 11 Dec 2017 at 2:06pm

After upgrade to new TIC, uploading workbooks from Viewer doesn't...

Expand content
After installing the upgrade of TIC (along with latest version of TDP) I can't upload workbooks from the TDP Viewer any more, it mentions a version of Decision Point but I can't find where that...

After installing the upgrade of TIC (along with latest version of TDP) I can't upload workbooks from the TDP Viewer any more, it mentions a version of Decision Point but I can't find where that should have been installed and whether that is part of the TDP, TIC and/or TDP Viewer package:

After clicking "Publish Workbook" I get the following error message twice:

Then I get the "Publish to Toad Intelligence Central" Window, clicking on the default folder to change where to publish it nets me:

Trying to publish it in the default "No_folder_assigned" folder results in:

The new version of TIC was installed on a new server afresh and empty so didn't have any remnants of the previous TIC version. The TDP Viewer is the same version I used with the previous TIC version. The workbook I created uses a view on TIC as data-source and I can successfully Publish the data in the workbook as dataset (even though I get the first error message from above and I can only publish in the  "No_folder_assigned" folder as choosing another folder triggers the second error winodwo from above.

120 4 / Create an account to join the discussion.
Dmitry
Follow / 15 Nov 2017 at 6:17pm / Toad Data Point
Latest post by on 11 Dec 2017 at 9:55am

Changing Connection in TDP Editor

Expand content
Hello, This might be a very simple question but I could not find an answer to this in the forum. When I change connection to a different server in Editor (Toad Data Point), I double click the server...

Hello,

This might be a very simple question but I could not find an answer to this in the forum.

When I change connection to a different server in Editor (Toad Data Point), I double click the server name, and then have to right click the tab of the Editor to select the new connection there as well. 

It would seem to me that there should be a single-step process to change connection that I am missing. Please let me know if it can be done in one step, not two.

Regards.

424 6 / Create an account to join the discussion.
bobmurdock
Follow / 7 Dec 2017 at 6:50pm / Toad Data Point
Latest post by on 8 Dec 2017 at 2:45pm

Automating Dynamic Query

Expand content
Hello This is my first crack at using the automation tool in Toad so please bare with me. Anyhow, I've written a query for a report my customer would like run every month or so. For argument sake...

Hello

This is my first crack at using the automation tool in Toad so please bare with me. Anyhow, I've written a query for a report my customer would like run every month or so.

For argument sake, assume I had the following query:

SELECT * FROM ARTISTS

WHERE ArtistID IN (insert long list of IDs which are alphanumeric)

My customer will be providing me with a list every month or whenever she wants to run the report so this can't be hard coded into the query.

How can I make the query run every month, and use the different ArtistIDs or variables? Also is there a way that this could be done in reverse from excel?

I've looked at the following link:

http://www.toadworld.com/products/toad-data-point/b/weblog/archive/2013/07/24/toad-data-point-automation-series-blog-12-variables

because I'm on v4.3 I don't see a lot of the screens she shows in her illustration.  Would appreciate the help.

Unanswered 87 2 / Create an account to join the discussion.
daniel.gunter_828
Follow / 7 Dec 2017 at 6:38pm / Toad Data Point
Latest post by on 8 Dec 2017 at 9:00am

Import template works separately but not within an automated scri...

Expand content
I am using TDP 4.2. I am in a learning mode for 4.2 vice previous version 3.8. I have an automated script pulling data from a Sybase database. One import module of the automated process keeps crashing...

I am using TDP 4.2. I am in a learning mode for 4.2 vice previous version 3.8. I have an automated script pulling data from a Sybase database. One import module of the automated process keeps crashing TDP and I have to close the application. All other modules within the same automated script work against the Sybase database. I created a new automated process with just the one trouble module and still have the same problem. However, if I right click the import template directly within the Project Manager (with the exact same connection as the automated script) and execute the import template, it works as it should. I am using the exact same connection and import template in the automated script. Appreciate any possible trouble shooting since TDP is not providing any specific error or corrective action.

Thanks

Unanswered 82 1 / Create an account to join the discussion.
samsupport
Follow / 28 Nov 2017 at 3:09am / Toad Data Point
Latest post by on 8 Dec 2017 at 1:13am

How to resolve Toad Data Point 4.2.1 installation error 1723?

Expand content
Hi, Our packaging team was testing the installer for Toad Data Point 4.2.1 on Windows 10 devices, however, when the file is executed it throws an error(screenshot below) Is the file compatible with...

Hi,

Our packaging team was testing the installer for Toad Data Point 4.2.1 on Windows 10 devices, however, when the file is executed it throws an error(screenshot below)

Is the file compatible with Windows 10 Creators Update? Any recommendations please, I searched the knowledge base but could not find any guidance.

Thanks.

Unanswered 262 5 / Create an account to join the discussion.
peter.d.maxwell
Follow / 7 Dec 2017 at 3:17pm / Toad Data Point
Latest post by on 7 Dec 2017 at 6:38pm

Upgrade to 4.3 Stuck

Expand content
I upgraded the TIC server with 4.3 and now when I try to run TDP 4.3 (which was automatically installed) on the server, it gets stuck on the 'Setting Migration Utility'. Clicking on 'Migrate'...

I upgraded the TIC server with 4.3 and now when I try to run TDP 4.3 (which was automatically installed) on the server, it gets stuck on the 'Setting Migration Utility'.  Clicking on 'Migrate' or 'Cancel' doesn't do anything.  No way to continue on.

Anyone else get this?  Any way to fix?

Thanks

Pete

95 5 / Create an account to join the discussion.
N.B.
Follow / 30 Nov 2017 at 8:07pm / Toad Data Point
Latest post by on 7 Dec 2017 at 5:53pm

Loop Dataset - How To?

Expand content
Greetings, I've got a new request that I believe would be perfect to use with the Loop Dataset activity in TDP, but I'm having some trouble fitting all the pieces together. This is the first...

Greetings,

I've got a new request that I believe would be perfect to use with the Loop Dataset activity in TDP, but I'm having some trouble fitting all the pieces together.  This is the first time I've used this activity, so I'm sure that's a large part of it.

To summarize: I have a list of values that are returned by a query; I then need to take that list and perform the same action for every value on the list just once.  Right now the list has 23 items and the action in question is to export the results of a query to Excel, using the value from the list as part of the query.

Seems like it should be fairly simple.

However, when I built a small test, and used the Log Comment activity as my action to perform, with the value of the dataset variable as the output, I got the same value 23 times in the log, instead of each unique value.  It seems as though it's not moving through the list and resetting the value for each loop, and I'm sure it has to do with something I've failed to configure correctly.

Does anyone have any insight on doing something like this?

Unanswered 204 3 / Create an account to join the discussion.
Anson1000
Follow / 14 Jul 2017 at 2:44pm / Toad Data Point
Latest post by on 7 Dec 2017 at 2:15pm

Error when connect csv file: [Microsoft][ODBC Driver Manager] data...

Expand content
TOAD version: 4.2 (64bit) Excel version: excel 2016 (32 bit) step to connect csv file 1.Create a csv file in excel and save it 2. connect this csv file in TOAD Error message

TOAD version: 4.2 (64bit)

Excel version: excel 2016 (32 bit)

step to connect csv file

1.Create a csv file in excel and save it

2. connect this csv file in TOAD

Error message 

569 2 / Create an account to join the discussion.
vrosasch
Follow / 28 Jul 2017 at 6:07pm / Toad Data Point
Latest post by on 5 Dec 2017 at 4:02am

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 607 5 / Create an account to join the discussion.
N.B.
Follow / 10 Sep 2012 at 8:12pm / Toad Data Point
Latest post by on 1 Dec 2017 at 7:24pm

Automation: Secure FTP using Private Key

Expand content
I think there may be a bug with TDA's implementation of the Secure FTP Connection with Public key only (not Public + Password). Despite setting the "Authentication" drop-down to "Public...
I think there may be a bug with TDA's implementation of the Secure FTP Connection with Public key only (not Public + Password).

Despite setting the "Authentication" drop-down to "Public Key", and supplying the "Private key file" in the appropriate place, testing the connection still prompts for a password (which in my case is blank). The test is successful, all is well.

But when I try to use that FTP connection in the Automation FTP step, it will not allow me to select any file operations because it says a password is required - despite having checked "Save password" on the connections property, and leaving the box blank when prompted and hitting ok.

We really need this feature, so if there's a work around here or some way to get it to work, that would really be awesome.
12634 13 / Create an account to join the discussion.
ANArada
Follow / 14 Nov 2017 at 7:51pm / Toad Data Point
Latest post by on 1 Dec 2017 at 6:25pm

Case statement issue (instead of cross connection query)

Expand content
Is this even possible? Instead of a cross connection query from excel or I guess you can call it vlookup, I want to create a "case when then statement" that is searching a specific word in the...

Is this even possible? Instead of a cross connection query from excel or I guess you can call it vlookup, I want to create a "case when then statement" that is searching a specific word in the table (Finding a word in the table that is not generated yet.)

When I execute the sql below it is giving me this error.

"[Sybase][ODBC Driver][Sybase IQ]Column 'GNL00347_7R_1_DB' not found"


SELECT  DC_E_ERBS_EUTRANCELLFDD_RAW.DATE_ID  
    , DC_E_ERBS_EUTRANCELLFDD_RAW.HOUR_ID  
    , DC_E_ERBS_EUTRANCELLFDD_RAW.MIN_ID  
    , DC_E_ERBS_EUTRANCELLFDD_RAW.ERBS  
    , DC_E_ERBS_EUTRANCELLFDD_RAW.EUtranCellFDD  
    , SUM(DC_E_ERBS_EUTRANCELLFDD_RAW.pmRrcConnEstabAtt) AS Sum_pmRrcConnEstabAtt   
    , CASE WHEN DC_E_ERBS_EUTRANCELLFDD_RAW.EUtranCellFDD = GNL00347_7R_1_DB THEN TEST
END AS TEST_123
FROM dc.DC_E_ERBS_EUTRANCELLFDD_RAW DC_E_ERBS_EUTRANCELLFDD_RAW
WHERE  ( "DC_E_ERBS_EUTRANCELLFDD_RAW"."DATE_ID" = '2017-11-14')
    AND ( "DC_E_ERBS_EUTRANCELLFDD_RAW"."ERBS" = 'GNL00347')
GROUP BY DC_E_ERBS_EUTRANCELLFDD_RAW.DATE_ID  
    , DC_E_ERBS_EUTRANCELLFDD_RAW.HOUR_ID  
    , DC_E_ERBS_EUTRANCELLFDD_RAW.MIN_ID  
    , DC_E_ERBS_EUTRANCELLFDD_RAW.ERBS  
    , DC_E_ERBS_EUTRANCELLFDD_RAW.EUtranCellFDD

412 4 / Create an account to join the discussion.
Shankspony
Follow / 30 Nov 2017 at 6:31pm / Toad Data Point

Header Image Disappears

Expand content
TOAD 4.0.1.775 Excel 2013 Direct write to existing Excel file worksheets removes image association in header field. I imagine this is related to the issue with TOAD 3.7-4 using an older Excel object library...

TOAD 4.0.1.775
Excel 2013

Direct write to existing Excel file worksheets removes image association in header field. I imagine this is related to the issue with TOAD 3.7-4 using an older Excel object library than previous versions and also causes broken slicers. Is this a known issue at this time and does TDP 4.3 fix this issue?

Dave

95 0 / Create an account to join the discussion.
ArjenLissenberg
Follow / 16 Nov 2017 at 5:52pm / Toad Data Point
Latest post by on 22 Nov 2017 at 8:33pm

Open Published Workbook option from Toad Data point Viewer gives Value...

Expand content
I created a Workbook linked to data on TIC with Toad Datapoint Viewer, I published this workbook on TIC. Now I want to open that workbook from TIC but I get the error message: "Value cannot be null"...

I created a Workbook linked to data on TIC with Toad Datapoint Viewer, I published this workbook on TIC. Now I want to open that workbook from TIC but I get the error message: "Value cannot be null" an another illegible message below it (see attachment). Goin to TIC with a browser does allow me to download and open the workbook. The workbook and the selected datasources do not have parameters or variables.

348 4 / Create an account to join the discussion.
julian.chasin_625
Follow / 3 Jan 2014 at 6:04pm / Toad Data Point
Latest post by on 22 Nov 2017 at 2:03pm

An "&" anywhere triggers Bind variable logic

Expand content
I am running an Automation script in TDP3.4 which ran fine in 3.2 and earlier versions. When it executes a SQL (Select to File), I get the error: Reporting_Daily.log: AllUP - Toad has detected some...

I am running an Automation script in TDP3.4 which ran fine in 3.2 and earlier versions.

When it executes a SQL (Select to File), I get the error:

Reporting_Daily.log: AllUP - Toad has detected some symbols within the expression indicating you might be using bind variables. Please define the following variable(s):

Y

This sql contains the following:

SELECT ALL

...

   decode(USING_DEPARTMENT,'17A','Carlin - AN&Y','17N','Carlin - AN&Y','17Y','Carlin - AN&Y','17C','Chasin - Center',  'OtherManager')    IPTmgr,

...

Is there a way to avoid this error when the "&" only appears in quoted text?

 

Also, a similar error:

Exception Messages:

AllUP_SW_Extract - Toad has detected some symbols within the expression indicating you might be using bind variables. Please define the following variable(s):

Chains

 

This sql contains the following:

/* List all tool orders, open and complete, released for the Safety Walk effort to enhance Posts&Chains, Flopboards&sliders */

SELECT ALL

...

 This time the "&" appears within a comment, where it should be 'inert'.

Answered 3516 8 / Create an account to join the discussion.
Adriang16
Follow / 20 Nov 2017 at 5:46pm / Toad Data Point
Latest post by on 21 Nov 2017 at 2:49am

Removing Subtotals from pivot grid

Expand content
I don't want to display subtotals in the pivot table in TDP. I cannot find a way to turn them off. I couldn't find any questions about it in the forum. Please advise and thank you for your time...

I don't want to display subtotals in the pivot table in TDP. I cannot find a way to turn them off. I couldn't find any questions about it in the forum.

Please advise and thank you for your time!

Answered 308 3 / Create an account to join the discussion.
ahoope11
Follow / 6 Nov 2017 at 7:26pm / Toad Data Point
Latest post by on 20 Nov 2017 at 6:03pm

Windows 10 Upgrade Compatibility Issues?

Expand content
Hello, I recently upgraded my computer to Windows 10. Since then, I've been experiencing issues with Toad Data Point Viewer freezing up on me. I am using version 3.7.2.16. Has anyone else experienced...

Hello, 

I recently upgraded my computer to Windows 10.  Since then, I've been experiencing issues with Toad Data Point Viewer freezing up on me. I am using version 3.7.2.16. 

Has anyone else experienced similar problems? 

Thanks!

432 4 / Create an account to join the discussion.
Mark Suprin
Follow / 8 Nov 2017 at 9:32pm / Toad Data Point
Latest post by on 13 Nov 2017 at 9:42pm

Can I Connect Toad Data Point to a PureFlex Database using an Oracle...

Expand content
Good day. I'm trying to connect to an IBM PureFlex database using Toad Data Point 4.2.0.279. I successfully connected to this database using Toad for Oracle 12.5. Now I'm trying to create an...

Good day.

I'm trying to connect to an IBM PureFlex database using Toad Data Point 4.2.0.279. I successfully connected to this database using Toad for Oracle 12.5. Now I'm trying to create an Oracle Connection in Toad Data Point, but I'm getting this error: Oracle Database Error

Network error:: 11004 - The requested name is valid, but no data of the requested type was found...

Thank you.

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