jbbaird

April 29, 2007

Thanks - what you described will go a long way towards acceptance as a BI tool set, not just reporting.

April 29, 2007

Any update on time horizon info available on the Semantic layer ... I prefer many things about Jasper but am leaning towards Pentaho for this reason.

Thanks

January 30, 2007

Any thoughts on this???

January 11, 2007

Any straight forward way come to mind to use the file system directory structure as the data source for a report?

The body of the report should look like:

Directory

Sub-directory

Thanks for any suggestions!

January 11, 2007

Is it possible to add static docs (pdf, xls) to the repository through the JasperIntelligence UI?

These should be avaialble to users alonside jasperreports?

Thanks!

November 4, 2006

I have a BigDecimal Field (RUN_ERR_CODE) with a value of 0 or a positive integer ...

I am trying to "print when expression" on

new Boolean ($F{RUN_ERR_CODE}.intValue()!=0)

To display when it is non zero - any guesses at why this doesn't work?

Thanks

November 1, 2006

How can the credentials be sent to bypass the login page?

Thanks

October 25, 2006

Thanks for humoring and idiot (me) ...

All works as expected now - turns out the zip extension does matter and when I renamed the zip to jar, things came to life.

I know I've used zips and jars interchangeably before (in iReport and other places) but renaming it does make a differnece here.

Thanks!

October 24, 2006

I'm near giving up ... I still cannot access an Oracle datasource through JI - I can hit MySql all day lon.

ojdbc14.zip is in both possible locations under tomcat directory and still no luck - the report does access Oracle when run from iReport using the same zip/jar.

Any help appreciated!

Error Message:

org.springframework.webflow.ActionExecutionException: Exception thrown executing [AnnotatedAction@ea9cf1 targetAction = com.jaspersoft.jasperserver.war.action.ViewReportAction@e596c9, attributes = map[[empty]]] in state 'verifyData' of flow 'viewReportFlow'; nested exception is com.jaspersoft.jasperserver.api.JSExceptionWrapper: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

Error Trace:

org.springframework.webflow.ActionExecutionException: Exception thrown executing [AnnotatedAction@ea9cf1 targetAction = com.jaspersoft.jasperserver.war.action.ViewReportAction@e596c9, attributes = map[[empty]]] in state 'verifyData' of flow 'viewReportFlow'; nested exception is com.jaspersoft.jasperserver.api.JSExceptionWrapper: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

com.jaspersoft.jasperserver.api.JSExceptionWrapper: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1355)

at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1201)

at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)

at java.lang.Class.forName0(Native Method)

at java.lang.Class.forName(Class.java:242)

at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.DbcpDataSourceFactory.registerDriver(DbcpDataSourceFactory.java:46)

at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.DbcpDataSourceFactory.createPooledDataSource(DbcpDataSourceFactory.java:39)

at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcReportDataSourceServiceFactory.getPoolDataSource(JdbcReportDataSourceServiceFactory.java:163)

at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcReportDataSourceServiceFactory.createService(JdbcReportDataSourceServiceFactory.java:147)

at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.createDataSourceService(EngineServiceImpl.java:591)

at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:538)

at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:301)

at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.executeReport(EngineServiceImpl.java:669)

at com.jaspersoft.jasperserver.api.engine.jasperreports.domain.impl.ReportUnitRequest.execute(ReportUnitRequest.java:58)

at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.execute(EngineServiceImpl.java:241)

at com.jaspersoft.jasperserver.war.action.ViewReportAction.verifyData(ViewReportAction.java:108)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:585)

at org.springframework.webflow.util.DispatchMethodInvoker.invoke(DispatchMethodInvoker.java:231)

at org.springframework.webflow.action.MultiAction.doExecute(MultiAction.java:141)

at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:67)

at org.springframework.webflow.AnnotatedAction.execute(AnnotatedAction.java:208)

at org.springframework.webflow.ActionExecutor.execute(ActionExecutor.java:54)

at org.springframework.webflow.ActionState.doEnter(ActionState.java:184)

at org.springframework.webflow.State.enter(State.java:201)

at org.springframework.webflow.Transition.execute(Transition.java:224)

at org.springframework.webflow.TransitionableState.onEvent(TransitionableState.java:105)

at org.springframework.webflow.Flow.onEvent(Flow.java:545)

at org.springframework.webflow.execution.impl.FlowExecutionControlContextImpl.signalEvent(FlowExecutionControlContextImpl.java:199)

at org.springframework.webflow.ActionState.doEnter(ActionState.java:188)

at org.springframework.webflow.State.enter(State.java:201)

at org.springframework.webflow.Flow.start(Flow.java:531)

at org.springframework.webflow.execution.impl.FlowExecutionControlContextImpl.start(FlowExecutionControlContextImpl.java:187)

at org.springframework.webflow.SubflowState.doEnter(SubflowState.java:131)

at org.springframework.webflow.State.enter(State.java:201)

at org.springframework.webflow.Transition.execute(Transition.java:224)

at org.springframework.webflow.TransitionableState.onEvent(TransitionableState.java:105)

at org.springframework.webflow.Flow.onEvent(Flow.java:545)

at org.springframework.webflow.execution.impl.FlowExecutionControlContextImpl.signalEvent(FlowExecutionControlContextImpl.java:199)

at org.springframework.webflow.execution.impl.FlowExecutionImpl.signalEvent(FlowExecutionImpl.java:239)

at org.springframework.webflow.executor.FlowExecutorImpl.signalEvent(FlowExecutorImpl.java:177)

at org.springframework.webflow.executor.support.FlowRequestHandler.handleFlowRequest(FlowRequestHandler.java:100)

at org.springframework.webflow.executor.mvc.FlowController.handleRequestInternal(FlowController.java:198)

at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)

at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:45)

at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:792)

at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:726)

at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396)

at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:360)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:83)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)

at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)

at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:134)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:181)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:191)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)

at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90)

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.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.coyote.http11.Http11Processor.process(Http11Processor.java:869)

at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)

at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)

at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)

at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)

at java.lang.Thread.run(Thread.java:595)