Toad crash at startup - Invalid Argument to data encode

breno.melo · February 23, 2021, 1:29pm

When using any Toad after any version 13+ it crashes and it's not able to start.
Toad 12.9.0.71 runs OK, but any other updated version is not able to start.

Tested on 13.0.0.80
Also tested in updated trial versions, same thing occurs.

Application:
-------------------------------------------------------
  1.1 Start Date      : Tue, 23 Feb 2021 10:24:29 -0300
  1.2 Name/Description: Toad.exe - (Toad® for Oracle)
  1.3 Version Number  : 13.0.0.80
  1.4 Parameters      : 
  1.6 Up Time         : 0 second(s)

Exception:
---------------------------------------------------
  2.1 Date       : Tue, 23 Feb 2021 10:24:29 -0300
  2.2 Address    : 000000000421C7AB
  2.3 Module Name: Toad.exe - (Toad® for Oracle)
  2.5 Type       : EConvertError
  2.6 Message    : Invalid argument to date encode.
  2.7 ID         : E625D4D2
  2.8 Count      : 1
  2.11 Sent      : 0

Operating System:
---------------------------------------------------------
  6.1 Type                : Microsoft Windows 10 (64 bit)
  6.2 Build #             : 1809 (10.0.17763.1697)
  6.4 Non-Unicode Language: Portuguese (0416)
  6.5 Charset/ACP         : 0/1252
  6.6 Install Language    : Portuguese (0416)
  6.7 UI Language         : Portuguese (0416)

Steps to reproduce:
------------
  8.1 Text: 


Call Stack Information:
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|Methods |Details|Stack           |Address         |Module      |Offset          |Source             |Unit           |Class            |Procedure/Method            |Line                        |
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|*Exception Thread: ID=14328; Parent=0; Priority=0                                                                                                                                               |
|Class=; Name=MAIN                                                                                                                                                                               |
|DeadLock=0; Wait Chain=                                                                                                                                                                         |
|Comment=                                                                                                                                                                                        |
|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
|7FFFFFFE|03     |0000000000000000|000000000421C7AB|Toad.exe    |000000000008C7AB|System.SysUtils.pas|System.SysUtils|                 |ConvertError                |                            |
|00000040|03     |00000000007FF748|00000000042283FC|Toad.exe    |00000000000983FC|System.SysUtils.pas|System.SysUtils|                 |EncodeDate                  |                            |
|00000040|03     |00000000007FF788|00000000047E8B6C|Toad.exe    |0000000000658B6C|cxDateUtils.pas    |cxDateUtils    |TdxTimeZoneHelper|CalculateTransitionDate     |                            |
|00000040|03     |00000000007FF7E8|00000000047E8A13|Toad.exe    |0000000000658A13|cxDateUtils.pas    |cxDateUtils    |TdxTimeZoneHelper|AddDSTInfo                  |                            |
|00000040|03     |00000000007FF848|00000000047E90A6|Toad.exe    |00000000006590A6|cxDateUtils.pas    |cxDateUtils    |TdxTimeZoneHelper|ReadTimeZoneInfoFromRegistry|                            |
|00000040|03     |00000000007FF918|00000000047E9566|Toad.exe    |0000000000659566|cxDateUtils.pas    |cxDateUtils    |TdxTimeZoneHelper|InitTimeZoneInformation     |                            |
|00000040|03     |00000000007FFD38|00000000047EA0A8|Toad.exe    |000000000065A0A8|cxDateUtils.pas    |cxDateUtils    |                 |InitializeUtils             |                            |
|00000040|04     |00000000007FFD68|000000000472D7CF|Toad.exe    |000000000059D7CF|dxCore.pas         |dxCore         |TdxUnitsLoader   |AddUnit                     |2268[7]                     |
|00000040|03     |00000000007FFDB8|00000000047EA205|Toad.exe    |000000000065A205|cxDateUtils.pas    |cxDateUtils    |                 |Initialization              |                            |
|00000040|03     |00000000007FFDE8|00000000041A32F2|Toad.exe    |00000000000132F2|System.pas         |System         |                 |InitUnits                   |                            |
|00000040|03     |00000000007FFE48|00000000041A3385|Toad.exe    |0000000000013385|System.pas         |System         |                 |_StartExe                   |                            |
|00000040|03     |00000000007FFE78|00000000041AF54D|Toad.exe    |000000000001F54D|SysInit.pas        |SysInit        |                 |_InitExe                    |                            |
|00000040|04     |00000000007FFEA8|0000000009D67785|Toad.exe    |0000000005BD7785|Toad.dpr           |Toad           |                 |Initialization              |1814[0]                     |
|00000040|03     |00000000007FFF28|00007FFCEE3B796E|kernel32.dll|000000000001796E|KERNEL32.DLL       |KERNEL32       |                 |BaseThreadInitThunk         |                            |
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

JohnDorlon · February 23, 2021, 3:20pm

Is Toad trying to make a database connection automatically?

What is the latest version that you've tried this with? Can I get a call stack from that version?

Also, if you've made any change to date format in Windows, try changing it to whatever the standard format is for Portuguese.

Thanks

breno.melo · February 23, 2021, 3:43pm

Hi John, thanks for the reply!

It's not trying to connect (also cleaned all connections on a fresh install)

Date of windows is according to my region - Brazil
It's windows standard now, never performed a change into these values.
Now changed to 'Portuguese (Brasil)' and English (US), and same issue occurs.

Application:
-------------------------------------------------------
  1.1 Start Date      : Tue, 23 Feb 2021 12:33:56 -0300
  1.2 Name/Description: Toad.exe - (Toad® for Oracle)
  1.3 Version Number  : 14.0.75.662
  1.4 Parameters      : 
  1.5 Compilation Date: Thu, 15 Oct 2020 18:42:20 -0300
  1.6 Up Time         : 0 second(s)

Exception:
------------------------------------------------------
  2.1 Date          : Tue, 23 Feb 2021 12:33:57 -0300
  2.2 Address       : 000000000422CB7B
  2.3 Module Name   : Toad.exe - (Toad® for Oracle)
  2.4 Module Version: 14.0.75.662
  2.5 Type          : EConvertError
  2.6 Message       : Invalid argument to date encode.
  2.7 ID            : B99BAAE5
  2.8 Count         : 1
  2.11 Sent         : 0

Call Stack Information:
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|Methods |Details|Stack           |Address         |Module      |Offset          |Source             |Unit           |Class            |Procedure/Method            |Line                        |
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|*Exception Thread: ID=16600; Parent=0; Priority=0                                                                                                                                               |
|Class=; Name=MAIN                                                                                                                                                                               |
|DeadLock=0; Wait Chain=                                                                                                                                                                         |
|Comment=                                                                                                                                                                                        |
|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
|7FFFFFFE|03     |0000000000000000|000000000422CB7B|Toad.exe    |000000000009CB7B|System.SysUtils.pas|System.SysUtils|                 |ConvertError                |                            |
|00000040|03     |00000000007FF748|000000000423703C|Toad.exe    |00000000000A703C|System.SysUtils.pas|System.SysUtils|                 |EncodeDate                  |                            |
|00000040|03     |00000000007FF788|0000000004813E2C|Toad.exe    |0000000000683E2C|cxDateUtils.pas    |cxDateUtils    |TdxTimeZoneHelper|CalculateTransitionDate     |                            |
|00000040|03     |00000000007FF7E8|0000000004813CD3|Toad.exe    |0000000000683CD3|cxDateUtils.pas    |cxDateUtils    |TdxTimeZoneHelper|AddDSTInfo                  |                            |
|00000040|03     |00000000007FF848|0000000004814366|Toad.exe    |0000000000684366|cxDateUtils.pas    |cxDateUtils    |TdxTimeZoneHelper|ReadTimeZoneInfoFromRegistry|                            |
|00000040|03     |00000000007FF918|0000000004814826|Toad.exe    |0000000000684826|cxDateUtils.pas    |cxDateUtils    |TdxTimeZoneHelper|InitTimeZoneInformation     |                            |
|00000040|03     |00000000007FFD38|0000000004815368|Toad.exe    |0000000000685368|cxDateUtils.pas    |cxDateUtils    |                 |InitializeUtils             |                            |
|00000040|04     |00000000007FFD68|00000000047592DF|Toad.exe    |00000000005C92DF|dxCore.pas         |dxCore         |TdxUnitsLoader   |AddUnit                     |2268[7]                     |
|00000040|03     |00000000007FFDB8|00000000048154C5|Toad.exe    |00000000006854C5|cxDateUtils.pas    |cxDateUtils    |                 |Initialization              |                            |
|00000040|03     |00000000007FFDE8|00000000041A3322|Toad.exe    |0000000000013322|System.pas         |System         |                 |InitUnits                   |                            |
|00000040|03     |00000000007FFE48|00000000041A33B5|Toad.exe    |00000000000133B5|System.pas         |System         |                 |_StartExe                   |                            |
|00000040|03     |00000000007FFE78|00000000041AF63D|Toad.exe    |000000000001F63D|SysInit.pas        |SysInit        |                 |_InitExe                    |                            |
|00000040|04     |00000000007FFEA8|000000000A1CEEC5|Toad.exe    |000000000603EEC5|Toad.dpr           |Toad           |                 |Initialization              |1845[0]                     |
|00000040|03     |00000000007FFF28|00007FFCEE3B796E|kernel32.dll|000000000001796E|KERNEL32.DLL       |KERNEL32       |                 |BaseThreadInitThunk         |                            |
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

JohnDorlon · February 23, 2021, 4:00pm

Do you have a setting in there somewhere to turn on or off daylight savings time?

Does the bug go away if you change that?

JohnDorlon · February 23, 2021, 4:56pm

Please export the registry entry hive: SOFTWARE\Microsoft\Windows NT\CurrentVersion\Time Zones

Rename the exported file to .txt and email it to me. john.dorlon@quest.com

It looks like the problem has something to do with data in that hive.

breno.melo · February 23, 2021, 5:30pm

Hi John,

Just sent the requested file at the e-mail.

I've changed the Timezone to other zones, like Argentina/Buenos Aires and North of brazil, they doens have 'summer time timezones'

The option is not enabled now, and it's not possible to activate.
Maybe this option was deactivated since we are not going to have it anymore (since 2019).

Same thing occurs.

Thanks!

JohnDorlon · February 23, 2021, 5:59pm

OK, if you go in the Registry to:
SOFTWARE\Microsoft\Windows NT\CurrentVersion\Time Zones\E. South America Standard Time

then rename the sub-node of Dynamic DST to something else (I just put an X in front of it), then Toad will work.

I guess this is OK if you don't participate in Daylight Savings time anymore, but I don't know if this will have an effect with Windows or any other windows program.

breno.melo · February 23, 2021, 6:11pm

John, it Works!

Many thanks for the help!

Very good job!

JohnDorlon · February 23, 2021, 6:15pm

Do you have any coworkers that use Toad? I am wondering if this will affect others in your region.

breno.melo · February 23, 2021, 6:41pm

Yes, I've also reported to them this solution and they had the same problem and was using versions before 13.

But there are other suppliers that use Toad, they don't report any issue in using (out of my company)

Topic		Replies	Views
Export dataset\|Insert statement Toad for Oracle - Beta	10	1235	February 16, 2016
Timestamp with timezone in schema browser not correct Toad for Oracle & DevOps Toolkit	37	3155	February 12, 2025
Format for date query Toad for Oracle & DevOps Toolkit	14	16392	October 18, 2017
00.00.0000 00:00 is not a valid date and time error on export dataset Toad for Oracle & DevOps Toolkit	19	3623	February 6, 2013
Toad crashes too often Toad for Oracle & DevOps Toolkit	17	3116	November 18, 2021

Toad crash at startup - Invalid Argument to data encode

Related topics