After assigning some generic resources...

[kwoot]

(Original Bugzilla Bug ID: 35)

Date: 2009-10-15 10:56:11 From: Xavi Castaño \<xcastanho@igalia.com> To: Javier Morán \<jmoran@igalia.com> Version: navalplan-1.0 (1.0.x) Duplicate: 27) Duplicate: 33) Last updated: 2011-01-18 17:54:21

---

(Note: this issue was migrated automatically with bugzilla2github.py tool )

[kwoot]

Bugzilla Comment ID: 78 Date: 2009-10-15 10:56:11 From: Xavi Castaño \<xcastanho@igalia.com>

and playing with zooms I received this exception:

org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:630) at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.convertHibernateAccessException(AbstractSessionFactoryBean.java:303) at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.translateExceptionIfPossible(AbstractSessionFactoryBean.java:282) at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:62) at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:212) at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:146) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy31.getDayAssignmentsByTaksElementGroupByDay(Unknown Source) at org.navalplanner.web.planner.TaskElementAdapter $TaskElementWrapper.calculateLimitDate(TaskElementAdapter.java:225) at org.navalplanner.web.planner.TaskElementAdapter $TaskElementWrapper.getHoursAdvanceEndDate(TaskElementAdapter.java:147) at org.zkoss.ganttz.data.Task.getHoursAdvanceEndDate(Task.java:172) at org.zkoss.ganttz.TaskComponent.updateCompletion(TaskComponent.java:325) at org.zkoss.ganttz.TaskComponent.updateProperties(TaskComponent.java:319) at org.zkoss.ganttz.TaskComponent.zoomChanged(TaskComponent.java:303) at org.zkoss.ganttz.TaskList$3.zoomLevelChanged(TaskList.java:272) at org.zkoss.ganttz.timetracker.TimeTracker $1.doNotify(TimeTracker.java:103) at org.zkoss.ganttz.timetracker.TimeTracker $1.doNotify(TimeTracker.java:100) at org.zkoss.ganttz.util.WeakReferencedListeners.fireEvent(WeakReferencedListeners.java:65) at org.zkoss.ganttz.timetracker.TimeTracker.fireZoomChanged(TimeTracker.java:99) at org.zkoss.ganttz.timetracker.TimeTracker.invalidatingChangeHappened(TimeTracker.java:139) at org.zkoss.ganttz.timetracker.TimeTracker.zoomIncrease(TimeTracker.java:134) at org.zkoss.ganttz.GanttPanel.zoomIncrease(GanttPanel.java:95) at org.zkoss.ganttz.Planner.zoomIncrease(Planner.java:123) 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:597) at bsh.Reflect.invokeMethod(Unknown Source) at bsh.Reflect.invokeObjectMethod(Unknown Source) at bsh.Name.invokeMethod(Unknown Source) at bsh.BSHMethodInvocation.eval(Unknown Source) at bsh.BSHPrimaryExpression.eval(Unknown Source) at bsh.BSHPrimaryExpression.eval(Unknown Source) at bsh.Interpreter.eval(Unknown Source) at bsh.Interpreter.eval(Unknown Source) at org.zkoss.zk.scripting.bsh.BSHInterpreter.exec(BSHInterpreter.java:119) at org.zkoss.zk.scripting.util.GenericInterpreter.interpret(GenericInterpreter.java:310) at org.zkoss.zk.ui.impl.PageImpl.interpret(PageImpl.java:787) at org.zkoss.zk.ui.impl.EventProcessor.process0(EventProcessor.java:176) at org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:141) at org.zkoss.zk.ui.impl.EventProcessingThreadImpl.process0(EventProcessingThreadImpl.java:493) at org.zkoss.zk.ui.impl.EventProcessingThreadImpl.run(EventProcessingThreadImpl.java:425) Caused by: org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.doList(Loader.java:2216) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104) at org.hibernate.loader.Loader.list(Loader.java:2099) at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:289) at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1695) at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142) at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:152) at org.navalplanner.business.planner.daos.DayAssignmentDAO.getDayAssignmentsByTaksElementGroupByDay(DayAssignmentDAO.java:104) at sun.reflect.GeneratedMethodAccessor435.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:138) ... 39 more Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'navaldev.day_assignment' doesn't exist at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715) at com.mysql.jdbc.Connection.execSQL(Connection.java:3249) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1268) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1403) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186) at org.hibernate.loader.Loader.getResultSet(Loader.java:1787) at org.hibernate.loader.Loader.doQuery(Loader.java:674) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236) at org.hibernate.loader.Loader.doList(Loader.java:2213) ... 53 more

[kwoot]

Bugzilla Comment ID: 79 Date: 2009-10-15 11:52:51 From: Oscar González \<ogonzalez@igalia.com>

It already has been fixed by Loren.

[kwoot]

Bugzilla Comment ID: 83 Date: 2009-10-15 12:07:55 From: Oscar González \<ogonzalez@igalia.com>

[kwoot]

Bugzilla Comment ID: 85 Date: 2009-10-15 12:09:36 From: Oscar González \<ogonzalez@igalia.com>