net.adrianromero.dataloader.DataException: java.sql.SQLException: Cannot convert value '2005-04-04 01:' from column 3 to TIMESTAMP.

openbravopos | salvafl | 1 decade ago
  1. 0

    Strange error at cash reports

    openbravopos | 1 decade ago | salvafl
    net.adrianromero.dataloader.DataException: java.sql.SQLException: Cannot convert value '2005-04-04 01:' from column 3 to TIMESTAMP.
  2. 0

    Hibernate | The Error Message

    theerrormessage.com | 1 year ago
    org.hibernate.exception.GenericJDBCException: could not execute query
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    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

    JIRA | 9 years ago | Tony De Keizer
    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}.)
  5. 0

    MySQL Bugs: #19274: failure to convert datetime '0000-00-00 00:00:00' to TIMESTAMP

    mysql.com | 2 months ago
    java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 1 to TIMESTAMP.

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      Cannot convert value '2005-04-04 01:' from column 3 to TIMESTAMP.

      at com.mysql.jdbc.ResultSet.getTimestampFromString()
    2. MySQL jdbc
      ResultSet.getTimestamp
      1. com.mysql.jdbc.ResultSet.getTimestampFromString(ResultSet.java:6369)
      2. com.mysql.jdbc.ResultSet.getTimestampInternal(ResultSet.java:6394)
      3. com.mysql.jdbc.ResultSet.getTimestamp(ResultSet.java:2268)
      3 frames
    3. net.adrianromero.dataloader
      SentenceDataResultSet.getCurrent
      1. net.adrianromero.dataloader.JDBCSentence$JDBCDataResultSet.getTimestamp(Unknown Source)
      2. net.adrianromero.dataloader.Datas$DatasTIMESTAMP.getValue(Unknown Source)
      3. net.adrianromero.dataloader.SerializerReadBasic.readValues(Unknown Source)
      4. net.adrianromero.dataloader.SentenceDataResultSet.getCurrent(Unknown Source)
      4 frames
    4. net.adrianromero.tpv
      JRDataSourceBasic.next
      1. net.adrianromero.tpv.reports.JRDataSourceBasic.next(JRDataSourceBasic.java:91)
      1 frame
    5. JasperReports
      JasperFillManager.fillReport
      1. net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:878)
      2. net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:160)
      3. net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:691)
      4. net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:160)
      5. net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:472)
      5 frames
    6. net.adrianromero.tpv
      JPanelReport$1.actionPerformed
      1. net.adrianromero.tpv.reports.JPanelReport.launchreport(JPanelReport.java:118)
      2. net.adrianromero.tpv.reports.JPanelReport.jButton1ActionPerformed(JPanelReport.java:180)
      3. net.adrianromero.tpv.reports.JPanelReport.access$000(JPanelReport.java:48)
      4. net.adrianromero.tpv.reports.JPanelReport$1.actionPerformed(JPanelReport.java:166)
      4 frames
    7. Java RT
      EventDispatchThread.run
      1. javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786)
      2. javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1839)
      3. javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
      4. javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
      5. javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:245)
      6. java.awt.Component.processMouseEvent(Component.java:5100)
      7. java.awt.Component.processEvent(Component.java:4897)
      8. java.awt.Container.processEvent(Container.java:1569)
      9. java.awt.Component.dispatchEventImpl(Component.java:3615)
      10. java.awt.Container.dispatchEventImpl(Container.java:1627)
      11. java.awt.Component.dispatchEvent(Component.java:3477)
      12. java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483)
      13. java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198)
      14. java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128)
      15. java.awt.Container.dispatchEventImpl(Container.java:1613)
      16. java.awt.Window.dispatchEventImpl(Window.java:1606)
      17. java.awt.Component.dispatchEvent(Component.java:3477)
      18. java.awt.EventQueue.dispatchEvent(EventQueue.java:456)
      19. java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201)
      20. java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151)
      21. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)
      22. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)
      23. java.awt.EventDispatchThread.run(EventDispatchThread.java:100)
      23 frames