none
BDC 2019 RC1 gateway does not work RRS feed

  • Question

  • Everything related to gateway does not work 

    knox log is

    2019-09-13 09:40:27,743 ERROR knox.gateway (AbstractGatewayFilter.java:doFilter(66)) - Failed to execute filter: javax.servlet.ServletException: org.apache.shiro.authz.AuthorizationException: There was a SQL error while authorizing user [admin]

    2019-09-13 09:40:27,743 ERROR knox.gateway (AbstractGatewayFilter.java:doFilter(66)) - Failed to execute filter: javax.servlet.ServletException: org.apache.shiro.authz.AuthorizationException: There was a SQL error while authorizing user [admin]
    2019-09-13 09:40:27,743 ERROR knox.gateway (GatewayFilter.java:doFilter(173)) - Gateway processing failed: javax.servlet.ServletException: org.apache.shiro.authz.AuthorizationException: There was a SQL error while authorizing user [admin]
    javax.servlet.ServletException: org.apache.shiro.authz.AuthorizationException: There was a SQL error while authorizing user [admin]
            at org.apache.shiro.web.servlet.AdviceFilter.cleanup(AdviceFilter.java:196)
            at org.apache.shiro.web.filter.authc.AuthenticatingFilter.cleanup(AuthenticatingFilter.java:155)
            at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:148)
            at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
            at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
            at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)
            at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)
            at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
            at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
            at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383)
            at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)
            at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
            at org.apache.knox.gateway.GatewayFilter$Holder.doFilter(GatewayFilter.java:372)
            at org.apache.knox.gateway.GatewayFilter$Chain.doFilter(GatewayFilter.java:272)
            at org.apache.knox.gateway.filter.ResponseCookieFilter.doFilter(ResponseCookieFilter.java:50)
            at org.apache.knox.gateway.filter.AbstractGatewayFilter.doFilter(AbstractGatewayFilter.java:61)
            at org.apache.knox.gateway.GatewayFilter$Holder.doFilter(GatewayFilter.java:372)
            at org.apache.knox.gateway.GatewayFilter$Chain.doFilter(GatewayFilter.java:272)
            at org.apache.knox.gateway.filter.XForwardedHeaderFilter.doFilter(XForwardedHeaderFilter.java:30)
            at org.apache.knox.gateway.filter.AbstractGatewayFilter.doFilter(AbstractGatewayFilter.java:61)
            at org.apache.knox.gateway.GatewayFilter$Holder.doFilter(GatewayFilter.java:372)
            at org.apache.knox.gateway.GatewayFilter$Chain.doFilter(GatewayFilter.java:272)
            at org.apache.knox.gateway.GatewayFilter.doFilter(GatewayFilter.java:171)
            at org.apache.knox.gateway.GatewayFilter.doFilter(GatewayFilter.java:94)
            at org.apache.knox.gateway.GatewayServlet.service(GatewayServlet.java:141)
            at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:812)
            at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669)
            at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:201)
            at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
            at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585)
            at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
            at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
            at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
            at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127)
            at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
            at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
            at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061)
            at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
            at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:215)
            at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
            at org.apache.knox.gateway.trace.TraceHandler.handle(TraceHandler.java:51)
            at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
            at org.apache.knox.gateway.filter.CorrelationHandler.handle(CorrelationHandler.java:41)
            at org.eclipse.jetty.servlets.gzip.GzipHandler.handle(GzipHandler.java:479)
            at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
            at org.apache.knox.gateway.filter.PortMappingHelperHandler.handle(PortMappingHelperHandler.java:152)
            at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:110)
            at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
            at org.eclipse.jetty.server.Server.handle(Server.java:499)
            at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:311)
            at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:258)
            at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:544)
            at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
            at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)
            at java.lang.Thread.run(Thread.java:748)
    Caused by: org.apache.shiro.authz.AuthorizationException: There was a SQL error while authorizing user [admin]
            at org.apache.shiro.realm.jdbc.JdbcRealm.doGetAuthorizationInfo(JdbcRealm.java:345)
            at org.apache.shiro.realm.AuthorizingRealm.getAuthorizationInfo(AuthorizingRealm.java:341)
            at org.apache.shiro.realm.AuthorizingRealm.hasRole(AuthorizingRealm.java:573)
            at org.apache.shiro.authz.ModularRealmAuthorizer.hasRole(ModularRealmAuthorizer.java:374)
            at org.apache.shiro.mgt.AuthorizingSecurityManager.hasRole(AuthorizingSecurityManager.java:153)
            at org.apache.shiro.subject.support.DelegatingSubject.hasRole(DelegatingSubject.java:224)
            at org.apache.knox.gateway.filter.ShiroSubjectIdentityAdapter.doFilter(ShiroSubjectIdentityAdapter.java:69)
            at org.apache.knox.gateway.GatewayFilter$Holder.doFilter(GatewayFilter.java:372)
            at org.apache.knox.gateway.GatewayFilter$Chain.doFilter(GatewayFilter.java:272)
            at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)
            at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
            at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
            ... 52 more
    Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'roles_permissions'.
            at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:254)
            at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1608)
            at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:578)
            at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:508)
            at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7240)
            at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2869)
            at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:243)
            at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:218)
            at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:434)
            at org.apache.shiro.realm.jdbc.JdbcRealm.getPermissions(JdbcRealm.java:401)
            at org.apache.shiro.realm.jdbc.JdbcRealm.doGetAuthorizationInfo(JdbcRealm.java:335)
            ... 63 more
    2019-09-13 09:40:27,744 ERROR knox.gateway (GatewayServlet.java:service(146)) - Gateway processing failed: javax.servlet.ServletException: org.apache.shiro.authz.AuthorizationException: There was a SQL error while authorizing user [admin]
    javax.servlet.ServletException: org.apache.shiro.authz.AuthorizationException: There was a SQL error while authorizing user [admin]
            at org.apache.shiro.web.servlet.AdviceFilter.cleanup(AdviceFilter.java:196)
            at org.apache.shiro.web.filter.authc.AuthenticatingFilter.cleanup(AuthenticatingFilter.java:155)
            at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:148)
            at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
            at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
            at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)
            at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)
            at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
            at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
            at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383)
            at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)
            at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
            at org.apache.knox.gateway.GatewayFilter$Holder.doFilter(GatewayFilter.java:372)
            at org.apache.knox.gateway.GatewayFilter$Chain.doFilter(GatewayFilter.java:272)
            at org.apache.knox.gateway.filter.ResponseCookieFilter.doFilter(ResponseCookieFilter.java:50)
            at org.apache.knox.gateway.filter.AbstractGatewayFilter.doFilter(AbstractGatewayFilter.java:61)
            at org.apache.knox.gateway.GatewayFilter$Holder.doFilter(GatewayFilter.java:372)
            at org.apache.knox.gateway.GatewayFilter$Chain.doFilter(GatewayFilter.java:272)
            at org.apache.knox.gateway.filter.XForwardedHeaderFilter.doFilter(XForwardedHeaderFilter.java:30)
            at org.apache.knox.gateway.filter.AbstractGatewayFilter.doFilter(AbstractGatewayFilter.java:61)
            at org.apache.knox.gateway.GatewayFilter$Holder.doFilter(GatewayFilter.java:372)
            at org.apache.knox.gateway.GatewayFilter$Chain.doFilter(GatewayFilter.java:272)
            at org.apache.knox.gateway.GatewayFilter.doFilter(GatewayFilter.java:171)
            at org.apache.knox.gateway.GatewayFilter.doFilter(GatewayFilter.java:94)
            at org.apache.knox.gateway.GatewayServlet.service(GatewayServlet.java:141)
            at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:812)
            at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669)
            at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:201)
            at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
            at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585)
            at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
            at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
            at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
            at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127)
            at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
            at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
            at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061)
            at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
            at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:215)
            at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
            at org.apache.knox.gateway.trace.TraceHandler.handle(TraceHandler.java:51)
            at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
            at org.apache.knox.gateway.filter.CorrelationHandler.handle(CorrelationHandler.java:41)
            at org.eclipse.jetty.servlets.gzip.GzipHandler.handle(GzipHandler.java:479)
            at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
            at org.apache.knox.gateway.filter.PortMappingHelperHandler.handle(PortMappingHelperHandler.java:152)
            at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:110)
            at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
            at org.eclipse.jetty.server.Server.handle(Server.java:499)
            at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:311)
            at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:258)
            at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:544)
            at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
            at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)
            at java.lang.Thread.run(Thread.java:748)
    Caused by: org.apache.shiro.authz.AuthorizationException: There was a SQL error while authorizing user [admin]
            at org.apache.shiro.realm.jdbc.JdbcRealm.doGetAuthorizationInfo(JdbcRealm.java:345)
            at org.apache.shiro.realm.AuthorizingRealm.getAuthorizationInfo(AuthorizingRealm.java:341)
            at org.apache.shiro.realm.AuthorizingRealm.hasRole(AuthorizingRealm.java:573)
            at org.apache.shiro.authz.ModularRealmAuthorizer.hasRole(ModularRealmAuthorizer.java:374)
            at org.apache.shiro.mgt.AuthorizingSecurityManager.hasRole(AuthorizingSecurityManager.java:153)
            at org.apache.shiro.subject.support.DelegatingSubject.hasRole(DelegatingSubject.java:224)
            at org.apache.knox.gateway.filter.ShiroSubjectIdentityAdapter.doFilter(ShiroSubjectIdentityAdapter.java:69)
            at org.apache.knox.gateway.GatewayFilter$Holder.doFilter(GatewayFilter.java:372)
            at org.apache.knox.gateway.GatewayFilter$Chain.doFilter(GatewayFilter.java:272)
            at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)
            at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
            at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
            ... 52 more
    Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'roles_permissions'.
            at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:254)
            at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1608)
            at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:578)
            at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:508)
            at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7240)
            at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2869)
            at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:243)
            at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:218)
            at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:434)
            at org.apache.shiro.realm.jdbc.JdbcRealm.getPermissions(JdbcRealm.java:401)
            at org.apache.shiro.realm.jdbc.JdbcRealm.doGetAuthorizationInfo(JdbcRealm.java:335)
            ... 63 more



    Wednesday, September 18, 2019 5:16 AM

All replies

  • I can see the SQL error in the log, but I have no idea what BDC 2019 Gateway is. Nor do I know in what context you get that stack dump. Can you clarify?


    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

    Wednesday, September 18, 2019 9:42 PM
    Moderator
  • Hi lurii Vaschuk,

     

    It seems to be new function in sql server 2019 RC.  We may not be familiar with it at present. I  recommend you to submit it to the Microsoft feedback at this link https://feedback.azure.com/forums/908035-sql-server .

     

    Best regards,

    Dedmon Dai


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Thursday, September 19, 2019 5:48 AM