Migrating repository from 3.1. to 4.0

[pumaking]

 Hi,

I set up a new server with an installation of 4.0. Now I want to migrate the repository from my old 3.1 installation to the new one.

Is this possible and if yes how?

[ernestoo]

 Hi, the upgrade plan is to export the 3.1 data using the import/export tool and then import into 4.0. The official way is to export in 3.1, import in 3.5, export again in 3.7 then finally import 4.0

The cowboy way is to go directly from 3.1 to 4.0 and look for any errors - basically if things were deprecated between versions you have to do the above. Mileage will vary.

Look at the installation manual for full instructions of using the import-export command line tool.

 

[pumaking]

Hi,

I now tried to export the repository first and I get the following error:

Exporting repository resource /Alle_Abteilungen/Ersatzteilinfo

08:29:25,610 ERROR JDBCTransaction:198 - Could not toggle autocommit

java.sql.SQLException: Unknown character set index for field '-13765' received from server.

at com.mysql.jdbc.Connection.getCharsetNameForIndex(Connection.java:3274)

at com.mysql.jdbc.Field.<init>(Field.java:159)

at com.mysql.jdbc.MysqlIO.unpackField(MysqlIO.java:644)

at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:414)

at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:1991)

at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:1413)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1757)

at com.mysql.jdbc.Connection.execSQL(Connection.java:3020)

at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:4989)

at org.apache.commons.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:268)

at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:293)

at org.hibernate.transaction.JDBCTransaction.toggleAutoCommit(JDBCTransaction.java:194)

at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:186)

at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:162)

at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:581)

at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:745)

at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:722)

at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:325)

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:111)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)

at $Proxy1.findResource(Unknown Source)

at com.jaspersoft.jasperserver.export.modules.repository.ResourceExporter.getFolderResources(ResourceExporter.java:203)

at com.jaspersoft.jasperserver.export.modules.repository.ResourceExporter.exportFolder(ResourceExporter.java:187)

at com.jaspersoft.jasperserver.export.modules.repository.ResourceExporter.exportFolders(ResourceExporter.java:252)

at com.jaspersoft.jasperserver.export.modules.repository.ResourceExporter.exportFolder(ResourceExporter.java:191)

at com.jaspersoft.jasperserver.export.modules.repository.ResourceExporter.exportFolders(ResourceExporter.java:252)

at com.jaspersoft.jasperserver.export.modules.repository.ResourceExporter.exportFolder(ResourceExporter.java:191)

at com.jaspersoft.jasperserver.export.modules.repository.ResourceExporter.processUri(ResourceExporter.java:162)

at com.jaspersoft.jasperserver.export.modules.repository.ResourceExporter.process(ResourceExporter.java:121)

at com.jaspersoft.jasperserver.export.ExporterImpl.invokeModules(ExporterImpl.java:174)

at com.jaspersoft.jasperserver.export.ExporterImpl.process(ExporterImpl.java:139)

at com.jaspersoft.jasperserver.export.ExporterImpl.performExport(ExporterImpl.java:119)

at com.jaspersoft.jasperserver.export.ExportCommandImpl.process(ExportCommandImpl.java:57)

at com.jaspersoft.jasperserver.export.BaseExportImportCommand.process(BaseExportImportCommand.java:87)

at com.jaspersoft.jasperserver.export.ExportCommand.main(ExportCommand.java:43)

 

Any idea?

[ernestoo]

Hmmm...can you try a newer jdbc driver jar? I believe they'd be in jdbc/drivers