Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev |
|
| QA |
|
| Priority | Low |
| Complexity | Unknown |
| Component | DBA-T - SQL Server - Storage Mngr |
| Version | 17.0 |
Aqua Data Studio 16.0.0-dev-36
Build #: 41067
Built on: 2014-Nov-13 02:32:22 P
1.Connect to SQL Server 2014.
2.Go to Menu -> DBA Tools -> SQL Server -> Storage Manager
3.Select SQL Server 2014 DB. Click on OK
4.Storage Manager window opens.
5.Select any database (from Tree Tab under Name column)
6.Click on toolbar menu "Update statistics"
7."Update statistics" pop up displayed,Click on "OK".
8.Warning displayed "CommonSchemaUtil.executeDDL() was not successful".
If we execute SQL query for the same in Query analyzer
It executes successfully.(see attached screenshot)
|
|
316 KB
|
|
209 KB
|
|
168 KB
|
|
271 KB
|
|
137 KB
|
|
93 KB
|
|
90 KB
|
|
45 KB
|
|
39 KB
|
|
76 KB
Same thing is happening for option :"Checkpoint"
In Query analyzer SQL executed successfully,
Option "Detach Database" also shows same warning.
For this , I use database which is in current use.
ADS shows proper pop up message also.("Cannot detach database "SQL Server 2012" because it is currently in use").
If we click on "OK" button on pop up ,ADS still throws warning message.
I think,this warning message is unnecessary(see attaches screenshot - Detach.png)
Option "Detach Database" also shows same warning.
For this , I use database which is in current use.
ADS shows proper pop up message also.("Cannot detach database "SQL Server 2012" because it is currently in use").
If we click on "OK" button on pop up ,ADS still throws warning message.
I think,this warning message is unnecessary(see attaches screenshot - Detach.png)
You may want to check the DBCC function as well.
You may want to check the DBCC function as well.
You may want to check the DBCC function as well.
DBCC functions should be okay, see this comment for more info.
You may want to check the DBCC function as well.
DBCC functions should be okay, see this comment for more info.
17.0 - SVN r47231/17.0.0-rc-43
Checkpoint: fixed problems caused by 'Update Statistics' and 'Checkpoint'.
The root cause of problems caused by 'Update statistics' and 'Checkpoint' is the same as issue #13886. The fix is the same, i.e. (1) a Messages tab is added to both 'Update Statistics' and 'Checkpoint' dialogs, (2) warning messages will be displayed in Messages tab, OK button is disabled and Cancel button is renamed to Close after action is successfully performed, (3) user needs to close dialog manually.
Problems described above have something to do with how to handle warning messages generated by CommonSchemaUtil.executeDDL().
Problem caused by 'Detach Database' described here has something to do with how to handle error messages generated by CommonSchemaUtil.executeDDL(). This is a different scenario and will be fixed separately.
17.0 - SVN r47231/17.0.0-rc-43
Checkpoint: fixed problems caused by 'Update Statistics' and 'Checkpoint'.
The root cause of problems caused by 'Update statistics' and 'Checkpoint' is the same as issue #13886. The fix is the same, i.e. (1) a Messages tab is added to both 'Update Statistics' and 'Checkpoint' dialogs, (2) warning messages will be displayed in Messages tab, OK button is disabled and Cancel button is renamed to Close after action is successfully performed, (3) user needs to close dialog manually.
Problems described above have something to do with how to handle warning messages generated by CommonSchemaUtil.executeDDL().
Problem caused by 'Detach Database' described here has something to do with how to handle error messages generated by CommonSchemaUtil.executeDDL(). This is a different scenario and will be fixed separately.
17.0 - SVN r47236/17.0.0-rc-43
Handled error message generated by CommonSchemaUtil.executeDDL() in CommonSchemaDialog.onOk(). This should fix the problem described by 'Detach Database' scenario.
17.0 - SVN r47236/17.0.0-rc-43
Handled error message generated by CommonSchemaUtil.executeDDL() in CommonSchemaDialog.onOk(). This should fix the problem described by 'Detach Database' scenario.
18.0 - SVN r47243/18.0.0-dev-19
Merged changes made in 17.0 branch to trunk.
18.0 - SVN r47243/18.0.0-dev-19
Merged changes made in 17.0 branch to trunk.
There are many classes are derived from CommonSchemaDialog, see this screenshot.
When OK button displayed in CommonSchemaDialog is clicked, CommonSchemaUtil.executeDDL() is called. Execution of CommonSchemaUtil.executeDDL() might produce warning or error messages.
In the current implementation;
(1) Error message is handled by CommonSchemaDialog (base class) and hence is shared by all derived classes.
(2) Whether to treat warning messages as an error is determined by the classes derived by CommonSchemaDialog, we need to test it case by case.
There are many classes are derived from CommonSchemaDialog, see this screenshot.
When OK button displayed in CommonSchemaDialog is clicked, CommonSchemaUtil.executeDDL() is called. Execution of CommonSchemaUtil.executeDDL() might produce warning or error messages.
In the current implementation;
(1) Error message is handled by CommonSchemaDialog (base class) and hence is shared by all derived classes.
(2) Whether to treat warning messages as an error is determined by the classes derived by CommonSchemaDialog, we need to test it case by case.
I checked all toolbar menu of storage manager,now all are working fine now.
I checked all toolbar menu of storage manager,now all are working fine now.
Verified in ADS 17 rc-43
Verified in ADS 17 rc-43
Issue #12747 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build ADS 17.0.0-rc-43/18.0.0-dev-19 |
| No time estimate |
1 issue link |
relates to #13886
Issue #13886Storage Mngr : Shrink Database feature gives Warning:"CommonSchemaUtil.executeDDL() was not successful" |
Same thing is happening for option :"Checkpoint"
In Query analyzer SQL executed successfully,
But through GUI ,it fails.(see checkpoint.png/QA-checkpoint.png)