Toad Data Point Forum - Toad Data Point - Toad World

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.

 

1905 4 / Create an account to join the discussion.
N.B.
Follow / 15 Jun 2017 at 8:53pm / Toad Data Point
Latest post by on 22 Jun 2017 at 11:13am

Toad Data Point on Windows Server (2008 R2, 2012, 2016)

Expand content
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...

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.

124 6 / Create an account to join the discussion.
mercier104_000
Follow / 12 May 2017 at 4:23pm / Toad Data Point
Latest post by on 22 Jun 2017 at 10:41am

TDP 4.2 Job Manager "value does not fall within the expected...

Expand content
Hi, 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...

Hi,

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...

Regards,

Franck  

169 4 / Create an account to join the discussion.
jemery
Follow / 20 Jun 2017 at 3:09pm / Toad Data Point
Latest post by on 21 Jun 2017 at 8:39pm

ERROR: Object reference not set to an instance of an object.

Expand content
Hello, 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...

Hello,

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 4.1.0.226 (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 4.1.0.226 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

Thank you,

John

Unanswered 50 2 / Create an account to join the discussion.
PGW
Follow / 19 Jun 2017 at 5:42pm / Toad Data Point
Latest post by on 21 Jun 2017 at 7:14pm

How to Create a Correlated Sub-query in Toad Data Point using Visual...

Expand content
Hello, 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...

Hello,

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

Unanswered 45 2 / Create an account to join the discussion.
m.carlucci
Follow / 16 Jun 2017 at 6:31pm / Toad Data Point
Latest post by on 20 Jun 2017 at 5:23pm

How do I make a TNSNames file?

Expand content
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...

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?

Unanswered 69 1 / Create an account to join the discussion.
veskojl
Follow / 13 Jun 2017 at 8:18pm / Toad Data Point
Latest post by on 20 Jun 2017 at 1:15am

Custom DATE format for ODBC (PostgreSQL)

Expand content
Hi, I'm using TDP 4.2.0.207 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-dd TimeStamp = yyyy-MM...

Hi, 

I'm using TDP 4.2.0.207 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-dd
TimeStamp = 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?

Unanswered 111 5 / Create an account to join the discussion.
BoulderRidge
Follow / 31 May 2017 at 4:29am / Toad Data Point
Latest post by on 17 Jun 2017 at 5:36am

Is my cross connection left join supported?

Expand content
Hi I’m new to Toad using Toad Data Point 3.8.1.677 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...

Hi I’m new to Toad using Toad Data Point 3.8.1.677 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.

MyDB2Database.TB_DIM_PRD_PKG DPP

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 ;)

Unanswered 167 5 / Create an account to join the discussion.
sssxxx
Follow / 7 Jun 2017 at 5:36pm / Toad Data Point
Latest post by on 17 Jun 2017 at 3:17am

Cannot find exported excel file after automation run complete

Expand content
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?

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?

146 6 / Create an account to join the discussion.
Barbgentile
Follow / 31 May 2017 at 6:52pm / Toad Data Point
Latest post by on 16 Jun 2017 at 5:52pm

Left join becomes inner join when where clauses are added

Expand content
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...

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?

SELECT AL1.PORTFOLIO_CODE,

AL2.PORTFOLIO_GROUP_ID,

AL1.PORTFOLIO_NAME,

AL1.PORTFOLIO_TYPE_CODE,

AL3.CODE_DESCRIPTION

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

Unanswered 210 8 / Create an account to join the discussion.
Orn Wilson
Follow / 23 May 2017 at 7:22pm / Toad Data Point
Latest post by on 15 Jun 2017 at 5:33pm

Help importing .csv to Teradata (system.OutOfMemoryException TDP 4...

Expand content
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...

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 4.0.0.624 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.OutOfMemoryException
Exception 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

Toad Data Point Error Message

System.OutOfMemoryException
Exception 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)

Toad Data Point Error Message

System.OutOfMemoryException
Exception 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)


Log data

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.csv
09:06:53 Thread (43) Importing 1 out of 1 files
09:06:54 Thread (43) Reading from file EFBI_COGNOS_CONTENT_CLEAN.csv
09: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: index
09:06:58 Thread (43) Nothing to discard, delete \\NW\data\EFBI\EFBI_Data_Transfer\NetVisn_to_EFBI\EFBI_COGNOS_CONTENT_CLEAN_rows_with_error.csv
09: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: index
09:37:55 Thread (43) Import Finished [2017-05-23 09:37:55]
09:37:55 Thread (43) Import time: 01:08:19.2423486

Answered 355 12 / Create an account to join the discussion.
andy.corson
Follow / 22 May 2017 at 3:01pm / Toad Data Point
Latest post by on 15 Jun 2017 at 3:18am

TDP 4.2 select to file and export templates adding extra lines to...

Expand content
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...

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? 

Unanswered 293 11 / Create an account to join the discussion.
Vaibhav Gupta
Follow / 14 Jun 2017 at 7:01am / Toad Data Point
Latest post by on 14 Jun 2017 at 12:55pm

Macros not firing up from scripts published on TIC working fine with...

Expand content
Hi, 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...

Hi,

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.

Unanswered 80 3 / Create an account to join the discussion.
Joe
Follow / 5 Aug 2015 at 11:29pm / Toad Data Point
Latest post by on 14 Jun 2017 at 4:02am

Toad Data Point querying slow after Oracle 12c upgrade

Expand content
Hello, I have been on version 3.6 (3.6.1.3294) 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...

Hello,

I have been on version 3.6 (3.6.1.3294) 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.

Regards,

Joe

5684 18 / Create an account to join the discussion.
Jim Taylor
Follow / 29 Oct 2010 at 3:52pm / Toad Data Point
Latest post by on 14 Jun 2017 at 2:53am

Date, Time, Timestamp format

Expand content
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...

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?

13893 3 / Create an account to join the discussion.
austins
Follow / 9 Jun 2017 at 7:01pm / Toad Data Point
Latest post by on 13 Jun 2017 at 6:37pm

Teradata row fetch speed very slow

Expand content
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...

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.

Unanswered 89 1 / Create an account to join the discussion.
amorano_234
Follow / 13 Jun 2017 at 4:29pm / Toad Data Point

MS Access Connection Doesn't Reflect New Table Columns and Data...

Expand content
Hi Everyone, 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...

Hi Everyone,

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.

30 0 / Create an account to join the discussion.
Anson1000
Follow / 6 Jun 2017 at 2:08am / Toad Data Point
Latest post by on 7 Jun 2017 at 11:34pm

Compare XML file to Hive table in hadoop

Expand content
Hi All, Could we Compare XML file to Hive table in hadoop in TOAD 4.1? We use hortonworks hadoop in Microsoft Azure: Cloud thanks

Hi All,

Could we Compare XML file to Hive table in hadoop in TOAD 4.1?

We use hortonworks hadoop in Microsoft Azure: Cloud 

thanks

76 2 / Create an account to join the discussion.
shansen_17166
Follow / 5 Jun 2017 at 4:10pm / Toad Data Point
Latest post by on 7 Jun 2017 at 7:29pm

Export Data from mySQL strange HTML markup for apostrophe, trademark...

Expand content
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?...

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:

 

99 2 / Create an account to join the discussion.
mf1375
Follow / 6 Jun 2017 at 7:27pm / Toad Data Point
Latest post by on 7 Jun 2017 at 12:39pm

data results different with joins and/or suqueries

Expand content
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...

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

104 2 / Create an account to join the discussion.