Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
ram
New Member

Uploding CUIC reports from 8.5.4 to 8.5.3

                 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

4 REPLIES

Uploding CUIC reports from 8.5.4 to 8.5.3

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

New Member

Uploding CUIC reports from 8.5.4 to 8.5.3

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

New Member

Uploding CUIC reports from 8.5.4 to 8.5.3

XML File of the Agentteam24 report:

--------------------------------------------------------

  26084C44100001371E74467F0A0101C7

  104

  GROUP_READ_EXEC_WRITE_OTHER_READ_EXEC_WRITE

  Default

  Agteam24

  Agteam24

 

  25F953651000013737B9D3FB0A0101C7

  19

  GROUP_READ_EXEC_WRITE_OTHER_READ_EXEC_WRITE

  Default

  Agteam24

  Agteam24

  CCCCCCCC00000000AAAAAAAA00000003

  ANBLCK

  SELECT

    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)

  false

  3600

  false

 

   

      2607CD8E1000013758F00C2E0A0101C7

      1

      AgentSkillGroup.BargeInCalls

      13

      DECIMAL

      BargeInCalls

      BargeInCalls

     

      false

      true

      true

      true

      false

      false

     

      12346

      SUM

     

     

     

     

     

     

     

   

   

      2607CD8E100001371B9DD90D0A0101C7

      1

      AgentSkillGroup.TotalOnHoldCalls

      20

      DECIMAL

      TotalOnHoldCalls

      TotalOnHoldCalls

     

      false

      true

      true

      true

      false

      false

     

      12346

      SUM

     

     

     

     

     

     

     

   

   

      2607CD8F10000137665181940A0101C7

      1

      AgentSkillGroup.SupAssistCalls

      10

      DECIMAL

      SupAssistCalls

      SupAssistCalls

     

      false

      true

      true

      true

      false

      false

     

      12346

      SUM

     

     

     

     

     

     

     

   

   

      2607CD8D100001377C8697EC0A0101C7

      1

      AgentSkillGroup.Handled

      16

      DECIMAL

      Handled

      Handled

     

      false

      true

      true

      true

      false

      false

     

      12346

      SUM

     

     

     

     

     

     

     

   

   

      2607CD8E100001372358CD0D0A0101C7

      1

      AgentSkillGroup.EmergencyAssist

      12

      DECIMAL

      EmergencyAssist

      EmergencyAssist

     

      false

      true

      true

      true

      false

      false

     

      12346

      SUM

     

     

     

     

     

     

     

   

   

      2607CD8E100001375C0DC0070A0101C7

      0

      AgentSkillGroup.IncomingHoldTime

      19

      DECIMAL

      IncomingHoldTime

      IncomingHoldTime

     

      false

      true

      true

      true

      false

      false

     

     

      NONE

     

     

     

     

     

     

     

   

   

      2607CD8E100001370506A3D20A0101C7

      1

      AgentSkillGroup.AbandonCallRing

      7

      DECIMAL

      AbandonCallRing

      AbandonCallRing

     

      false

      true

      true

      true

      false

      false

     

      12346

      SUM

     

     

     

     

     

     

     

   

   

      2607CD8D100001373E6FBC010A0101C7

      1

      AgentHour.NotReadyTime

      26

      DECIMAL

      NotReadyTime

      NotReadyTime

     

      false

      true

      true

      true

      false

      false

     

      Minutes and seconds (hh:mm:ss)

      SUM

     

     

     

     

     

     

     

   

   

      2607CD8F100001371C191F450A0101C7

      0

      AgentSkillGroup.AgentTeamID

      1

      DECIMAL

      AgentTeamID

      AgentTeamID

     

      false

      true

      true

      true

      false

      false

     

     

      NONE

     

     

     

     

     

     

     

   

   

      2607CD8F100001375D7CC7950A0101C7

      0

      AgentSkillGroup.datecol

      6

      DATETIME

      datecol

      datecol

     

      false

      true

      true

      true

      false

      false

     

     

      NONE

     

     

     

     

     

     

     

   

   

      2607CD8E100001371FAE295B0A0101C7

      1

      AgentSkillGroup.IncomingHoldCalls

      21

      DECIMAL

      IncomingHoldCalls

      IncomingHoldCalls

     

      false

      true

      true

      true

      false

      false

     

      12346

      SUM

     

     

     

     

     

     

     

   

   

      2607CD8E10000137537671140A0101C7

      1

      AgentSkillGroup.TalkTime

      23

      DECIMAL

      TalkTime

      TalkTime

     

      false

      true

      true

      true

      false

      false

     

      Minutes and seconds (hh:mm:ss)

      SUM

     

     

     

     

     

     

     

   

   

      2607CD8E100001374EF1A9F00A0101C7

      0

      AgentSkillGroup.FullName

      4

      STRING

      FullName

      FullName

     

      false

      true

      true

      true

      false

      false

     

     

      NONE

     

     

     

     

     

     

     

   

   

      2607CD8D100001373950C77B0A0101C7

      1

      AgentSkillGroup.ReservedTime

      27

      DECIMAL

      ReservedTime

      ReservedTime

     

      false

      true

      true

      true

      false

      false

     

      Minutes and seconds (hh:mm:ss)

      SUM

     

     

     

     

     

     

     

   

   

      2607CD8E1000013747A930FC0A0101C7

      0

      AgentSkillGroup.AgentSkillID

      5

      DECIMAL

      AgentSkillID

      AgentSkillID

     

      false

      true

      true

      true

      false

      false

     

     

      NONE

     

     

     

     

     

     

     

   

   

      2607CD8E100001375FB1A9A60A0101C7

      3

      ISNULL(Handletime / nullif((Handled),0), 0)

      17

      DECIMAL

      AHT

      AHT

     

      false

      true

      true

      true

      false

      false

     

      Minutes and seconds (hh:mm:ss)

      CUSTOMFORMULA

      CuicMath.sum(rows,f15) /

CuicMath.sum(rows,f16)

     

     

     

     

     

     

   

   

      2607CD8E100001371135D0930A0101C7

      0

      AgentSkillGroup.BusyOtherTime

      29

      DECIMAL

      BusyOtherTime

      BusyOtherTime

     

      false

      true

      true

      true

      false

      false

     

     

      NONE

     

     

     

     

     

     

     

   

   

      2607CD8E10000137267823EB0A0101C7

      1

      AgentSkillGroup.AbandonCallHold

      9

      DECIMAL

      AbandonCallHold

      AbandonCallHold

     

      false

      true

      true

      true

      false

      false

     

      12346

      SUM

     

     

     

     

     

     

     

   

   

      2607CD8D10000137024083E50A0101C7

      1

      AgentSkillGroup.WrapTime

      28

      DECIMAL

      WrapTime

      WrapTime

     

      false

      true

      true

      true

      false

      false

     

      Minutes and seconds (hh:mm:ss)

      SUM

     

     

     

     

     

     

     

   

   

      2607CD8F1000013742128B690A0101C7

      1

      AgentSkillGroup.SupAssistCallsTime

      11

      DECIMAL

      SupAssistCallsTime

      SupAssistCallsTime

     

      false

      true

      true

      true

      false

      false

     

      Minutes and seconds (hh:mm:ss)

      SUM

     

     

     

     

     

     

     

   

   

      2607CD8E100001373EEA493E0A0101C7

      0

      AgentSkillGroup.Media

      3

      STRING

      Media

      Media

     

      false

      true

      true

      true

      false

      false

     

     

      NONE

     

     

     

     

     

     

     

   

   

      2607CD8E100001373917F5570A0101C7

      1

      AgentSkillGroup.TotalOnHoldTime

      18

      DECIMAL

      TotalOnHoldTime

      TotalOnHoldTime

     

      false

      true

      true

      true

      false

      false

     

      Minutes and seconds (hh:mm:ss)

      SUM

     

     

     

     

     

     

     

   

   

      2607CD8E100001377CEC9C230A0101C7

      1

      AgentSkillGroup.HoldTime

      25

      DECIMAL

      HoldTime

      HoldTime

     

      false

      true

      true

      true

      false

      false

     

      Minutes and seconds (hh:mm:ss)

      SUM

     

     

     

     

     

     

     

   

   

      2607CD8D100001372BD668CB0A0101C7

      4

      ISNULL(IncomingHoldTime / nullif((IncomingHoldCalls),0), 0)

      22

      DECIMAL

      AHoldT

      AHoldT

     

      false

      true

      true

      true

      false

      false

     

      Minutes and seconds (hh:mm:ss)

      CUSTOMFORMULA

      CuicMath.sum(rows,f19) /

CuicMath.sum(rows,f21)

     

     

     

     

     

     

   

   

      2607CD8D100001376CE4CC560A0101C7

      0

      AgentSkillGroup.Agent_Team

      0

      STRING

      Agent_Team

      Agent_Team

     

      false

      true

      true

      true

      false

      false

     

     

      NONE

     

     

     

     

     

     

     

   

   

      2607CD8E1000013768DFC32E0A0101C7

      0

      AgentSkillGroup.Supervisor

      2

      STRING

      Supervisor

      Supervisor

     

      false

      true

      true

      true

      false

      false

     

     

      NONE

     

     

     

     

     

     

     

   

   

      2607CD8E100001371008C1260A0101C7

      1

      AgentSkillGroup.RedirectNoAnswer

      8

      DECIMAL

      RedirectNoAnswer

      RedirectNoAnswer

     

      false

      true

      true

      true

      false

      false

     

      12346

      SUM

     

     

     

     

     

     

     

   

   

      2607CD8E1000013731284F5E0A0101C7

      0

      AgentSkillGroup.Handletime

      15

      DECIMAL

      Handletime

      Handletime

     

      false

      true

      true

      true

      false

      false

     

     

      NONE

     

     

     

     

     

     

     

   

   

      2607CD8E100001373283DB440A0101C7

      1

      AgentSkillGroup.InterceptCalls

      14

      DECIMAL

      InterceptCalls

      InterceptCalls

     

      false

      true

      true

      true

      false

      false

     

      12346

      SUM

     

     

     

     

     

     

     

   

   

      2607CD8E100001370701899D0A0101C7

      1

      AgentHour.AvailTime

      24

      DECIMAL

      AvailTime

      AvailTime

     

      false

      true

      true

      true

      false

      false

     

      Minutes and seconds (hh:mm:ss)

      SUM

     

     

     

     

     

     

     

   

 

 

   

      2607CD8F1000013716561B2E0A0101C7

      0

      1

      DATETIME

     

      @start_datetime

      true

     

      false

      ,

      @start_datetime

     

     

      false

     

   

   

      2607CD8F1000013757D1B6EA0A0101C7

      0

      0

      DECIMAL

     

      @agtteam_list

     

  CCCCCCCC00000000DDDDDDDD00000002

  3

  GROUP_READ_EXEC_WRITE_OTHER_READ_EXEC_WRITE

  Default

  SELECT Agent_Team.AgentTeamID AS ID, Agent_Team.EnterpriseName AS VALUE FROM Agent_Team (nolock) ORDER BY Agent_Team.EnterpriseName ASC

 

  SELECT DISTINCT Agent_Team.AgentTeamID AS ID, Agent_Team.EnterpriseName AS VALUE FROM Agent_Team (nolock), Agent_Team_Member (nolock), Agent_Team_Supervisor (nolock) WHERE ( Agent_Team.AgentTeamID = Agent_Team_Member.AgentTeamID) and (Agent_Team_Member.AgentTeamID = Agent_Team_Supervisor.AgentTeamID ) and ( ( Agent_Team_Supervisor.SupervisorSkillTargetID = <COLLECTIONIDENTIFIER> ) ) ORDER BY Agent_Team.EnterpriseName ASC

  [CUIC.Template.Agent_Teams.description]

  [CUIC.Template.Agent_Teams]

  CCCCCCCC00000000AAAAAAAA00000003

  STOCK

      true

     

      false

      ,

      @agtteam_list

     

     

      false

     

   

   

      2607CD8F100001372ED1121A0A0101C7

      0

      2

      DATETIME

     

      @end_datetime

      true

     

      false

      ,

      @end_datetime

     

     

      false

     

   

 

 

 

 

 

  false

  0

  false

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         

 

   

      26084C5910000137048842E20A0101C7

      18

     

      Agteam24

      Agteam24

      true

      1

      10

      2

      0

      0

      26084C7D10000137734E29B80A0101C7

      26084C7C1000013706A83D2E0A0101C7

      true

      true

      false

      18

     

       

          26084C7D10000137244EC1A00A0101C7

          3

          70

         

          2607CD8E1000013731284F5E0A0101C7

          true

          Handletime

          -1

         

       

       

          26084C7C10000137544157D00A0101C7

          2

          70

         

          2607CD8D100001373950C77B0A0101C7

          true

          Reserved Time

          -1

         

       

       

          26084C7D10000137696417DC0A0101C7

          3

          70

         

          2607CD8E10000137267823EB0A0101C7

          true

          Aban Hold

          8

         

       

       

          26084C7D10000137518D2A140A0101C7

          2

          70

         

          2607CD8E10000137537671140A0101C7

          true

          Active Time

          -1

         

       

       

          26084C7C1000013765C248FA0A0101C7

          1

          70

         

          2607CD8E100001375C0DC0070A0101C7

          true

          IncomingHoldTime

          -1

         

       

       

          26084C7D1000013706E82BA60A0101C7

          3

          70

         

          2607CD8E100001372358CD0D0A0101C7

          true

          Emerg Assist

          11

         

       

       

          26084C7D100001375AFB95810A0101C7

          3

          70

         

          2607CD8E100001371B9DD90D0A0101C7

          true

          TotalOnHoldCalls

          -1

         

       

       

          26084C7C1000013756FAE75A0A0101C7

          3

          70

         

          2607CD8F1000013742128B690A0101C7

          true

          Sup Assist Time

          10

         

       

       

        26084C7C1000013706A83D2E0A0101C7

        2

        70

       

        2607CD8E1000013768DFC32E0A0101C7

        true

        Supervisor

        1

       

     

       

          26084C7C1000013779551E840A0101C7

          2

          70

         

          2607CD8E100001373EEA493E0A0101C7

          true

          Media

          2

         

       

       

          26084C7D1000013753E941820A0101C7

          2

          70

         

          2607CD8E100001371FAE295B0A0101C7

          true

          Held Tasks

          -1

         

       

       

          26084C7D100001372BB3FC590A0101C7

          2

          70

         

          2607CD8D100001372BD668CB0A0101C7

          true

          Avg Hold Time

          -1

         

       

       

          26084C7C1000013736A172B80A0101C7

          3

          70

         

          2607CD8E1000013758F00C2E0A0101C7

          true

          Barge In

          12

         

       

       

          26084C7D100001377658FAC60A0101C7

          2

          70

         

          2607CD8D100001373E6FBC010A0101C7

          true

          Not Ready Time

          -1

         

       

       

          26084C7C100001374709E0B20A0101C7

          3

          70

         

          2607CD8E100001371008C1260A0101C7

          true

          Redirect No Answer

          7

         

       

       

          26084C7C1000013745F999750A0101C7

          3

          70

         

          2607CD8F100001371C191F450A0101C7

          true

          AgentTeamID

          -1

         

       

       

          26084C7C1000013754F1B6A50A0101C7

          1

          70

         

          2607CD8F100001375D7CC7950A0101C7

          true

          datecol

          -1

         

       

       

          26084C7D1000013725A093EE0A0101C7

          3

          70

         

          2607CD8E100001373917F5570A0101C7

          true

          TotalOnHoldTime

          -1

         

       

       

          26084C7C1000013707F206ED0A0101C7

          3

          70

         

          2607CD8E100001370506A3D20A0101C7

          true

          Aban Ring

          6

         

       

       

          26084C7C10000137672AA6850A0101C7

          1

          70

         

          2607CD8E100001375FB1A9A60A0101C7

          true

          AHT

          -1

         

       

       

          26084C7D1000013728A92B4B0A0101C7

          1

          70

         

          2607CD8E100001371135D0930A0101C7

          true

          BusyOtherTime

          -1

         

       

       

        26084C7D10000137734E29B80A0101C7

        2

        70

       

        2607CD8D100001376CE4CC560A0101C7

        true

        Agent_Team

        0

       

     

       

          26084C7D100001372740CDC00A0101C7

          2

          70

         

          2607CD8E100001370701899D0A0101C7

          true

          Not Active Time

          -1

         

       

       

          26084C7C100001370695673B0A0101C7

          2

          70

         

          2607CD8E100001377CEC9C230A0101C7

          true

          Hold Time

          -1

         

       

       

          26084C7D1000013718264BBA0A0101C7

          2

          70

         

          2607CD8D10000137024083E50A0101C7

          true

          Wrap Up Time

          -1

         

       

       

          26084C7D100001375D3ECB180A0101C7

          3

          70

         

          2607CD8F10000137665181940A0101C7

          true

          Sup Assist

          9

         

       

       

          26084C7D100001372A575CA70A0101C7

          1

          70

         

          2607CD8E1000013747A930FC0A0101C7

          true

          AgentSkillID

          -1

         

       

       

          26084C7D1000013715D758490A0101C7

          2

          70

         

          2607CD8E100001374EF1A9F00A0101C7

          true

          Agent Name

          3

         

       

       

          26084C7C10000137357D31AE0A0101C7

          3

          70

         

          2607CD8E100001373283DB440A0101C7

          true

          Intercept

          13

         

       

       

          26084C7D100001374C1CB82D0A0101C7

          1

          70

         

          2607CD8D100001377C8697EC0A0101C7

          true

          Handled

          -1

         

       

     

     

       

          30A38BA9100001374EE3BE0D0A0101C7

          8

         

           

              3BCFED86100001376D2BFEAD0A0101C7

              0

              26084C7C10000137672AA6850A0101C7

              1

             

           

           

              30A38BBB10000137021F70020A0101C7

              0

              26084C7D100001374C1CB82D0A0101C7

              0

             

           

         

         

          Incoming

          4

       

       

          30AC64E3100001370CEA1C030A0101C7

          12

         

           

              3BB568B310000137341F774F0A0101C7

              0

              26084C7D100001372BB3FC590A0101C7

              1

             

           

           

              3BB568B0100001372CC52F5A0A0101C7

              0

              26084C7D1000013753E941820A0101C7

              0

             

           

         

         

          Incoming Hold Tasks

          5

       

       

          30EABE8B100001373048DDD40A0101C7

          7

         

           

              30EABE9B10000137193A1A010A0101C7

              0

              26084C7D1000013718264BBA0A0101C7

              5

             

           

           

              30EABE911000013704EDA24D0A0101C7

              0

              26084C7D100001377658FAC60A0101C7

              3

             

           

           

              30EABE961000013764A1DF450A0101C7

              0

              26084C7D100001372740CDC00A0101C7

              1

             

           

           

              30EABE93100001377244878F0A0101C7

              0

              26084C7C100001370695673B0A0101C7

              2

             

           

           

              30EABE9810000137334628EC0A0101C7

              0

              26084C7D10000137518D2A140A0101C7

              0

             

           

           

              30EABE9D100001377E080C4E0A0101C7

              0

              26084C7C10000137544157D00A0101C7

              4

             

           

         

         

          Agent State Times

          14

       

     

   

 

 

 

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.

New Member

Uploding CUIC reports from 8.5.4 to 8.5.3

Got the solution and it is worked for me.

I have deleted the two xml tags i.e from report xml.

Because these two fields are not included in cuic 8.5.3.

1259
Views
0
Helpful
4
Replies
CreatePlease to create content