nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Can't Access Data Source Other Than Samples

gbade

Good day all,
 
I am relatively new to BIRT, having migrated from Microstrategy. I have a few questions and I am also experiencing a few challenges I wish they'd be resolved;
 
I tried uploading a report I designed in BIRT Designer Pro to BIRT iHUB F-type, but clicking the submit button doesn't bring any result. I proceeded to explore iHub, but I can only access sample reports, sample data sources. I have my SQL server connected to BIRT Designer Pro but I can't access the same for iHub. Please, how do I go about this? How do I access data sources in iHub?
 
I also found out each time I tried executing a report I designed from Designer Pro, iHub keeps returning an error - "Can't execute reports in BIRT iHub F-type"
 
 
Please, i'd really appreciate help on this as i'm running against a deadline

Find more posts tagged with

Comments

gbade

I just published a report to iHub and each time I try running it, I get a "There's an error in processing your request. Error code:17070".
 
Please I need help.

RSiegler

gbade,
 
If you open up the jsrvr log files located under $F-Type_Home$/data/server/log/ what exceptions or errors are you seeing there?
 
The Error Code: 17070 is a generic error code indicating that there was an error processing the request and the underlying errors would be in the log files.

gbade

RSiegler,
 
Hi. This is what I found in the log file:
 
Thread 32, 251] 2015-01-13 03:05:52 UTC-0800 com.actuate.reportapi.engine.birt.document.ReportDocumentManager.getReportDocument() 
WARNING: The specified report: /$$$Transient/acfile8.dashboarddocument was not found. The report appears to have expired. 
[Thread 32, 251] 2015-01-13 03:05:52 UTC-0800 com.actuate.reportapi.engine.birt.GetReportDesignTask.doTask() 
WARNING: GetReportDesignTask: class com.actuate.reportapi.enginemanager.JREMExceptioncom.actuate.reportapi.enginemanager.JREMException: Your report appears to have expired. Please refresh your browser. 
at com.actuate.reportapi.engine.birt.document.ReportDocumentManager.getReportDocument(ReportDocumentManager.java:873) 
at com.actuate.reportapi.engine.birt.document.ReportDocumentManager.getReportDocumentByTask(ReportDocumentManager.java:1052) 
at com.actuate.reportapi.engine.birt.GetReportDesignTask.getDesignFromDocumentFile(GetReportDesignTask.java:160) 
at com.actuate.reportapi.engine.birt.GetReportDesignTask.doTask(GetReportDesignTask.java:82) 
at com.actuate.reportapi.engine.Task.execute(Task.java:325) 
at com.actuate.javaserver.birt.BirtViewerReportDesignHandle.getDesignObject(BirtViewerReportDesignHandle.java:152) 
at com.actuate.iv.context.bean.IVDocumentBean.getReportDesignHandle(IVDocumentBean.java:103) 
at com.actuate.iv.context.IVServerContext.getReportDesignHandle(IVServerContext.java:474) 
at com.actuate.iv.controller.actionhandler.AbstractIVModelActionHandler.prepareExecution(AbstractIVModelActionHandler.java:807) 
at com.actuate.iv.controller.actionhandler.IVGetMetadataActionHandler.prepareExecution(IVGetMetadataActionHandler.java:137) 
at com.actuate.iv.controller.actionhandler.AbstractIVModelActionHandler.execute(AbstractIVModelActionHandler.java:514) 
at com.actuate.iv.soapengine.processor.IVComponentProcessor.executeAction(IVComponentProcessor.java:67) 
at com.actuate.iv.soapengine.processor.IVDocumentProcessor.handleGetMetadata(IVDocumentProcessor.java:365) 
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) 
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
at java.lang.reflect.Method.invoke(Method.java:606) 
at com.actuate.iv.soapengine.processor.IVComponentProcessor.process(IVComponentProcessor.java:138) 
at com.actuate.schemas.ActuateSoapBindingImpl.getIVUpdatedObjects(ActuateSoapBindingImpl.java:840) 
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) 
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
at java.lang.reflect.Method.invoke(Method.java:606) 
at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:388) 
at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:283) 
at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323) 
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32) 
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118) 
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83) 
at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:453) 
at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281) 
at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699) 
at com.actuate.iv.servlet.IVServerServlet.handleRequest(IVServerServlet.java:69) 
at com.actuate.iv.servlet.IVServerServlet.doPost(IVServerServlet.java:51) 
at javax.servlet.http.HttpServlet.service(HttpServlet.java:647) 
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327) 
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728) 
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) 
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) 
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222) 
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) 
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502) 
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) 
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100) 
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953) 
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) 
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408) 
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041) 
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:603) 
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310) 
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) 
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) 
at java.lang.Thread.run(Thread.java:744) 
[Thread 32, 251] 2015-01-13 03:05:53 UTC-0800 com.actuate.schemas.ActuateSoapBindingImpl.getIVUpdatedObjects() 
SEVERE: Cannot get report design file. Cause: Your report appears to have expired. Please refresh your browser..Cannot get report design file. Cause: Your report appears to have expired. Please refresh your browser.. 
at com.actuate.iv.context.bean.IVDocumentBean.getReportDesignHandle(IVDocumentBean.java:116) 
at com.actuate.iv.context.IVServerContext.getReportDesignHandle(IVServerContext.java:474) 
at com.actuate.iv.controller.actionhandler.AbstractIVModelActionHandler.prepareExecution(AbstractIVModelActionHandler.java:807) 
at com.actuate.iv.controller.actionhandler.IVGetMetadataActionHandler.prepareExecution(IVGetMetadataActionHandler.java:137) 
at com.actuate.iv.controller.actionhandler.AbstractIVModelActionHandler.execute(AbstractIVModelActionHandler.java:514) 
at com.actuate.iv.soapengine.processor.IVComponentProcessor.executeAction(IVComponentProcessor.java:67) 
at com.actuate.iv.soapengine.processor.IVDocumentProcessor.handleGetMetadata(IVDocumentProcessor.java:365) 
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) 
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
at java.lang.reflect.Method.invoke(Method.java:606) 
at com.actuate.iv.soapengine.processor.IVComponentProcessor.process(IVComponentProcessor.java:138) 
at com.actuate.schemas.ActuateSoapBindingImpl.getIVUpdatedObjects(ActuateSoapBindingImpl.java:840) 
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) 
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
at java.lang.reflect.Method.invoke(Method.java:606) 
at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:388) 
at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:283) 
at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323) 
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32) 
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118) 
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83) 
at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:453) 
at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281) 
at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699) 
at com.actuate.iv.servlet.IVServerServlet.handleRequest(IVServerServlet.java:69) 
at com.actuate.iv.servlet.IVServerServlet.doPost(IVServerServlet.java:51) 
at javax.servlet.http.HttpServlet.service(HttpServlet.java:647) 
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327) 
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728) 
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) 
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) 
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222) 
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) 
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502) 
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) 
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100) 
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953) 
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) 
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408) 
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041) 
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:603) 
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310) 
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) 
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) 
at java.lang.Thread.run(Thread.java:744) 
Caused by: org.eclipse.birt.report.service.api.ReportServiceException: Cannot get report design file. Cause: Your report appears to have expired. Please refresh your browser. 
at com.actuate.javaserver.birt.BirtViewerReportDesignHandle.getDesignObject(BirtViewerReportDesignHandle.java:156) 
at com.actuate.iv.context.bean.IVDocumentBean.getReportDesignHandle(IVDocumentBean.java:103) 
... 46 more 
Caused by: com.actuate.reportapi.enginemanager.JREMException: Cannot get report design file. Cause: Your report appears to have expired. Please refresh your browser. 
at com.actuate.reportapi.engine.birt.document.ReportDocumentManager.getReportDocument(ReportDocumentManager.java:873) 
at com.actuate.reportapi.engine.birt.document.ReportDocumentManager.getReportDocumentByTask(ReportDocumentManager.java:1052) 
at com.actuate.reportapi.engine.birt.GetReportDesignTask.getDesignFromDocumentFile(GetReportDesignTask.java:160) 
at com.actuate.reportapi.engine.birt.GetReportDesignTask.doTask(GetReportDesignTask.java:82) 
at com.actuate.reportapi.engine.Task.execute(Task.java:325) 
at com.actuate.javaserver.birt.BirtViewerReportDesignHandle.getDesignObject(BirtViewerReportDesignHandle.java:152) 
... 47 more 
Caused by: com.actuate.reportapi.enginemanager.JREMException: Your report appears to have expired. Please refresh your browser. 
... 53 more 
[Thread 20] 2015-01-13 04:05:01 UTC-0800 com.actuate.javaserver.HeartBeatTimer$HeartBeatTask.checkHeartbeat() 
WARNING: Effective heartbeat clock interval was: 477 seconds.

RSiegler

Can you upload the contents of the log folder here?
Snippets may not be entirely useful in debugging this scenario.

JFreeman

In addition to the log files requested by Ryan, could you also upload a sample of a report that you have created that is not working on iHub F-Type?