Toad World® Forums

Toad for oracle 14.0.75 - Session browser not showing full details

Hi,

I am new in Toad family. So, i am not sure if this is correct way to address something but here it is, i am facing issue with session browser.
Recently, i have updated Toad for Oracle to 14.0.75.662 and at the same time we updated oracle client to 12c. Usually we are using session browser functionality to utilize few things, after upgrade of Toad for Oracle and Oracle client, i am not able to see full details of session browser, in addition it is throwing an error when i open session browser window.

ERROR - Field 'CON_ID' not found.

Weirdly, Session browser works fine in older version (10.6).

Let me know, if someone have any idea about this.

Thank you,
Pratik

Hi Patrik,

This is a great place to report problems.

I'm trying Toad 14 on a 12.1 database and not seeing this error. Can you try this?

Go to Main Menu -> Database -> Spool SQL -> Spool to screen. This will capture all SQL executed by Toad.
Then open Session Browser so that the error occurs again.
Paste the spool SQL output here.

Also, if you see an error dialog like this:
image

Click where it says "click here". Then, in the next dialog, check "Copy to clipboard" and click OK. Then post your clipboard contents here. It will contain details about the error.

Thanks.

Hi John,

Thank you for answering query, i can not retrieve any SQL but i can see similar dialog box as you mentioned.

i have pasted below exception details,

Application:

1.1 Start Date : Mon, 2 Nov 2020 09:22:41 +0200
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 23:42:20 +0200
1.6 Up Time : 6 hour(s), 2 second(s)

Exception:

2.1 Date : Mon, 2 Nov 2020 15:22:44 +0200
2.2 Address : 0000000004AA67
2.3 Module Name : Toad.exe - (Toad® for Oracle)
2.4 Module Version: 14.0.75.662
2.5 Type : EDatabaseError
2.6 Message : Field 'CON_ID' not found.
2.7 ID : 436E2BE3
2.8 Count : 1
2.11 Sent : 0

Comment=
7FFFFFFE
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040

-Pratik

Are you connected to a pluggable/container or "normal" database?

Also, I know you said that you updated your Oracle client to 12c, but what is the server version that you are connected to?

I am connect to PDB.

As per server version, it is also 12c.

If you do a "select * from V$SESSION" in the editor, is the CON_ID column present?

No, There isn't CON_ID present when checking the session query.

That's the problem. That column is supposed to be there on 12c according to Oracle docs.

So, Toad expects it.

If the database was upgraded, perhaps this view was missed?

Thank you John,
That seems to be problem,
I will check with team and let you know what we found out about it.

1 Like