View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003634 | SymmetricDS Pro | Bug | public | 2018-07-17 19:45 | 2021-03-30 19:14 |
| Reporter | mmichalek | Assigned To | |||
| Priority | normal | ||||
| Status | new | Resolution | open | ||
| Target Version | 3.12.9 | ||||
| Summary | 0003634: SQL Server Error when lacking some privileges and clicking on a database in SQL Explorer. | ||||
| Description | Got this exception when clicking on the DB in SQL Explorer. Was able to still run SQL against the database through SQL Explorer after clearing the error. 2018-07-17 15:38:13,010 ERROR [corp-000] [DbTree] [qtp1777443462-20] com.microsoft.sqlserver.jdbc.SQLServerException: The server principal "symmetric" is not able to access the database "model" under the current security context. (org.jumpmind.vaadin.ui.sqlexplorer.DbTree.expanded(DbTree.java:229)) org.jumpmind.db.sql.SqlException: com.microsoft.sqlserver.jdbc.SQLServerException: The server principal "symmetric" is not able to access the database "model" under the current security context. at org.jumpmind.db.sql.ChangeCatalogConnectionHandler.before(ChangeCatalogConnectionHandler.java:29) at org.jumpmind.db.platform.AbstractJdbcDdlReader$6.execute(AbstractJdbcDdlReader.java:1412) at org.jumpmind.db.platform.AbstractJdbcDdlReader$6.execute(AbstractJdbcDdlReader.java:1) at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:501) at org.jumpmind.db.platform.AbstractJdbcDdlReader.getSchemaNames(AbstractJdbcDdlReader.java:1407) at org.jumpmind.vaadin.ui.sqlexplorer.DbTree.addCatalogNodes(DbTree.java:335) at org.jumpmind.vaadin.ui.sqlexplorer.DbTree.expanded(DbTree.java:185) at org.jumpmind.vaadin.ui.sqlexplorer.DbTree$Listener.nodeExpand(DbTree.java:381) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:510) at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:211) at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:174) at com.vaadin.server.AbstractClientConnector.fireEvent(AbstractClientConnector.java:1033) at com.vaadin.v7.ui.Tree.fireExpandEvent(Tree.java:1123) at com.vaadin.v7.ui.Tree.expandItem(Tree.java:348) at com.vaadin.v7.ui.Tree.changeVariables(Tree.java:554) at com.vaadin.server.communication.ServerRpcHandler.changeVariables(ServerRpcHandler.java:626) at com.vaadin.server.communication.ServerRpcHandler.handleInvocation(ServerRpcHandler.java:471) at com.vaadin.server.communication.ServerRpcHandler.handleInvocations(ServerRpcHandler.java:414) at com.vaadin.server.communication.ServerRpcHandler.handleRpc(ServerRpcHandler.java:274) at com.vaadin.server.communication.PushHandler.lambda$new$1(PushHandler.java:145) at com.vaadin.server.communication.PushHandler.callWithUi(PushHandler.java:235) at com.vaadin.server.communication.PushHandler.onMessage(PushHandler.java:520) at com.vaadin.server.communication.PushAtmosphereHandler.onMessage(PushAtmosphereHandler.java:87) at com.vaadin.server.communication.PushAtmosphereHandler.onRequest(PushAtmosphereHandler.java:77) at org.atmosphere.cpr.AsynchronousProcessor.action(AsynchronousProcessor.java:223) at org.atmosphere.cpr.AsynchronousProcessor.suspended(AsynchronousProcessor.java:115) at org.atmosphere.container.Servlet30CometSupport.service(Servlet30CometSupport.java:67) at org.atmosphere.cpr.AtmosphereFramework.doCometSupport(AtmosphereFramework.java:2284) at org.atmosphere.websocket.DefaultWebSocketProcessor.dispatch(DefaultWebSocketProcessor.java:593) at org.atmosphere.websocket.DefaultWebSocketProcessor$3.run(DefaultWebSocketProcessor.java:345) at org.atmosphere.util.VoidExecutorService.execute(VoidExecutorService.java:101) at org.atmosphere.websocket.DefaultWebSocketProcessor.dispatch(DefaultWebSocketProcessor.java:340) at org.atmosphere.websocket.DefaultWebSocketProcessor.invokeWebSocketProtocol(DefaultWebSocketProcessor.java:447) at org.atmosphere.container.JSR356Endpoint$3.onMessage(JSR356Endpoint.java:272) at org.atmosphere.container.JSR356Endpoint$3.onMessage(JSR356Endpoint.java:269) at org.eclipse.jetty.websocket.jsr356.messages.TextWholeMessage.messageComplete(TextWholeMessage.java:56) at org.eclipse.jetty.websocket.jsr356.endpoints.JsrEndpointEventDriver.onTextFrame(JsrEndpointEventDriver.java:218) at org.eclipse.jetty.websocket.common.events.AbstractEventDriver.incomingFrame(AbstractEventDriver.java:162) at org.eclipse.jetty.websocket.common.WebSocketSession.incomingFrame(WebSocketSession.java:375) at org.eclipse.jetty.websocket.common.extensions.AbstractExtension.nextIncomingFrame(AbstractExtension.java:182) at org.eclipse.jetty.websocket.common.extensions.compress.PerMessageDeflateExtension.nextIncomingFrame(PerMessageDeflateExtension.java:105) at org.eclipse.jetty.websocket.common.extensions.compress.CompressExtension.forwardIncoming(CompressExtension.java:142) at org.eclipse.jetty.websocket.common.extensions.compress.PerMessageDeflateExtension.incomingFrame(PerMessageDeflateExtension.java:85) at org.eclipse.jetty.websocket.common.extensions.ExtensionStack.incomingFrame(ExtensionStack.java:220) at org.eclipse.jetty.websocket.common.Parser.notifyFrame(Parser.java:220) at org.eclipse.jetty.websocket.common.Parser.parse(Parser.java:256) at org.eclipse.jetty.websocket.common.io.AbstractWebSocketConnection.readParse(AbstractWebSocketConnection.java:679) at org.eclipse.jetty.websocket.common.io.AbstractWebSocketConnection.onFillable(AbstractWebSocketConnection.java:511) at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:279) at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:104) at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:124) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:247) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.produce(EatWhatYouKill.java:140) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131) at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:243) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:679) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:597) at java.lang.Thread.run(Thread.java:745) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The server principal "symmetric" is not able to access the database "model" under the current security context. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254) at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84) at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:39) at com.microsoft.sqlserver.jdbc.SQLServerConnection$1ConnectionCommand.doExecute(SQLServerConnection.java:1756) 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.SQLServerConnection.connectionCommand(SQLServerConnection.java:1761) at com.microsoft.sqlserver.jdbc.SQLServerConnection.setCatalog(SQLServerConnection.java:2063) at org.apache.commons.dbcp.DelegatingConnection.setCatalog(DelegatingConnection.java:374) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setCatalog(PoolingDataSource.java:333) at org.jumpmind.db.sql.ChangeCatalogConnectionHandler.before(ChangeCatalogConnectionHandler.java:21) ... 61 more | ||||
| Additional Information | SQL Server Express 2012 Use create script: USE [master] GO /* For security reasons the login is created disabled and with a random password. */ /****** Object: Login [symmetric] Script Date: 7/17/2018 3:40:53 PM ******/ CREATE LOGIN [symmetric] WITH PASSWORD='', DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO ALTER LOGIN [symmetric] DISABLE GO USE [db-prod] GO /****** Object: User [symmetric] Script Date: 7/17/2018 3:41:51 PM ******/ CREATE USER [symmetric] FOR LOGIN [symmetric] WITH DEFAULT_SCHEMA=[dbo] GO | ||||
| Tags | sql explorer | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2018-07-17 19:45 | mmichalek | New Issue | |
| 2018-07-17 19:47 | mmichalek | File Added: screen-error.png | |
| 2019-05-09 17:53 | elong | Tag Attached: sql explorer | |
| 2019-05-09 17:54 | elong | Target Version | => 3.10.3 |
| 2019-06-24 17:47 | elong | Target Version | 3.10.3 => 3.10.4 |
| 2019-08-09 18:28 | elong | Target Version | 3.10.4 => 3.10.5 |
| 2019-11-01 12:23 | admin | Target Version | 3.10.5 => 3.10.6 |
| 2019-11-14 19:34 | elong | Target Version | 3.10.6 => 3.10.7 |
| 2019-12-09 15:27 | admin | Target Version | 3.10.7 => 3.10.8 |
| 2020-01-02 14:46 | admin | Target Version | 3.10.8 => 3.10.9 |
| 2020-01-22 19:09 | elong | Target Version | 3.10.9 => 3.10.10 |
| 2020-02-14 13:26 | elong | Target Version | 3.10.10 => 3.10.11 |
| 2020-03-16 20:15 | admin | Target Version | 3.10.11 => 3.10.12 |
| 2020-05-26 12:26 | elong | Target Version | 3.10.12 => 3.11.10 |
| 2020-06-24 20:34 | elong | Target Version | 3.11.10 => 3.12.2 |
| 2020-07-20 13:09 | elong | Target Version | 3.12.2 => 3.12.3 |
| 2020-08-31 19:44 | elong | Target Version | 3.12.3 => 3.12.4 |
| 2020-09-23 15:33 | admin | Target Version | 3.12.4 => 3.12.5 |
| 2020-11-09 13:49 | admin | Target Version | 3.12.5 => 3.12.6 |
| 2021-01-08 20:46 | admin | Target Version | 3.12.6 => 3.12.7 |
| 2021-02-25 13:10 | admin | Target Version | 3.12.7 => 3.12.8 |
| 2021-03-30 19:14 | admin | Target Version | 3.12.8 => 3.12.9 |