|
From: Neville R. <row...@ho...> - 2015-08-29 10:55:36
|
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: sd...@af...
To: squ...@li...
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
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
