net.sf.jasperreports.engine.JRException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Strange error at cash reports
    via openbravopos by salvafl
    ,
  • Hibernate | The Error Message
    via by Unknown author,
  • The error "Value '0000-00' can not be represented as java.sql.Timestamp" has been reported on a specific account and invoice when trying to save the invoice. The invoice saves correctly but you can only exit the edit dialogue by cancelling. The error is consistent on the specific invoice instance but has not been seen on any other instances. Exception from Tomcat Logs: [WARN,JDBCExceptionReporter,http-8080-Processor21] SQL Error: 0, SQLState: S1009 [ERROR,JDBCExceptionReporter,http-8080-Processor21] Value '0000-00-00' can not be represented as java.sql.Timestamp [ERROR,ErrorHelper,http-8080-Processor21] Value '0000-00-00' can not be represented as java.sql.Timestamp org.openvpms.component.business.service.ruleengine.RuleEngineException: Failed to execute the business rule for method save. at org.openvpms.component.business.service.ruleengine.DroolsRuleEngine.invoke(DroolsRuleEngine.java:96) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174) at $Proxy1.save(Unknown Source) at sun.reflect.GeneratedMethodAccessor245.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:292) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:163) at $Proxy2.save(Unknown Source) at sun.reflect.GeneratedMethodAccessor245.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:292) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122) at org.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:80) at org.openvpms.component.business.service.security.OpenVPMSMethodSecurityInterceptor.invoke(OpenVPMSMethodSecurityInterceptor.java:54) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174) at $Proxy2.save(Unknown Source) at org.openvpms.web.component.im.edit.SaveHelper.save(SaveHelper.java:61) at org.openvpms.web.component.im.edit.SaveHelper.save(SaveHelper.java:47) at org.openvpms.web.component.im.edit.AbstractIMObjectEditor.saveObject(AbstractIMObjectEditor.java:519) at org.openvpms.web.component.im.edit.AbstractIMObjectEditor.doSave(AbstractIMObjectEditor.java:492) at org.openvpms.web.component.im.edit.AbstractIMObjectEditor.save(AbstractIMObjectEditor.java:274) at org.openvpms.web.component.im.edit.EditDialog.save(EditDialog.java:150) at org.openvpms.web.component.im.edit.EditDialog.onOK(EditDialog.java:125) at org.openvpms.web.component.dialog.PopupDialog.onButton(PopupDialog.java:199) at org.openvpms.web.component.dialog.PopupDialog$2.actionPerformed(PopupDialog.java:305) at nextapp.echo2.app.button.AbstractButton.fireActionPerformed(AbstractButton.java:135) at echopointng.ButtonEx$1.actionPerformed(ButtonEx.java:120) at nextapp.echo2.app.button.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:70) at echopointng.model.DefaultButtonModelEx.doAction(DefaultButtonModelEx.java:51) at echopointng.ButtonEx.processInput(ButtonEx.java:202) at nextapp.echo2.app.update.ClientUpdateManager.process(ClientUpdateManager.java:116) at nextapp.echo2.app.update.UpdateManager.processClientUpdates(UpdateManager.java:89) at nextapp.echo2.webcontainer.ContainerSynchronizeService.renderUpdate(ContainerSynchronizeService.java:472) at nextapp.echo2.webrender.service.SynchronizeService.service(SynchronizeService.java:279) at nextapp.echo2.webrender.WebRenderServlet.process(WebRenderServlet.java:273) at nextapp.echo2.webrender.WebRenderServlet.doPost(WebRenderServlet.java:189) at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:292) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:108) at org.acegisecurity.intercept.web.SecurityEnforcementFilter.doFilter(SecurityEnforcementFilter.java:197) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303) at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:143) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:246) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:220) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:173) at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:120) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Unknown Source) Caused by: org.springmodules.jsr94.Jsr94InvalidRuleSessionException: org.openvpms.component.business.service.archetype.ArchetypeServiceException: Failed to execute query: {0}.; nested exception is javax.rules.InvalidRuleSessionException: org.openvpms.component.business.service.archetype.ArchetypeServiceException: Failed to execute query: {0}. at org.springmodules.jsr94.core.Jsr94Template.executeStateless(Jsr94Template.java:149) at org.springmodules.jsr94.core.Jsr94RuleSupport.executeStateless(Jsr94RuleSupport.java:108) at org.springmodules.jsr94.core.Jsr94RuleSupport.executeStateless(Jsr94RuleSupport.java:148) at org.openvpms.component.business.service.ruleengine.DroolsRuleEngine.afterMethodInvocation(DroolsRuleEngine.java:157) at org.openvpms.component.business.service.ruleengine.DroolsRuleEngine.invoke(DroolsRuleEngine.java:94) ... 70 more Caused by: RuleException(javax.rules.InvalidRuleSessionException: org.openvpms.component.business.service.archetype.ArchetypeServiceException: Failed to execute query: {0}.), root cause(org.drools.spi.ConsequenceException: org.openvpms.component.business.service.archetype.ArchetypeServiceException: Failed to execute query: {0}.) at org.drools.jsr94.rules.StatelessRuleSessionImpl.executeRules(StatelessRuleSessionImpl.java:169) at org.drools.jsr94.rules.StatelessRuleSessionImpl.executeRules(StatelessRuleSessionImpl.java:126) at org.springmodules.jsr94.core.Jsr94RuleSupport$1.execute(Jsr94RuleSupport.java:115) at org.springmodules.jsr94.core.Jsr94Template.executeStateless(Jsr94Template.java:146) ... 74 more Caused by: org.drools.spi.ConsequenceException: org.openvpms.component.business.service.archetype.ArchetypeServiceException: Failed to execute query: {0}. at org.drools.semantics.java.JavaBlockConsequence.invoke(JavaBlockConsequence.java:150) at org.drools.reteoo.AgendaItem.fire(AgendaItem.java:168) at org.drools.reteoo.Agenda.fireNextItem(Agenda.java:476) at org.drools.reteoo.WorkingMemoryImpl.fireAllRules(WorkingMemoryImpl.java:253) at org.drools.reteoo.WorkingMemoryImpl.fireAllRules(WorkingMemoryImpl.java:268) at org.drools.jsr94.rules.StatelessRuleSessionImpl.executeRules(StatelessRuleSessionImpl.java:165) ... 77 more Caused by: org.openvpms.component.business.service.archetype.ArchetypeServiceException: Failed to execute query: {0}. at org.openvpms.component.business.service.archetype.ArchetypeService.get(ArchetypeService.java:404) at org.openvpms.component.system.common.query.IMObjectQueryIterator.getPage(IMObjectQueryIterator.java:103) at org.openvpms.component.system.common.query.QueryIterator.hasNext(QueryIterator.java:81) at org.openvpms.archetype.rules.finance.account.CustomerAccountRules.updateBalance(CustomerAccountRules.java:412) at org.openvpms.archetype.rules.finance.account.CustomerAccountRules.updateBalance(CustomerAccountRules.java:391) at org.openvpms.archetype.rules.finance.account.CustomerAccountRules.updateBalance(CustomerAccountRules.java:130) at Consequence_1.invoke(ANONYMOUS.java:4) at org.drools.semantics.java.JavaBlockConsequence.invoke(JavaBlockConsequence.java:130) ... 82 more Caused by: org.openvpms.component.business.dao.im.common.IMObjectDAOException: Failed to execute the query: {0}. at org.openvpms.component.business.dao.hibernate.im.entity.IMObjectDAOHibernate.get(IMObjectDAOHibernate.java:234) at org.openvpms.component.business.service.archetype.ArchetypeService$DefaultQueryDelegator.get(ArchetypeService.java:1176) at org.openvpms.component.business.service.archetype.ArchetypeService$DefaultQueryDelegator.get(ArchetypeService.java:1166) at org.openvpms.component.business.service.archetype.ArchetypeService$QueryDelegator.get(ArchetypeService.java:1121) at org.openvpms.component.business.service.archetype.ArchetypeService.get(ArchetypeService.java:402) ... 89 more Caused by: org.hibernate.exception.GenericJDBCException: could not execute query 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.loader.Loader.doList(Loader.java:2214) at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2127) at org.hibernate.loader.Loader.list(Loader.java:2087) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at org.openvpms.component.business.dao.hibernate.im.entity.IMObjectDAOHibernate.executeQuery(IMObjectDAOHibernate.java:561) at org.openvpms.component.business.dao.hibernate.im.entity.IMObjectDAOHibernate.get(IMObjectDAOHibernate.java:231) ... 93 more Caused by: java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Timestamp at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910) at com.mysql.jdbc.ResultSet.getNativeTimestamp(ResultSet.java:4394) at com.mysql.jdbc.ResultSet.getTimestampInternal(ResultSet.java:6055) at com.mysql.jdbc.ResultSet.getTimestamp(ResultSet.java:5681) at com.mysql.jdbc.ResultSet.getTimestamp(ResultSet.java:5719) at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:261) at org.hibernate.type.TimestampType.get(TimestampType.java:30) at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:163) at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:154) at org.hibernate.type.AbstractType.hydrate(AbstractType.java:81) at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2092) at org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1371) at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1299) at org.hibernate.loader.Loader.getRow(Loader.java:1197) at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:568) at org.hibernate.loader.Loader.doQuery(Loader.java:689) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) at org.hibernate.loader.Loader.doList(Loader.java:2211) ... 102 more [WARN,JDBCExceptionReporter,http-8080-Processor21] SQL Error: 0, SQLState: S1009
    via by Tony De Keizer,
  • Date functions in JPQL
    via by 843830,
  • Mysql  And TimeStamp
    via by 843859,
  • Java - Mysql Datetime problem
    via by 807599,
    • net.sf.jasperreports.engine.JRException: java.sql.SQLException: Cannot convert value '2005-04-04 01:' from column 3 to TIMESTAMP. at net.adrianromero.tpv.reports.JRDataSourceBasic.next(JRDataSourceBasic.java:101) at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:878) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:160) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:691) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:160) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:472) at net.adrianromero.tpv.reports.JPanelReport.launchreport(JPanelReport.java:118) at net.adrianromero.tpv.reports.JPanelReport.jButton1ActionPerformed(JPanelReport.java:180) at net.adrianromero.tpv.reports.JPanelReport.access$000(JPanelReport.java:48) at net.adrianromero.tpv.reports.JPanelReport$1.actionPerformed(JPanelReport.java:166) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786) at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1839) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:245) at java.awt.Component.processMouseEvent(Component.java:5100) at java.awt.Component.processEvent(Component.java:4897) at java.awt.Container.processEvent(Container.java:1569) at java.awt.Component.dispatchEventImpl(Component.java:3615) at java.awt.Container.dispatchEventImpl(Container.java:1627) at java.awt.Component.dispatchEvent(Component.java:3477) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128) at java.awt.Container.dispatchEventImpl(Container.java:1613) at java.awt.Window.dispatchEventImpl(Window.java:1606) at java.awt.Component.dispatchEvent(Component.java:3477) at java.awt.EventQueue.dispatchEvent(EventQueue.java:456) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137) at java.awt.EventDispatchThread.run(EventDispatchThread.java:100) Caused by: net.adrianromero.dataloader.DataException: java.sql.SQLException: Cannot convert value '2005-04-04 01:' from column 3 to TIMESTAMP. at net.adrianromero.dataloader.JDBCSentence$JDBCDataResultSet.getTimestamp(Unknown Source) at net.adrianromero.dataloader.Datas$DatasTIMESTAMP.getValue(Unknown Source) at net.adrianromero.dataloader.SerializerReadBasic.readValues(Unknown Source) at net.adrianromero.dataloader.SentenceDataResultSet.getCurrent(Unknown Source) at net.adrianromero.tpv.reports.JRDataSourceBasic.next(JRDataSourceBasic.java:91) ... 32 more Caused by: java.sql.SQLException: Cannot convert value '2005-04-04 01:' from column 3 to TIMESTAMP. at com.mysql.jdbc.ResultSet.getTimestampFromString(ResultSet.java:6369) at com.mysql.jdbc.ResultSet.getTimestampInternal(ResultSet.java:6394) at com.mysql.jdbc.ResultSet.getTimestamp(ResultSet.java:2268) ... 37 more

    Users with the same issue

    Unknown visitor
    Unknown visitor1 times, last one,