You will no longer receive e-mail notifications from this forum.
Contact Support through Twitter!
Log-In to post
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.
This is both a question and a topic for discussion, so... :-)
I'm looking to get some feedback on anyone who is running Toad Data Point on Windows Server OS's instead of Windows Desktop OS's - i.e. Windows Server 2008 R2, Windows Server 2012, Windows Server 2016 instead of Windows 7, Windows 8.1, Windows 10.
We've entered in to the lifecycle refresh of our current automation hosts - two Dell OptiPlex desktops with Windows 7 - and we've been asked to consider migrating to virtual machines. While I'm comfortable with doing that, the problem is that our Virtual Infrastructure doesn't allow Desktop OS's on non-VDI instances - and VDI won't work for us because it's not persistent by design. So our only choice is our pick of Windows Server versions.
Unlike my typical approach of jumping into the deep end with both feet, I thought I would ask all of you if you've had any experience with this type of setup, virtual or physical, and if you've had any issues.
trying TDP 4.2 to see if problems encountered with 4.1 was solved...
Everything seems to work well in automation scripts but hang when i try to schedule them.
two differents messages...
I've already had "Exception: Object reference not set to an instance of an object." with 4.1, solved by choosing Task scheduler 1.0...
This new one "value does not fall within the expected range" with 4.2 (task scheduler checked)...
All my scheduled jobs works perfectly with TDP 3.8, but i would migrate them to full 64bit environnement...
Thanks for your reply...
I am trying to create an automation which will export data into an .xlsm spreadsheet which then runs a macro. However, whenever I run my automation I receive an "Object reference not set to an instance of an object" error. This error occurs whether or not I am running a macro after the export. Additionally, none of my colleagues here have this issue; we will perform the exact same steps and I get an error whereas they do not.
I am currently running Toad Data Point 184.108.40.206 (64 bit), which is a newer version than any of my colleagues are running, as far as I know. We are all running Windows 7 Professional. The only difference between my system and theirs is that I am running Microsoft Office 2016, while everybody else uses 2013.
Is there a known export issue with Toad Data Point and the Office 2016?
I have attached the log, set to verbose, but I don't think it'll be too helpful.
If anybody could shed some light on how to resolve this, I would be greatly appreciative. We have the ability to revert my Office to 2013, if that might be a solution to this issue.
-- 6/20/2017 8:20:38 AM: Daily_New_Dealers_Report.log: Setting up environment-- 6/20/2017 8:20:38 AM: Daily_New_Dealers_Report.log: Script run by Toad Data Point 220.127.116.11 as jemery on FFC-xxx-- 6/20/2017 8:20:38 AM: Daily_New_Dealers_Report.log: Build started-- 6/20/2017 8:20:38 AM: Daily_New_Dealers_Report.log: Compiling script-- 6/20/2017 8:20:38 AM: Daily_New_Dealers_Report.log: Start CompileWorkflow-- 6/20/2017 8:20:38 AM: Daily_New_Dealers_Report.log: Before Compile-- 6/20/2017 8:20:39 AM: Daily_New_Dealers_Report.log: Return from CompileWorkflow-- 6/20/2017 8:20:39 AM: Daily_New_Dealers_Report.log: Workflow Compiled without Errors-- 6/20/2017 8:20:39 AM: Daily_New_Dealers_Report.log: Workflow Compiled has warnings-- 6/20/2017 8:20:39 AM: Daily_New_Dealers_Report.log: Warning: No Exception Handler. To send an Email when there is an error, change the value of Email on Error to true and enter email values.-- 6/20/2017 8:20:39 AM: Daily_New_Dealers_Report.log: Build completed-- 6/20/2017 8:20:39 AM: Daily_New_Dealers_Report.log: Create Workflow instance-- 6/20/2017 8:20:39 AM: Daily_New_Dealers_Report.log: Started workflow instance-- 6/20/2017 8:20:39 AM: Daily_New_Dealers_Report.log: Begin execution script activities-- 6/20/2017 8:20:39 AM: Daily_New_Dealers_Report.log: Variable "ROOT_PATH" set to ''-- 6/20/2017 8:20:39 AM: Daily_New_Dealers_Report.log: Running embedded export template-- 6/20/2017 8:20:39 AM: Daily_New_Dealers_Report.log: Executing export using connection CompassDB2 (FNDODBCxxxxx) is not XQuery Connection-- 6/20/2017 8:20:39 AM: Daily_New_Dealers_Report.log: Export_1 - Object reference not set to an instance of an object.-- 6/20/2017 8:20:39 AM: Daily_New_Dealers_Report.log: Failed
I am evaluating Toad Data Point as a replacement for OracleEPM/Hyperion/Brio. So far, I like what we see, but want to test in a bit more detail. I am not a developer but an applied data analyst. I generally do not write SQL directly, but rely instead on a visual query builder.
I need help writing a correlated subquery using the visual query designer in Toad Data Point. I can build a subquery but cannot figure out how to join it back to the main query properly. What follows is the SQL we wish to replicate using the Visual Designer in TOAD Data Point: SELECT AL1.SGBSTDN_PIDM, AL1.SGBSTDN_TERM_CODE_EFF FROM SATURN.SGBSTDN AL1 WHERE (AL1.SGBSTDN_TERM_CODE_EFF IN
(SELECT MAX ( AL2.SGBSTDN_TERM_CODE_EFF ) FROM SATURN.SGBSTDN AL2 WHERE (AL2.SGBSTDN_PIDM=AL1.SGBSTDN_PIDM)))I've exported the above from Oracle EPM/Hyperion/Brio. Of course, I can paste it into the query builder in TOAD Data Point, execute it, and it works fine. However, I would like to be able to build it using the visual designer (the DIAGRAM tab in Query Builder). The particular thing I cannot figure out is how to link the subquery back to the main query, which is represented by this:
WHERE (AL2.SGBSTDN_PIDM=AL1.SGBSTDN_PIDM)I understand that Toad Data Point may approach a problem like this differently than did Oracle EPM/Hyperion/Brio, I just can't figure out what that approach may be.
Thanks for any advice you may have, and please forgive my ignorance.Paul
I'm setting up Toad Data Point 4.2 and my office is making the switch (from Brio) so I'm trying to document a clean installation method.
Direct Connect works fine but can't do cross-queries with Excel so I'm setting up an Oracle Client connection. I installed the Oracle 12.2 basic driver and ODBC package. When I get to this point of the install it asks for a TNS Service Name. If I leave this blank the connection test crashes. I'm not sure if I should already have a tnsnames.ora file or if I need to create that myself. Where can I find this or what steps do I need to do to create it?
I'm using TDP 18.104.22.168 to connect to a PostgreSQL database. The thing is I want the DATE and the DATETIME columns to be formatted in a different way:
Date = yyyy-MM-ddTimeStamp = yyyy-MM-dd hh:mm:ss
I've tried to set up a custom format just for the dates by configuring:
Odbc:DATE=yyyy-MM-dd, (as mentioned in a very old thread here)
but this doesn't seem to work. I'm pretty sure that technique works in "Toad for SQL Server", where it is possible to have different formatting, but I'm not sure if TDP allows this for ODBC.
Does anybody know if this is feasible at all?
Hi I’m new to Toad using Toad Data Point 22.214.171.1247 Base Edition. I have created a cross connection query using one MS Access 2010 table and three DB2 tables. When I make them all inner joins my query works fine. When I switch one join (between Access and one DB2 table) to a left join, I get an error “[Microsoft][ODBC Microsoft Access Drive] JOIN expression not supported”.
In the interest of full disclosure, the join uses a substring of the DB2 field per snippet below (real DB names masked). However this join works fine when it is an inner join, so that doesn't appear to be the issue.
LEFT JOIN MyAccessDatabase.tbDIM_ExtHP_Market_Segment DIM
on RIGHT(DPP.PKG_NM,5) = DIM.BPL
Does my version of Toad support this type of join? I don’t want to waste more time tweaking syntax if it is simply not supported. Thanks for any comments ;)
Why cannot I find the excel file in the locations that I have set up when the log shows the automation run complete and file name generated?
I am trying to join all the elements in one table to a portion of another table. The join happens, then the restrictive where clause; I am trying to get the restrictive where clause to run first, then the join.. I want to filter out the stuff I don't want from tables AL2 and AL3, and THEN join them to AL1 with an outer join. If I put (+) next to the AL2 and AL3 and clauses, the query works, but it will not let me save the format (it eliminates the (+)'s. What is the current version of SQL syntax for this?
FROM A.ENTITY_VIEW AL1, A.ENTITY_LIST_VIEW AL2, A.CODES_VIEW AL3
WHERE (AL1.PORTFOLIO_CODE = AL2.PORTFOLIO_CODE(+))
AND (AL1.ENTITY_ID_UNTRIMMED = AL3.CODE_VALUE(+))
AND ( ( AL2.PORTFOLIO_GROUP_ID = 'DLYPRICE' Note: can add (+) after ID and it works.
AND AL3.CODE_INTERFACE = 'PROD ') Note: same here after interface
AND AL3.CODE_TYPE_SHORT_DESC = 'PORTPRICSRCE ') Note: same here after desc
Any help is appreciated in order to help me get my data imported. Thank you in advance.
I sporadically get a 'Toad Data Point Error Message' and 'Toad Error Message' when attempting to import .csv to Teradata existing table using Toad Data Point 126.96.36.1994 Import Wizard. I get the error whether the .csv is on a network file share or local. The .csv is about 125MB and 20000 rows. I've tried allowing TDP to 'Optimize block size', but that fails every time so I have manually set the 'Processing row count' to 5000. The .csv is generated by an upstream reporting system, and I'm attempting to load it several times per week until we get an automation solution in place.
This is on a Dell Precision 7510 with 16GB RAM and 7GB free while running this import.
Error text and log below:
Toad Data Point Error Message
System.OutOfMemoryExceptionException of type 'System.OutOfMemoryException' was thrown.Stack Trace: at System.Drawing.Graphics.get_Clip() at System.Drawing.GraphicsContext..ctor(Graphics g) at System.Drawing.Graphics.Save() at System.Windows.Forms.Control.WmPaint(Message& m) at System.Windows.Forms.Control.WndProc(Message& m) at DevExpress.XtraBars.Controls.DockedBarControl.WndProc(Message& msg) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
Toad Error Message
System.OutOfMemoryExceptionException of type 'System.OutOfMemoryException' was thrown.Stack Trace: at System.Diagnostics.NtProcessInfoHelper.GetProcessInfos(IntPtr dataPtr) at System.Diagnostics.NtProcessInfoHelper.GetProcessInfos() at System.Diagnostics.ProcessManager.GetProcessInfos(String machineName) at System.Diagnostics.Process.EnsureState(State state) at System.Diagnostics.Process.get_ProcessName() at DevExpress.Utils.FormShadow.FormShadow.get_IsDesignMode() at DevExpress.Utils.FormShadow.FormShadow.get_ShouldShowShadowWindow() at DevExpress.Utils.FormShadow.FormShadow.UpdateShadowWindowPositions(Boolean delayWhileMove) at DevExpress.Utils.FormShadow.FormShadow.OnUpdate() at DevExpress.Utils.FormShadow.FormShadow.EndUpdate() at DevExpress.XtraEditors.XtraForm.InitFormShadow() at DevExpress.XtraEditors.XtraForm.UpdateFormBorderEffect() at DevExpress.XtraEditors.XtraForm.OnLoad(EventArgs e) at Quest.Toad.Gui.BaseForm.OnLoad(EventArgs e) at System.Windows.Forms.Form.OnCreateControl() at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible) at System.Windows.Forms.Control.CreateControl() at System.Windows.Forms.Control.WmShowWindow(Message& m) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ScrollableControl.WndProc(Message& m) at System.Windows.Forms.Form.WmShowWindow(Message& m) at System.Windows.Forms.Form.WndProc(Message& m) at DevExpress.XtraEditors.XtraForm.WndProc(Message& msg) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
System.OutOfMemoryExceptionException of type 'System.OutOfMemoryException' was thrown.Stack Trace: at DevExpress.XtraBars.Painters.BarPainter.DrawLink(GraphicsInfoArgs e, BarControlViewInfo viewInfo, BarLinkViewInfo item) at DevExpress.XtraBars.Painters.BarPainter.Draw(GraphicsInfoArgs e, CustomViewInfo info, Object sourceInfo) at DevExpress.XtraBars.Controls.CustomControl.DirectDraw(PaintEventArgs e) at DevExpress.XtraBars.Controls.CustomControl.OnPaint(PaintEventArgs e) at DevExpress.XtraBars.Controls.CustomBarControl.OnPaint(PaintEventArgs e) at System.Windows.Forms.Control.PaintWithErrorHandling(PaintEventArgs e, Int16 layer) at System.Windows.Forms.Control.WmPaint(Message& m) at System.Windows.Forms.Control.WndProc(Message& m) at DevExpress.XtraBars.Controls.DockedBarControl.WndProc(Message& msg) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
08:29:36 Thread (1) Connecting to :EFB0371@TERAFRZ1.ca.boeing.com (BEDW_POC_EFBI_METRICS_T). 08:29:36 Thread (43) Import Started [2017-05-23 08:29:36]08:29:36 Thread (43) Processing "EFBI_COGNOS_CONTENT_CLEAN.csv" into "BEDW_POC_EFBI_METRICS_T.COGNOS_CONTENT_CLEAN"09:06:53 Thread (43) The rows failed importing will be written to file : \\NW\data\EFBI\EFBI_Data_Transfer\NetVisn_to_EFBI\EFBI_COGNOS_CONTENT_CLEAN_rows_with_error.csv09:06:53 Thread (43) Importing 1 out of 1 files09:06:54 Thread (43) Reading from file EFBI_COGNOS_CONTENT_CLEAN.csv09:06:58 Thread (43) Failed to parse the file.Index was out of range. Must be non-negative and less than the size of the collection.Parameter name: index09:06:58 Thread (43) Nothing to discard, delete \\NW\data\EFBI\EFBI_Data_Transfer\NetVisn_to_EFBI\EFBI_COGNOS_CONTENT_CLEAN_rows_with_error.csv09:37:55 Thread (43) Error(s) occured, no rows were imported.
09:37:55 Thread (43) Error importing data, please check file format options: Failed to parse the file.Index was out of range. Must be non-negative and less than the size of the collection.Parameter name: index09:37:55 Thread (43) Import Finished [2017-05-23 09:37:55]09:37:55 Thread (43) Import time: 01:08:19.2423486
I have noticed when comparing many of my reports generated using TDP 3.7 to those generated using TDP 4.2, that there are dozens or even thousands of extra lines in the Excel sheets. Is anyone else experiencing this? Is there a new setting I am missing to prevent this?
I have a script that has an export activity followed with a macro, when I run this script from TDP , macro fire up. But when I run the same script after publishing from TIC, it ignores the macro and only export happens. I am using TDP 4.2 and TIC 3.3.
I have been on version 3.6 (188.8.131.5294) for some time and everything has been working well. I am connecting to Oracle databases most of the time, and previously they have all been on Oracle 11g. Recently they have upgraded a couple databases to 12c, and my queries from Toad Data Point are running extremely slow. I initially thought it was an Oracle issue, but I can run the same queries through some other Oracle tools (e.g., Oracle SQL Developer, SQL Plus, Toad for Oracle) and everything runs fine. It is only in Toad Data Point that I have this issue.
Has anyone experienced the same issue or have an idea why this might be occurring? I even reinstalled Data Point, and I have also tried the new 3.7 version. I am using the Oracle native client to connect, so no ODBC is involved.
Thank you all for your time and input.
I'm using TDA to query a DB2 database that has datatypes of DATE, TIME and TIMESTAMP. My problem is that the grid is using one format for all three datatypes. I'm new to TDA after using QMF for the last 10 years. Is there any way to customize the format for each datatype?
One of my users is having an issue with TOAD 3.6 and Teradata. It was working fine and then all of a sudden queries are taking forever to execute in Toad and downloading results will be extremely slow. I've tried resetting his TOAD profile and comparing connection details and nothing seems "off". When we use Teradata SQL Assistant on same computer and connection the results download very fast.
I've also found a recommendation elsewhere on the forum to enable "Use Non-X views in Object Explorer" but that appears to be more for connecting faster and not changing the row-fetch speed.
Any ideas? It's a head scratcher for sure.
I'm using Toad Data Point 4.2 and have an Access connection setup to a DB on my network. The connection is successfully setup and I can see the details of the two tables I'm looking in the database (i.e. the column definition and what not); however, when I go to view the data, it doesn't show anything, it is left all blank. Further, when I open the db in Access natively, there is data in both tables. When I go to add a new column in the DB, save the DB, and then re-open Toad, upon reconnecting the DB, the new column is not there. I'm very perplexed by this. Has anyone seen this before?
I can verify that I am using a 32 bit version of Office 2010, with a 32 bit version of Toad Data Point as well.
Could we Compare XML file to Hive table in hadoop in TOAD 4.1?
We use hortonworks hadoop in Microsoft Azure: Cloud
When exporting data from my mySQL database in a longish product description field I'm getting strange characters that my internal project needs translated to normal. What can I do to achieve this? Example of poor data <html markeup?> in notepad
Adapts the Jumboâ„¢ or Jumbo 2000â„¢ Ceiling Mount to round pipes [upto 2â€ (55mm) in diameter]. Bracket can be usedwith or without an extension column.
Correct look on web:
The community was very helpful to me to get a query built for Toad Datapoint with a Vertica database. I can get the query to run, but the output data/results is different for the same data that inputted to the older Toad for Oracle database. I have been trying to find out why and have not made progress.
The present sql has 2 subqueries and each subquery has 3 inner joins. I need data from 6 different tables. If 1 run just one of the subqueries stand alone, it is the same data as when I run ther complete sql. If I run just the data for any of the individual tables by itself, the data matches 100% to the Toad for Oracle. To me it is not a subquery issue, but more of a inner join issue.
The other part is trying to get a formula to obtain a Success Ratio.
THANKS in advance