Hello,

I am trying to upgrade Teaming 1.0.3 to 2.0.

I am doing this in a test environment with our real environments data.

Old Environment:
Teaming 1.0.3
SLES 10 SP1 64 bit
MySQL 5.0.86-community (different server)
Sun JDK 1.5.0_12 32bit

New Environment:
Teaming 2.0
SLES 10 SP2 64 bit (XEN VM)
MySQL 5.0.88-community (same server)
Sun JDK 1.6.0_15 64 bit

I backed up the sitescape and lportal databases from the old env and restored them to the new mysql server. I also copied (tar files) the data directory (basic setup) and the install directory to the new environment. I modified the old installer.xml file and added the new hostname and database parameters. I started the installed and did the 'Update Software and Settings' option. The install finished successfully. I am attaching the installer log file here. I did let the installer update the database. I have not tried to update the database manually. I did use the 60 day trial license.

When I start teaming, I get the following error.

2009-12-31 17:30:24,660 WARN [main] [org.hibernate.impl.SessionFactoryObjectFactory] - InitialContext did not implement EventContext
2009-12-31 17:30:26,809 INFO [main] [org.kablink.teaming.license.LicenseManager] - Loading license
2009-12-31 17:30:26,921 ERROR [main] [org.kablink.teaming.license.LicenseManager] - Invalid or missing license - system will continue with limited access.
2009-12-31 17:30:28,285 INFO [main] [com.novell.teaming.docconverter.impl.TextStellentC onverter] - DOCCONVERTER: Loading config/docconverter.cfg
2009-12-31 17:30:48,645 WARN [main] [org.hibernate.util.JDBCExceptionReporter] - SQL Error: 1062, SQLState: 23000
2009-12-31 17:30:48,645 ERROR [main] [org.hibernate.util.JDBCExceptionReporter] - Duplicate entry '1-test--1' for key 2
2009-12-31 17:30:54,830 ERROR [main] [org.springframework.web.context.ContextLoader] - Context initialization failed
org.springframework.beans.factory.BeanCreationExce ption: Error creating bean with name 'defaultEmailFormatter' defined in ServletContext resource [/WEB-INF/context/applicationContext.xml]: Cannot resolve reference to bean 'zoneModule' while setting bean property 'zoneModule'; nested exception is org.springframework.beans.factory.BeanCreationExce ption: Error creating bean with name 'zoneModule' defined in ServletContext resource [/WEB-INF/context/additionalContext.xml]: Cannot create inner bean 'com.novell.teaming.module.zone.impl.StandaloneZon eModule#60c0c8b5' of type [com.novell.teaming.module.zone.impl.StandaloneZone Module] while setting bean property 'target'; nested exception is org.springframework.beans.factory.BeanCreationExce ption: Error creating bean with name 'com.novell.teaming.module.zone.impl.StandaloneZon eModule#60c0c8b5' defined in ServletContext resource [/WEB-INF/context/additionalContext.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.ConstraintViolationExcepti on: could not update: [org.kablink.teaming.domain.Definition#8af8899218a5 d80a0118ad77f7eb01cc]

I am attaching the full catalina.out file as well.

At first I was using MySQL 5.1 64 bit and I received the same error. Now I am using 5.0. I tried installing the patch that is available for Teaming 2.0 even though it seemed unrelated and I received the same error.

In Teaming 1.0.3, we have 90+ Teams and 440+ users. Starting from scratch is not a option :(. Any assistance is greatly appreciated.