Guest User!

You are not Sophos Staff.

This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

v18 MR4 - Webadmin tomcat crashes. 500 Internal Server Error

Since Upgrade to MR4 I can reproduce this error when doing any GUI Packet capture and clicking 28 (or some times a few more) times in a row on the refresh button.

only thing that helps then is logging in with SSH and executing:

service tomcat:restart -ds nosync

Any browser.

Userportal on other port still works when WebAdmin is generating the error 500.

Never noticed the issue in MR1 and used the packet capture option regularly there.

See logs:

tomcat.log

2021-01-11 12:58:05,954:INFO:CSC - EventBean: { opCode: manage_page_detail, mode: 301, waitForeResponse: true, reques                                                                                                                        tType: 1, opcodetype: 0, entityId: 39, beanName: null, syncalbe: true, comProtocol: u }
2021-01-11 12:58:06,483:ERROR: - EXCEPTION IN RESULTSET WRAPPER WHILE EXECUTING QUERY: java.lang.NullPointerException                                                                                                                        java.lang.NullPointerException
        at com.elitecore.jdbchelper.ResultSetWrapper.<init>(ResultSetWrapper.java:40)
        at com.elitecore.jdbchelper.SqlReader.getResultSetWrapper(SqlReader.java:199)
        at com.sophos.sf.auth.AuthHelper.isRefererCheckRequired(AuthHelper.java:105)
        at com.sophos.sf.auth.AuthHelper.hasValidReferer(AuthHelper.java:128)
        at com.sophos.sf.auth.HttpSessionHelper.isExpired(HttpSessionHelper.java:59)
        at com.sophos.sf.auth.HttpSessionHelper.isExpired(HttpSessionHelper.java:29)
        at cyberoam.sessionmanagement.SessionCheckFilter.doFilter(SessionCheckFilter.java:69)
        at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1602)
        at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:540)
        at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:146)
        at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)
        at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
        at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:257)
        at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1701)
        at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)
        at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1345)
        at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)
        at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:480)
        at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1668)
        at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)
        at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1247)
        at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)
        at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:220)
        at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:126)
        at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
        at org.eclipse.jetty.server.Server.handle(Server.java:502)
        at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:370)
        at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:267)
        at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:305)
        at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103)
        at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:117)
        at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)
        at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)
        at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)
        at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126)
        at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366)
        at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:765)
        at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:683)
        at java.lang.Thread.run(Thread.java:748)

2021-01-11 12:58:06,483:INFO:CSC - EventBean: { opCode: manage_page_detail, mode: 301, waitForeResponse: true, reques                                                                                                                        tType: 1, opcodetype: 0, entityId: 39, beanName: null, syncalbe: true, comProtocol: u }
2021-01-11 12:58:06,483:ERROR: - EXCEPTION IN RESULTSET WRAPPER WHILE EXECUTING QUERY: java.lang.NullPointerException                                                                                                                        java.lang.NullPointerException
        at com.elitecore.jdbchelper.ResultSetWrapper.<init>(ResultSetWrapper.java:40)
        at com.elitecore.jdbchelper.SqlReader.getResultSetWrapper(SqlReader.java:199)
        at com.sophos.sf.auth.AuthHelper.isRefererCheckRequired(AuthHelper.java:105)
        at com.sophos.sf.auth.AuthHelper.hasValidReferer(AuthHelper.java:128)
        at com.sophos.sf.auth.HttpSessionHelper.isExpired(HttpSessionHelper.java:59)
        at com.sophos.sf.auth.HttpSessionHelper.isExpired(HttpSessionHelper.java:29)
        at cyberoam.corporate.servlets.CyberoamCommonServlet._doPost(CyberoamCommonServlet.java:486)
        at cyberoam.corporate.servlets.CyberoamCommonServlet.doPost(CyberoamCommonServlet.java:363)
        at cyberoam.corporate.servlets.CyberoamCommonServlet.doGet(CyberoamCommonServlet.java:205)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
        at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:873)
        at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1623)
        at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:214)
        at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1610)
        at cyberoam.utilities.csrf.CSRFCheckFilter.doFilter(CSRFCheckFilter.java:150)
        at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1610)
        at cyberoam.sessionmanagement.SessionCheckFilter.doFilter(SessionCheckFilter.java:74)
        at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1602)
        at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:540)
        at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:146)
        at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)
        at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
        at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:257)
        at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1701)
        at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)
        at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1345)
        at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)
        at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:480)
        at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1668)
        at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)
        at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1247)
        at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)
        at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:220)
        at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:126)
        at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
        at org.eclipse.jetty.server.Server.handle(Server.java:502)
        at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:370)
        at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:267)
        at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:305)
        at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103)
        at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:117)
        at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)
        at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)
        at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)
        at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126)
        at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366)
        at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:765)
        at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:683)
        at java.lang.Thread.run(Thread.java:748)

2021-01-11 12:58:06,484:ERROR:ACL - Exception in checkUserOperation java.lang.NullPointerException
        at com.elitecore.jdbchelper.SqlReader.getInstanceResultSetWrapperForPreparedStatement(SqlReader.java:806)
        at com.elitecore.jdbchelper.SqlReader.getInstanceResultSetWrapperForPreparedStatement(SqlReader.java:686)
        at cyberoam.system.helpers.ACLImplHelper.isPageReadable(ACLImplHelper.java:125)
        at cyberoam.corporate.servlets.CyberoamCommonServlet._doPost(CyberoamCommonServlet.java:526)
        at cyberoam.corporate.servlets.CyberoamCommonServlet.doPost(CyberoamCommonServlet.java:363)
        at cyberoam.corporate.servlets.CyberoamCommonServlet.doGet(CyberoamCommonServlet.java:205)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
        at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:873)
        at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1623)
        at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:214)
        at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1610)
        at cyberoam.utilities.csrf.CSRFCheckFilter.doFilter(CSRFCheckFilter.java:150)
        at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1610)
        at cyberoam.sessionmanagement.SessionCheckFilter.doFilter(SessionCheckFilter.java:74)
        at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1602)
        at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:540)
        at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:146)
        at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)
        at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
        at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:257)
        at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1701)
        at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)
        at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1345)
        at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)
        at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:480)
        at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1668)
        at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)
        at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1247)
        at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)
        at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:220)
        at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:126)
        at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
        at org.eclipse.jetty.server.Server.handle(Server.java:502)
        at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:370)
        at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:267)
        at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:305)
        at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103)
        at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:117)
        at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)
        at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)
        at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)
        at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126)
        at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366)
        at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:765)
        at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:683)
        at java.lang.Thread.run(Thread.java:748)



This thread was automatically locked due to age.
Parents Reply Children
  • Odd - I could not reproduce this on 3 different appliances. Could we still look into this and check for Bug ID? 

  • same on XG106 - after 28 times refresh click it crashed

    XG106_XN01_SFOS 18.0.4 MR-4

    2021-01-11 15:49:11,51:INFO:CSC - UserId: -1, ___username: LOCAL, __currentlyloggedinuserip: , ___component: LOCAL
    2021-01-11 15:49:11,51:INFO:CSC - Event Bean:{ opCode: gethainfo, mode: 382, waitForeResponse: true, requestType: 0, opcodetype: 0, entityId: 0, beanName: null, syncalbe: false, comProtocol: u }
    2021-01-11 15:49:11,51:INFO:CSC - Keys in json: ["mode", "___serverport", "___component", "___serverprotocol", "___username", "currentlyloggedinuserip", "___serverip"]
    2021-01-11 15:49:11,52:INFO:CSC - final opcode:
    opcode gethainfo csc/1.2
    content-type:json
    content-length:191
    
    
    2021-01-11 15:49:11,534:INFO:CSC - UserId: -1, ___username: LOCAL, __currentlyloggedinuserip: , ___component: LOCAL
    2021-01-11 15:49:11,534:INFO:CSC - Event Bean:{ opCode: gethaconn, mode: 383, waitForeResponse: true, requestType: 0, opcodetype: 0, entityId: 0, beanName: null, syncalbe: false, comProtocol: u }
    2021-01-11 15:49:11,534:INFO:CSC - Keys in json: ["mode", "___serverport", "___component", "___serverprotocol", "___username", "currentlyloggedinuserip", "___serverip"]
    2021-01-11 15:49:11,534:INFO:CSC - final opcode:
    opcode gethaconn csc/1.2
    content-type:json
    content-length:191
    
    
    2021-01-11 15:49:12,91:INFO:CSC - EventBean: { opCode: get_firm_list, mode: 2705, waitForeResponse: true, requestType: 0, opcodetype: 2, entityId: 41, beanName: null, syncalbe: true, comProtocol: t }
    2021-01-11 15:49:12,92:INFO:CSC - EventBean: { opCode: heartbeat:HBstatus, mode: 1322, waitForeResponse: true, requestType: 1, opcodetype: 1, entityId: 41, beanName: cyberoam.utilities.helpers.ControlCenterHelper, syncalbe: false, comProtocol: t }
    2021-01-11 15:49:12,96:INFO:HFHelper - X-FROWARDED-FOR: 172.16.xxx.xxx
    2021-01-11 15:49:12,96:INFO:CSC - UserId: 20, ___username: myname@xxxxx.xx, __currentlyloggedinuserip: , ___component: GUI
    2021-01-11 15:49:12,96:INFO:CSC - Event Bean:{ opCode: get_firm_list, mode: 2705, waitForeResponse: true, requestType: 0, opcodetype: 2, entityId: 41, beanName: null, syncalbe: true, comProtocol: t }
    2021-01-11 15:49:12,96:INFO:CSC - Keys in json: ["currentlyloggedinuserid", "___serverport", "___component", "___serverprotocol", "___username", "transactionid", "___meta", "___serverip", "currentlyloggedinuserip"]
    2021-01-11 15:49:12,99:INFO:CSC - final opcode:
    opcode apiInterface csc/1.0
    content-type:json
    content-length:295
    
    
    2021-01-11 15:49:17,104:INFO:CSC - EventBean: { opCode: heartbeat:HBstatus, mode: 1322, waitForeResponse: true, requestType: 1, opcodetype: 1, entityId: 41, beanName: cyberoam.utilities.helpers.ControlCenterHelper, syncalbe: false, comProtocol: t }
    2021-01-11 15:49:17,590:INFO:CSC - EventBean: { opCode: request_for_data_object, mode: 300, waitForeResponse: true, requestType: 1, opcodetype: 0, entityId: 39, beanName: null, syncalbe: true, comProtocol: t }
    2021-01-11 15:49:19,817:INFO:CSC - EventBean: { opCode: manage_page_detail, mode: 301, waitForeResponse: true, requestType: 1, opcodetype: 0, entityId: 39, beanName: null, syncalbe: true, comProtocol: u }
    2021-01-11 15:49:21,720:INFO:CSC - EventBean: { opCode: request_for_data_object, mode: 300, waitForeResponse: true, requestType: 1, opcodetype: 0, entityId: 39, beanName: null, syncalbe: true, comProtocol: t }
    2021-01-11 15:49:45,739:INFO:CSC - EventBean: { opCode: packet_capture_filter, mode: 242, waitForeResponse: true, requestType: 1, opcodetype: 0, entityId: 7, beanName: cyberoam.system.helpers.ConnectionCaptureHelper, syncalbe: false, comProtocol: u }
    2021-01-11 15:49:48,366:INFO:CSC - EventBean: { opCode: request_for_data_object, mode: 300, waitForeResponse: true, requestType: 1, opcodetype: 0, entityId: 39, beanName: null, syncalbe: true, comProtocol: t }
    2021-01-11 15:49:51,702:INFO:CSC - EventBean: { opCode: packet_capture_filter, mode: 242, waitForeResponse: true, requestType: 1, opcodetype: 0, entityId: 7, beanName: cyberoam.system.helpers.ConnectionCaptureHelper, syncalbe: false, comProtocol: u }
    2021-01-11 15:49:53,70:INFO:CSC - EventBean: { opCode: packet_capture, mode: 230, waitForeResponse: true, requestType: 1, opcodetype: 0, entityId: 7, beanName: null, syncalbe: false, comProtocol: u }
    2021-01-11 15:49:54,194:INFO:CSC - EventBean: { opCode: manage_page_detail, mode: 301, waitForeResponse: true, requestType: 1, opcodetype: 0, entityId: 39, beanName: null, syncalbe: true, comProtocol: u }
    2021-01-11 15:49:55,259:INFO:CSC - EventBean: { opCode: manage_page_detail, mode: 301, waitForeResponse: true, requestType: 1, opcodetype: 0, entityId: 39, beanName: null, syncalbe: true, comProtocol: u }
    2021-01-11 15:49:56,27:INFO:CSC - EventBean: { opCode: manage_page_detail, mode: 301, waitForeResponse: true, requestType: 1, opcodetype: 0, entityId: 39, beanName: null, syncalbe: true, comProtocol: u }
    2021-01-11 15:49:56,628:INFO:CSC - EventBean: { opCode: manage_page_detail, mode: 301, waitForeResponse: true, requestType: 1, opcodetype: 0, entityId: 39, beanName: null, syncalbe: true, comProtocol: u }
    2021-01-11 15:49:57,261:INFO:CSC - EventBean: { opCode: manage_page_detail, mode: 301, waitForeResponse: true, requestType: 1, opcodetype: 0, entityId: 39, beanName: null, syncalbe: true, comProtocol: u }
    2021-01-11 15:49:58,42:INFO:CSC - EventBean: { opCode: manage_page_detail, mode: 301, waitForeResponse: true, requestType: 1, opcodetype: 0, entityId: 39, beanName: null, syncalbe: true, comProtocol: u }
    2021-01-11 15:49:58,740:INFO:CSC - EventBean: { opCode: manage_page_detail, mode: 301, waitForeResponse: true, requestType: 1, opcodetype: 0, entityId: 39, beanName: null, syncalbe: true, comProtocol: u }
    2021-01-11 15:49:59,299:INFO:CSC - EventBean: { opCode: manage_page_detail, mode: 301, waitForeResponse: true, requestType: 1, opcodetype: 0, entityId: 39, beanName: null, syncalbe: true, comProtocol: u }
    2021-01-11 15:50:00,8:INFO:CSC - EventBean: { opCode: manage_page_detail, mode: 301, waitForeResponse: true, requestType: 1, opcodetype: 0, entityId: 39, beanName: null, syncalbe: true, comProtocol: u }
    2021-01-11 15:50:00,625:INFO:CSC - EventBean: { opCode: manage_page_detail, mode: 301, waitForeResponse: true, requestType: 1, opcodetype: 0, entityId: 39, beanName: null, syncalbe: true, comProtocol: u }
    2021-01-11 15:50:01,296:INFO:CSC - EventBean: { opCode: manage_page_detail, mode: 301, waitForeResponse: true, requestType: 1, opcodetype: 0, entityId: 39, beanName: null, syncalbe: true, comProtocol: u }
    2021-01-11 15:50:01,938:INFO:CSC - EventBean: { opCode: manage_page_detail, mode: 301, waitForeResponse: true, requestType: 1, opcodetype: 0, entityId: 39, beanName: null, syncalbe: true, comProtocol: u }
    2021-01-11 15:50:02,577:INFO:CSC - EventBean: { opCode: manage_page_detail, mode: 301, waitForeResponse: true, requestType: 1, opcodetype: 0, entityId: 39, beanName: null, syncalbe: true, comProtocol: u }
    2021-01-11 15:50:03,170:INFO:CSC - EventBean: { opCode: manage_page_detail, mode: 301, waitForeResponse: true, requestType: 1, opcodetype: 0, entityId: 39, beanName: null, syncalbe: true, comProtocol: u }
    2021-01-11 15:50:03,842:INFO:CSC - EventBean: { opCode: manage_page_detail, mode: 301, waitForeResponse: true, requestType: 1, opcodetype: 0, entityId: 39, beanName: null, syncalbe: true, comProtocol: u }
    2021-01-11 15:50:04,432:INFO:CSC - EventBean: { opCode: manage_page_detail, mode: 301, waitForeResponse: true, requestType: 1, opcodetype: 0, entityId: 39, beanName: null, syncalbe: true, comProtocol: u }
    2021-01-11 15:50:05,71:INFO:CSC - EventBean: { opCode: manage_page_detail, mode: 301, waitForeResponse: true, requestType: 1, opcodetype: 0, entityId: 39, beanName: null, syncalbe: true, comProtocol: u }
    2021-01-11 15:50:05,680:INFO:CSC - EventBean: { opCode: manage_page_detail, mode: 301, waitForeResponse: true, requestType: 1, opcodetype: 0, entityId: 39, beanName: null, syncalbe: true, comProtocol: u }
    2021-01-11 15:50:06,366:INFO:CSC - EventBean: { opCode: manage_page_detail, mode: 301, waitForeResponse: true, requestType: 1, opcodetype: 0, entityId: 39, beanName: null, syncalbe: true, comProtocol: u }
    2021-01-11 15:50:06,850:INFO:CSC - EventBean: { opCode: manage_page_detail, mode: 301, waitForeResponse: true, requestType: 1, opcodetype: 0, entityId: 39, beanName: null, syncalbe: true, comProtocol: u }
    2021-01-11 15:50:07,489:INFO:CSC - EventBean: { opCode: manage_page_detail, mode: 301, waitForeResponse: true, requestType: 1, opcodetype: 0, entityId: 39, beanName: null, syncalbe: true, comProtocol: u }
    2021-01-11 15:50:07,988:INFO:CSC - EventBean: { opCode: manage_page_detail, mode: 301, waitForeResponse: true, requestType: 1, opcodetype: 0, entityId: 39, beanName: null, syncalbe: true, comProtocol: u }
    2021-01-11 15:50:08,613:INFO:CSC - EventBean: { opCode: manage_page_detail, mode: 301, waitForeResponse: true, requestType: 1, opcodetype: 0, entityId: 39, beanName: null, syncalbe: true, comProtocol: u }
    2021-01-11 15:50:09,127:INFO:CSC - EventBean: { opCode: manage_page_detail, mode: 301, waitForeResponse: true, requestType: 1, opcodetype: 0, entityId: 39, beanName: null, syncalbe: true, comProtocol: u }
    2021-01-11 15:50:09,741:INFO:CSC - EventBean: { opCode: manage_page_detail, mode: 301, waitForeResponse: true, requestType: 1, opcodetype: 0, entityId: 39, beanName: null, syncalbe: true, comProtocol: u }
    2021-01-11 15:50:10,382:INFO:CSC - EventBean: { opCode: manage_page_detail, mode: 301, waitForeResponse: true, requestType: 1, opcodetype: 0, entityId: 39, beanName: null, syncalbe: true, comProtocol: u }
    2021-01-11 15:50:10,969:INFO:CSC - EventBean: { opCode: manage_page_detail, mode: 301, waitForeResponse: true, requestType: 1, opcodetype: 0, entityId: 39, beanName: null, syncalbe: true, comProtocol: u }
    2021-01-11 15:50:11,552:INFO:CSC - EventBean: { opCode: manage_page_detail, mode: 301, waitForeResponse: true, requestType: 1, opcodetype: 0, entityId: 39, beanName: null, syncalbe: true, comProtocol: u }
    2021-01-11 15:50:12,206:INFO:CSC - EventBean: { opCode: manage_page_detail, mode: 301, waitForeResponse: true, requestType: 1, opcodetype: 0, entityId: 39, beanName: null, syncalbe: true, comProtocol: u }
    2021-01-11 15:50:12,890:ERROR: - EXCEPTION IN RESULTSET WRAPPER WHILE EXECUTING QUERY: java.lang.NullPointerExceptionjava.lang.NullPointerException
            at com.elitecore.jdbchelper.ResultSetWrapper.<init>(ResultSetWrapper.java:40)
            at com.elitecore.jdbchelper.SqlReader.getResultSetWrapper(SqlReader.java:199)
            at com.sophos.sf.auth.AuthHelper.isRefererCheckRequired(AuthHelper.java:105)
            at com.sophos.sf.auth.AuthHelper.hasValidReferer(AuthHelper.java:128)
            at com.sophos.sf.auth.HttpSessionHelper.isExpired(HttpSessionHelper.java:59)
            at com.sophos.sf.auth.HttpSessionHelper.isExpired(HttpSessionHelper.java:29)
            at cyberoam.sessionmanagement.SessionCheckFilter.doFilter(SessionCheckFilter.java:69)
            at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1602)
            at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:540)
            at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:146)
            at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)
            at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
            at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:257)
            at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1701)
            at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)
            at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1345)
            at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)
            at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:480)
            at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1668)
            at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)
            at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1247)
            at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)
            at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:220)
            at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:126)
            at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
            at org.eclipse.jetty.server.Server.handle(Server.java:502)
            at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:370)
            at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:267)
            at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:305)
            at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103)
            at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:117)
            at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)
            at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)
            at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)
            at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126)
            at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366)
            at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:765)
            at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:683)
            at java.lang.Thread.run(Thread.java:748)
    
    2021-01-11 15:50:12,896:INFO:CSC - EventBean: { opCode: manage_page_detail, mode: 301, waitForeResponse: true, requestType: 1, opcodetype: 0, entityId: 39, beanName: null, syncalbe: true, comProtocol: u }
    2021-01-11 15:50:12,897:ERROR: - EXCEPTION IN RESULTSET WRAPPER WHILE EXECUTING QUERY: java.lang.NullPointerExceptionjava.lang.NullPointerException
            at com.elitecore.jdbchelper.ResultSetWrapper.<init>(ResultSetWrapper.java:40)
            at com.elitecore.jdbchelper.SqlReader.getResultSetWrapper(SqlReader.java:199)
            at com.sophos.sf.auth.AuthHelper.isRefererCheckRequired(AuthHelper.java:105)
            at com.sophos.sf.auth.AuthHelper.hasValidReferer(AuthHelper.java:128)
            at com.sophos.sf.auth.HttpSessionHelper.isExpired(HttpSessionHelper.java:59)
            at com.sophos.sf.auth.HttpSessionHelper.isExpired(HttpSessionHelper.java:29)
            at cyberoam.corporate.servlets.CyberoamCommonServlet._doPost(CyberoamCommonServlet.java:486)
            at cyberoam.corporate.servlets.CyberoamCommonServlet.doPost(CyberoamCommonServlet.java:363)
            at cyberoam.corporate.servlets.CyberoamCommonServlet.doGet(CyberoamCommonServlet.java:205)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
            at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:873)
            at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1623)
            at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:214)
            at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1610)
            at cyberoam.utilities.csrf.CSRFCheckFilter.doFilter(CSRFCheckFilter.java:150)
            at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1610)
            at cyberoam.sessionmanagement.SessionCheckFilter.doFilter(SessionCheckFilter.java:74)
            at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1602)
            at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:540)
            at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:146)
            at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)
            at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
            at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:257)
            at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1701)
            at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)
            at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1345)
            at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)
            at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:480)
            at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1668)
            at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)
            at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1247)
            at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)
            at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:220)
            at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:126)
            at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
            at org.eclipse.jetty.server.Server.handle(Server.java:502)
            at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:370)
            at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:267)
            at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:305)
            at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103)
            at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:117)
            at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)
            at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)
            at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)
            at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126)
            at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366)
            at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:765)
            at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:683)
            at java.lang.Thread.run(Thread.java:748)
    
    2021-01-11 15:50:12,900:ERROR:ACL - Exception in checkUserOperation java.lang.NullPointerException
            at com.elitecore.jdbchelper.SqlReader.getInstanceResultSetWrapperForPreparedStatement(SqlReader.java:806)
            at com.elitecore.jdbchelper.SqlReader.getInstanceResultSetWrapperForPreparedStatement(SqlReader.java:686)
            at cyberoam.system.helpers.ACLImplHelper.isPageReadable(ACLImplHelper.java:125)
            at cyberoam.corporate.servlets.CyberoamCommonServlet._doPost(CyberoamCommonServlet.java:526)
            at cyberoam.corporate.servlets.CyberoamCommonServlet.doPost(CyberoamCommonServlet.java:363)
            at cyberoam.corporate.servlets.CyberoamCommonServlet.doGet(CyberoamCommonServlet.java:205)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
            at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:873)
            at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1623)
            at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:214)
            at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1610)
            at cyberoam.utilities.csrf.CSRFCheckFilter.doFilter(CSRFCheckFilter.java:150)
            at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1610)
            at cyberoam.sessionmanagement.SessionCheckFilter.doFilter(SessionCheckFilter.java:74)
            at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1602)
            at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:540)
            at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:146)
            at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)
            at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
            at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:257)
            at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1701)
            at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)
            at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1345)
            at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)
            at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:480)
            at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1668)
            at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)
            at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1247)
            at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)
            at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:220)
            at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:126)
            at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
            at org.eclipse.jetty.server.Server.handle(Server.java:502)
            at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:370)
            at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:267)
            at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:305)
            at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103)
            at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:117)
            at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)
            at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)
            at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)
            at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126)
            at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366)
            at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:765)
            at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:683)
            at java.lang.Thread.run(Thread.java:748)

  • FormerMember
    0 FormerMember in reply to LuCar Toni

    Hi ,

    I tried to replicate this on 2 different firewalls, but I could not replicate this issue. I will check internally and update this thread. 

    Thanks,