[Upgrading from 4.7 to 5.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:Jasper5buildomaticbindb-common.xml:520: The following error occurred while executing this line:

C:Jasper5buildomaticbinimport-export.xml:283: The following error occurred while executing this line:

C:Jasper5buildomaticbinimport-export.xml:158: Java returned: -1

[JasperServer reports available via SSL VPN]

Hello Daniel

i know this is a really old post, but did you found out what was causing the problem?

i am having the same problem between netasq U70 and Jasperserver 4.5