Toad World® Forums

Toad crash at startup - Invalid Argument to data encode

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.

image

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

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

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

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?

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.

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!

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.

1 Like

John, it Works!

Many thanks for the help!

Very good job!

1 Like

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

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)