05-25-2012 05:48 AM - edited 03-14-2019 09:55 AM
I created CUIC reports in 8.5.4 version and now wanted these to load in 8.5.3 version. Doing this the lower version throwing an error.
I see the import is possible from lower to higher version. Is there a way to import from 8.5(4) to 8.5(3) with out deleting the existing report and report defination
05-26-2012 05:57 AM
What is the error that it's generating? Also, post the XML of the report, there might be parameter that can be edited or deleted to allow the upload.
david
05-27-2012 11:58 PM
Hi david,
Thanks for ur reponse,it will be greate help if we figure it out.
Error Message:
---------------------
[product_name=CUIC][subsystem_exception_info=][tid=http-8444-3][version_number=CUIC_8_5_3_0_0_0_198]: Information associated with the following logged exception
0000000006: 172.22.10.27: May 22 2012 14:52:12.123 -0700: %CCBU_CUIC_MIGRATION-3-EXCEPTION: %[EXCEPTION=com.thoughtworks.xstream.converters.ConversionException: entityVersion : entityVersion : entityVersion : entityVersion
---- Debugging information ----
message : entityVersion : entityVersion
cause-exception : com.thoughtworks.xstream.mapper.CannotResolveClassException
cause-message : entityVersion : entityVersion
class : com.cisco.ccbu.cuic.objectmodel.reportdefinition.CuicReportDefinitionImpl
required-type : com.cisco.ccbu.cuic.objectmodel.reportdefinition.CuicReportDefinitionImpl
-------------------------------]: There was an exception that occurred.
0000000007: 172.22.10.27: May 22 2012 14:52:12.124 -0700: %CCBU_CUIC_MIGRATION-3-EXCEPTION_INFO: %[build_date=Dec 15, 2011 7:39 AM][build_type=rel][exception=com.thoughtworks.xstream.converters.ConversionException: entityVersion : entityVersion : entityVersion : entityVersion
---- Debugging information ----
message : entityVersion : entityVersion
cause-exception : com.thoughtworks.xstream.mapper.CannotResolveClassException
cause-message : entityVersion : entityVersion
class : com.cisco.ccbu.cuic.objectmodel.reportdefinition.CuicReportDefinitionImpl
required-type : com.cisco.ccbu.cuic.objectmodel.reportdefinition.CuicReportDefinitionImpl
-------------------------------
at com.thoughtworks.xstream.core.TreeUnmarshaller.convert(TreeUnmarshaller.java:89)
at com.thoughtworks.xstream.core.AbstractReferenceUnmarshaller.convert(AbstractReferenceUnmarshaller.java:63)
at com.thoughtworks.xstream.core.TreeUnmarshaller.convertAnother(TreeUnmarshaller.java:76)
at com.thoughtworks.xstream.core.TreeUnmarshaller.convertAnother(TreeUnmarshaller.java:60)
at com.thoughtworks.xstream.core.TreeUnmarshaller.start(TreeUnmarshaller.java:137)
at com.thoughtworks.xstream.core.AbstractTreeMarshallingStrategy.unmarshal(AbstractTreeMarshallingStrategy.java:33)
at com.thoughtworks.xstream.XStream.unmarshal(XStream.java:923)
at com.thoughtworks.xstream.XStream.unmarshal(XStream.java:909)
at com.thoughtworks.xstream.XStream.fromXML(XStream.java:861)
at com.cisco.ccbu.cuic.businesslogic.XMLTransform.XMLTransformerImpl.convertToObject(XMLTransformerImpl.java:2785)
at com.cisco.ccbu.cuic.businesslogic.XMLTransform.XMLTransformerImpl.importReportDefFromXMLInternal(XMLTransformerImpl.java:1228)
at com.cisco.ccbu.cuic.businesslogic.XMLTransform.XMLTransformerImpl.importReportFromXMLInternal(XMLTransformerImpl.java:1742)
at com.cisco.ccbu.cuic.businesslogic.XMLTransform.XMLTransformerImpl.importReportsFromXML(XMLTransformerImpl.java:2523)
at com.cisco.ccbu.cuic.webcontrollers.report.ReportManagerController.importReportFromXML(ReportManagerController.java:871)
at com.cisco.ccbu.cuic.webcontrollers.report.ReportManagerController.importExistingCustomReports(ReportManagerController.java:1280)
at com.cisco.ccbu.cuic.webcontrollers.report.ReportManagerController.handleRequestInternal(ReportManagerController.java:513)
at com.cisco.ccbu.cuic.webcontrollers.CuicAbstractController.handleAuthorizationAndRequestInternal(CuicAbstractController.java:373)
at com.cisco.ccbu.cuic.webcontrollers.CuicAbstractController.handleRequest(CuicAbstractController.java:314)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at sun.reflect.GeneratedMethodAccessor201.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:269)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:301)
at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:162)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:283)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:56)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:189)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:185)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
at org.springframework.security.ui.switchuser.SwitchUserProcessingFilter.doFilterHttp(SwitchUserProcessingFilter.java:299)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.ui.SessionFixationProtectionFilter.doFilterHttp(SessionFixationProtectionFilter.java:67)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:277)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:277)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.securechannel.ChannelProcessingFilter.doFilterHttp(ChannelProcessingFilter.java:116)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.securechannel.ChannelProcessingFilter.doFilterHttp(ChannelProcessingFilter.java:116)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
at sun.reflect.GeneratedMethodAccessor203.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:269)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:301)
at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:243)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:56)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:189)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:185)
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:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:421)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
at java.lang.Thread.run(Thread.java:619)
Caused by: com.thoughtworks.xstream.mapper.CannotResolveClassException: entityVersion : entityVersion
at com.thoughtworks.xstream.mapper.DefaultMapper.realClass(DefaultMapper.java:68)
at com.thoughtworks.xstream.mapper.MapperWrapper.realClass(MapperWrapper.java:38)
at com.thoughtworks.xstream.mapper.DynamicProxyMapper.realClass(DynamicProxyMapper.java:71)
at com.thoughtworks.xstream.mapper.MapperWrapper.realClass(MapperWrapper.java:38)
at com.thoughtworks.xstream.mapper.PackageAliasingMapper.realClass(PackageAliasingMapper.java:88)
at com.thoughtworks.xstream.mapper.MapperWrapper.realClass(MapperWrapper.java:38)
at com.thoughtworks.xstream.mapper.ClassAliasingMapper.realClass(ClassAliasingMapper.java:86)
at com.thoughtworks.xstream.mapper.MapperWrapper.realClass(MapperWrapper.java:38)
at com.thoughtworks.xstream.mapper.MapperWrapper.realClass(MapperWrapper.java:38)
at com.thoughtworks.xstream.mapper.MapperWrapper.realClass(MapperWrapper.java:38)
at com.thoughtworks.xstream.mapper.MapperWrapper.realClass(MapperWrapper.java:38)
at com.thoughtworks.xstream.mapper.MapperWrapper.realClass(MapperWrapper.java:38)
at com.thoughtworks.xstream.mapper.MapperWrapper.realClass(MapperWrapper.java:38)
at com.thoughtworks.xstream.mapper.ArrayMapper.realClass(ArrayMapper.java:96)
at com.thoughtworks.xstream.mapper.MapperWrapper.realClass(MapperWrapper.java:38)
at com.thoughtworks.xstream.mapper.MapperWrapper.realClass(MapperWrapper.java:38)
at com.thoughtworks.xstream.mapper.MapperWrapper.realClass(MapperWrapper.java:38)
at com.thoughtworks.xstream.mapper.MapperWrapper.realClass(MapperWrapper.java:38)
at com.thoughtworks.xstream.mapper.MapperWrapper.realClass(MapperWrapper.java:38)
at com.thoughtworks.xstream.mapper.MapperWrapper.realClass(MapperWrapper.java:38)
at com.thoughtworks.xstream.mapper.MapperWrapper.realClass(MapperWrapper.java:38)
at com.thoughtworks.xstream.mapper.CachingMapper.realClass(CachingMapper.java:52)
at com.thoughtworks.xstream.converters.reflection.AbstractReflectionConverter.determineType(AbstractReflectionConverter.java:347)
at com.thoughtworks.xstream.converters.reflection.AbstractReflectionConverter.doUnmarshal(AbstractReflectionConverter.java:208)
at com.thoughtworks.xstream.converters.reflection.AbstractReflectionConverter.unmarshal(AbstractReflectionConverter.java:162)
at com.thoughtworks.xstream.core.TreeUnmarshaller.convert(TreeUnmarshaller.java:82)
... 104 more
][product_name=CUIC][subsystem_exception_info=][tid=http-8444-3][version_number=CUIC_8_5_3_0_0_0_198]: Information associated with the following logged exception
0000003902: 172.22.10.27: May 22 2012 14:52:12.126 -0700: %CCBU___________CUIC-3-ERROR: Failed to import report 'Agteam26' : entityVersion : entityVersion : entityVersion : entityVersion
---- Debugging information ----
message : entityVersion : entityVersion
cause-exception : com.thoughtworks.xstream.mapper.CannotResolveClassException
cause-message : entityVersion : entityVersion
class : com.cisco.ccbu.cuic.objectmodel.reportdefinition.CuicReportDefinitionImpl
required-type : com.cisco.ccbu.cuic.objectmodel.reportdefinition.CuicReportDefinitionImpl
------------------------------- <- XMLTransformerImpl.java:2550 [com.cisco.ccbu.cuic.businesslogic.XMLTransform.XMLTransformerImpl.importReportsFromXML]
0000000156: 172.22.10.27: May 22 2012 14:52:12.126 -0700: %CCBU_CUIC_MODEL_OBJECTS-3-EXCEPTION: %[EXCEPTION=com.cisco.ccbu.cuic.CuicException: entityVersion : entityVersion : entityVersion : entityVersion
---- Debugging information ----
message : entityVersion : entityVersion
cause-exception : com.thoughtworks.xstream.mapper.CannotResolveClassException
cause-message : entityVersion : entityVersion
class : com.cisco.ccbu.cuic.objectmodel.reportdefinition.CuicReportDefinitionImpl
required-type : com.cisco.ccbu.cuic.objectmodel.reportdefinition.CuicReportDefinitionImpl
-------------------------------]: There was an exception that occurred.
0000000157: 172.22.10.27: May 22 2012 14:52:12.126 -0700: %CCBU_CUIC_MODEL_OBJECTS-3-EXCEPTION_INFO: %[build_date=Dec 15, 2011 7:39 AM][build_type=rel][exception=com.cisco.ccbu.cuic.CuicException: entityVersion : entityVersion : entityVersion : entityVersion
---- Debugging information ----
message : entityVersion : entityVersion
cause-exception : com.thoughtworks.xstream.mapper.CannotResolveClassException
cause-message : entityVersion : entityVersion
class : com.cisco.ccbu.cuic.objectmodel.reportdefinition.CuicReportDefinitionImpl
required-type : com.cisco.ccbu.cuic.objectmodel.reportdefinition.CuicReportDefinitionImpl
-------------------------------
at com.cisco.ccbu.cuic.businesslogic.XMLTransform.XMLTransformerImpl.convertToObject(XMLTransformerImpl.java:2788)
at com.cisco.ccbu.cuic.businesslogic.XMLTransform.XMLTransformerImpl.importReportDefFromXMLInternal(XMLTransformerImpl.java:1228)
at com.cisco.ccbu.cuic.businesslogic.XMLTransform.XMLTransformerImpl.importReportFromXMLInternal(XMLTransformerImpl.java:1742)
at com.cisco.ccbu.cuic.businesslogic.XMLTransform.XMLTransformerImpl.importReportsFromXML(XMLTransformerImpl.java:2523)
at com.cisco.ccbu.cuic.webcontrollers.report.ReportManagerController.importReportFromXML(ReportManagerController.java:871)
at com.cisco.ccbu.cuic.webcontrollers.report.ReportManagerController.importExistingCustomReports(ReportManagerController.java:1280)
at com.cisco.ccbu.cuic.webcontrollers.report.ReportManagerController.handleRequestInternal(ReportManagerController.java:513)
at com.cisco.ccbu.cuic.webcontrollers.CuicAbstractController.handleAuthorizationAndRequestInternal(CuicAbstractController.java:373)
at com.cisco.ccbu.cuic.webcontrollers.CuicAbstractController.handleRequest(CuicAbstractController.java:314)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at sun.reflect.GeneratedMethodAccessor201.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:269)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:301)
at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:162)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:283)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:56)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:189)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:185)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
at org.springframework.security.ui.switchuser.SwitchUserProcessingFilter.doFilterHttp(SwitchUserProcessingFilter.java:299)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.ui.SessionFixationProtectionFilter.doFilterHttp(SessionFixationProtectionFilter.java:67)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:277)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:277)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.securechannel.ChannelProcessingFilter.doFilterHttp(ChannelProcessingFilter.java:116)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.securechannel.ChannelProcessingFilter.doFilterHttp(ChannelProcessingFilter.java:116)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
at sun.reflect.GeneratedMethodAccessor203.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:269)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:301)
at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:243)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:56)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:189)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:185)
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:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:421)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
at java.lang.Thread.run(Thread.java:619)
][product_name=CUIC][subsystem_exception_info=][tid=http-8444-3][version_number=CUIC_8_5_3_0_0_0_198]: Information associated with the following logged exception
05-28-2012 12:00 AM
XML File of the Agentteam24 report:
--------------------------------------------------------
Agent_Team = AgentSkillGroup.Agent_Team,
AgentTeamID = AgentSkillGroup.AgentTeamID,
Supervisor = AgentSkillGroup.Supervisor,
Media = AgentSkillGroup.Media,
FullName = AgentSkillGroup.FullName,
AgentSkillID = AgentSkillGroup.AgentSkillID,
datecol= AgentSkillGroup.datecol,
AbandonCallRing = AgentSkillGroup.AbandonCallRing,
RedirectNoAnswer = AgentSkillGroup.RedirectNoAnswer,
AbandonCallHold = AgentSkillGroup.AbandonCallHold,
SupAssistCalls = AgentSkillGroup.SupAssistCalls,
SupAssistCallsTime = AgentSkillGroup.SupAssistCallsTime,
EmergencyAssist = AgentSkillGroup.EmergencyAssist,
BargeInCalls = AgentSkillGroup.BargeInCalls,
InterceptCalls = AgentSkillGroup.InterceptCalls,
Handletime = AgentSkillGroup.Handletime,
Handled = AgentSkillGroup.Handled,
AHT = ISNULL(Handletime / nullif((Handled),0), 0),
TotalOnHoldTime = AgentSkillGroup.TotalOnHoldTime,
IncomingHoldTime = AgentSkillGroup.IncomingHoldTime,
TotalOnHoldCalls = AgentSkillGroup.TotalOnHoldCalls,
IncomingHoldCalls = AgentSkillGroup.IncomingHoldCalls ,
AHoldT = ISNULL(IncomingHoldTime / nullif((IncomingHoldCalls),0), 0),
TalkTime = AgentSkillGroup.TalkTime,
AvailTime = AgentHour.AvailTime,
HoldTime = AgentSkillGroup.HoldTime,
NotReadyTime = AgentHour.NotReadyTime,
ReservedTime = AgentSkillGroup.ReservedTime,
WrapTime = AgentSkillGroup.WrapTime,
BusyOtherTime = AgentSkillGroup.BusyOtherTime
FROM
( SELECT
Agent_Team=Agent_Team.EnterpriseName,
AgentTeamID = Agent_Team.AgentTeamID,
Supervisor=(SELECT Person.LastName + ', ' + Person.FirstName FROM Agent, Person WHERE Agent.SkillTargetID = Agent_Team.PriSupervisorSkillTargetID AND Agent.PersonID = Person.PersonID),
Media = Media_Routing_Domain.EnterpriseName,
FullName = Person.LastName + ', ' + Person.FirstName,
AgentSkillID = Agent.SkillTargetID,
datecol=Convert(DateTime,(Convert(Varchar(20),ASGHH.DateTime, 112))),
AbandonCallRing = SUM(ISNULL(ASGHH.AbandonRingCalls, 0)),
RedirectNoAnswer = SUM(ISNULL(ASGHH.RedirectNoAnsCalls, 0)),
AbandonCallHold = SUM(ISNULL(ASGHH.AbandonHoldCalls, 0)),
SupAssistCalls = SUM(ISNULL(ASGHH.SupervAssistCalls, 0)),
SupAssistCallsTime = SUM(ISNULL(ASGHH.SupervAssistCallsTime, 0)),
EmergencyAssist = SUM(ISNULL(ASGHH.EmergencyAssists, 0)),
BargeInCalls = SUM(ISNULL(ASGHH.BargeInCalls, 0)),
InterceptCalls = SUM(ISNULL(ASGHH.InterceptCalls, 0)),
Handletime = SUM(ISNULL(ASGHH.HandledCallsTime, 0)),
Handled = SUM(ISNULL(ASGHH.CallsHandled,0)),
TotalOnHoldTime = SUM(ISNULL(ASGHH.IncomingCallsOnHoldTime, 0)) + SUM(ISNULL(ASGHH.AgentOutCallsOnHoldTime, 0)) + SUM(ISNULL(ASGHH.InternalCallsOnHoldTime, 0)),
IncomingHoldTime = SUM(ISNULL(ASGHH.IncomingCallsOnHoldTime, 0)),
TotalOnHoldCalls = SUM(ISNULL(ASGHH.IncomingCallsOnHold, 0)) + SUM(ISNULL(ASGHH.AgentOutCallsOnHold, 0)) + SUM(ISNULL(ASGHH.InternalCallsOnHold, 0)),
IncomingHoldCalls = SUM(ISNULL(ASGHH.IncomingCallsOnHold,0)),
TalkTime = SUM(ISNULL(ASGHH.TalkInTime, 0)) +
SUM(ISNULL(ASGHH.TalkOutTime, 0)) +
SUM(ISNULL(ASGHH.TalkOtherTime, 0)) +
SUM(ISNULL(ASGHH.TalkAutoOutTime, 0)) +
SUM(ISNULL(ASGHH.TalkPreviewTime, 0)) +
SUM(ISNULL(ASGHH.TalkReserveTime, 0)),
HoldTime = SUM(ISNULL(ASGHH.HoldTime, 0)),
ReservedTime = SUM(ISNULL(ASGHH.ReservedStateTime, 0)),
WrapTime = SUM(ISNULL(ASGHH.WorkNotReadyTime, 0)) + SUM(ISNULL(ASGHH.WorkReadyTime, 0)),
BusyOtherTime = SUM(ISNULL(ASGHH.BusyOtherTime, 0)),
StartDate = CONVERT(DATETIME, :start_datetime),
EndDate = CONVERT(DATETIME, :end_datetime)
FROM
Agent,
Person,
Media_Routing_Domain,
Agent_Skill_Group_Interval ASGHH,
Agent_Team_Member,
Agent_Team,
Skill_Group
WHERE
( ASGHH.SkillGroupSkillTargetID = Skill_Group.SkillTargetID ) and
( Agent.PersonID = Person.PersonID ) and
( Media_Routing_Domain.MRDomainID = Skill_Group.MRDomainID) and
( Skill_Group.SkillTargetID NOT IN (SELECT BaseSkillTargetID FROM Skill_Group WHERE Priority > 0 AND Deleted != 'Y') ) and
( Agent.SkillTargetID = ASGHH.SkillTargetID ) and
( Agent.SkillTargetID = Agent_Team_Member.SkillTargetID ) and
( Agent_Team_Member.AgentTeamID = Agent_Team.AgentTeamID ) and
( ( Agent_Team_Member.AgentTeamID in ( :agtteam_list ) ) ) AND
( ASGHH.DateTime >= :start_datetime) AND
( ASGHH.DateTime <= :end_datetime)
GROUP BY
Agent_Team.EnterpriseName,
Agent_Team.PriSupervisorSkillTargetID,
Agent_Team.AgentTeamID,
Agent.SkillTargetID,
Person.LastName,
Person.FirstName,
Media_Routing_Domain.EnterpriseName,
Convert(DateTime,(Convert(Varchar(20),ASGHH.DateTime, 112))) ) AgentSkillGroup,
( SELECT
Media = Media_Routing_Domain.EnterpriseName,
AvailTime = SUM(ISNULL(AHH.AvailTime, 0)),
NotReadyTime = SUM(ISNULL(AHH.NotReadyTime,0)),
AgentSkillID = AHH.SkillTargetID,
datecol=Convert(DateTime,(Convert(Varchar(20),AHH.DateTime, 112)))
FROM
Agent,
Agent_Interval AHH,
Media_Routing_Domain
WHERE
Agent.SkillTargetID= AHH.SkillTargetID and
AHH.MRDomainID = Media_Routing_Domain.MRDomainID and
AHH.DateTime >= :start_datetime and
AHH.DateTime <= :end_datetime
GROUP BY
AHH.SkillTargetID,
Media_Routing_Domain.EnterpriseName,
Convert(DateTime,(Convert(Varchar(20),AHH.DateTime, 112))) ) AgentHour
WHERE
AgentSkillGroup.AgentSkillID = AgentHour.AgentSkillID and
AgentSkillGroup.datecol = AgentHour.datecol and
AgentSkillGroup.Media = AgentHour.Media
ORDER BY AgentSkillGroup.Agent_Team,
AgentSkillGroup.FullName,
AgentSkillGroup.AgentSkillID,
AgentSkillGroup.datecol
OPTION (MAXDOP 1)
CuicMath.sum(rows,f16)
CuicMath.sum(rows,f21)
If we can find solution for this,i need to do same modification for remaing 40 reports which are in 8.5.4 because client has a 8.5.3 version.
05-29-2012 03:41 AM
Got the solution and it is worked for me.
I have deleted the two xml tags i.e
Because these two fields are not included in cuic 8.5.3.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide