Uploaded image for project: 'AdMaxLocal'
  1. AdMaxLocal
  2. AML-536

Wrong error displayed, expecting INVALID_TARGETING_CRITERIA_ERROR

    Details

    • Sprint:
      Sprint 10, Sprint 11

      Description

      This is what I sent via soapUI: campaigns (services in ('google',) and businessAreaId in ('2000040') and locationId in ('18363'))

      Expected Error: INVALID_TARGETING_CRITERIA_ERROR
      Actual Error: permissions error

      [2012-10-02 15:15:57,754]-1549405 [http-8080-1] INFO com.thesearchagency.sapi.security.TokenParsingInterceptor - handleMessage
      [2012-10-02 15:15:57,754]-1549405 [http-8080-1] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor - Received query string: null
      [2012-10-02 15:15:57,754]-1549405 [http-8080-1] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor - Using context from header: X-TSA-Authenticate
      [2012-10-02 15:15:57,755]-1549406 [http-8080-1] DEBUG com.thesearchagency.security.TokenizedSecurityContext - Token:CHD6Z35UIB52P23SWVTJ6LQLWWO6LSLPGRAZEZBHMKPQYDDW3E5SODSRGIL7RHBWQ5I3VEFI5DP3ALA5H6JSWDCIBYBJZI6USK3QYTXBAM6ZXR4CHJIMFZ2WHJV7BLUTUU7IK2YO2PW5T23V2Q5XC57HIA======
      [2012-10-02 15:15:57,758]-1549409 [http-8080-1] INFO com.thesearchagency.sapi.security.TokenParsingInterceptor - Adding (token 4421618960868944:[e042e3b8-b281-4851-a76d-acfabb994dec, c7542d20-f6ba-4784-842b-9202a92190e2]:{}) context to message
      [2012-10-02 15:15:57,760]-1549411 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - ------------------- Beginning request conversion ----------
      [2012-10-02 15:15:57,760]-1549411 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - Found security context for c7542d20-f6ba-4784-842b-9202a92190e2
      [2012-10-02 15:15:57,760]-1549411 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - Found tokenized security context: (token 4421618960868944:[e042e3b8-b281-4851-a76d-acfabb994dec, c7542d20-f6ba-4784-842b-9202a92190e2]:{})
      [2012-10-02 15:15:57,760]-1549411 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - ------------------- End request conversion ----------
      [2012-10-02 15:15:57,760]-1549411 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - Getting request context for c7542d20-f6ba-4784-842b-9202a92190e2 in realm null
      [2012-10-02 15:15:57,761]-1549412 [http-8080-1] DEBUG com.thesearchagency.util.PropertiesPropertySetFactory - Property set for settings/null.properties is {}
      [2012-10-02 15:15:57,762]-1549413 [http-8080-1] INFO com.thesearchagency.sapi.security.PermissionsCheckingInterceptor - handleMessage
      [2012-10-02 15:15:57,762]-1549413 [http-8080-1] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor - resource: public javax.ws.rs.core.Response com.thesearchagency.sapi.services.campaign.CampaignService.getCampaignEstimate(com.thesearchagency.saas.core.services.IRequestContext,java.lang.String)
      [2012-10-02 15:15:57,762]-1549413 [http-8080-1] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor - Excuting getCampaignEstimate
      [2012-10-02 15:15:57,763]-1549414 [http-8080-1] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor - Checking for execute permissions on SAPI:com.thesearchagency.sapi.services.campaign.CampaignService.getCampaignEstimate
      [2012-10-02 15:15:57,763]-1549414 [http-8080-1] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor - Getting connection for com_thesearchagency_saas_core_services_security_manager_TSASecurityManager
      [2012-10-02 15:15:57,764]-1549415 [http-8080-1] ERROR jdbc.audit - 25. PreparedStatement.executeQuery() SELECT users.email,users.realm_id,users.id,users.salt,users.password FROM users WHERE users.id='c7542d20-f6ba-4784-842b-9202a92190e2'
      com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

      The last packet successfully received from the server was 139,916 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.
      at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
      at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
      at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
      at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3090)
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2979)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3520)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)
      at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
      at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2281)
      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
      at net.sf.log4jdbc.PreparedStatementSpy.executeQuery(PreparedStatementSpy.java:735)
      at com.thesearchagency.database.storage.JDBCStorageManager.get(JDBCStorageManager.java:132)
      at com.thesearchagency.database.storage.JDBCStorageManager.get(JDBCStorageManager.java:176)
      at com.thesearchagency.saas.core.services.security.manager.dao.StorageManagerSecurityDAO.getPrincipalById(StorageManagerSecurityDAO.java:38)
      at com.thesearchagency.saas.core.services.security.manager.TSASecurityManager.getPermissions(TSASecurityManager.java:199)
      at com.thesearchagency.saas.core.services.security.manager.TSASecurityManager.isPermitted(TSASecurityManager.java:131)
      at com.thesearchagency.saas.core.services.security.SecurityServiceComponent.isPermitted(SecurityServiceComponent.java:83)
      at com.thesearchagency.sapi.security.PermissionsCheckingInterceptor.isAuthorized(PermissionsCheckingInterceptor.java:102)
      at com.thesearchagency.sapi.security.PermissionsCheckingInterceptor.handleMessage(PermissionsCheckingInterceptor.java:61)
      at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:262)
      at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)
      at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:211)
      at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:213)
      at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:154)
      at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:130)
      at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:221)
      at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:141)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
      at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:197)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
      at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
      at java.lang.Thread.run(Thread.java:679)
      Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
      at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2540)
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2990)
      ... 40 more
      [2012-10-02 15:15:57,766]-1549417 [http-8080-1] ERROR jdbc.sqlonly - 25. PreparedStatement.executeQuery() SELECT users.email,users.realm_id,users.id,users.salt,users.password FROM users WHERE users.id='c7542d20-f6ba-4784-842b-9202a92190e2'
      com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

      The last packet successfully received from the server was 139,916 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.
      at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
      at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
      at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
      at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3090)
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2979)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3520)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)
      at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
      at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2281)
      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
      at net.sf.log4jdbc.PreparedStatementSpy.executeQuery(PreparedStatementSpy.java:735)
      at com.thesearchagency.database.storage.JDBCStorageManager.get(JDBCStorageManager.java:132)
      at com.thesearchagency.database.storage.JDBCStorageManager.get(JDBCStorageManager.java:176)
      at com.thesearchagency.saas.core.services.security.manager.dao.StorageManagerSecurityDAO.getPrincipalById(StorageManagerSecurityDAO.java:38)
      at com.thesearchagency.saas.core.services.security.manager.TSASecurityManager.getPermissions(TSASecurityManager.java:199)
      at com.thesearchagency.saas.core.services.security.manager.TSASecurityManager.isPermitted(TSASecurityManager.java:131)
      at com.thesearchagency.saas.core.services.security.SecurityServiceComponent.isPermitted(SecurityServiceComponent.java:83)
      at com.thesearchagency.sapi.security.PermissionsCheckingInterceptor.isAuthorized(PermissionsCheckingInterceptor.java:102)
      at com.thesearchagency.sapi.security.PermissionsCheckingInterceptor.handleMessage(PermissionsCheckingInterceptor.java:61)
      at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:262)
      at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)
      at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:211)
      at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:213)
      at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:154)
      at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:130)
      at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:221)
      at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:141)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
      at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:197)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
      at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
      at java.lang.Thread.run(Thread.java:679)
      Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
      at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2540)
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2990)
      ... 40 more
      [2012-10-02 15:15:57,767]-1549418 [http-8080-1] ERROR jdbc.sqltiming - 25. PreparedStatement.executeQuery() FAILED! SELECT users.email,users.realm_id,users.id,users.salt,users.password FROM users WHERE users.id='c7542d20-f6ba-4784-842b-9202a92190e2'

      {FAILED after 0 msec}

      com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

      The last packet successfully received from the server was 139,916 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.
      at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
      at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
      at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
      at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3090)
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2979)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3520)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)
      at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
      at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2281)
      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
      at net.sf.log4jdbc.PreparedStatementSpy.executeQuery(PreparedStatementSpy.java:735)
      at com.thesearchagency.database.storage.JDBCStorageManager.get(JDBCStorageManager.java:132)
      at com.thesearchagency.database.storage.JDBCStorageManager.get(JDBCStorageManager.java:176)
      at com.thesearchagency.saas.core.services.security.manager.dao.StorageManagerSecurityDAO.getPrincipalById(StorageManagerSecurityDAO.java:38)
      at com.thesearchagency.saas.core.services.security.manager.TSASecurityManager.getPermissions(TSASecurityManager.java:199)
      at com.thesearchagency.saas.core.services.security.manager.TSASecurityManager.isPermitted(TSASecurityManager.java:131)
      at com.thesearchagency.saas.core.services.security.SecurityServiceComponent.isPermitted(SecurityServiceComponent.java:83)
      at com.thesearchagency.sapi.security.PermissionsCheckingInterceptor.isAuthorized(PermissionsCheckingInterceptor.java:102)
      at com.thesearchagency.sapi.security.PermissionsCheckingInterceptor.handleMessage(PermissionsCheckingInterceptor.java:61)
      at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:262)
      at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)
      at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:211)
      at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:213)
      at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:154)
      at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:130)
      at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:221)
      at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:141)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
      at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:197)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
      at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
      at java.lang.Thread.run(Thread.java:679)
      Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
      at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2540)
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2990)
      ... 40 more
      [2012-10-02 15:15:57,769]-1549420 [http-8080-1] ERROR com.thesearchagency.database.storage.JDBCStorageManager - Exception thrown in get()
      com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

      The last packet successfully received from the server was 139,916 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.
      at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
      at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
      at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
      at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3090)
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2979)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3520)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)
      at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
      at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2281)
      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
      at net.sf.log4jdbc.PreparedStatementSpy.executeQuery(PreparedStatementSpy.java:735)
      at com.thesearchagency.database.storage.JDBCStorageManager.get(JDBCStorageManager.java:132)
      at com.thesearchagency.database.storage.JDBCStorageManager.get(JDBCStorageManager.java:176)
      at com.thesearchagency.saas.core.services.security.manager.dao.StorageManagerSecurityDAO.getPrincipalById(StorageManagerSecurityDAO.java:38)
      at com.thesearchagency.saas.core.services.security.manager.TSASecurityManager.getPermissions(TSASecurityManager.java:199)
      at com.thesearchagency.saas.core.services.security.manager.TSASecurityManager.isPermitted(TSASecurityManager.java:131)
      at com.thesearchagency.saas.core.services.security.SecurityServiceComponent.isPermitted(SecurityServiceComponent.java:83)
      at com.thesearchagency.sapi.security.PermissionsCheckingInterceptor.isAuthorized(PermissionsCheckingInterceptor.java:102)
      at com.thesearchagency.sapi.security.PermissionsCheckingInterceptor.handleMessage(PermissionsCheckingInterceptor.java:61)
      at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:262)
      at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)
      at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:211)
      at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:213)
      at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:154)
      at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:130)
      at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:221)
      at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:141)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
      at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:197)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
      at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
      at java.lang.Thread.run(Thread.java:679)
      Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
      at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2540)
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2990)
      ... 40 more
      [2012-10-02 15:15:57,771]-1549422 [http-8080-1] ERROR com.thesearchagency.sapi.security.PermissionsCheckingInterceptor - Exception thrown handling authorization request
      java.lang.RuntimeException: com.thesearchagency.database.storage.StorageManagerException: package com.thesearchagency.database.storage.INTERNAL_ERROR_EXCEPTION
      at com.thesearchagency.saas.core.services.security.manager.dao.StorageManagerSecurityDAO.getPrincipalById(StorageManagerSecurityDAO.java:41)
      at com.thesearchagency.saas.core.services.security.manager.TSASecurityManager.getPermissions(TSASecurityManager.java:199)
      at com.thesearchagency.saas.core.services.security.manager.TSASecurityManager.isPermitted(TSASecurityManager.java:131)
      at com.thesearchagency.saas.core.services.security.SecurityServiceComponent.isPermitted(SecurityServiceComponent.java:83)
      at com.thesearchagency.sapi.security.PermissionsCheckingInterceptor.isAuthorized(PermissionsCheckingInterceptor.java:102)
      at com.thesearchagency.sapi.security.PermissionsCheckingInterceptor.handleMessage(PermissionsCheckingInterceptor.java:61)
      at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:262)
      at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)
      at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:211)
      at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:213)
      at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:154)
      at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:130)
      at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:221)
      at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:141)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
      at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:197)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
      at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
      at java.lang.Thread.run(Thread.java:679)
      Caused by: com.thesearchagency.database.storage.StorageManagerException: package com.thesearchagency.database.storage.INTERNAL_ERROR_EXCEPTION
      at com.thesearchagency.database.storage.JDBCStorageManager.get(JDBCStorageManager.java:157)
      at com.thesearchagency.database.storage.JDBCStorageManager.get(JDBCStorageManager.java:176)
      at com.thesearchagency.saas.core.services.security.manager.dao.StorageManagerSecurityDAO.getPrincipalById(StorageManagerSecurityDAO.java:38)
      ... 27 more
      Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

      The last packet successfully received from the server was 139,916 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.
      at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
      at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
      at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
      at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3090)
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2979)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3520)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)
      at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
      at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2281)
      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
      at net.sf.log4jdbc.PreparedStatementSpy.executeQuery(PreparedStatementSpy.java:735)
      at com.thesearchagency.database.storage.JDBCStorageManager.get(JDBCStorageManager.java:132)
      ... 29 more
      Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
      at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2540)
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2990)
      ... 40 more
      [2012-10-02 15:15:57,774]-1549425 [http-8080-1] WARN org.apache.cxf.phase.PhaseInterceptorChain - Interceptor for

      {http://security.services.sapi.thesearchagency.com/}

      SecurityService has thrown exception, unwinding now
      org.apache.cxf.interceptor.security.AccessDeniedException: Failure checking for permissions
      at com.thesearchagency.sapi.security.PermissionsCheckingInterceptor.handleMessage(PermissionsCheckingInterceptor.java:67)
      at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:262)
      at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)
      at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:211)
      at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:213)
      at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:154)
      at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:130)
      at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:221)
      at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:141)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
      at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:197)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
      at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
      at java.lang.Thread.run(Thread.java:679)
      [2012-10-02 15:15:57,775]-1549426 [http-8080-1] INFO com.thesearchagency.sapi.security.SecurityExceptionInterceptor - Setting HTTP status code to 403

        Attachments

          Activity

            People

            • Assignee:
              stacie.waleyko Stacie Waleyko (Inactive)
              Reporter:
              jelliott Jen Clarke (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: