MSSQL Monitor Tab

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

MSSQL Monitor Tab

Shannon Duncan

So I was trying to use the MSSQL Monitor tab, and every time I click it while running a query the system freezes. After the query finishes, this shows up in my logs. Ideas?

 

2015-08-25 15:38:28,388 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.plugins.mssql.gui.MonitorPanel  - Unexpected exception: The user does not have permission to perform this action.

com.microsoft.sqlserver.jdbc.SQLServerException: The user does not have permission to perform this action.

                at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)

                at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)

                at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)

                at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)

                at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)

                at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)

                at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)

                at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)

                at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:285)

                at net.sourceforge.squirrel_sql.plugins.mssql.gui.MonitorPanel.refreshData(MonitorPanel.java:155)

                at net.sourceforge.squirrel_sql.plugins.mssql.gui.MonitorPanel.refreshComponent(MonitorPanel.java:143)

                at net.sourceforge.squirrel_sql.client.session.mainpanel.BaseMainPanelTab.select(BaseMainPanelTab.java:90)

                at net.sourceforge.squirrel_sql.client.gui.session.MainPanel.updateState(MainPanel.java:309)

                at net.sourceforge.squirrel_sql.client.gui.session.MainPanel.performStateChanged(MainPanel.java:384)

                at net.sourceforge.squirrel_sql.client.gui.session.MainPanel.access$100(MainPanel.java:52)

                at net.sourceforge.squirrel_sql.client.gui.session.MainPanel$2.stateChanged(MainPanel.java:140)

                at javax.swing.JTabbedPane.fireStateChanged(Unknown Source)

                at javax.swing.JTabbedPane$ModelListener.stateChanged(Unknown Source)

                at javax.swing.DefaultSingleSelectionModel.fireStateChanged(Unknown Source)

                at javax.swing.DefaultSingleSelectionModel.setSelectedIndex(Unknown Source)

                at javax.swing.JTabbedPane.setSelectedIndexImpl(Unknown Source)

                at javax.swing.JTabbedPane.setSelectedIndex(Unknown Source)

                at javax.swing.plaf.basic.BasicTabbedPaneUI$Handler.mousePressed(Unknown Source)

                at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)

                at java.awt.Component.processMouseEvent(Unknown Source)

                at javax.swing.JComponent.processMouseEvent(Unknown Source)

                at java.awt.Component.processEvent(Unknown Source)

                at java.awt.Container.processEvent(Unknown Source)

                at java.awt.Component.dispatchEventImpl(Unknown Source)

                at java.awt.Container.dispatchEventImpl(Unknown Source)

                at java.awt.Component.dispatchEvent(Unknown Source)

                at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)

                at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)

                at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)

                at java.awt.Container.dispatchEventImpl(Unknown Source)

                at java.awt.Component.dispatchEvent(Unknown Source)

                at java.awt.EventQueue.dispatchEventImpl(Unknown Source)

                at java.awt.EventQueue.access$500(Unknown Source)

                at java.awt.EventQueue$3.run(Unknown Source)

                at java.awt.EventQueue$3.run(Unknown Source)

                at java.security.AccessController.doPrivileged(Native Method)

                at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)

                at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)

                at java.awt.EventQueue$4.run(Unknown Source)

                at java.awt.EventQueue$4.run(Unknown Source)

                at java.security.AccessController.doPrivileged(Native Method)

                at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)

                at java.awt.EventQueue.dispatchEvent(Unknown Source)

                at net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:99)

                at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)

                at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)

                at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)

                at java.awt.EventDispatchThread.pumpEvents(Unknown Source)

                at java.awt.EventDispatchThread.pumpEvents(Unknown Source)

                at java.awt.EventDispatchThread.run(Unknown Source)

 

Thanks,

 

Shannon Duncan

 

 

CONFIDENTIAL INFORMATION MAY BE ENCLOSED: This message (and any associated files) is intended only for the use of the individual or entity to which it is addressed and may contain information that is confidential, subject to copyright or constitutes a trade secret. If you are not the intended recipient you are hereby notified that any dissemination, copying or distribution of this message, or files associated with this message, is strictly prohibited. If you have received this message in error, please notify us immediately by replying to the message and deleting it from your computer. Messages sent to and from us may be monitored. Internet communications cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Therefore, we do not accept responsibility for any errors or omissions that are present in this message, or any attachment, that have arisen as a result of e-mail transmission. If verification is required, please request a hard-copy version. Any views or opinions presented are solely those of the author and do not necessarily represent those of the company.
------------------------------------------------------------------------------

_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: MSSQL Monitor Tab

Neville Rowe
Hi Shannon,

I don't have a copy of MS SQL Server handy to test. However that line is executing

SELECT * FROM master.dbo.sysperfinfo

so I guess either you don't have access to that view or that view doesn't exist in your system.

As a quick check could you try running that from the SQL window and make sure you get an appropriate error. Also if you could post the SQL server version.

I'm not sure what we can do about this but may be able to try some ideas if you have the time.


From: [hidden email]
To: [hidden email]
Date: Tue, 25 Aug 2015 20:43:51 +0000
Subject: [Squirrel-sql-users] MSSQL Monitor Tab

So I was trying to use the MSSQL Monitor tab, and every time I click it while running a query the system freezes. After the query finishes, this shows up in my logs. Ideas?

 

2015-08-25 15:38:28,388 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.plugins.mssql.gui.MonitorPanel  - Unexpected exception: The user does not have permission to perform this action.

com.microsoft.sqlserver.jdbc.SQLServerException: The user does not have permission to perform this action.

                at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)

                at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)

                at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)

                at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)

                at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)

                at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)

                at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)

                at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)

                at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:285)

                at net.sourceforge.squirrel_sql.plugins.mssql.gui.MonitorPanel.refreshData(MonitorPanel.java:155)

                at net.sourceforge.squirrel_sql.plugins.mssql.gui.MonitorPanel.refreshComponent(MonitorPanel.java:143)

                at net.sourceforge.squirrel_sql.client.session.mainpanel.BaseMainPanelTab.select(BaseMainPanelTab.java:90)

                at net.sourceforge.squirrel_sql.client.gui.session.MainPanel.updateState(MainPanel.java:309)

                at net.sourceforge.squirrel_sql.client.gui.session.MainPanel.performStateChanged(MainPanel.java:384)

                at net.sourceforge.squirrel_sql.client.gui.session.MainPanel.access$100(MainPanel.java:52)

                at net.sourceforge.squirrel_sql.client.gui.session.MainPanel$2.stateChanged(MainPanel.java:140)

                at javax.swing.JTabbedPane.fireStateChanged(Unknown Source)

                at javax.swing.JTabbedPane$ModelListener.stateChanged(Unknown Source)

                at javax.swing.DefaultSingleSelectionModel.fireStateChanged(Unknown Source)

                at javax.swing.DefaultSingleSelectionModel.setSelectedIndex(Unknown Source)

                at javax.swing.JTabbedPane.setSelectedIndexImpl(Unknown Source)

                at javax.swing.JTabbedPane.setSelectedIndex(Unknown Source)

                at javax.swing.plaf.basic.BasicTabbedPaneUI$Handler.mousePressed(Unknown Source)

                at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)

                at java.awt.Component.processMouseEvent(Unknown Source)

                at javax.swing.JComponent.processMouseEvent(Unknown Source)

                at java.awt.Component.processEvent(Unknown Source)

                at java.awt.Container.processEvent(Unknown Source)

                at java.awt.Component.dispatchEventImpl(Unknown Source)

                at java.awt.Container.dispatchEventImpl(Unknown Source)

                at java.awt.Component.dispatchEvent(Unknown Source)

                at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)

                at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)

                at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)

                at java.awt.Container.dispatchEventImpl(Unknown Source)

                at java.awt.Component.dispatchEvent(Unknown Source)

                at java.awt.EventQueue.dispatchEventImpl(Unknown Source)

                at java.awt.EventQueue.access$500(Unknown Source)

                at java.awt.EventQueue$3.run(Unknown Source)

                at java.awt.EventQueue$3.run(Unknown Source)

                at java.security.AccessController.doPrivileged(Native Method)

                at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)

                at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)

                at java.awt.EventQueue$4.run(Unknown Source)

                at java.awt.EventQueue$4.run(Unknown Source)

                at java.security.AccessController.doPrivileged(Native Method)

                at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)

                at java.awt.EventQueue.dispatchEvent(Unknown Source)

                at net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:99)

                at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)

                at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)

                at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)

                at java.awt.EventDispatchThread.pumpEvents(Unknown Source)

                at java.awt.EventDispatchThread.pumpEvents(Unknown Source)

                at java.awt.EventDispatchThread.run(Unknown Source)

 

Thanks,

 

Shannon Duncan

 

 

CONFIDENTIAL INFORMATION MAY BE ENCLOSED: This message (and any associated files) is intended only for the use of the individual or entity to which it is addressed and may contain information that is confidential, subject to copyright or constitutes a trade secret. If you are not the intended recipient you are hereby notified that any dissemination, copying or distribution of this message, or files associated with this message, is strictly prohibited. If you have received this message in error, please notify us immediately by replying to the message and deleting it from your computer. Messages sent to and from us may be monitored. Internet communications cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Therefore, we do not accept responsibility for any errors or omissions that are present in this message, or any attachment, that have arisen as a result of e-mail transmission. If verification is required, please request a hard-copy version. Any views or opinions presented are solely those of the author and do not necessarily represent those of the company.
------------------------------------------------------------------------------
_______________________________________________ Squirrel-sql-users mailing list [hidden email] https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

------------------------------------------------------------------------------

_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Loading...