Workaround
Modify Toad.ini; its default location is %APPDATA%\Quest Software\Toad for Oracle\xxx\User Files\Toad.ini – xxx referred to Toad version.
1) Modify InternetAccess=0 to the [SETTINGS] section – (where 1 check online and 0 is to check offline).
2) If startup delays are still present the user should also set AuthenticodeDisableCRLCheck=1 in Toad.ini.
3) Add DEBUG=1 to the [SETTINGS] section. Example
4) Example as follow:
[SETTINGS]
DEBUG=1
SCRIPTDEBUG=0
InternetAccess=0
AuthenticodeDisableCRLCheck=1
BarPaintingOptimization=0
UpgradeFlags=115
The InternetAccess=0 INI setting removes Toad's ability to connect to the internet. This setting is also applied to the Certified Version Engine client.
Debug = 1 is optional for logging purposes.
Next, modify appsettings.json; its location is <install-dir>\CertifiedVersionEngine\appsettings.json where <install-dir> is the directory containing Toad.exe.
1) Add a new section for AuthenticodeOptions and add a new key/value pair for "urlRetrievalTimeoutSeconds": 1
2) Set Serilog > MinimumLevel value to Debug (
optional)
3) Example as follow:
{
"ProductPolicies": {
"ApiBase": "https://certifiedversions.ism.quest.com",
"Query": "api/policies?productId={0}&productVersion={1}"
},
"Serilog": {
"MinimumLevel": "Debug",
"WriteTo": [
{
"Name": "File",
"Args": {
"path": "%ProgramData%\\Quest Software\\DBT\\CVE\\Logs\\CVE.log",
"fileSizeLimitBytes": 20000000,
"rollingInterval": "Day",
"rollOnFileSizeLimit": true,
"retainedFileCountLimit": 5
}
}
]
},
"ApiPolicy": {
"RetryCount": 2,
"TimeoutSeconds": 5
}
},
"AuthenticodeOptions": {
"urlRetrievalTimeoutSeconds": 1
}
}
Adding this parameters is to set the CVENG client's URL retrieval timeout used for cert validation.
Set MinimumLevel value to "Debug" is for logging purposes.
