Upgrading from 4.7 to 5.0

0

I have big problems when I want to upgrade from 4.7 to 5.0:

I followed the manual:

my jasperserver 4.7 is installed in opt/jasperreports-server-cp-4.7.0/

Then you have to go to tomcat direcory:

opt/jasperreports-server-cp-4.7.0/apache-tomcat

and backup the webapps/jasperserver and then delete that directory.. I did that!

then backup DB

I copied my default_master.properties and paste it in the jasper5/buildomatic

 

then i ran the upgrade script..

I got a couple of warnings, but everything is ok.. But my server isn't upgraded?

/opt/jasperserver/apache-tomcat/webapps/jasperserver is gone and not recreated..

 

Is that a correct upgrade procedure?

I also tried it to not delete the webapps/jasperserver directory, but then I only see the 4.7 version..

What am I doing wrong?

first I had error about java_home, then I installed java on my ubuntu... So I don't know what I am doing wrong?

samhast's picture
92
Joined: Nov 4 2011 - 6:41am
Last seen: 4 years 2 months ago

3 Answers:

0

The manual explained me this:

 

go to the tomat directory.

make a new backup directory and copy tomcat/webapps/jasperserver to that backup directory

delete tomcat/webapps/jasperserver directory..

 

But when I upgrade to 5, there is nonew directory in webapps...

 

So I think it's normal that it doesn't work..

samhast's picture
92
Joined: Nov 4 2011 - 6:41am
Last seen: 4 years 2 months ago
0

Solved:

First I installed java on my ubuntu server:

apt-get install openjdk-6-jre

then I set my java_home variable:

export JAVA_HOME=/usr/lib/jvm/java-6-openjdk

The second fault I made:

I copied the default_master.properties form my old jasperserver;

now I copied it from samle_conf and configured it like it was described in the manual.

So now everything is fine. Jasperserver 5 is installed on my system

samhast's picture
92
Joined: Nov 4 2011 - 6:41am
Last seen: 4 years 2 months ago
0
Hi i am having the same scenario upgrading form Jasper 4.7 to 5.0 i am using buildomatic scripts to upgrade the same DB I have included below the error i am receiving. The jasperserver inside the tomcat is not being created neither (i deleted the old one) [java] at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:633) [java] at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412) [java] at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411) [java] at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374) [java] at org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:1046) [java] at org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:1039) [java] at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.findByName(HibernateRepositoryServiceImpl.java:1012) [java] at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.findByURI(HibernateRepositoryServiceImpl.java:988) [java] at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.loadResource(HibernateRepositoryServiceImpl.java:294) [java] at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.loadResource(HibernateRepositoryServiceImpl.java:287) [java] at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl$1.execute(HibernateRepositoryServiceImpl.java:191) [java] at com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateDaoImpl.executeCallback(HibernateDaoImpl.java:55) [java] at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.getResourceUnsecure(HibernateRepositoryServiceImpl.java:189) [java] at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.getResource(HibernateRepositoryServiceImpl.java:184) [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [java] at java.lang.reflect.Method.invoke(Method.java:601) [java] at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318) [java] at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) [java] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) [java] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) [java] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [java] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) [java] at $Proxy8.getResource(Unknown Source) [java] at com.jaspersoft.jasperserver.export.modules.repository.ResourceImporter.importResource(ResourceImporter.java:420) [java] at com.jaspersoft.jasperserver.export.modules.repository.ResourceImporter.process(ResourceImporter.java:148) [java] at com.jaspersoft.jasperserver.export.ImporterImpl.process(ImporterImpl.java:156) [java] at com.jaspersoft.jasperserver.export.ImporterImpl.performImport(ImporterImpl.java:98) [java] at com.jaspersoft.jasperserver.export.ImportCommandImpl.process(ImportCommandImpl.java:57) [java] at com.jaspersoft.jasperserver.export.BaseExportImportCommand.process(BaseExportImportCommand.java:94) [java] at com.jaspersoft.jasperserver.export.ImportCommand.main(ImportCommand.java:43) [java] Caused by: org.hibernate.exception.SQLGrammarException: could not execute query [java] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90) [java] at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) [java] at org.hibernate.loader.Loader.doList(Loader.java:2235) [java] at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129) [java] at org.hibernate.loader.Loader.list(Loader.java:2124) [java] at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:118) [java] at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1597) [java] at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306) [java] at org.springframework.orm.hibernate3.HibernateTemplate$36.doInHibernate(HibernateTemplate.java:1056) [java] at org.springframework.orm.hibernate3.HibernateTemplate$36.doInHibernate(HibernateTemplate.java:1) [java] at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406) [java] ... 29 more [java] Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'this_.resourceType' in 'field list' [java] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [java] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) [java] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [java] at java.lang.reflect.Constructor.newInstance(Constructor.java:525) [java] at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) [java] at com.mysql.jdbc.Util.getInstance(Util.java:386) [java] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053) [java] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120) [java] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052) [java] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503) [java] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664) [java] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2794) [java] at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155) [java] at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2322) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) [java] at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) [java] at org.hibernate.loader.Loader.getResultSet(Loader.java:1812) [java] at org.hibernate.loader.Loader.doQuery(Loader.java:697) [java] at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259) [java] at org.hibernate.loader.Loader.doList(Loader.java:2232) [java] ... 37 more BUILD FAILED C:\Jasper5\buildomatic\bin\db-common.xml:520: The following error occurred while executing this line: C:\Jasper5\buildomatic\bin\import-export.xml:283: The following error occurred while executing this line: C:\Jasper5\buildomatic\bin\import-export.xml:158: Java returned: -1
georgeslteif's picture
Joined: Jan 25 2010 - 6:04am
Last seen: 1 year 2 months ago
Feedback