History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: XPR-392
Type: Bug Bug
Status: Open Open
Priority: Critical Critical
Assignee: Unassigned
Reporter: Jacques Morel
Votes: 0
Watchers: 0
Available Workflow Actions

Submit Patch
Operations

If you were logged in you would be able to see more operations.
xplanner

Exception in the 0.6->0.7b7 database migration on iteration days_worked

Created: 28/Mar/07 01:50 PM   Updated: 29/Jun/07 06:12 PM
Component/s: Database
Affects Version/s: 0.6.x
Fix Version/s: 0.7

Time Tracking:
Not Specified


 Description  « Hide
https://sourceforge.net/forum/message.php?msg_id=3904429

I have upgraded from Xplanner 0.6.2 to 0.7b7, and everything looked ok during
upgrade, but when I start Tomcat 5.0 i get this trace:

2006-09-07 15:56:01 StandardContext[/xplanner]Loading Spring root
WebApplicationContext
2006-09-07 15:56:31 StandardContext[/xplanner]Exception sending context initialized
event to listener instance of class
com.technoetic.xplanner.filters.XPlannerMigrationLauncher
java.lang.RuntimeException: Migration exception caught during migration
       at com.technoetic.xplanner.filters.XPlannerMigrationLauncher.contextInitialized
(XPlannerMigrationLauncher.java:70)
       at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:
3827)
       at org.apache.catalina.core.StandardContext.start(StandardContext.java:4343)
       at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:8
23)
       at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:807)
       at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:595)
       at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.j
ava:277)
       at org.apache.catalina.core.StandardHost.install(StandardHost.java:832)
       at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:625)
       at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:431)
       at org.apache.catalina.startup.HostConfig.start(HostConfig.java:983)
       at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:349)
       at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSuppor
t.java:119)
       at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1091)
       at org.apache.catalina.core.StandardHost.start(StandardHost.java:789)
       at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1083)
       at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:478)
       at org.apache.catalina.core.StandardService.start(StandardService.java:480)
       at org.apache.catalina.core.StandardServer.start(StandardServer.java:2313)
       at org.apache.catalina.startup.Catalina.start(Catalina.java:556)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
       at java.lang.reflect.Method.invoke(Method.java:324)
       at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:287)
       at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:425)
Caused by: com.tacitknowledge.util.migration.MigrationException: exception during
migration
       at com.technoetic.xplanner.upgrade.JdbcMigrationTaskSupport.migrate(JdbcMigrati
onTaskSupport.java:54)
       at com.tacitknowledge.util.migration.MigrationProcess.doMigrations(MigrationPro
cess.java:162)
       at com.tacitknowledge.util.migration.jdbc.JdbcMigrationLauncher.doMigrations(Jd
bcMigrationLauncher.java:288)
       at com.tacitknowledge.util.migration.jdbc.JdbcMigrationLauncher.doMigrations(Jd
bcMigrationLauncher.java:108)
       at com.technoetic.xplanner.filters.XPlannerMigrationLauncher.contextInitialized
(XPlannerMigrationLauncher.java:67)
       ... 25 more
Caused by: net.sf.hibernate.PropertyAccessException: exception setting property
value with CGLIB (set hibernate.cglib.use_reflection_optimizer=false for more
info) setter of com.technoetic.xplanner.domain.Iteration.setDaysWorked
       at net.sf.hibernate.persister.AbstractEntityPersister.setPropertyValues(Abstrac
tEntityPersister.java:220)
       at net.sf.hibernate.impl.SessionImpl.initializeEntity(SessionImpl.java:2224)
       at net.sf.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:
319)
       at net.sf.hibernate.loader.Loader.doQuery(Loader.java:309)
       at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader
.java:138)
       at net.sf.hibernate.loader.Loader.doList(Loader.java:1063)
       at net.sf.hibernate.loader.Loader.list(Loader.java:1054)
       at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854)
       at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1554)
       at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1531)
       at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1523)
       at com.technoetic.xplanner.security.install.MigrateStoryPriorityToOrderNo.migra
te(MigrateStoryPriorityToOrderNo.java:26)
       at com.technoetic.xplanner.upgrade.JdbcMigrationTaskSupport.migrate(JdbcMigrati
onTaskSupport.java:49)
       ... 29 more
Caused by: net.sf.cglib.beans.BulkBeanException
       at com.technoetic.xplanner.domain.Iteration$$BulkBeanByCGLIB$$7e9f40df.setPrope
rtyValues(<generated>)
       at net.sf.hibernate.persister.AbstractEntityPersister.setPropertyValues(Abstrac
tEntityPersister.java:215)
       ... 41 more
Caused by: java.lang.NullPointerException
       ... 43 more

2006-09-07 15:56:31 StandardContext[/xplanner]Closing Spring root
WebApplicationContext
2006-09-07 15:56:31 StandardContext[/xplanner]Shutting down Log4J
2006-09-07 15:56:32 StandardContext[/jsp-examples]ContextListener:
contextInitialized()
2006-09-07 15:56:32 StandardContext[/jsp-examples]SessionListener:
contextInitialized()
2006-09-07 15:56:32 StandardContext[/servlets-examples]ContextListener:
contextInitialized()
2006-09-07 15:56:32 StandardContext[/servlets-examples]SessionListener:
contextInitialized()


If I go back to the old version, it starts up fine.

______________________________________________________________________
Reply Forward Invite SourceForge.net to Gmail
By: tkvarenes

I think I got this to work by setting the value of days_worked in the database
to a value '1' rather than the value 'null'. Can this be right?

______________________________________________________________________
Reply Forward Invite SourceForge.net to Gmail
By: trupoet

FYI This worked for me as well when I got this error.

days_worked is found in the iteration table. It was set to NULL for all rows
so I set it to 1 for all rows and the migrationt ask worked at that point.

 All   Comments   Work Log   Change History      Sort Order: Ascending order - Click to sort in descending order
Jacques Morel - 29/Jun/07 06:12 PM
As a short term fix, assigning a default value of 0 or 1 will work.
However long term we need to support velocity calculation without effort adjustment (w/o factoring the man.days difference between iterations).