Buy or Renew
Buy or Renew
Cisco + Splunk: It’s a new day for your data. Learn more.
 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Start a conversation
1624
Views
0
Helpful
4
Replies

Uploding CUIC reports from 8.5.4 to 8.5.3

ram
Level 1
Level 1

‎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

Labels:
0 Helpful
4 Replies 4

david.macias
VIP
VIP

‎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

Blog
0 Helpful

santoshsunkaranam
Level 1
Level 1
In response to david.macias

‎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

0 Helpful

santoshsunkaranam
Level 1
Level 1
In response to santoshsunkaranam

‎05-28-2012 12:00 AM

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.

0 Helpful

santoshsunkaranam
Level 1
Level 1
In response to santoshsunkaranam

‎05-29-2012 03:41 AM

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.

0 Helpful
Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:

Customers Also Viewed These Support Documents