返回
-
标题
"Default schema not available" in optimizer schema drop down -
说明
A query is entered into Optimizer for tuning. But before anything can be analyzed and found, Optimizer returned the error "default schema not available".
When clicking on the schema drop down (upper right corner, which notes default) to select a schema an error is given. When clicking on the database drop down (which correctly notes the database) the error "Unhandled error... Data is Null. This method or property cannot be calledon Null values" is given.The error "defaults schema not available" will continue to come up and Optimizer cannot continue.Connection info seems correct. The schema is a limited privilage user. This is not an issue if logged on as dbo.Steps to Replicate:1. Open Toad for SQL Server with the connection (log in with a limited user)
2. Input a sql into editor3. Click 'automatically optimize the current statment' in Toad editor's toolbar
4. Optimizer launches and starts auto optimize
5. Click database drop down list in the upper right coner
6. Error occurs