The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday noon (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday noon (PST)
Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

SLA reports internal error

Highlighted
Marija7
Occasional Contributor

SLA reports internal error

Hi,
I have this problem when I try to open any SLA report, I get this error: An internal error has occurred.
Apache Tomcat/5.5.20
In C:\HPBAC\log\EJBContainer\reports.log I get this:
2009-06-01 13:03:05,142 [TP-Processor1] (GenerateAction.java:50) ERROR - MERQ-120319: caught RFWException (user Exception) in action.
GenerateAction=com.mercury.am.bac.core.reports.standard.RFWException: com.mercury.bac.slm.reports.common.SlmReportException: Failed to retrive data from GDE. The following error occured:
Error code: 7
Error Message: Execution Error:: [mercury][Oracle JDBC Driver]No more data available to read.
2009-06-01 13:03:05,142 [TP-Processor16] (GenerateAction.java:50) ERROR - MERQ-120319: caught RFWException (user Exception) in action.
GenerateAction=com.mercury.am.bac.core.reports.standard.RFWException: com.mercury.bac.slm.reports.common.SlmReportException: Failed to retrive data from GDE. The following error occured:
Error code: 7
Error Message: Execution Error:: [mercury][Oracle JDBC Driver]No more data available to read.
2009-06-01 13:03:05,142 [TP-Processor7] (RFWExceptionHandler.java:37) ERROR - MERQ-121006: Exception was thrown in Reports Framework
com.mercury.am.bac.core.reports.standard.RFWException: com.mercury.bac.slm.reports.common.SlmReportException: Failed to retrive data from GDE. The following error occured:
Error code: 7
Error Message: Execution Error:: [mercury][Oracle JDBC Driver]No more data available to read.
at com.mercury.bac.slm.reports.definition.itemsSummary.ItemSummaryDataGenerator.generateData(ItemSummaryDataGenerator.java:57)
at com.mercury.am.bac.core.reports.venus.defmgr.DistributedReportDefinition.generateData(DistributedReportDefinition.java:90)
at com.mercury.am.bac.core.reports.venus.statemgr.ReportState.generateData(ReportState.java:345)
at com.mercury.am.bac.core.reports.venus.statemgr.ReportStateManager.generateReport(ReportStateManager.java:239)
at com.mercury.am.bac.core.reports.venus.controller.RFWController.generateReport(RFWController.java:171)
at com.mercury.am.bac.core.reports.venus.servlet.actions.GenerateAction.execute(GenerateAction.java:47)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:463)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:398)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1056)
at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:388)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:231)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:463)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:398)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1056)
at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:388)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:231)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:463)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:398)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1056)
at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:388)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:231)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.mercury.bac.ha.centers.HALoginStateFilter.doFilter(HALoginStateFilter.java:122)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.mercury.topaz.webinfra.filters.NoCacheFilter.doFilter(NoCacheFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.mercury.am.bac.core.ui.utils.gzip.GZipServletFilter.doFilter(GZipServletFilter.java:77)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.mercury.am.bac.core.ui.utils.trim.TrimFilter.doFilter(TrimFilter.java:45)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.mercury.topaz.webinfra.filters.UserStatsLogFilter.doFilter(UserStatsLogFilter.java:101)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.mercury.topaz.reportsExt.login.BacSsoFilter.doFilter(BacSsoFilter.java:200)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.mercury.topaz.reportsExt.login.BacSsoFilter.doFilter(BacSsoFilter.java:200)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.hp.sw.bto.ast.security.lwsso.LWSSOFilter.doFilter(LWSSOFilter.java:86)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.mercury.j2f.j2eeutils.GZipSetCharacterEncodingFilter.doFilter(GZipSetCharacterEncodingFilter.java:189)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
Caused by: com.mercury.bac.slm.reports.common.SlmReportException: Failed to retrive data from GDE. The following error occured:
Error code: 7
Error Message: Execution Error:: [mercury][Oracle JDBC Driver]No more data available to read.
at com.mercury.bac.slm.reports.util.DataRetrievalUtil.query(DataRetrievalUtil.java:690)
at com.mercury.bac.slm.reports.generator.core.dataretrieval.rawdata.DataRetrievalManager.retrieveData(DataRetrievalManager.java:108)
at com.mercury.bac.slm.reports.generator.rfw.impl.generator.AggregatedDataGenerator.generateData(AggregatedDataGenerator.java:153)
at com.mercury.bac.slm.reports.definition.itemsSummary.ItemSummaryDataGenerator.generateData(ItemSummaryDataGenerator.java:52)
... 97 more
2009-06-01 13:03:05,142 [TP-Processor8] (RFWExceptionHandler.java:37) ERROR - MERQ-121006: Exception was thrown in Reports Framework
com.mercury.am.bac.core.reports.standard.RFWException: com.mercury.bac.slm.reports.common.SlmReportException: Failed to retrive data from GDE. The following error occured:
Error code: 7
Error Message: Execution Error:: [mercury][Oracle JDBC Driver]No more data available to read.
at com.mercury.bac.slm.reports.definition.itemsSummary.ItemSummaryDataGenerator.generateData(ItemSummaryDataGenerator.java:57)
at com.mercury.am.bac.core.reports.venus.defmgr.DistributedReportDefinition.generateData(DistributedReportDefinition.java:90)
1 REPLY
Marija7
Occasional Contributor

Re: SLA reports internal error

I'd appreciate your help:)
//Add this to "OnDomLoad" event