CA Service Management

Expand all | Collapse all

Out of Box Active Request Aging Report Not Running

  • 1.  Out of Box Active Request Aging Report Not Running

    Posted Aug 21, 2017 12:11 AM

    Hi Team,

     

    I have setup CABI Jaspersoft r6.2 with CA SDM 17.0. Whenever I create a user under servicemanagement organization with out of box role Role_User and trying to run out of box Active Request Aging report. It is not showing output and keeps on loading it. It is not showing any error either. Although other out of box reports like Active Incidents/Active Incidents Aging etc are running fine.

     

     

    Even after explicitly setting the permission of the user to Administer for the Active Request Aging report only, it is not able to run that report.

     

    Can anyone confirm whether same issue is occurring in their environment as well? Is it a known bug?

     

    Note: With superuser, I am able to run the Active Request Aging report successfully.

     

    Thanks & Regards,

    Balram 



  • 2.  Re: Out of Box Active Request Aging Report Not Running

    Posted Aug 21, 2017 07:56 AM

    Hi Balram,

    In the sdm_ds data source in jasper, do you have the username and password set to the user attribute (placeholders) or do you have it set to "ServiceDesk" with the appropriate password?  

    Can you share a screenshot of your data source?

    Thanks,

    Jon I.



  • 3.  Re: Out of Box Active Request Aging Report Not Running

    Posted Aug 22, 2017 12:05 AM

    Hi Jon,

     

    I have provided the username and password of ServiceDesk user in sdm_ds configuration. Here is the screenshot of the configuration for your reference:

     

    It is causing issue in only one out of box report (Active Request Aging) and that report is also running fine with superuser. Even other similar reports under Aging folder of Requests directory are running fine.

     

    What can be the reason for this? Do I need to change the username and password to user attributes instead of ServiceDesk user?

     

    Thanks & Regards,

    Balram



  • 4.  Re: Out of Box Active Request Aging Report Not Running

    Posted Aug 22, 2017 08:39 AM

    Ok so its only when you log in as a non "superuser" account that the problem happens?    To explain a bit about the user attributes - basically what that does is allow you to pass the user's Service Desk userid and password to Service Desk via the data source, so that the data partition constraints for that user are enforced when the data comes back from Service Desk into the Jasper report.  In order to set that up, you would have to have each user created in Jasper under the servicemanagmeent organization, and then you would need to have each user log in and run the Service Desk User Authorization report, which would then populate the attributes with the Service Desk userid and password for that user, on that user's jasper account (thus it can then be passed to the data source when that user runs reports).

    However, in your case, since its only happening to this one report, that seems to not be the problem here because it would affect all reports - and you should be able to run any report as any user if the data source is set to log into SDM as the "servicedesk" account.  SO, I dont think you need to set up the user attributes to fix this one.  Its really odd to be honest - strange that when logging in as a user other than superuser, that you can run all other reports but this particular one.  I would check the jasperserver.log file at the point when it hangs on that report.  See if there are any error messages in there and share the snippet of the error here if there are any.

    Let us know,

    Thanks,

    Jon I.



  • 5.  Re: Out of Box Active Request Aging Report Not Running

    Posted Aug 23, 2017 12:19 AM

    Hi Jon,

     

    Most of the times, the report just keeps on loading and loading without any error. On one occasion, it gave the following error on CABI console:

     

    It is saying that the resource do not belong to the user's organization. But the organization of user is servicemanagement itself and he is able to run other out of box reports successfully.

     

    Kindly suggest.

     

    Thanks & Regards,

    Balram



  • 6.  Re: Out of Box Active Request Aging Report Not Running

    Posted Aug 23, 2017 12:28 AM

    Hi Jon,

     

    In the jasperserver.log file, it is generating the following error:

     

    2017-08-23 09:53:29,556 ERROR errorPage_jsp,http-bio-8090-exec-407:313 - JSException:
    2017-08-23 09:53:29,558 ERROR errorPage_jsp,http-bio-8090-exec-407:617 - stack trace of exception that redirected to errorPage.jsp
    com.jaspersoft.jasperserver.multipleTenancy.MTResourceNotVisibleException: You may not access resources which do not belong to your organization.
    Arguments:
    at com.jaspersoft.jasperserver.multipleTenancy.DefaultPathTransformer.toExternalPath(DefaultPathTransformer.java:150)
    at com.jaspersoft.jasperserver.multipleTenancy.DefaultPathTransformer$2.transformPath(DefaultPathTransformer.java:56)
    at com.jaspersoft.jasperserver.multipleTenancy.UriPathTransformationWrapper.transformPath(UriPathTransformationWrapper.java:38)
    at com.jaspersoft.jasperserver.multipleTenancy.MTReportExecutionHyperlinkProducerFactory$MTHyperlinkProducer.getParameterReportURI(MTReportExecutionHyperlinkProducerFactory.java:161)
    at com.jaspersoft.jasperserver.api.engine.jasperreports.util.BaseReportExecutionHyperlinkProducerFactory$BaseHyperlinkProducer.appendParameters(BaseReportExecutionHyperlinkProducerFactory.java:95)
    at com.jaspersoft.jasperserver.api.engine.jasperreports.util.BaseReportExecutionHyperlinkProducerFactory$BaseHyperlinkProducer.getHyperlink(BaseReportExecutionHyperlinkProducerFactory.java:81)
    at com.jaspersoft.jasperserver.war.action.hyperlinks.ReportExecutionHyperlinkProducerFactory$HyperlinkProducer.getHyperlink(ReportExecutionHyperlinkProducerFactory.java:76)
    at net.sf.jasperreports.engine.export.HtmlExporter.resolveHyperlinkURL(HtmlExporter.java:2036)
    at net.sf.jasperreports.engine.export.HtmlExporter.getHyperlinkURL(HtmlExporter.java:1961)
    at net.sf.jasperreports.engine.export.HtmlExporter$ExporterContext.getHyperlinkURL(HtmlExporter.java:2627)
    at com.jaspersoft.jasperreports.util.ChartDataSettingOutput.toJsonHyperlinkValue(ChartDataSettingOutput.java:216)
    at com.jaspersoft.jasperreports.util.ChartDataSettingOutput.toJsonModelPropertyValue(ChartDataSettingOutput.java:196)
    at com.jaspersoft.jasperreports.util.ChartDataSettingOutput.setDataProperties(ChartDataSettingOutput.java:180)
    at com.jaspersoft.jasperreports.util.ChartDataSettingOutput.addSeries(ChartDataSettingOutput.java:162)
    at com.jaspersoft.jasperreports.highcharts.charts.settings.ChartDataSettingService.perform(ChartDataSettingService.java:87)
    at com.jaspersoft.jasperreports.highcharts.charts.StandardPrintChartCreator.performService(StandardPrintChartCreator.java:99)
    at com.jaspersoft.jasperreports.highcharts.charts.StandardPrintChartCreator.getPrintChart(StandardPrintChartCreator.java:76)
    at com.jaspersoft.jasperreports.highcharts.charts.ChartHtmlHandler.generateChartHtml(ChartHtmlHandler.java:81)
    at com.jaspersoft.jasperreports.highcharts.charts.ChartHtmlHandler.getHtmlFragment(ChartHtmlHandler.java:63)
    at net.sf.jasperreports.engine.export.HtmlExporter.writeGenericElement(HtmlExporter.java:1425)
    at net.sf.jasperreports.engine.export.HtmlExporter$CellElementVisitor.visit(HtmlExporter.java:2614)
    at net.sf.jasperreports.engine.export.HtmlExporter$CellElementVisitor.visit(HtmlExporter.java:2528)
    at net.sf.jasperreports.engine.fill.JRTemplateGenericPrintElement.accept(JRTemplateGenericPrintElement.java:163)
    at net.sf.jasperreports.engine.export.HtmlExporter$TableVisitor.visit(HtmlExporter.java:2499)
    at net.sf.jasperreports.engine.export.HtmlExporter$TableVisitor.visit(HtmlExporter.java:2483)
    at net.sf.jasperreports.engine.export.tabulator.ElementCell.accept(ElementCell.java:56)
    at net.sf.jasperreports.engine.export.HtmlExporter.exportTable(HtmlExporter.java:590)
    at net.sf.jasperreports.engine.export.HtmlExporter.exportPage(HtmlExporter.java:493)
    at net.sf.jasperreports.engine.export.HtmlExporter.exportReportToWriter(HtmlExporter.java:385)
    at net.sf.jasperreports.engine.export.HtmlExporter.exportReport(HtmlExporter.java:239)
    at org.apache.jsp.WEB_002dINF.jsp.modules.viewReport.DefaultJasperViewer_jsp._jspService(DefaultJasperViewer_jsp.java:301)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:439)
    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:743)
    at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:603)
    at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:542)
    at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:905)
    at org.apache.jasper.runtime.PageContextImpl.include(PageContextImpl.java:656)
    at com.jaspersoft.jasperserver.war.tags.JasperViewerTag.doEndTag(JasperViewerTag.java:272)
    at org.apache.jsp.WEB_002dINF.jsp.modules.viewReport.reportOutput_jsp._jspx_meth_js_005fjasperviewer_005f0(reportOutput_jsp.java:148)
    at org.apache.jsp.WEB_002dINF.jsp.modules.viewReport.reportOutput_jsp._jspService(reportOutput_jsp.java:96)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:439)
    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:43)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:743)
    at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:485)
    at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:410)
    at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:337)
    at org.springframework.web.servlet.view.InternalResourceView.renderMergedOutputModel(InternalResourceView.java:238)
    at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:264)
    at org.springframework.webflow.mvc.servlet.ServletMvcView.doRender(ServletMvcView.java:50)
    at org.springframework.webflow.mvc.view.AbstractMvcView.render(AbstractMvcView.java:187)
    at org.springframework.webflow.engine.ViewState.render(ViewState.java:296)
    at org.springframework.webflow.engine.ViewState.doEnter(ViewState.java:186)
    at org.springframework.webflow.engine.State.enter(State.java:194)
    at org.springframework.webflow.engine.Transition.execute(Transition.java:227)
    at org.springframework.webflow.engine.impl.FlowExecutionImpl.execute(FlowExecutionImpl.java:393)
    at org.springframework.webflow.engine.impl.RequestControlContextImpl.execute(RequestControlContextImpl.java:214)
    at org.springframework.webflow.engine.TransitionableState.handleEvent(TransitionableState.java:119)
    at org.springframework.webflow.engine.Flow.handleEvent(Flow.java:555)
    at org.springframework.webflow.engine.impl.FlowExecutionImpl.handleEvent(FlowExecutionImpl.java:388)
    at org.springframework.webflow.engine.impl.RequestControlContextImpl.handleEvent(RequestControlContextImpl.java:210)
    at org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:105)
    at org.springframework.webflow.engine.State.enter(State.java:194)
    at org.springframework.webflow.engine.Transition.execute(Transition.java:227)
    at org.springframework.webflow.engine.impl.FlowExecutionImpl.execute(FlowExecutionImpl.java:393)
    at org.springframework.webflow.engine.impl.RequestControlContextImpl.execute(RequestControlContextImpl.java:214)
    at org.springframework.webflow.engine.TransitionableState.handleEvent(TransitionableState.java:119)
    at org.springframework.webflow.engine.Flow.handleEvent(Flow.java:555)
    at org.springframework.webflow.engine.impl.FlowExecutionImpl.handleEvent(FlowExecutionImpl.java:388)
    at org.springframework.webflow.engine.impl.RequestControlContextImpl.handleEvent(RequestControlContextImpl.java:210)
    at org.springframework.webflow.engine.ViewState.handleEvent(ViewState.java:232)
    at org.springframework.webflow.engine.ViewState.resume(ViewState.java:196)
    at org.springframework.webflow.engine.Flow.resume(Flow.java:545)
    at org.springframework.webflow.engine.impl.FlowExecutionImpl.resume(FlowExecutionImpl.java:261)
    at org.springframework.webflow.executor.FlowExecutorImpl.resumeExecution(FlowExecutorImpl.java:169)
    at sun.reflect.GeneratedMethodAccessor479.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    at org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:64)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    at com.sun.proxy.$Proxy145.resumeExecution(Unknown Source)
    at org.springframework.webflow.mvc.servlet.FlowHandlerAdapter.handle(FlowHandlerAdapter.java:183)
    at org.springframework.webflow.mvc.servlet.FlowController.handleRequest(FlowController.java:174)
    at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
    at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:919)
    at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:851)
    at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:953)
    at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:855)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
    at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:829)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at com.jaspersoft.jasperserver.war.StaticFilesCacheControlFilter.doFilter(StaticFilesCacheControlFilter.java:161)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
    at com.jaspersoft.jasperserver.api.security.IPadSupportFilter.doFilter(IPadSupportFilter.java:67)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at com.jaspersoft.jasperserver.war.common.JSSwitchUserProcessingFilter.doFilter(JSSwitchUserProcessingFilter.java:157)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
    at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
    at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)
    at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:143)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at com.ca.jasper.authentication.JaaSProxyAuthenticationFilter.doFilter(JaaSProxyAuthenticationFilter.java:183)
    at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)
    at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at com.jaspersoft.jasperserver.multipleTenancy.MTBasicProcessingFilter.doFilter(MTBasicProcessingFilter.java:194)
    at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)
    at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:217)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199)
    at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)
    at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at com.jaspersoft.ji.license.LicenseCheckFilter.doFilter(LicenseCheckFilter.java:103)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at com.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.java:86)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at com.jaspersoft.jasperserver.war.NullFilter.doFilter(NullFilter.java:43)
    at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)
    at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at com.ca.jasper.ext.filter.ExternalAuthenticationProxyFilter.doFilter(ExternalAuthenticationProxyFilter.java:77)
    at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)
    at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:217)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:57)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at com.jaspersoft.jasperserver.api.security.JSCsrfGuardFilter.doFilter(JSCsrfGuardFilter.java:83)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at com.jaspersoft.jasperserver.api.security.WebAppSecurityFilter.doFilter(WebAppSecurityFilter.java:80)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at com.jaspersoft.jasperserver.war.MultipartRequestWrapperFilter.doFilter(MultipartRequestWrapperFilter.java:95)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at com.jaspersoft.jasperserver.war.NullFilter.doFilter(NullFilter.java:43)
    at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)
    at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at com.jaspersoft.jasperserver.api.security.encryption.EncryptionFilter.doFilter(EncryptionFilter.java:150)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at com.ca.jasper.filters.BasicRefererBasedCsrfFilter.doFilter(BasicRefererBasedCsrfFilter.java:136)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
    at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
    at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)
    at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at com.jaspersoft.jasperserver.war.util.SessionDecoratorFilter.doFilter(SessionDecoratorFilter.java:63)
    at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)
    at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67)
    at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)
    at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at com.jaspersoft.jasperserver.war.P3PFilter.doFilter(P3PFilter.java:43)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:615)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1115)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
    at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    at java.lang.Thread.run(Unknown Source)
    Caused by: com.jaspersoft.jasperserver.multipleTenancy.MTResourceNotVisibleException: Path /organizations/servicemanagement"/organizations/servicemanagement/capability/reports/CA_Service_Desk/Incident_and_Problem_Management/Aging/Active_Incidents_Aging" is not visible in organization context Multitenancy context: organization servicemanagement
    Arguments:
    at com.jaspersoft.jasperserver.multipleTenancy.DefaultPathTransformer.toExternalPath(DefaultPathTransformer.java:147)
    ... 216 more



  • 7.  Re: Out of Box Active Request Aging Report Not Running
    Best Answer

    Posted Aug 23, 2017 01:44 PM

    Can you delete the servicemanagement organization and re-create it and reload the content?



  • 8.  Re: Out of Box Active Request Aging Report Not Running

    Posted Aug 24, 2017 12:46 AM

    Hi Steve,

     

    There are some custom reports present in this organization. By reloading the content, you mean to first export the content (export everything option), delete the organization and then import that content again?

     

    Thanks & Regards,

    Balram



  • 9.  Re: Out of Box Active Request Aging Report Not Running

    Posted Aug 25, 2017 12:01 AM

    Export current content so you don't lose custom content and reload OOTB content and check if that works.  

     

    If it does work delete the servicemangement org again and import from the export containing the customers content.



  • 10.  Re: Out of Box Active Request Aging Report Not Running

    Posted Aug 25, 2017 07:23 AM

    Hi Steve,

     

    After reloading the OOTB content (without deleting the servicemanagement organization, I imported it and modified the sdm_ds ServiceDesk credentials), the issue got fixed.

     

    After import, my custom content is still present and running fine (as the organization was not deleted). Do I need to import the custom data backup again?

     

    Thanks & Regards,

    Balram



  • 11.  Re: Out of Box Active Request Aging Report Not Running

    Posted Aug 25, 2017 02:31 PM

    Good to hear things are working.   I wouldn't do anything else as long as everything is working.  

     

    Not sure why a re-import fixed it but all indications was that it was some type of permissions problem and I was hoping that a re-import would solve it and sure enough it did.