Toad Data Point Beta Program Community

Toad Data Point - Beta Forum

Chris Barnett

Issue with Automation variables in TDP Beta

Expand content
Hi, I just upgraded my beta to 4.3.0.291 and I'm hitting an issue with the variable handling. Normally, whenever a new version comes out, variables fluctuate between showing up as quote-encapsulated...

Hi, I just upgraded my beta to 4.3.0.291 and I'm hitting an issue with the variable handling.  Normally, whenever a new version comes out, variables fluctuate between showing up as quote-encapsulated and not.  It normally doesn't affect functionality other than sort order and it's a beta, so no big deal.  This time around it's doing something new.

My automation basically sets a variable (#TODAY#)  which generates today's date in YYYY-MM-DD format as a string.   I then use that variable to name my query export and then in my notification emails, I provide a url with the filename for the day.  It's all pretty simple stuff. 

The export now exports the filename without quote-encapsulating the date portion, which is how I'd prefer it.  However, every other step in automation is still using & looking for the quote-encapsulated version, so parts of the job start failing.  I've tried simple things like the copy file action and my email notification action and they all fail.  

E.G.  I'm generated Filename_2017-08-11.xlsx and the rest of the job is looking for Filename_'2017-08-11'.xlsx ,  even though every step refers to the same #TODAY# variable.   

I've tried rebuilding the variable  as Date('YYYY-MM-DD') and to_char(Current_date(), "YYYY-MM-DD') and both behave the same way.    I've also tried setting it as a DateTime variable, which introduced new issues. 

Is there something I'm missing to get this to behave consistently ?  

Thanks,

Chris

49 0 / Create an account to join the discussion.
Aleksey Bazhenov

Toad Data Point Beta 4.3.0.291 is now available

Expand content
Installer is available on the TDA Community website: https://www.toadworld.com/products/toad-data-point/toad_data_point_beta_program The latest list of fixes and enhancements can be found in the Release...

Installer is available on the TDA Community website:

https://www.toadworld.com/products/toad-data-point/toad_data_point_beta_program

The latest list of fixes and enhancements can be found in the Release Notes:

http://dev.toadfordataanalyst.com/releasenotes/beta/ToadforDataAnalystsRNBeta.htm

TDP Development Team

25 0 / Create an account to join the discussion.
Mike Triplett

Toad Data Point Beta 4.3.0.253 (32 bit) - Job Manager does not wo...

Expand content
I'm currently running Toad Data Point 4.2.1.303 (32 bit) and after upgrading to Windows 10 - Creators Edition the Job Manager fails and I cannot schedule any tasks. I saw a suggest to upgrade to...

I'm currently running Toad Data Point 4.2.1.303 (32 bit) and after upgrading to Windows 10 - Creators Edition the Job Manager fails and I cannot schedule any tasks.  

I saw a suggest to upgrade to the Beta to see if it fixes my problem.  I've installed Toad Data Point Beta 4.3.0.253 (32 bit) and that does not fix the error.

This is the error I receive when attempting to "Schedule" a "Automation".

Exception: (1,1306):WnfStateChangeTrigger:

I've also tried changing to Task Scheduler 1.0 and that fails also.

46 0 / Create an account to join the discussion.
Chris Barnett
Follow / 11 Jul 2017 at 4:29pm / Toad Data Point Beta Program
Latest post by on 14 Jul 2017 at 8:55pm

Issue with Job Manager/Automations in beta 4.3.0.220

Expand content
When trying to access the Job Manager in 4.3.0.220 (Win7 /32-bit Toad Data Point), the following error triggers: System.MissingMethodException Method not found: 'DevExpress.Utils.ImageCollection...

When trying to access the Job Manager in 4.3.0.220 (Win7 /32-bit Toad Data Point), the following error triggers:

System.MissingMethodException
Method not found: 'DevExpress.Utils.ImageCollection Quest.Toad.Util.Global.get_ImageList()'.
Stack Trace:
at Quest.JobManagement.UI.Plugin.ConcoleToad.LoadServers()
at Quest.JobManagement.UI.Plugin.ConcoleToad.initControls()
at Quest.JobManagement.UI.Plugin.ConcoleToad..ctor()
at Quest.JobManagement.UI.Plugin.Analyst.ConcoleToadAnalyst..ctor()
at Quest.JobManagement.UI.Plugin.PluginForm.CreateMainControl()
at Quest.JobManagement.UI.Plugin.PluginForm.StartAll()
at Quest.JobManagement.UI.Plugin.PluginForm..ctor()
at Quest.JobManagement.UI.Plugin.PluginForm.JustShow(Object sender, ITrl[] trls)

The same thing happens when trying to schedule a new automation.   

Downgrading to the last viable beta works, but that expires on 07/16.  Are there any options for getting around this or do I need to wait for a new beta version to be released?

Thanks,

Chris

Unanswered 141 2 / Create an account to join the discussion.
Aleksey Bazhenov

Toad Data Point Beta 4.3.0.253 is now available

Expand content
Installer is available on the TDA Community website: https://www.toadworld.com/products/toad-data-point/toad_data_point_beta_program The latest list of fixes and enhancements can be found in the Release...

Installer is available on the TDA Community website:

https://www.toadworld.com/products/toad-data-point/toad_data_point_beta_program

The latest list of fixes and enhancements can be found in the Release Notes:

http://dev.toadfordataanalyst.com/releasenotes/beta/ToadforDataAnalystsRNBeta.htm

TDP Development Team

56 0 / Create an account to join the discussion.
Aleksey Bazhenov

Toad Data Point Beta 4.3.0.220 is now available

Expand content
Installer is available on the TDA Community website: www.toadworld.com/.../toad_data_point_beta_program The latest list of fixes and enhancements can be found in the Release Notes: http://dev.toadfordataanalyst...

Installer is available on the TDA Community website:

www.toadworld.com/.../toad_data_point_beta_program

The latest list of fixes and enhancements can be found in the Release Notes:

http://dev.toadfordataanalyst.com/releasenotes/beta/ToadforDataAnalystsRNBeta.htm

TDP Development Team

101 0 / Create an account to join the discussion.
yan2
Follow / 19 Mar 2017 at 3:22am / Toad Data Point Beta Program
Latest post by on 24 Jun 2017 at 1:54am

Azure SQL DB - object MS_Description cannot be displayed

Expand content
There has been a recent (seamless ?) enhancement of Azure SQL db, namely, it does support now the addition of extended properties to tables, columns,... Maybe it did for a while but at https://msdn.microsoft...

There has been a recent (seamless ?) enhancement of Azure SQL db, namely, it does support now the addition of extended properties to tables, columns,... Maybe it did for a while but at https://msdn.microsoft.com/en-us/library/ms180047.aspx, the green checkmark next to Azure SQL DB is new (since Jan apparently).

e.g. the following statement does not error out anymore - it did last time I tried a few months ago.

EXEC sys.sp_addextendedproperty @name = N'MS_Description', @value = 'test description', @level0type = N'SCHEMA', @level0name = 'dbo', @level1type = N'TABLE',  @level1name = 'mytable' 


Can TDP be updated to act like with SQL Server connections and allow to display the Description, among others,

  • of the columns in the properties tab of a table
  • in the Object Explorer context-menu, Options > Extra Columnazure (in both Tables and Columns panes)
293 3 / Create an account to join the discussion.
joseluis.teixeira
Follow / 29 May 2017 at 10:05am / Toad Data Point Beta Program
Latest post by on 1 Jun 2017 at 7:22pm

Beta Download :: Wrong link/version

Expand content
Hello, I was trying to download latest Beta release, but it seems that something went wrong on download link. On forums announcement we can find this: But when reaching download page http:...

Hello,

I was trying to download latest Beta release, but it seems that something went wrong on download link.

On forums announcement we can find this:

But when reaching download page http://www.toadworld.com/products/toad-data-point/toad_data_point_beta_program, this is what is showing:

Can you provide download link for latest release?

160 1 / Create an account to join the discussion.
Aleksey Bazhenov

Toad Data Point Beta 4.3.0.128 is now available

Expand content
Installer is available on the TDA Community website: www.toadworld.com/.../toad_data_point_beta_program The latest list of fixes and enhancements can be found in the Release Notes: dev.toadfordataanalyst...

Installer is available on the TDA Community website:

www.toadworld.com/.../toad_data_point_beta_program

The latest list of fixes and enhancements can be found in the Release Notes: 
dev.toadfordataanalyst.com/.../ToadforDataAnalystsRNBeta.htm

TDP Development Team

160 0 / Create an account to join the discussion.
joseluis.teixeira
Follow / 29 May 2017 at 10:01am / Toad Data Point Beta Program
Latest post by on 29 May 2017 at 10:09am

Know Issues :: ODBC Progress Openedge

Expand content
Hello, I was reading http://dev.toadfordataanalyst.com/releasenotes/beta/ToadforDataAnalystsRNBeta.htm and found this Defect ID: ST69744 On my last trial I was successfully working on several Openedge...

Hello,

I was reading http://dev.toadfordataanalyst.com/releasenotes/beta/ToadforDataAnalystsRNBeta.htm and found this Defect ID: ST69744

On my last trial I was successfully working on several Openedge Progress databases through Toad Datapoint ODBC connection.

174 1 / Create an account to join the discussion.
tzujeff
Follow / 4 May 2017 at 7:56am / Toad Data Point Beta Program
Latest post by on 18 May 2017 at 12:42pm

Toad Data Point Beta 4.2.0.206- select to file, export options, append...

Expand content
the append rows grayed out when filename with variable, for example Rate#CurrentClass#.xlsx

the append rows grayed out when filename with variable, for example Rate#CurrentClass#.xlsx

Unanswered 178 1 / Create an account to join the discussion.
Aleksey Bazhenov
Follow / 14 Apr 2017 at 9:14pm / Toad Data Point Beta Program
Latest post by on 27 Apr 2017 at 7:00pm

Toad Data Point Beta 4.2.0.206 is now available

Expand content
Installer is available on the TDA Community website: www.toadworld.com/.../toad_data_point_beta_program The latest list of fixes and enhancements can be found in the Release Notes: dev.toadfordataanalyst...

Installer is available on the TDA Community website:

www.toadworld.com/.../toad_data_point_beta_program

The latest list of fixes and enhancements can be found in the Release Notes: 
dev.toadfordataanalyst.com/.../ToadforDataAnalystsRNBeta.htm

TDP Development Team

408 5 / Create an account to join the discussion.
Butter
Follow / 15 Mar 2017 at 10:54am / Toad Data Point Beta Program
Latest post by on 28 Mar 2017 at 8:14am

restoring defaults does not work

Expand content
I've tried to restore defaults for highlight styles. Without [visible] effects.D:\Documents and Settings\mmotyl1\Pictures\Toad\retore defaults.png -- Butter

I've tried to restore defaults for highlight styles. Without [visible] effects.D:\Documents and Settings\mmotyl1\Pictures\Toad\retore defaults.png

--
 Butter

233 1 / Create an account to join the discussion.
yan2
Follow / 31 Jan 2017 at 4:10pm / Toad Data Point Beta Program
Latest post by on 19 Mar 2017 at 2:56am

Multiple database browser tabs + feedback mechanism

Expand content
Is it possible to open multiple DB browsers ? This is useful when building queries to see (on other screens) as you go the content of the underlying tables. A generic logistic question to Quest: where...

Is it possible to open multiple DB browsers ? This is useful when building queries to see (on other screens) as you go the content of the underlying tables.

A generic logistic question to Quest: where should one best post requests or ideas, and is there a voting mechanism to help set roadmap priorities ?

We have no idea if someone's feedback is taken into consideration nor do we know what Quest is up to on user's requests - a status like accepted, not considered or under review would help.  

Answered 339 2 / Create an account to join the discussion.
Aleksey Bazhenov

Toad Data Point_Beta_4.2.0.659 is now available

Expand content
Installer is available on the TDA Community website: www.toadworld.com/.../toad_data_point_beta_program The latest list of fixes and enhancements can be found in the Release Notes: dev.toadfordataanalyst...

Installer is available on the TDA Community website:

www.toadworld.com/.../toad_data_point_beta_program

The latest list of fixes and enhancements can be found in the Release Notes: 
dev.toadfordataanalyst.com/.../ToadforDataAnalystsRNBeta.htm

TDP Development Team

187 0 / Create an account to join the discussion.
Aleksey Bazhenov

Toad Data Point_Beta_4.2.0.603 is now available

Expand content
Installer is available on the TDA Community website: www.toadworld.com/.../toad_data_point_beta_program The latest list of fixes and enhancements can be found in the Release Notes: dev.toadfordataanalyst...

Installer is available on the TDA Community website:

www.toadworld.com/.../toad_data_point_beta_program

The latest list of fixes and enhancements can be found in the Release Notes: 
dev.toadfordataanalyst.com/.../ToadforDataAnalystsRNBeta.htm

TDP Development Team

222 0 / Create an account to join the discussion.
Aleksey Bazhenov

Toad Data Point_Beta_4.2.0.562 is now available

Expand content
Toad Data Point_Beta_4.2.0.562 is now available Installer is available on the TDA Community website: www.toadworld.com/.../toad_data_point_beta_program The latest list of fixes and enhancements can...

Toad Data Point_Beta_4.2.0.562 is now available

Installer is available on the TDA Community website:
www.toadworld.com/.../toad_data_point_beta_program

The latest list of fixes and enhancements can be found in the Release Notes:
dev.toadfordataanalyst.com/.../ToadforDataAnalystsRNBeta.htm

TDP Development Team

226 0 / Create an account to join the discussion.
Aleksey Bazhenov
Follow / 16 Jan 2017 at 9:53pm / Toad Data Point Beta Program
Latest post by on 31 Jan 2017 at 11:23pm

Toad Data Point_Beta_4.2.0.495 is now available

Expand content
Toad Data Point_Beta_4.2.0.495 is now available Installer is available on the TDA Community website: www.toadworld.com/.../toad_data_point_beta_program The latest list of fixes and enhancements can...

Toad Data Point_Beta_4.2.0.495 is now available

Installer is available on the TDA Community website:
www.toadworld.com/.../toad_data_point_beta_program

The latest list of fixes and enhancements can be found in the Release Notes:
dev.toadfordataanalyst.com/.../ToadforDataAnalystsRNBeta.htm

TDP Development Team

361 4 / Create an account to join the discussion.
Butter
Follow / 31 Jan 2017 at 9:27am / Toad Data Point Beta Program

script error

Expand content
Hi, following script is correct [Oracle SQL Dev runs it without any problem] SET SERVEROUTPUT ON DECLARE l_today_date DATE ; BEGIN l_today_date := Sysdate; DBMS_OUTPUT.put_line (to_char(l_today_date...

Hi, 

following script is correct [Oracle SQL Dev runs it without any problem]

SET SERVEROUTPUT ON
DECLARE
 l_today_date DATE ;
BEGIN
 l_today_date := Sysdate; 
 DBMS_OUTPUT.put_line (to_char(l_today_date,'yyyy-mm-dd hh:mm:ss' )); 
 DBMS_OUTPUT.put_line ('----------------------------------');
END;

But TOAD has a problem with it.

ORA-00922: brakująca lub niepoprawna opcja = missing or incorrect option.
--
 Butter

223 0 / Create an account to join the discussion.
john.burgtorf
Follow / 13 Jan 2017 at 4:50pm / Toad Data Point Beta Program
Latest post by on 25 Jan 2017 at 7:58pm

Automation, Loop dataset error when adding the select to file act...

Expand content
Hi, in TDP 4.1.0.56 I receive an error when adding the select to file activity. The Error is System.Argument OutOfRangeException: Index was out of range. Can you verify a simple automation script works...

Hi, in TDP 4.1.0.56 I receive an error when adding the select to file activity.  The Error is System.Argument OutOfRangeException: Index was out of range.  Can you verify a simple automation script works with the system activity loop database and the database activity of select to file?  Thank You, John

406 6 / Create an account to join the discussion.