You will no longer receive e-mail notifications from this forum.
Log-In to post
Contact Support on Twitter
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)
- Link to Download & Documentation
- Link to Trial
- Overview of new feature(s) (with link to the 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)
2. Common Oracle connection problems (7712)
3. Error, "ORA-12170: TNS:Connect timeout occurred" when connecting to Oracle (105610)
4. Error connecting to database after installing on Windows 64-Bit OS: "ORA-12154" (12495)
5. "ERROR  [IBM] SQL30081N A communication error has been detected." when connecting to DB2 (47041)
Feel free to browse them. Remember to sign in to your account to view.
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.
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?
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.
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 ?
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.
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?
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.
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.
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.
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.
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.
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?
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.
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.
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?
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.
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.
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?
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!