How do I solve the error “Cannot open the selected Model. The file “C:\Path_Name\File_Name.qbx” has unknown content.” Some one asked this same question in this post but did not get a response or answer. I have been unable to successfuly reopen a a model since I started using Toad for Oracle several months ago.
Oracle DBA Edition 2018 v13.0.0.80
Win 10 Pro v1703 build 15063.1088
Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production
Was the .qbx file in question saved using the same version of Toad or an earlier version? If so, which version?
Does this happen for every file/model or just a specific one? If so, can you try to isolate the problem?
Can you give us an idea of what was involved in this model, or the query that was generated? Creating a very simple model, saving, and re-opening is working fine.
From: zajac bounce-zajac@toadworld.com
Sent: Tuesday, July 17, 2018 12:11 PM
Subject: [Toad for Oracle - Discussion Forum] Cannot open the selected Model. The file “C:\Path_Name\File_Name.qbx” has unknown content.
Cannot open the selected Model. The file “C:\Path_Name\File_Name.qbx” has unknown content.
Thread created by zajac
How do I solve the error “Cannot open the selected Model. The file “C:\Path_Name\File_Name.qbx” has unknown content.” Some one asked this same question in this
post but did not get a response or answer. I have been unable to successfuly reopen a a model since I started using Toad for Oracle several months ago.
Oracle DBA Edition 2018 v13.0.0.80
Win 10 Pro v1703 build 15063.1088
Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle Forum notifications altogether.
Toad for Oracle - Discussion Forum
Flag
this post as spam/abuse.
Yes they were all made in the same version of Toad.
So far i have been every qdx file.
These models have been super simple 3 to 4 tables, inner joined, named columns instead of select all, with aggregates such as SUM and GROUP BY.
I believe I have found the cause of the corruption. I made a test query with out any aggregates and was able to save and close toad and reopen the file with out any trouble. I added a COUNT() and GROUP BY and save the query and then closed toad. When toad closed it gave an error.
I don’t recall seeing this before but it’s possible that I missed it anyway the file is corrupt now and will not open giving the “Cannot open the selected Model. The file “C:\Path_Name\File_Name.qbx” has unknown content” error
I’ve added a group by and count to my query along with some others and I’m still not seeing this.
Can you maybe try to recreate it using a built-in Oracle schema like HR or SCOTT? Also, you can go ahead and send me the corrupt file and I can have a developer take a look at it.
Thanks!
I am unable to add the example schemas to the corporate production and test instances I will have to build a new instance on my local PC and try it that way. in the mean time here is one one the corrupt files.
Wave_Pick.zip (157 KB)