topkatz

I actualy tried this very thing on linux. We are on 3.7 and wanted to get up to 5.6. I installed 5.6 and tried the import from my exported 3.7. Some of my reports work and some dont. I get a error about casting integers to boolean. I would have to back track and try it again for specifics. In any event this aproach has not worked for me as of yet.

I'm trying to upgrade a working jasperserver 3.7 ce install on CentOS 7 up to 5.6.1 My 3.7 is using packaged tomcat 5.5 and installed mysql. I downloaded the jasperreports-server-cp-5.6.1.bin.zip and folowed the upgrade directions. I exported my 3.7 data. I then copied and edited the buildomatic config. I then ran js-upgrade-newdb-ce.sh with my exported file. I did recive a "WARNING: JAVA_HOME enviorment not found" It rant eh script and said it succeded. After I started back up jasperserver usign the jasperctl script. Trying to log in I get 404. Here is the catalina.out: Dec 11, 2014 11:53:30 AM org.apache.coyote.http11.Http11BaseProtocol destroyINFO: Stopping Coyote HTTP/1.1 on http-8080Dec 11, 2014 11:53:36 AM org.apache.coyote.http11.Http11BaseProtocol initINFO: Initializing Coyote HTTP/1.1 on http-8080Dec 11, 2014 11:53:36 AM org.apache.catalina.startup.Catalina loadINFO: Initialization processed in 338 msDec 11, 2014 11:53:36 AM org.apache.catalina.core.StandardService startINFO: Starting service CatalinaDec 11, 2014 11:53:36 AM org.apache.catalina.core.StandardEngine startINFO: Starting Servlet Engine: Apache Tomcat/5.5.20Dec 11, 2014 11:53:36 AM org.apache.catalina.core.StandardHost startINFO: XML validation disabledDec 11, 2014 11:53:37 AM org.apache.catalina.startup.HostConfig deployDirectorySEVERE: Error deploying web application directory jasperserverorg.apache.commons.logging.LogConfigurationException: java.lang.UnsupportedClassVersionError: Bad version number in .class file (Caused by java.lang.UnsupportedClassVersionError: Bad version number in .class file) at org.apache.commons.logging.impl.LogFactoryImpl.newInstance(LogFactoryImpl.java:538) at org.apache.commons.logging.impl.LogFactoryImpl.getInstance(LogFactoryImpl.java:235) at org.apache.commons.logging.LogFactory.getLog(LogFactory.java:370) at org.apache.catalina.core.ContainerBase.getLogger(ContainerBase.java:380) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4114) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524) at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:904) at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:867) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:474) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021) at org.apache.catalina.core.StandardHost.start(StandardHost.java:718) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442) at org.apache.catalina.core.StandardService.start(StandardService.java:450) at org.apache.catalina.core.StandardServer.start(StandardServer.java:709) at org.apache.catalina.startup.Catalina.start(Catalina.java:551) 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.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)Caused by: java.lang.UnsupportedClassVersionError: Bad version number in .class file at java.lang.ClassLoader.defineClass1(Native Method) at java.lang.ClassLoader.defineClass(ClassLoader.java:620) at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:124) at org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappClassLoader.java:1815) at org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader.java:869) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1322) 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:164) at org.apache.log4j.helpers.Loader.loadClass(Loader.java:178) at org.apache.log4j.helpers.OptionConverter.instantiateByClassName(OptionConverter.java:317) at org.apache.log4j.helpers.OptionConverter.instantiateByKey(OptionConverter.java:120) at org.apache.log4j.PropertyConfigurator.parseAppender(PropertyConfigurator.java:629) at org.apache.log4j.PropertyConfigurator.parseCategory(PropertyConfigurator.java:612) at org.apache.log4j.PropertyConfigurator.configureRootCategory(PropertyConfigurator.java:509) at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:415) at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:441) at org.apache.log4j.helpers.OptionConverter.selectAndConfigure(OptionConverter.java:468) at org.apache.log4j.LogManager.<clinit>(LogManager.java:122) at org.apache.log4j.Logger.getLogger(Logger.java:104) at org.apache.commons.logging.impl.Log4JLogger.getLogger(Log4JLogger.java:229) at org.apache.commons.logging.impl.Log4JLogger.<init>(Log4JLogger.java:65) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:494) at org.apache.commons.logging.impl.LogFactoryImpl.newInstance(LogFactoryImpl.java:529) ... 26 more[/code]Not sure what went wrong. I can see that the jasperctl script is useing the JRE_HOME in the jasperserver-3.7 dir. Any ideas what happend or what to look at?

I'm leaning this way. I also did a successful roll back by switching out the old webapp dir and importing the sql dump.

I have been using js ce 3.7.0 in production since teh first of this year. Before that in development for around another six months. I run on Cent OS 5.5 x64 using bundeled Tomcat and local mysql. My production enviorment is stable and I'm having no problems. Recently I started playing around with upgrading to 4.1. I have succesfuly done so in a VM eviorment. I am fairly confident that my reports do not break. Am I crazy to upgrade a working production enviorment? Should I just "Dont fix what is not broken". I like the idea of staying current, however I dont think there are any new features or bugs that are fixed taht I need. Thanks

java version "1.6.0_25" Java SE Runtime Enviorment (build 1.6.0_25-b06) Java HotSpot 64-Bit Server VM (build 20.0-b11.mixed mode)

Sorry, should have mentioned that I am on the bundled tomcat. I belive that it uses a JVM included in the bundle. I also think that CentOS 6 is using JVM 1.6. I will double check Monday in the AM.

I have been working on a new production enviorment using CentOS 6. I'm using JasperServer 3.7.0 CE. I am unable to execute any reports at this point, even the example ones. Here is my error output. org.springframework.web.util.NestedServletException: Handler processing failed; nested exception is java.lang.NoClassDefFoundError org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:924) org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807) org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571) org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:501) javax.servlet.http.HttpServlet.service(HttpServlet.java:689) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:83) org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) com.jaspersoft.jasperserver.war.security.JSSwitchUserProcessingFilter.doFilterHttp(JSSwitchUserProcessingFilter.java:146) org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:139) org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97) org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:175) org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:277) org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:175) org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:53) org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175) org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67) org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) root cause java.lang.NoClassDefFoundError net.sf.jasperreports.engine.xml.JRAbstractStyleFactory.createObject(JRAbstractStyleFactory.java:163) org.apache.commons.digester.FactoryCreateRule.begin(FactoryCreateRule.java:389) org.apache.commons.digester.Digester.startElement(Digester.java:1361) org.apache.xerces.parsers.AbstractSAXParser.startElement(Unknown Source) org.apache.xerces.parsers.AbstractXMLDocumentParser.emptyElement(Unknown Source) org.apache.xerces.impl.xs.XMLSchemaValidator.emptyElement(Unknown Source) org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanStartElement(Unknown Source) org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) org.apache.xerces.parsers.XMLParser.parse(Unknown Source) org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source) org.apache.commons.digester.Digester.parse(Digester.java:1647) net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:235) net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:222) net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:210) com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.compileReport(EngineServiceImpl.java:886) com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.compileReport(EngineServiceImpl.java:1338) com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.CacheableCompiledReports.getData(CacheableCompiledReports.java:58) com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryCache.saveData(HibernateRepositoryCache.java:177) com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryCache.getCachedItem(HibernateRepositoryCache.java:107) com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryCache.cache(HibernateRepositoryCache.java:67) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) java.lang.reflect.Method.invoke(Method.java:585) org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) com.jaspersoft.jasperserver.api.common.util.spring.ReattemptMethodInterceptor.invoke(ReattemptMethodInterceptor.java:51) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) $Proxy8.cache(Unknown Source) com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.getCompiledReport(EngineServiceImpl.java:896) com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.getJasperReport(EngineServiceImpl.java:658) com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:369) com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.executeReport(EngineServiceImpl.java:871) com.jaspersoft.jasperserver.api.engine.jasperreports.domain.impl.ReportUnitRequest.execute(ReportUnitRequest.java:57) com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.execute(EngineServiceImpl.java:319) com.jaspersoft.jasperserver.war.action.ViewReportAction.executeReport(ViewReportAction.java:383) com.jaspersoft.jasperserver.war.action.ViewReportAction.executeReport(ViewReportAction.java:373) com.jaspersoft.jasperserver.war.action.ViewReportAction.runReport(ViewReportAction.java:255) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) java.lang.reflect.Method.invoke(Method.java:585) org.springframework.webflow.action.DispatchMethodInvoker.invoke(DispatchMethodInvoker.java:98) org.springframework.webflow.action.MultiAction.doExecute(MultiAction.java:123) org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:188) org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:51) org.springframework.webflow.action.EvaluateAction.doExecute(EvaluateAction.java:79) org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:188) org.springframework.webflow.execution.AnnotatedAction.execute(AnnotatedAction.java:145) org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:51) org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:101) org.springframework.webflow.engine.State.enter(State.java:194) org.springframework.webflow.engine.Transition.execute(Transition.java:227) org.springframework.webflow.engine.impl.FlowExecutionImpl.execute(FlowExecutionImpl.java:391) org.springframework.webflow.engine.impl.RequestControlContextImpl.execute(RequestControlContextImpl.java:214) org.springframework.webflow.engine.TransitionableState.handleEvent(TransitionableState.java:119) org.springframework.webflow.engine.Flow.handleEvent(Flow.java:555) org.springframework.webflow.engine.impl.FlowExecutionImpl.handleEvent(FlowExecutionImpl.java:386) org.springframework.webflow.engine.impl.RequestControlContextImpl.handleEvent(RequestControlContextImpl.java:210) org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:105) org.springframework.webflow.engine.State.enter(State.java:194) org.springframework.webflow.engine.Flow.start(Flow.java:535) org.springframework.webflow.engine.impl.FlowExecutionImpl.start(FlowExecutionImpl.java:364) org.springframework.webflow.engine.impl.FlowExecutionImpl.start(FlowExecutionImpl.java:222) org.springframework.webflow.executor.FlowExecutorImpl.launchExecution(FlowExecutorImpl.java:140) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) java.lang.reflect.Method.invoke(Method.java:585) org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) org.springframework.security.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) $Proxy17.launchExecution(Unknown Source) org.springframework.webflow.mvc.servlet.FlowHandlerAdapter.handle(FlowHandlerAdapter.java:193) org.springframework.webflow.mvc.servlet.FlowController.handleRequest(FlowController.java:174) org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48) org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875) org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807) org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571) org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:501) javax.servlet.http.HttpServlet.service(HttpServlet.java:689) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:83) org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) com.jaspersoft.jasperserver.war.security.JSSwitchUserProcessingFilter.doFilterHttp(JSSwitchUserProcessingFilter.java:146) org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:139) org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97) org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:175) org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:277) org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:175) org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:53) org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175) org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67) org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)Any ideas on this would be much apreciated.

Hello, can I upload a xls datasource to jasperserver to use when my report is being run. Another option would be to hand jasperserver the file from webservice. Can this be done, any examples of this. I know how to do it in ireport, and just point to my xls doc, but I want it to prompt the user for a file, and run the report against it.

I can not reproduce teh error right now as my tables are dumped, however I can show you the xml and tell you what is going on. Field deff: <field name="tbDate" class="java.sql.Date"> <fieldDescription><![CDATA[]]></fieldDescription> </field> Field display: <staticText> <reportElement x="159" y="298" width="41" height="14"/> <textElement/> <text><![CDATA[TBDate:]]></text> </staticText> <textField pattern="MM/dd/yyyy"> <reportElement x="200" y="298" width="63" height="14"/> <textElement/> <textFieldExpression class="java.util.Date"><![CDATA[$F{tbDate}]]></textFieldExpression> </textField> The problem is that this value is not always a real date, some times its '0000-00-00'. When it is, the report fails with an error saying that its not a date. I know I can work around this by setting the field as a string, but then I can not use the date pattern to alter the date format (which I want to do)

I'm sorry, I should ahve been more specific. My system already has mysql installed, so I just have jasperservers version of tomcat. To get things started I go to /opt/jasperserver-ce-3.7.0 and issue the jasperserverctl.sh command.

Hello, anyone care to share an init script for jasperserver? Something to stick in /etc/rc.d/init.d

I have a report that retrives a date object that can be 0000-00-00. I would like to continue to use the date field for this data in the report for formating reasons. Is there a way to handle this? Right now my report dies if my data contains 0000-00-00.

I found this: http://jasperforge.org/plugins/espforum/view.php?group_id=83&forumid=101&topicid=61248#61268 Maybe I never tried to preview a report that had been deployed that contained resources stored in the repo.?

Hello all, I have been building all sorts of reports and a issue crept up today. I can not tell if its the way it always has been, or if something got inadvertantly changed in my development enviorment. I build my report localy and its subreports. Everything works fine. I upload my report and subreport to my jasperserver repo. My report is executed as expected from jasperserver. My issue comes in when I want to do further work on the report. I open the parent report from the repo. If I click "preview" in ireport my subreports bomb out with an error of "Unable to locate the subreport with expression: ""repo:sub1.jrxml"" ". Obviously my report is not looking to the repo to get the subreport. The real question is why. Now if I right click the main.jrxml in the repo structure and click "run report unit" it works as expected and the subreport gets fired from the repo. I could have swore I could run the report localy when opened in ireport for editing. Am I imagingn that? I can just run the report unit, I just feel like I did it right from preview before. Thanks Mike

I came up with a workaround, as I figure there is no way to tell the webservice what session to use. This is what I did: 1. In the report and subreports setup a new parameter $P!{TABLE} and use it in the SQL 2. In my PHP script I built a random string generator function 3. Create a new table and name it using the random string function 4. stick my calculated data in the table 5. call my webservice and use the new TABLE parameter with the random name. 6. Delete the table. Everything is working as you would expect!

I have a report I built that uses calculated data from my tables. I would like to put this data in a temporary table, then have jasperserver webservice use it. Up untill now I have not been able to get the webservice instance to see the temporay table. Is there a way to do this via php, or must I use a static table for my results for the report?

No ideas on this? When I inspect the field in ireport this is what is in the pattern field ¤ #,##0.00 If I replace the square in there it appears to work in the webservice. Post Edited by topkatz at 04/30/2010 12:25 Post Edited by topkatz at 04/30/2010 12:27

Here is a screen shot of the output: http://img440.imageshack.us/img440/3332/screenshotkf.png img440.imageshack.us/img440/3332/screenshotkf.png http://img440.imageshack.us/img440/3332/screenshotkf.png

I have a report which I'm running via the webservice. When I do so it does not print dollor signs were aplicable, it displays a little square type charecter. If I run th ereport from the web portal it displays correctly. This is what I send over to the web service, maybe there is a config item I need to get the charecter to display correctly? Code:<request operationName=\"runReport\" locale=\"en\"> <argument name=\"RUN_OUTPUT_FORMAT\">$format</argument> <resourceDescriptor name=\"\" wsType=\"\" uriString=\"$report\" isNew=\"false\"> <label>null</label> $params_xml </resourceDescriptor> </request>

After digging around a bit I realized this is exactly what the web service is intended to be used for. I now have a simple SOAP/PHP script that gets jasperserver to spit out the report to the user.

I have a web app Im building and I have been using jasperserver for some of my more complex reports. This web app is to be used in both a intranet and the web. I would prefer to keep jasper as a seamless part off the app, and not require users to login. I also wold like to avoid exposing the jasperserver to the web at all of posible. Is it posible to have php request a report from jasper and have jasper output a pdf file that I then just send to the user as an attachment? This way the server only has to have the jasper user credentials, and I dont need to pass them or the report parameters in the url? I can setup tomcat to use ssl, but to have the user not login I need to send the user credentils in the url, which is a bad idea over the web.

got it - right click the report name and add group : (

I must be missing something as I can not find were grouping is located. Any help here would be apreciated. BTW - if I try to add it during the wizard it says it failed to create report.

The simple anwser to this is, you just have to backup your db. What I did to test all this: - In a VM I started witha fresh mysql install. - restored a backup of my application db - installed a fresh copy of jasperserver - restored my backup of the jasperserver db Everything worked as expected. As long as you use the same db information you should be all set. The only thing Im not sure on is if I installed jasperserver to a new location, ie - not /opt/jasper... Hope this helps someone Mike

Nobody wants to share how they handle DR with jasperserver? Is backing up the mysql tables enough? Would a reinstall of jasperserver, then dumping the db's back into a fresh mysql install do the trick?