Exception in Hours Woked Per Resource report

[kwoot]

(Original Bugzilla Bug ID: 1412)

Date: 2012-04-17 11:45:38 From: Manuel Rego Casasnovas \<rego@igalia.com> To: Manuel Rego Casasnovas \<rego@igalia.com> Version: libreplan-1.2 (1.2.x) Last updated: 2012-04-27 10:03:56

---

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

[kwoot]

Bugzilla Comment ID: 3914 Date: 2012-04-17 11:45:38 From: Manuel Rego Casasnovas \<rego@igalia.com>

Stacktrace: SEVERE: Failed to load media, /view/z_jcn/qC5Q78/e2q/0/hoursWorkedPerWorkerReport.html

org.zkoss.zk.ui.UiException: net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression : Source text : $F{clockFinish} net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression : Source text : $F{clockFinish} java.lang.ClassCastException: org.joda.time.LocalTime cannot be cast to java.util.Date at hoursWorkedPerWorker_1334663025716_397319.evaluate(hoursWorkedPerWorker_1334663025716_397319.java:414) at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:182) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:570) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:538) at net.sf.jasperreports.engine.fill.JRFillElement.evaluateExpression(JRFillElement.java:868) at net.sf.jasperreports.engine.fill.JRFillTextField.evaluateText(JRFillTextField.java:368) ...

[kwoot]

Bugzilla Comment ID: 3915 Date: 2012-04-17 14:28:14 From: Manuel Rego Casasnovas \<rego@igalia.com>

In order to reproduce the bug you have to create a work report using clock start and clock finish instead of setting hours directly.

[kwoot]

Bugzilla Comment ID: 3918 Date: 2012-04-17 16:19:50 From: Manuel Rego Casasnovas \<rego@igalia.com>

commit 691bd6634a1c73fd5da290e422080e526bd5fdb4 Author: Manuel Rego Casasnovas rego@igalia.com Date: Tue Apr 17 18:18:04 2012 +0200

Bug #1412: Fix problem converting to string clockStart and clockFinish

FEA: ItEr76S04BugFixing

[kwoot]

Bugzilla Comment ID: 3970 Date: 2012-04-27 10:02:52 From: Manuel Rego Casasnovas \<rego@igalia.com>

This patch is causing a regression if you use work reports without clock (the default one).

Stacktrace: SEVERE: >>org.springframework.orm.hibernate3.HibernateQueryException: could not instantiate class [org.libreplan.business.reports.dtos.HoursWorkedPerResourceDTO] from tuple; nested exception is org.hibernate.QueryException: could not instantiate class [org.libreplan.business.reports.dtos.HoursWorkedPerResourceDTO] from tuple

org.hibernate.QueryException: could not instantiate class [org.libreplan.business.reports.dtos.HoursWorkedPerResourceDTO] from tuple java.lang.reflect.InvocationTargetException: null java.lang.NullPointerException at org.libreplan.business.reports.dtos.HoursWorkedPerResourceDTO.(HoursWorkedPerResourceDTO.java:61) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:532) at org.hibernate.transform.AliasToBeanConstructorResultTransformer.transformTuple(AliasToBeanConstructorResultTransformer.java:55) at org.hibernate.hql.HolderInstantiator.instantiate(HolderInstantiator.java:69) at org.hibernate.loader.hql.QueryLoader.getResultList(QueryLoader.java:358) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2108) at org.hibernate.loader.Loader.list(Loader.java:2103) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:340) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1122) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at org.libreplan.business.resources.daos.ResourceDAO.getWorkingHoursPerWorker(ResourceDAO.java:208) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:616) 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) 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 $Proxy44.getWorkingHoursPerWorker(Unknown Source) at org.libreplan.web.reports.HoursWorkedPerWorkerModel.getHoursWorkedPerWorkerReport(HoursWorkedPerWorkerModel.java:99) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:616) 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.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 $Proxy130.getHoursWorkedPerWorkerReport(Unknown Source) at org.libreplan.web.reports.HoursWorkedPerWorkerController.getDataSource(HoursWorkedPerWorkerController.java:109) at org.libreplan.web.reports.LibrePlanReportController.showReport(LibrePlanReportController.java:68) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:616) 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:134) at org.zkoss.zk.scripting.util.GenericInterpreter.interpret(GenericInterpreter.java:341) at org.zkoss.zk.ui.impl.PageImpl.interpret(PageImpl.java:876) at org.zkoss.zk.ui.impl.EventProcessor.process0(EventProcessor.java:180) at org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:138) at org.zkoss.zk.ui.impl.EventProcessingThreadImpl.process0(EventProcessingThreadImpl.java:517) at org.zkoss.zk.ui.impl.EventProcessingThreadImpl.run(EventProcessingThreadImpl.java:444)

[kwoot]

Bugzilla Comment ID: 3971 Date: 2012-04-27 10:03:56 From: Manuel Rego Casasnovas \<rego@igalia.com>

commit 09748f6ef0f5229cec9382d0318eab8466d4c88a Author: Manuel Rego Casasnovas rego@igalia.com Date: Fri Apr 27 12:03:19 2012 +0200

Bug #1412: Avoid NPE if clockStart and clockFinish are not defined

FEA: ItEr76S04BugFixing