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.

 

2500 4 / Create an account to join the discussion.
welcomejt
Follow / 10 Oct 2017 at 10:52pm / Toad Data Point
Latest post by on 17 Oct 2017 at 11:14pm

Do you plan to support Netezza Advanced->Send to Query Builder...

Expand content
I work for a consulting firm that performs data migrations for Fortune 100/500 companies and we utilize SQL and ETL tools to perform our duties. The majority of our time is in SQL and we create a lot of...

I work for a consulting firm that performs data migrations for Fortune 100/500 companies and we utilize SQL and ETL tools to perform our duties.  The majority of our time is in SQL and we create a lot of views in our work to push down to the database and to create reports.  SQL Server Management studio has the most functionality that I have seen and gives the ability to edit or create views with a query builder.  Looks like this functionality is available for some databases, but not Netezza.  Our current clients staging database is Netezza and that function is greyed out if I copy the view sql into the standard SQL editor and choose Advanced->Send to Query Builder.  Do you plan to implement this? I am looking at this tool and whether we will purchase, but really need this functionality to perform our jobs.

148 8 / Create an account to join the discussion.
ben9
Follow / 16 Oct 2017 at 8:21pm / Toad Data Point

Change program icon

Expand content
Hi I run both Toad for SQL server and Toad for Data Point. Both have the same icon on the taskbar. It is a little confusing so if it's possible I want to make them different. I tried but couldn't...

Hi I run both Toad for SQL server and Toad for Data Point. Both have the same icon on the taskbar. It is a little confusing so if it's possible I want to make them different.

I tried but couldn't change the icon. Does anyone know how to?

thanks,

Ben

23 0 / Create an account to join the discussion.
andy.corson
Follow / 21 Sep 2017 at 12:53pm / Toad Data Point
Latest post by on 16 Oct 2017 at 7:23pm

Data compare for specific tables/columns in database

Expand content
I have used data compare with Excel data connections before and it works great. I tried to do one on a database yesterday, and after the compare wizard analyzed the databases, it displayed a list of tables...

I have used data compare with Excel data connections before and it works great. I tried to do one on a database yesterday, and after the compare wizard analyzed the databases, it displayed a list of tables. I want to select only a handful of the tables, and choose which columns to compare. Is this possible? Or do I have to construct select statements choosing the tables and columns, export the data to Excel, and then use Excel data connections? I didn't want to have to create a bunch of Excel connections, which is why I went the database route.

Unanswered 123 1 / Create an account to join the discussion.
mercier104_000
Follow / 12 Jan 2017 at 4:29pm / Toad Data Point
Latest post by on 16 Oct 2017 at 6:54pm

If condition in automation script is not working properly (TDP 4.1...

Expand content
As i say in object, TDP return an error with condition . that's veryr strange ! condition worked in TDP 3.8. error message is : Exception Messages: If_1 - ''False'' cannot be converted...

As i say in object, TDP return an error with condition . that's veryr strange ! condition worked in TDP 3.8.

error message is :

Exception Messages:
If_1 - ''False'' cannot be converted to boolean.

When using Test button in activity, it' working !

Toad seems to quote every variables including its own !

Any workaround ?

Franck 

713 4 / Create an account to join the discussion.
Kris.Kawaguchi
Follow / 22 Sep 2017 at 2:00am / Toad Data Point
Latest post by on 16 Oct 2017 at 6:12pm

Transpose Table Data for Comparison

Expand content
Is there an efficient approach to transpose a given table so that it results in the following: Primary Key | Field | Value 1 Field 1 Value 1 Field 2 Value 1 Field 3 Value 2 Field 1 Value ...

Is there an efficient approach to transpose a given table so that it results in the following:

Primary Key |    Field     |  Value

1                      Field 1       Value

1                      Field 2      Value 

1                      Field 3       Value

2                      Field 1       Value

2                      Field 2      Value 

2                      Field 3       Value

I would like to be able to do this for 2 or more similar tables and then join them back by primary key and Field in order to compare there values.

Unanswered 77 1 / Create an account to join the discussion.
sssxxx
Follow / 16 Oct 2017 at 2:01pm / Toad Data Point
Latest post by on 16 Oct 2017 at 5:36pm

program memory

Expand content
Getting error message from the automation job - Output_Provider - Program memory is too low. 408 MBs available. Reduce size of work load or increase RAM. Who can tell how to fix it?

Getting error message from the automation job - Output_Provider - Program memory is too low. 408 MBs available. Reduce size of work load or increase RAM. Who can tell how to fix it?

25 1 / Create an account to join the discussion.
amlloyd
Follow / 5 Jul 2017 at 5:19pm / Toad Data Point
Latest post by on 13 Oct 2017 at 7:23pm

Can Automation Designer Insert/Delete rows in a table based on a file...

Expand content
Before I fall into the rabbit hole, I figured I'd ask if this is even possible. Every month I get a file that tells me which rows in Table A to delete and which rows from this file to append to Table...

Before I fall into the rabbit hole, I figured I'd ask if this is even possible. Every month I get a file that tells me which rows in Table A to delete and which rows from this file to append to Table A. Is Toad Automation Designer capable of automating this task? I know this is the bread and butter of SSIS but for the sake of argument, let's say I don't have SSIS privs. 

414 8 / Create an account to join the discussion.
ArjenLissenberg
Follow / 13 Oct 2017 at 1:47pm / Toad Data Point

How to aggregate a string in Toad Datapoint?

Expand content
Hi, We are testing out Toad to see whether it can replace Hyperion Brio for us. One of the features of Brio was that one could use the SUM() function to aggregate strings, not just sum numbers; a "SUM...

Hi,

We are testing out Toad to see whether it can replace Hyperion Brio for us. One of the features of Brio was that one could use the SUM() function to aggregate strings, not just sum numbers; a "SUM(Managers,Location)" would yield a result were, for each location, all the managers would be shown, in a comma separated fashion. In Toad the SUM() function seems to only work for numbers and I have not been able to find a way to approach this, I have tried as calculated field in the query, as a Transform and Cleanse step, Pivot and in a Report design. Does anyone know a way, it should not be a very uncommon way of aggregating data.

Thanks!

51 0 / Create an account to join the discussion.
tennis_champion
Follow / 24 Jul 2017 at 7:56pm / Toad Data Point
Latest post by on 13 Oct 2017 at 2:04am

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. 

475 12 / Create an account to join the discussion.
marcia.m
Follow / 2 Oct 2017 at 9:31pm / Toad Data Point
Latest post by on 11 Oct 2017 at 4:12am

Upgrade path from Toad Data Point 3.8 32-bit to TDP 4.2 64-bit with...

Expand content
We're trying to determine the best upgrade path from TDP 3.8 32-bit, to TSP 4.2 64-bit, while keeping the user's settings as they were. I personally do not have control over the installer, it...

We're trying to determine the best upgrade path from TDP 3.8 32-bit,  to TSP 4.2 64-bit, while keeping the user's settings as they were.


I personally do not have control over the installer,  it is done via MSI, and executed by our packaging group guy, for rollout to many machines in enterprise. I am testing it now, and hitting some issues.

1. If he installs 4.2 64-bit,  it is not recognized as an upgrade, and so none of my prior settings are migrated (connections, UI settings , etc.)      We've tried manually forcing it, but still nothing is migrated. 
2. If he installs 4.2 32-bit, then I get the migration popups and warnings, as expected,and my customizations are brought over.

Is going from 3.8 32-bit  to  4.2 64-bit a  valid  migration path?

If not, is there any recommended best practice for how to end up at 4.2 64-bit while keeping my 3.8 settings?   That's what we need to do, but can't see how yet. 

Thanks!

Unanswered 209 12 / Create an account to join the discussion.
chad.king
Follow / 19 Jan 2017 at 2:37pm / Toad Data Point
Latest post by on 9 Oct 2017 at 4:48pm

Insert/Update Query Not Working in Select to File Automation 4.1

Expand content
Team, I'm wondering if you have seen an issue in 4.1 where update/insert queries are not working in 4.1 Select to File Automation? I do see on the release notes the mention of "In compatibility...

Team,

I'm wondering if you have seen an issue in 4.1 where update/insert queries are not working in 4.1 Select to File Automation? 

I do see on the release notes the mention of "In compatibility mode, the ODBC driver does not return enough information for the CommandBuilder to correctly generate update or insert statements." as being an issue.

BUT, I wanted to see if this applied to my specific issue.

We use an I-Series ODBC connection to DB2.  We run daily update queries.  In previous versions to automate, we've been able to accomplish this using the Select to File activity just fine.

Now, when converting to 4.1, the select to file activity errors and I get the message back saying "Unable to parse any SELECT statements from the SQL query." 

Just so you know though, on 4.1 when running the same exact update query in the edit window, the query works just fine.

I had to revert my update automation tasks at this point back to 4.0 to get them back to working for the time being.

I'm wondering if there's a known issue and if not, if I should submit this as a support case?

Also, if it is a known issue, is there any type of workaround on 4.1? 

Please let me know if you need anything else from myself.

Thanks!

657 6 / Create an account to join the discussion.
amysto
Follow / 4 Oct 2017 at 8:10pm / Toad Data Point
Latest post by on 4 Oct 2017 at 11:58pm

Toad Data Point Automation Error - DLL file

Expand content
Hi, I have TDP v 4.0 and i have set up an automation to create a report and when i run it, it is always failing at one point and gives the error "....System.Workflow.Activities.dll could not be...

Hi,

I have TDP v 4.0 and i have set up an automation to create a report and when i run it, it is always failing at one point and gives the error "....System.Workflow.Activities.dll could not be opened -- File is corrupt". Ive tried several programs to try and open this file but nothing is working... are there any suggestions on how to fix this error?

55 1 / Create an account to join the discussion.
jack.zito
Follow / 4 Oct 2017 at 4:34pm / Toad Data Point
Latest post by on 4 Oct 2017 at 9:18pm

Mouse Pointer Configuration

Expand content
Toad Data Point 4.2, is there a way to change the mouse pointer from the annoying hand icon? I have gone through all the Options and just do not see how to do this. My previous version did not have the...

Toad Data Point 4.2, is there a way to change the mouse pointer from the annoying hand icon? I have gone through all the Options and just do not see how to do this. My previous version did not have the hand as a mouse pointer.

Unanswered 80 5 / Create an account to join the discussion.
jack.zito
Follow / 4 Oct 2017 at 3:34pm / Toad Data Point
Latest post by on 4 Oct 2017 at 6:38pm

Data Grid Formatting

Expand content
Is there a way to format data grid output to highlight alternate rows? Toad Data Point 4.2. I have looked in Tools->Options->Environment->Grid and just don't see the obvious if the feature...

Is there a way to format data grid output to highlight alternate rows? Toad Data Point 4.2.

I have looked in Tools->Options->Environment->Grid and just don't see the obvious if the feature exists.

Thanks

Unanswered 67 3 / Create an account to join the discussion.
andy.corson
Follow / 18 May 2017 at 7:37pm / Toad Data Point
Latest post by on 3 Oct 2017 at 4:47am

Variable in file copy activity on file name

Expand content
I have a string variable that is created in a set variable activity - To_char(Add_months(Current_date(), -1), 'MMMM YYYY') - the output is "April 2017". In TDP 3.7 the file name would...

I have a string variable that is created in a set variable activity - To_char(Add_months(Current_date(), -1), 'MMMM YYYY') - the output is "April 2017". In TDP 3.7 the file name would appear as "file name April 2017.xlsx" but in TDP 4.2 it appears as "file name 'April 2017'.xlsx" with single quotes around the month and year. In the file copy activity I have "file name #month#.xlsx" Should I not be using the # to set off the variable?

Unanswered 425 5 / Create an account to join the discussion.
N.B.
Follow / 29 Sep 2017 at 1:03am / Toad Data Point
Latest post by on 2 Oct 2017 at 5:44pm

[TDP] Support for Windows Session 0 Isolation?

Expand content
Greetings, As part of a new project, we are migrating our Toad automations from Windows 7 desktops to Windows Server 2012 R2 VMs. With that, however, comes an issue where the service account that runs...

Greetings,

As part of a new project, we are migrating our Toad automations from Windows 7 desktops to Windows Server 2012 R2 VMs.

With that, however, comes an issue where the service account that runs the Toad automations isn't allowed to remain logged in on the Windows Server 2012 desktop for more than 48 hours - this is a corporation-wide GPO setting and cannot be changed.

Where we're having a problem is that the TDP Scheduled Task will appear to execute, but no output is produced, and the log is not updated.

If I leave the service account logged in, and simply 'lock' my session, everything works as expected - just like our Windows 7 machines - but in 48 hours, the account is automatically logged out, and we're back to either having to login, or getting no output.

From my research, it appears that starting with Windows Vista (yeah, I know...), Microsoft implemented Session 0 Isolation, meaning all interactive logins start at Session 1 and up, and Session 0 is reserved for system and service use only, including Scheduled Tasks configured with the option of 'Run whether user is logged on or not'.  The problem is that Session 0 does not have an interactive desktop, so any processes that are expecting a UI response, or even the ability to create a UI, seem to fail, which would appear to include Toad.

That said, I've read in various threads on here and around the net that folks have gotten this to work correctly, but so far - after several weeks - I haven't been able to figure it out, and I'm hoping one of you kind folks will be able to point me in the right direction.

Unanswered 183 8 / Create an account to join the discussion.
mutyala.uppuluri
Follow / 25 Sep 2017 at 5:26pm / Toad Data Point

Mapr Support 50190 Error Resolution

Expand content
I am getting an error Mapr Support 50190 Error creating temporary swap file name while connecting to driver Hive. Please let me know how can I resolve the issue.

I am getting an error  Mapr Support 50190 Error creating temporary swap file name while connecting to driver Hive. Please let me know how can I resolve the issue.

81 0 / Create an account to join the discussion.
k@hn
Follow / 22 Sep 2017 at 12:08pm / Toad Data Point
Latest post by on 22 Sep 2017 at 2:32pm

'Toad Data Point - Getting Started' training has paused and...

Expand content
So, there isn't any help or a contact address for support that I have heard back from. I started the 'Toad Data Point - Getting Started' training and had to pause mid-way through as the video...

So, there isn't any help or a contact address for support that I have heard back from.

I started the 'Toad Data Point - Getting Started' training and had to pause mid-way through as the video content was not showing, and I resumed the course the screen just freezes, has anyone else experienced this?

151 1 / Create an account to join the discussion.
cmbettini
Follow / 19 Sep 2017 at 1:49pm / Toad Data Point
Latest post by on 20 Sep 2017 at 1:51pm

How to create a comma separated list in Automation to be used in "Select...

Expand content
Does anyone know if this is possible? I'd like to use a SQL variable to select a list of account numbers from one database, then store the results, separated by commas, to be used in a "Select...

Does anyone know if this is possible?

I'd like to use a SQL variable to select a list of account numbers from one database, then store the results, separated by commas, to be used in a "Select * Where in :List " statement.  My goal is to greatly speed up an already existing Cross connection query.  I'm currently trying to join a table of 10million records against about 500 records in another cloud database. I've tested this in the editor using static values in the list, but I'm looking to automate it somehow. Thanks!

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