Category
Product Version
Topic
Subtopic
How to purchase or buy Toad? How to acquire a Commercial license key for Toad? (4289355)
How to acquire a Commercial license key?
SQL Optimizer not working (4327946)
While running Optimizer and start Indexes searching, after two hours the process stops and aborts. ... The tool blocks database when deleting indexes, but the same operation is not blocking for SQL Server Database Engine Tuning Advisor.
Spring Framework - CVE-2022-22965 vulnerability (4294347)
If the application is deployed as a Spring Boot executable jar, i.e. the default, it is not vulnerable to the exploit. ... However, the nature of the vulnerability is more general, and there may be other ways to exploit it.</div><div></div><div><span style="font-size: 11pt;font-family: Calibri, sans-serif;color: black;background-position: initial;background-size: initial;background-repeat: initial;background-attachment: initial;background-origin: initial;background-clip: initial;"><a href="https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcve.mitre.org%2Fcgi-bin%2Fcvename.cgi%3Fname%3DCVE-2022-22965&data=04%7C01%7CEdgar.Ueno%40quest.com%7C3f66f912a3e848237dc508da164f9082%7C91c369b51c9e439c989c1867ec606603%7C0%7C0%7C637846828231918011%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=Bo7M3KNRtpiUTyScwNLYrKdkUiXC29vNOjGLa2cJ2AU%3D&reserved=0"
Where can I download SQL Optimizer for SQL Server? (4267577)
Where can I download SQL Optimizer for SQL Server? ... Click here to download the latest version of the SQL Optimizer for SQL Server.
UI Chopping Fonts under Windows 7 when DPI scaling is greater than 125% (4275064)
In using Quest SQL Optimizer for SQL Server, its UI gets 'chopped off' under Windows 7 when DPI scaling is greater than 125%. ... Set DPI to 100%. ... STATUS: ... Waiting for fix in a future version of Quest SQL Optimizer for SQL Server.
Toad for SQL Server license key is not activating SQL Optimizer for SQL Server (4238589)
I am having an issue with my licensing key. ... I have a Toad for SQL Server license key that should give me access to SQL Optimizer for SQL Server. ... I enter the key in Toad and I am able to access Toad with no problem.
Sending a simple select query with objects belonging to sys causes "Invalid SQL Statement." (4290886)
If I run the following from Toad SQL Server or SQL Server Studio Management, it knows that sysobjects belongs to owner sys without qualification. ... When this query is send to SQL Optimizer for tuning, SQL Optimizer throws "Original SQL: Invalid SQL Statement" complaining about 'sysobjects.'
Error: "The query has been cancelled because the estimated cost this query(xxx) exceeds the confi (4341455)
"The query has been cancelled because the estimated cost this query(3869) exceeds the configured threshold of 3000" ... The query governor cost limit has been exceeded. ... This is a SQL Server configuration setting which is managed by the local DBA using the 'sp_configure' system stored procedure(SP) on the SQL instance.
SQL Scanner error: 'Failed to connect "QCSS_SQLScanner.qc" to database.' (4282924)
When I click OK on the error box, I can still proceed but what is causing this error? ... 1. The database's meta data is too big ... 2. The connection between database and the Software is relatively slow
Viewing the Find SQL results makes an Exception error occur (4247748)
After the results are compiled, click on the link that is supposed to show the details, but the graphs are empty and an Exception error message is returned. ... This only happen when connecting to the database using IP, it works fine when using Windows Authentication.
Unable to pick database from Foglight PA Repository with SQL Optimizer. (4226347)
When trying to connect to the PA repository from Optimizer, the option is grayed out and it cannot access the database. ... The PA repository is accessible from the computer (through PA) without issue.
Log4j Vulnerability CVE-2021-44228 (4273218)
Are Toad products affected by the Log4j vulnerability CVE-2021-44228? <p><strong>Toad for Oracle:</strong><br>Toad for Oracle does not use Log4j. Therefore this vulnerability does not affect the product.<br>Toad for Oracle uses OraLDAPClntNN.dll (where NN is oracle version number like 12, 18, 19, etc)</p><p><br>It's unclear if Oracle LDAP client this uses Log4j, but believe this is not the case. </p><p>Some more information about the exploit:<br>"An attacker who can control log messages or log message parameters can execute arbitrary code loaded from LDAP servers when message lookup substitution is enabled"<br><br>Toad doesn't use any log message lookup substitution. The only messages we get from LDAP are numeric error codes, and Toad does not use any lookup substitution on them, or anything else.</p><p><br><strong>Toad Edge:</strong><br>Toad Edge doesn't use Log4j 2, but does use Log4 1.2.17<br><br>The range for this particular security vulnerability (CVE-2021-44228) is Log 4j 2.x to Log4j 2.15.0-rc1<br>Also, Toad Edge is not a server based application. The attack needs to happen over HTTP(S) requests.<br><br><br><strong>Unaffected products:</strong></p><p>Toad for Oracle</p><p>Toad for Oracle Editions</p><p>Toad for SQL Server</p><p>Toad for DB2</p><p>Toad for SAP</p><p>Toad for Data Point</p><p>Toad Intelligence Central</p><p>Toad Data Modeler</p><p>Toad Edge</p><p>SQL Navigator</p><p>SQL Optimizer for Oracle</p><p>SQL Optimizer for SQL Server</p><p>SQL Optimizer for DB2 LUW</p><p>SQL Optimizer for DB2 ZOS</p><p>SQL Optimizer for SAP</p><p>Benchmark Factory for Databases</p><p>Code Tester for Oracle</p><p>Toad DevOps Toolkit</p><p></p><p>Spotlight on Oracle</p><p>Spotlight on SAP</p><p>Spotlight on DB2 LUW</p><p></p>
Error "4294967118" is not a Valid Integer Value" when executing many alternatives (4303162)
Getting the following error when I try to execute many alternatives ... "4294967118" is not a Valid Integer Value ... Reduce the intelligence level and select less alternatives for execution ... Waiting for fix in a future release of SQL Optimizer for SQL Server
How to install and download SQL Optimizer for SQL Server (4293745)
How to download and install SQL Optimizer for SQL Server Review the <a href="https://support.quest.com/sql-optimizer-for-sql-server/technical-documents" target="_blank">Installation Guide</a> for instructions and information on the installation of SQL Optimizer for SQL Server
Using a server qualifier gives "Qualifying table with a server name is not supported in this vers (4275263)
When I tried to optimize a query using SQL Optimizer 8.0 with a server qualifier, I get the following message: ... "Qualifying table with a server name is not supported in this version." ... I'm using a linked server so without the server qualifier, SQL Optimizer throws the following error:
Getting SHOWPLAN permission denied error (4239073)
Getting a SHOWPLAN permission denied error when running the optimizer. ... The user using SQL Optimizer does not have SHOWPLAN granted to them.
SQL Optimizer for SQL Server crashes with huge number of results. (4279217)
Application crashes when a report with a big number of results is being opened. ... Launch the SQL Optimizer for SQL Server</div><div>2. ... You will see the data folder of Find SQL</div></div><div></div><div>Workaround</div><div>1.
Where to download the SQL Optimizer for SQL Server trial edition? (4261751)
It cannot found on the products trial page. ... If only the SQL Optimizer is needed please contact Quest Software Support who can provide a FTP download link for a trial Optimizer installer.
SQL Optimizer takes a long time, or does not provide alternative SQL statements. (4303463)
After the query is submitted to the SQL Optimizer to be optimized, the SQL Optimizer takes a long time or seems to hang while working to return alternative queries. ... Try lowering it in order for SQL Optimizer to apply less hints and permutations on SQL statement.
SQL Optimizer returns much slower execution time for SQL statement than Toad. (4223063)
Running a particular SQL statement in Toad or any other tool takes a less than 10 seconds where as running the same query in Optimizer takes over a minute. ... Why is there a difference in execution in Optimizer and other products and why is Optimizer is slower making it difficult to analyze and compare alternates?
Tune SQL button is not responding in the Foglight console in the SQL PI page (4281604)
SQL Optimizer is standalone application that is licensed separate from Foglight and needs to be installed in order to Tune SQLs. ... <p>SQL Optimizer for SQL Server or Oracle should be installed on the same PC where the user is accessing the Foglight console.
"Find SQL" funcionality takes a lot of time to return results (4334455)
The main problem is when reading the trace. ... It is needed to go through all the trace to collect each SQL statement so, the larger the file size is, the longer the time it take. ... Then for each SQL statement collected, Find SQL will retrieve the execution plan.
Installation error: 1622 - Error opening installation log file. Verify that the specified log file location exist and that you can write to it. (4289146)
The installation of component SQL Optimizer for SQL Server has failed with the following error: ... 1622 - Error opening installation log file. ... Verify that the specified log file location exist and that you can write to it.
"Original SQL: Error running the process" upon running analyze (4339530)
Complex stored procedures that have multiple selects, updates and inserts produce an error. ... It might be impossible to split up each statement because each of them depends on the previous one.
Sql scan function hanging (4342038)
Trying to use the SQL scan function to scan a Stored Proc in SQL Optimizer and its getting stuck at NN%. ... It's a complex stored procedure. ... "if @CC = 'Y'" is the reason to cause the scan process hanging.
New Product Association
- Self Service Tools
- Knowledge Base
- Notifications & Alerts
- Product Support
- Software Downloads
- Technical Documentation
- User Forums
- Video Tutorials
- RSS Feed
- Contact Us
- Technical Support
- View All