pel123

FIXED IT! The problem was due to 1 bad user entry in the jiuser table in the postgres backend, this caused problems when viewing users and roles. See error below - ERROR Cipherer,http-8080-Processor20:146 - java.lang.NumberFormatException: For input string: "pe" java.lang.NumberFormatException: For input string: "pe" at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48) at java.lang.Integer.parseInt(Integer.java:447) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.Cipherer.dehexify(Cipherer.java:209) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.Cipherer.decode(Cipherer.java:147) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.PasswordCipherer.decodePassword(PasswordCipherer.java:119) at com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibernate.RepoUser.toClient(RepoUser.java:335) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.UserAuthorityServiceImpl.convertUserListToDtoList(UserAuthorityServiceImpl.java:1173) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.UserAuthorityServiceImpl.getTenantUsers(UserAuthorityServiceImpl.java:988) at sun.reflect.GeneratedMethodAccessor222.invoke(Unknown Source)

Under IE6 sp2 I recieve the error - An unexpected exception has occurred when I try and look at roles. I can see the roles now though after a machine reboot and can see 2 users assigned to them, but get error - An unexpected exception has occurred - when clicking on the roles.

Hi all , I have recently upgraded from Jasperserver 3.1 to 3.5 (Postgres backend). Using the instructions from - http://www.raj2u.net/jasperserver-35-with-postgresql-83-on-linux.html To install and then using an export import utility. After the export import I can see all the reports and other objects but no Roles or users. The roles and users are visable in the database but not through the Jasper server 3.5 browser view. Any ideas? Thanks, Perry.

SUCCESS! Wahoo! The Export import process was using the wong version of JAVA - changed the following in js-import-export.sh - JAVA_EXEC=java if test -f ../java/bin/java then JAVA_HOME=../java PATH=$JAVA_HOME/bin:$PATH JAVA_EXEC=$JAVA_HOME/bin/java fi JAVA_EXEC=/usr/java/jdk1.6.0_07/bin/java #if test -f ../java/bin/java #then # JAVA_HOME=../java # PATH=$JAVA_HOME/bin:$PATH # JAVA_EXEC=$JAVA_HOME/bin/java #fi Thanks for all your help people, expecially TKavanagh. Perry.

./js-export.sh --help seems to show more information suggesting that the class - org.objectweb.asm.util.TraceClassVisitor cannot be found. Will try and use ECHO Thanks, Perry. [root@fgv165 scripts]# ./js-export.sh --help Usage: ./js-export.sh [OPTIONS] Options: --help Print this help. --output-dir Output folder. --output-zip Output zip file. --everything Export everything. --roles Roles to export; if no roles are specified, all roles will be exported. --role-users Specifies that when exporting roles, users belonging to the exported roles will be automatically exported. --users Users to export; if no users are specified, all users will be exported. --uris Repository URIs of resources or folders to export. --repository-permissions Specifies that object permission are to be exported for repository resources and folders. --report-jobs List of report unit URIs whose scheduled job are to be exported. Folder URIs can also be specified. 13:55:42,759 ERROR BaseExportImportCommand:45 - org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quartzScheduler' defined in class path resource [config/applicationContext-report-scheduling-for-export.xml]: Cannot resolve reference to bean 'transactionManager' while setting bean property 'transactionManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager' defined in class path resource [config/applicationContext-for-export.xml]: Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [config/applicationContext-for-export.xml]: Invocation of init method failed; nested exception is java.lang.NoClassDefFoundError: net.sf.cglib.core.DebuggingClassWriter$1 org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quartzScheduler' defined in class path resource [config/applicationContext-report-scheduling-for-export.xml]: Cannot resolve reference to bean 'transactionManager' while setting bean property 'transactionManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager' defined in class path resource [config/applicationContext-for-export.xml]: Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [config/applicationContext-for-export.xml]: Invocation of init method failed; nested exception is java.lang.NoClassDefFoundError: net.sf.cglib.core.DebuggingClassWriter$1 Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager' defined in class path resource [config/applicationContext-for-export.xml]: Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [config/applicationContext-for-export.xml]: Invocation of init method failed; nested exception is java.lang.NoClassDefFoundError: net.sf.cglib.core.DebuggingClassWriter$1 Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [config/applicationContext-for-export.xml]: Invocation of init method failed; nested exception is java.lang.NoClassDefFoundError: net.sf.cglib.core.DebuggingClassWriter$1 Caused by: java.lang.NoClassDefFoundError: net.sf.cglib.core.DebuggingClassWriter$1 at java.lang.Class.initializeClass(libgcj.so.7rh) at net.sf.cglib.core.DebuggingClassWriter.toByteArray(DebuggingClassWriter.java:73) at net.sf.cglib.core.DefaultGeneratorStrategy.generate(DefaultGeneratorStrategy.java:26) at net.sf.cglib.core.AbstractClassGenerator.create(AbstractClassGenerator.java:216) at net.sf.cglib.core.KeyFactory$Generator.create(KeyFactory.java:145) at net.sf.cglib.core.KeyFactory.create(KeyFactory.java:117) at net.sf.cglib.core.KeyFactory.create(KeyFactory.java:108) at net.sf.cglib.core.KeyFactory.create(KeyFactory.java:104) at net.sf.cglib.proxy.Enhancer.<clinit>(Enhancer.java:69) at java.lang.Class.initializeClass(libgcj.so.7rh) at org.hibernate.proxy.pojo.cglib.CGLIBLazyInitializer.getProxyFactory(CGLIBLazyInitializer.java:107) at org.hibernate.proxy.pojo.cglib.CGLIBProxyFactory.postInstantiate(CGLIBProxyFactory.java:43) at org.hibernate.tuple.entity.PojoEntityTuplizer.buildProxyFactory(PojoEntityTuplizer.java:162) at org.hibernate.tuple.entity.AbstractEntityTuplizer.<init>(AbstractEntityTuplizer.java:135) at org.hibernate.tuple.entity.PojoEntityTuplizer.<init>(PojoEntityTuplizer.java:55) at org.hibernate.tuple.entity.EntityEntityModeToTuplizerMapping.<init>(EntityEntityModeToTuplizerMapping.java:56) at org.hibernate.tuple.entity.EntityMetamodel.<init>(EntityMetamodel.java:269) at org.hibernate.persister.entity.AbstractEntityPersister.<init>(AbstractEntityPersister.java:425) at org.hibernate.persister.entity.SingleTableEntityPersister.<init>(SingleTableEntityPersister.java:109) at org.hibernate.persister.PersisterFactory.createClassPersister(PersisterFactory.java:55) at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:226) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1291) at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:804) at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:744) at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:131) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1118) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1085) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:429) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:245) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:124) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1019) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:809) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:245) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:124) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1019) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:809) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:236) at org.springframework.context.support.AbstractApplicationContext.getLifecycleBeans(AbstractApplicationContext.java:816) at org.springframework.context.support.AbstractApplicationContext.stop(AbstractApplicationContext.java:791) at org.springframework.context.support.AbstractApplicationContext.doClose(AbstractApplicationContext.java:609) at org.springframework.context.support.AbstractApplicationContext.close(AbstractApplicationContext.java:578) at com.jaspersoft.jasperserver.export.BaseExportImportCommand.process(BaseExportImportCommand.java:102) at com.jaspersoft.jasperserver.export.ExportCommand.main(ExportCommand.java:43) Caused by: java.lang.ClassNotFoundException: org.objectweb.asm.util.TraceClassVisitor not found in gnu.gcj.runtime.SystemClassLoader{urls=[file:./,file:config/,file:lib/acegi-security-1.0.1.jar,file:lib/activation-1.1.jar,file:lib/antlr-2.7.6.jar,file:lib/aopalliance-1.0.jar,file:lib/asm-1.5.3.jar,file:lib/asm-attrs-1.5.3.jar,file:lib/avalon-framework-cvs-20020806.jar,file:lib/batik-1.5-fop-0.20-5.jar,file:lib/bcmail-jdk14-136.jar,file:lib/bcprov-jdk14-136.jar,file:lib/castor-1.0.jar,file:lib/cglib-2.1_3.jar,file:lib/commons-beanutils-1.7.0.jar,file:lib/commons-cli-1.0.jar,file:lib/commons-codec-1.3.jar,file:lib/commons-collections-3.2.jar,file:lib/commons-dbcp-1.2.1.jar,file:lib/commons-digester-1.7.jar,file:lib/commons-discovery-0.2.jar,file:lib/commons-lang-2.1.jar,file:lib/commons-logging-1.0.4.jar,file:lib/commons-math-1.0.jar,file:lib/commons-pool-1.2.jar,file:lib/commons-vfs-1.0.jar,file:lib/dom4j-1.6.1.jar,file:lib/edb-jdbc14.jar,file:lib/ehcache-1.2.3.jar,file:lib/eigenbase-properties-0.5.0.jar,file:lib/eigenbase-resgen-0.5.0.jar,file:lib/eigenbase-xom-0.5.0.jar,file:lib/fop-0.20.5.jar,file:lib/groovy-all-minimal-1.0.jar,file:lib/hibernate-3.2.1.ga.jar,file:lib/itext-2.1.0.jar,file:lib/jai_codec-1.1_mr.jar,file:lib/jai_core-1.1_mr.jar,file:lib/jakarta-regexp-1.4.jar,file:lib/jasperreports-3.1.2.jar,file:lib/jasperreports-chart-themes-3.1.2.jar,file:lib/jasperserver-api-common-3.1.0.jar,file:lib/jasperserver-api-common-impl-3.1.0.jar,file:lib/jasperserver-api-engine-3.1.0.jar,file:lib/jasperserver-api-engine-impl-3.1.0.jar,file:lib/jasperserver-api-metadata-3.1.0.jar,file:lib/jasperserver-api-metadata-impl-3.1.0.jar,file:lib/jasperserver-export-tool-3.1.0.jar,file:lib/jasperserver-repository-hibernate-3.1.0.jar,file:lib/javacup-0.10k.jar,file:lib/jcommon-1.0.13.jar,file:lib/jdtcore-3.1.0.jar,file:lib/jfreechart-1.0.10.jar,file:lib/jpivot-3.0.0.jar,file:lib/jsf-api-1.1.jar,file:lib/jta-1.0.1B.jar,file:lib/jxl-2.6.jar,file:lib/log4j-1.2.12.jar,file:lib/mail-1.4.jar,file:lib/mondrian-2.3.2.8944-DB2.jar,file:lib/mysql-connector-java-3.1.14.jar,file:lib/mysql-connector-java-5.1.5.jar,file:lib/oro-2.0.8.jar,file:lib/png-encoder-1.5.jar,file:lib/postgresql-8.2-504.jdbc3.jar,file:lib/quartz-1.5.1.jar,file:lib/spring-2.0.2.jar,file:lib/spring-beans-2.0.2.jar,file:lib/spring-context-2.0.2.jar,file:lib/spring-core-2.0.2.jar,file:lib/spring-dao-2.0.2.jar,file:lib/spring-hibernate3-2.0.2.jar,file:lib/spring-jdbc-2.0.2.jar,file:lib/tbutils-wcf-3.0.0.jar,file:lib/wcf-3.0.0.jar,file:lib/xalan-2.4.1.jar,file:lib/xercesImpl-2.6.0.jar], parent=gnu.gcj.runtime.ExtensionClassLoader{urls=[], parent=null}} at java.net.URLClassLoader.findClass(libgcj.so.7rh) at java.lang.ClassLoader.loadClass(libgcj.so.7rh) at java.lang.ClassLoader.loadClass(libgcj.so.7rh) at java.lang.Class.forName(libgcj.so.7rh) at java.lang.Class.initializeClass(libgcj.so.7rh) ...56 more

I think I've got further but there isn't a lot of info out there for this error message either - [root@fgv165 scripts]# ./js-export.sh --everything --output-zip js-3.1-export.zip 13:48:41,152 ERROR BaseExportImportCommand:45 - org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quartzScheduler' defined in class path resource [config/applicationContext-report-scheduling-for-export.xml]: Cannot resolve reference to bean 'transactionManager' while setting bean property 'transactionManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager' defined in class path resource [config/applicationContext-for-export.xml]: Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [config/applicationContext-for-export.xml]: Invocation of init method failed; nested exception is java.lang.NoClassDefFoundError: net.sf.cglib.proxy.Enhancer org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quartzScheduler' defined in class path resource [config/applicationContext-report-scheduling-for-export.xml]: Cannot resolve reference to bean 'transactionManager' while setting bean property 'transactionManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager' defined in class path resource [config/applicationContext-for-export.xml]: Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [config/applicationContext-for-export.xml]: Invocation of init method failed; nested exception is java.lang.NoClassDefFoundError: net.sf.cglib.proxy.Enhancer Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager' defined in class path resource [config/applicationContext-for-export.xml]: Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [config/applicationContext-for-export.xml]: Invocation of init method failed; nested exception is java.lang.NoClassDefFoundError: net.sf.cglib.proxy.Enhancer Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [config/applicationContext-for-export.xml]: Invocation of init method failed; nested exception is java.lang.NoClassDefFoundError: net.sf.cglib.proxy.Enhancer Caused by: java.lang.NoClassDefFoundError: net.sf.cglib.proxy.Enhancer at java.lang.Class.initializeClass(libgcj.so.7rh)

Thanks for that, it will give me something to work on. Perry.

Thanks for the suggestion Lucian, unfortunenately it didn't do me any good. I am getting the same error when trying to get 3.5 working on the same box. My 3.1 Jasper server instance still works though, it's just theexport that doesn't. Cheers, Perry.

Hi , Thanks I've seen those though and I have already changed my dialect to - metadata.hibernate.dialect=com.jaspersoft.hibernate.dialect.PostgresqlNoBlobDialect and my tables have bytea data types rather than OID. Have you spotted something else in there that may help? Thanks, Perry.

I'm trying to upgrade from Jasper server 3.0 to 3.5 with a Postgres backend. The export is failing - ./js-export.sh --everything --output-zip js-3.1-export.zip Originally I didn't have the export scripts and other folders in my installation, I had to extract the files to the script directory and setup the property files. The jdbc property file is shown below - ************************************************************************************************** > cat js.jdbc.properties # below is property that determines the Hibernate dialect #metadata.hibernate.dialect=org.hibernate.dialect.MySQLDialect #metadata.hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect metadata.hibernate.dialect=com.jaspersoft.hibernate.dialect.PostgresqlNoBlobDialect metadata.hibernate.dataSource.jndiName=jdbc/jasperserver metadata.jdbc.driverClassName=org.postgresql.Driver metadata.jdbc.url=jdbc:postgresql://IP_ADDRESS:5444/djsr2 metadata.jdbc.username=jasperserver_owner metadata.jdbc.password=password #metadata.jdbc.encryptedPassword=encrypted-postgres ************************************************************************************************** I am getting the following error - ************************************************************************************************** [root@fgv165 scripts]# ./js-export.sh --everything --output-zip js-3.1-export.zip 10:40:42,053 ERROR BaseExportImportCommand:45 - org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quartzScheduler' defined in class path resource [config/applicationContext-report-scheduling-for-export.xml]: Cannot resolve reference to bean 'transactionManager' while setting bean property 'transactionManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager' defined in class path resource [config/applicationContext-for-export.xml]: Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [config/applicationContext-for-export.xml]: Invocation of init method failed; nested exception is org.hibernate.HibernateException: Dialect class not found: com.jaspersoft.hibernate.dialect.PostgresqlNoBlobDialect org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quartzScheduler' defined in class path resource [config/applicationContext-report-scheduling-for-export.xml]: Cannot resolve reference to bean 'transactionManager' while setting bean property 'transactionManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager' defined in class path resource [config/applicationContext-for-export.xml]: Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [config/applicationContext-for-export.xml]: Invocation of init method failed; nested exception is org.hibernate.HibernateException: Dialect class not found: com.jaspersoft.hibernate.dialect.PostgresqlNoBlobDialect Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager' defined in class path resource [config/applicationContext-for-export.xml]: Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [config/applicationContext-for-export.xml]: Invocation of init method failed; nested exception is org.hibernate.HibernateException: Dialect class not found: com.jaspersoft.hibernate.dialect.PostgresqlNoBlobDialect Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [config/applicationContext-for-export.xml]: Invocation of init method failed; nested exception is org.hibernate.HibernateException: Dialect class not found: com.jaspersoft.hibernate.dialect.PostgresqlNoBlobDialect Caused by: org.hibernate.HibernateException: Dialect class not found: com.jaspersoft.hibernate.dialect.PostgresqlNoBlobDialect at org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:81) at org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:42) at org.hibernate.cfg.SettingsFactory.determineDialect(SettingsFactory.java:409) at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:119) at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2006) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1289) at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:804) at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:744) at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:131) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1118) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1085) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:429) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:245) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:124) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1019) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:809) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:245) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:124) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1019) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:809) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:236) at org.springframework.context.support.AbstractApplicationContext.getLifecycleBeans(AbstractApplicationContext.java:816) at org.springframework.context.support.AbstractApplicationContext.stop(AbstractApplicationContext.java:791) at org.springframework.context.support.AbstractApplicationContext.doClose(AbstractApplicationContext.java:609) at org.springframework.context.support.AbstractApplicationContext.close(AbstractApplicationContext.java:578) at com.jaspersoft.jasperserver.export.BaseExportImportCommand.process(BaseExportImportCommand.java:102) at com.jaspersoft.jasperserver.export.ExportCommand.main(ExportCommand.java:43) [root@fgv165 scripts]# ************************************************************************************************** Thanks, Perry

I'm getting there on the configuration, but am stuck at the moment with the error below when running the export. ./js-export.sh --everything --output-zip js-3.1-export.zip Invocation of init method failed; nested exception is org.hibernate.HibernateException: Dialect class not found: com.jaspersoft.hibernate.dialect.PostgresqlNoBlobDialect Caused by: org.hibernate.HibernateException: Dialect class not found: com.jaspersoft.hibernate.dialect.PostgresqlNoBlobDialect

Thanks that's very helpfull. Yes I have already done the extraction of the script folder from - jasperserver-3.0.0-bin.zip. I have started configuring the export-import using those files. Thanks it's good to know I am going down the right route with this. I can confirm the drivers are the same for EnterpriseDB as they are for Postgresql. I'll let you know how I get on. Thanks again.

My 3.0 installation has a Postgresql/Enterprisedb 8.3 backend database. Perry.

Hi , Thanks for the quick reply. I am missing the js-export.sh file from the 3.0 installation though, as I need to export the repository of reports etc. before I can upgrade to 3.5. Cheers, Perry.

Hi , I am trying to upgrade from jasper server 3 to 3.5 on Linux but have no js-export.sh file in my script directory to export the repository data. I am following the procedure below to upgrade - http://kent.dl.sourceforge.net/project/jasperserver/JasperServer/JasperServer%203.5.0/JasperServer-3.5-Install-Guide.pdf Jasperserver 3 was installed from the following zip file - jasperserver-3.0-bin.zip Using the following procedure- http://www.raj2u.net/jasperserver-installation-on-linux.html#comment-2 Please see below a listing of my script directory- /opt/apache-tomcat-5.5.27/webapps/jasperserver/scripts -rw-r--r-- 1 root root 2379 Jul 17 2008 customTooltip.js -rw-r--r-- 1 root root 3004 Jul 17 2008 common-utils.js -rw-r--r-- 1 root root 2931 Jul 17 2008 checkbox-utils.js -rw-r--r-- 1 root root 6437 Jul 17 2008 view-report.js -rw-r--r-- 1 root root 2014 Jul 17 2008 jasperserver.js -rw-r--r-- 1 root root 1872 Jul 17 2008 error.js -rw-r--r-- 1 root root 20 Jul 17 2008 edition.js -rw-r--r-- 1 root root 6427 Jul 17 2008 drag.js -rw-r--r-- 1 root root 17508 Jul 17 2008 ajax.js -rw-r--r-- 1 root root 142634 Oct 13 2008 repositoryExplorer.js -rw-r--r-- 1 root root 27078 Oct 13 2008 repositoryExplorerDragAndDrop.js -rw-r--r-- 1 root root 53871 Oct 13 2008 nanotree.js -rw-r--r-- 1 root root 25375 Oct 13 2008 common.js -rw-r--r-- 1 root root 45281 Oct 20 2008 treesupport.js The file is nowhere in the installation, please help. Thanks, Perry.

Thanks for the reply Sherman. I think custom report output destinations would make the JS more flexible and it would be great if it appears in a future release. Cheers, Perry.

Is it possible to store the reports on the file system rather than as Blobs in the repository database? Thanks, Perry.