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

Deprecated Business Areas and Categories are not being handled correctly in AML

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: Aquidneck
    • Component/s: None
    • Labels:
      None
    • Sprint:
      Sprint 12

      Description

      Core returns 'deprecated' for inactive business categories and areas while AML is expecting inactive. AML needs to either convert deprecated entries to inactive or add deprecated as a status. I have to change all statuses to active in the business area and category tables to get anything, including active status items, to show up. Here's the trace:

      2012-11-07 20:04:38,706-20155134 [http-8080-3] DEBUG com.thesearchagency.util.PropertiesPropertySetFactory - Property set for settings/com.reseller1.properties is {}
      2012-11-07 20:04:38,707-20155135 [http-8080-3] DEBUG com.thesearchagency.saas.core.services.taxonomy.manager.TaxonomyManager - Searching for business in

      {business=com.thesearchagency.saas.core.services.taxonomy.provider.CoreBusinessTaxonomyProvider@53d11f70, location=com.thesearchagency.saas.core.services.taxonomy.provider.CoreLocationTaxonomyProvider@46671d0d}

      2012-11-07 20:04:38,717-20155145 [http-8080-3] INFO jdbc.sqltiming - select bc.id, bc.description, bc.status from businessCategories bc where bc.id=9

      {executed in 4 msec}

      2012-11-07 20:04:38,727-20155155 [http-8080-3] WARN org.apache.cxf.phase.PhaseInterceptorChain - Application

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

      SecurityService has thrown exception, unwinding now
      org.apache.cxf.interceptor.Fault: No enum const class com.thesearchagency.saas.core.models.ITaxonomyNode$Status.
      at org.apache.cxf.service.invoker.AbstractInvoker.createFault(AbstractInvoker.java:162)
      at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:128)
      at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:167)
      at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:94)
      at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58)
      at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:94)
      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.doGet(AbstractHTTPServlet.java:146)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
      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.lang.IllegalArgumentException: No enum const class com.thesearchagency.saas.core.models.ITaxonomyNode$Status.
      at java.lang.Enum.valueOf(Enum.java:214)
      at com.thesearchagency.saas.core.models.ITaxonomyNode$Status.valueOf(ITaxonomyNode.java:14)
      at com.thesearchagency.saas.core.services.taxonomy.dao.CoreBusinessTaxonomyDAO$1.mapRow(CoreBusinessTaxonomyDAO.java:116)
      at com.thesearchagency.saas.core.services.taxonomy.dao.CoreBusinessTaxonomyDAO$1.mapRow(CoreBusinessTaxonomyDAO.java:108)
      at org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:92)
      at org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:1)
      at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:649)
      at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:587)
      at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:637)
      at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:666)
      at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:674)
      at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:729)
      at com.thesearchagency.saas.core.services.taxonomy.dao.CoreBusinessTaxonomyDAO.getBusinessCategory(CoreBusinessTaxonomyDAO.java:59)
      at com.thesearchagency.saas.core.services.taxonomy.provider.CoreBusinessTaxonomyProvider.getNode(CoreBusinessTaxonomyProvider.java:128)
      at com.thesearchagency.saas.core.services.taxonomy.provider.CoreBusinessTaxonomyProvider.getNodes(CoreBusinessTaxonomyProvider.java:66)
      at com.thesearchagency.saas.core.services.taxonomy.manager.TaxonomyManager.getNodes(TaxonomyManager.java:101)
      at com.thesearchagency.saas.core.services.taxonomy.TaxonomyServiceComponent.getNodes(TaxonomyServiceComponent.java:58)
      at com.thesearchagency.sapi.services.taxonomy.TaxonomyService.getNodes(TaxonomyService.java:90)
      at sun.reflect.GeneratedMethodAccessor75.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:616)
      at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:180)
      at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:96)
      ... 26 more
      2012-11-07 20:04:38,728-20155156 [http-8080-3] WARN org.apache.cxf.phase.PhaseInterceptorChain - Exception in handleFault on interceptor org.apache.cxf.binding.xml.interceptor.XMLFaultOutInterceptor@4bb807ac
      org.apache.cxf.interceptor.Fault: No enum const class com.thesearchagency.saas.core.models.ITaxonomyNode$Status.
      at org.apache.cxf.service.invoker.AbstractInvoker.createFault(AbstractInvoker.java:162)
      at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:128)
      at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:167)
      at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:94)
      at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58)
      at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:94)
      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.doGet(AbstractHTTPServlet.java:146)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
      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.lang.IllegalArgumentException: No enum const class com.thesearchagency.saas.core.models.ITaxonomyNode$Status.
      at java.lang.Enum.valueOf(Enum.java:214)
      at com.thesearchagency.saas.core.models.ITaxonomyNode$Status.valueOf(ITaxonomyNode.java:14)
      at com.thesearchagency.saas.core.services.taxonomy.dao.CoreBusinessTaxonomyDAO$1.mapRow(CoreBusinessTaxonomyDAO.java:116)
      at com.thesearchagency.saas.core.services.taxonomy.dao.CoreBusinessTaxonomyDAO$1.mapRow(CoreBusinessTaxonomyDAO.java:108)
      at org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:92)
      at org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:1)
      at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:649)
      at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:587)
      at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:637)
      at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:666)
      at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:674)
      at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:729)
      at com.thesearchagency.saas.core.services.taxonomy.dao.CoreBusinessTaxonomyDAO.getBusinessCategory(CoreBusinessTaxonomyDAO.java:59)
      at com.thesearchagency.saas.core.services.taxonomy.provider.CoreBusinessTaxonomyProvider.getNode(CoreBusinessTaxonomyProvider.java:128)
      at com.thesearchagency.saas.core.services.taxonomy.provider.CoreBusinessTaxonomyProvider.getNodes(CoreBusinessTaxonomyProvider.java:66)
      at com.thesearchagency.saas.core.services.taxonomy.manager.TaxonomyManager.getNodes(TaxonomyManager.java:101)
      at com.thesearchagency.saas.core.services.taxonomy.TaxonomyServiceComponent.getNodes(TaxonomyServiceComponent.java:58)
      at com.thesearchagency.sapi.services.taxonomy.TaxonomyService.getNodes(TaxonomyService.java:90)
      at sun.reflect.GeneratedMethodAccessor75.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:616)
      at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:180)
      at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:96)
      ... 26 more
      2012-11-07 20:04:38,729-20155157 [http-8080-3] ERROR org.apache.cxf.interceptor.AbstractFaultChainInitiatorObserver - Error occurred during error handling, give up!
      org.apache.cxf.interceptor.Fault: No enum const class com.thesearchagency.saas.core.models.ITaxonomyNode$Status.
      at org.apache.cxf.service.invoker.AbstractInvoker.createFault(AbstractInvoker.java:162)
      at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:128)
      at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:167)
      at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:94)
      at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58)
      at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:94)
      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.doGet(AbstractHTTPServlet.java:146)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
      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.lang.IllegalArgumentException: No enum const class com.thesearchagency.saas.core.models.ITaxonomyNode$Status.
      at java.lang.Enum.valueOf(Enum.java:214)
      at com.thesearchagency.saas.core.models.ITaxonomyNode$Status.valueOf(ITaxonomyNode.java:14)
      at com.thesearchagency.saas.core.services.taxonomy.dao.CoreBusinessTaxonomyDAO$1.mapRow(CoreBusinessTaxonomyDAO.java:116)
      at com.thesearchagency.saas.core.services.taxonomy.dao.CoreBusinessTaxonomyDAO$1.mapRow(CoreBusinessTaxonomyDAO.java:108)
      at org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:92)
      at org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:1)
      at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:649)
      at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:587)
      at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:637)
      at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:666)
      at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:674)
      at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:729)
      at com.thesearchagency.saas.core.services.taxonomy.dao.CoreBusinessTaxonomyDAO.getBusinessCategory(CoreBusinessTaxonomyDAO.java:59)
      at com.thesearchagency.saas.core.services.taxonomy.provider.CoreBusinessTaxonomyProvider.getNode(CoreBusinessTaxonomyProvider.java:128)
      at com.thesearchagency.saas.core.services.taxonomy.provider.CoreBusinessTaxonomyProvider.getNodes(CoreBusinessTaxonomyProvider.java:66)
      at com.thesearchagency.saas.core.services.taxonomy.manager.TaxonomyManager.getNodes(TaxonomyManager.java:101)
      at com.thesearchagency.saas.core.services.taxonomy.TaxonomyServiceComponent.getNodes(TaxonomyServiceComponent.java:58)
      at com.thesearchagency.sapi.services.taxonomy.TaxonomyService.getNodes(TaxonomyService.java:90)
      at sun.reflect.GeneratedMethodAccessor75.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:616)
      at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:180)
      at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:96)
      ... 26 more

        Attachments

          Activity

            People

            • Assignee:
              gavin.nicol Gavin Nicol (Inactive)
              Reporter:
              jeff.brown Jeff Brown (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: