Re: [base] creatItem err while migrate from 1.2 to 2.2.2
Hi, As it turned out it was not a bug, but a mis-configuration of MySQL/BASE. The error happens when your database uses one charset, the db.url setting in base.config uses a different charset and your data contains a character outside the ASCII range. Check the data in the Protocols table in BASE 1, and make sure the db.url uses the same charset as the database. Well, I got no errors during the migration, when I created the base2 and base2dynamic db with phpMyAdmin (latin1_swedish_ci collation), while I got some using the initdb script (utf-8). The next problem is: After a successful migration, I miss the pictures. :s I now wonder, what went wrong this time. Best regards Bernd - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ The BASE general discussion mailing list basedb-users@lists.sourceforge.net unsubscribe: send a mail with subject unsubscribe to [EMAIL PROTECTED]
Re: [base] creatItem err while migrate from 1.2 to 2.2.2
Hi, On Tue, 15 May 2007 19:57:40 +0200, Nicklas Nordborg [EMAIL PROTECTED] wrote: Bernd Schwendele wrote: Hi, I have a problem with the mirgrate-script. I do not have any glue what this message means. It seems like the migration of BASE 1 plug-in definitions is broken. If you don't need those you can disable that part of the migration. Change the 'includePlugins' setting in the migrate.properties file to 'no'. Thanks, I heeded your advise. The migrate script was running about an hour and crashed again. 14:44:25,877 INFO migration:77 - ProtocolTransfer: run: could not insert: [net.sf.basedb.core.data.ProtocolData] run net.sf.basedb.core.BaseException: could not insert: [net.sf.basedb.core.data.ProtocolData] at net.sf.basedb.core.HibernateUtil.saveData(HibernateUtil.java:978) at net.sf.basedb.core.DbControl.commit(DbControl.java:370) at net.sf.basedb.clients.migrate.Transfer.run(Transfer.java:302) at net.sf.basedb.clients.migrate.ProtocolTransfer.start(ProtocolTransfer.java:83) at net.sf.basedb.clients.migrate.Migrater.startTransfer(Migrater.java:218) at net.sf.basedb.clients.migrate.Migrater.run(Migrater.java:117) at net.sf.basedb.clients.migrate.Migrater.main(Migrater.java:478) Caused by: org.hibernate.exception.GenericJDBCException: could not insert: [net.sf.basedb.core.data.ProtocolData] at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:40) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2154) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2634) at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:48) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248) at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298) at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181) at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107) at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187) at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33) at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172) at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27) at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70) at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535) at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523) at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519) at net.sf.basedb.core.HibernateUtil.saveData(HibernateUtil.java:969) ... 6 more Regards Bernd - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ The BASE general discussion mailing list basedb-users@lists.sourceforge.net unsubscribe: send a mail with subject unsubscribe to [EMAIL PROTECTED]
Re: [base] creatItem err while migrate from 1.2 to 2.2.2
Bernd Schwendele wrote: Hi, I have a problem with the mirgrate-script. I do not have any glue what this message means. It seems like the migration of BASE 1 plug-in definitions is broken. If you don't need those you can disable that part of the migration. Change the 'includePlugins' setting in the migrate.properties file to 'no'. The plug-in definitions can be migrated by hand by exporting them from BASE 1 and then importing them to BASE 2. It can be a lot of work if you have many plug-ins, but even if the migration worked, you would still have to copy/recompile the plug-ins on the new server. /Nicklas --- 18:45:40,006 INFO migration:77 - PluginTransfer: createItem: Base1 name=Normalization: Global median ratio; id=1 18:45:40,190 ERROR migration:85 - creatItem err net.sf.basedb.core.ItemNotFoundException: Item not found: PluginConfiguration[id=0] at net.sf.basedb.core.PluginConfiguration.getById(PluginConfiguration.java:101) at net.sf.basedb.plugins.Base1PluginExecuter.configure(Base1PluginExecuter.java:261) at net.sf.basedb.core.PluginConfigurationRequest.invoke(PluginConfigurationRequest.java:113) at net.sf.basedb.clients.migrate.PluginTransfer.createItem(PluginTransfer.java:129) at net.sf.basedb.clients.migrate.Transfer.runUnBatched(Transfer.java:398) at net.sf.basedb.clients.migrate.PluginTransfer.start(PluginTransfer.java:93) at net.sf.basedb.clients.migrate.Migrater.startTransfer(Migrater.java:218) at net.sf.basedb.clients.migrate.Migrater.run(Migrater.java:92) at net.sf.basedb.clients.migrate.Migrater.main(Migrater.java:478) --- The migration before worked, so this is quite strage. Settings and config-files are the same. The whole output of migrate_from_1.2.sh is attached. Maybe someone can help me :) Regards Bernd - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ The BASE general discussion mailing list basedb-users@lists.sourceforge.net unsubscribe: send a mail with subject unsubscribe to [EMAIL PROTECTED] - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ The BASE general discussion mailing list basedb-users@lists.sourceforge.net unsubscribe: send a mail with subject unsubscribe to [EMAIL PROTECTED]