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.
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.
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.
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.
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.
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:
because I'm on v4.3 I don't see a lot of the screens she shows in her illustration. Would appreciate the help.
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.
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.
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?
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?
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
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.
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_123FROM 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
TOAD 126.96.36.1995Excel 2013Direct 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?
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.
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):
This sql contains the following:
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:
AllUP_SW_Extract - Toad has detected some symbols within the expression indicating you might be using bind variables. Please define the following variable(s):
/* List all tool orders, open and complete, released for the Safety Walk effort to enhance Posts&Chains, Flopboards&sliders */
This time the "&" appears within a comment, where it should be 'inert'.
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 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 188.8.131.52.
Has anyone else experienced similar problems?
I'm trying to connect to an IBM PureFlex database using Toad Data Point 184.108.40.2069. 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...