TOAD Beta 13.0.0.60 new Bug pop-up error message- Invalid release: ""

Toad for Oracle - Beta
1

Good Morning TOAD Team,

TOAD Beta 13.0.0.60 new Bug pop-up error message. The modal pop-up message appears when I make a connection from the recent connections drop down list.

Invalid release: “”

2

Excellent, I was waiting for something like this. What version of DB? Can you post the string returned by this query?

SELECT version
FROM product_component_version
WHERE UPPER (product) LIKE ‘%ORACLE%’

Thanks,

Michael

3

Good Morning Michael,

Yes,

VERSION
12.1.0.2.0

I like the simpler select *

from V$version

BANNER,CON_ID
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production,0,
PL/SQL Release 12.1.0.2.0 - Production,0,
CORE 12.1.0.2.0 Production,0,
TNS for Solaris: Version 12.1.0.2.0 - Production,0,
NLSRTL Version 12.1.0.2.0 - Production,0

From the support bundle:

** ORACLE CLIENT INFORMATION

Oracle Client Version : 12.2.0.1
Oracle Client DLL : C:\Oracle12c_64-bit\12.2.0_client\bin\oci.dll
TNSNAMES.ora Location : C:\Oracle12c_64-bit\12.2.0_client\Network\Admin\tnsnames.ora
NLS_LANG : AMERICAN_AMERICA.WE8MSWIN1252
SQLPATH : C:\Oracle12c_64-bit\12.2.0_client\dbs
LOCAL :

** ORACLE SERVER INFORMATION

Connection 1 : CMS@EBSSDEV.DOL.GOV ** Active Session **
Oracle Server Version : Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
Oracle Server NLS_CHARACTERSET : WE8MSWIN1252
Oracle Server NLS_NCHAR_CHARACTERSET : AL16UTF16
Oracle Session User : CMS (Normal)

4

Ok, thanks. Can you send me your zipped user files to michaelstaszewskiquest.com?

Thanks,

Michael

5

If you’ve not yet sent user files you can hold off, thanks. I was able to reproduce it with one of my connections here.

Thanks,

Michael

6

This will be fixed in next beta.

Thanks,

Michael

7

Good Afternoon TOAD Team,

Thank you Michael! Looks fixed from my end; it has not happened since the update.

8

I have the same problem, but with TOAD 13.2.0.258 connecting to:
Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production
PL/SQL Release 12.2.0.1.0 - Production
CORE 12.2.0.1.0 Production
TNS for 64-bit Windows: Version 12.2.0.1.0 - Production
NLSRTL Version 12.2.0.1.0 - Production

I have noticed that schemas with the SELECT_CATALOG_ROLE throw the
Invalid release: "12.2.0."
message.

Also, once the message is thrown, other TOAD functions are also broken:
Clicking a Table in the Schema Browser throws "ORA-00942: table or view does not exist", but then displays data on the Columns tab. The Data tab is empty. Clicking the Script tab throws: "ORA-00904: "HYBRID": invalid identifier"

9

See this thread... Toad 13.1.1.5 with Oracle 19.0.0.0.0 issue

Is your Oracle compatible parameter set to "12.2.0." ? If so follow the resolution steps in the other thread. There is a regular expression that validates the Oracle release version of both your database and its compatible setting and a release string with a trailing period like that is not handled. I will look at the regex and see how to enable it to be more flexible while remaining useful for its intended purpose.