java.sql.BatchUpdateException: The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value.

Oracle Community | Balaji Radhakrishnan | 2 years ago
  1. 0

    BPEL Transaction Inactive : Instance terminated without handling the Error

    Oracle Community | 2 years ago | Balaji Radhakrishnan
    java.sql.BatchUpdateException: The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value.
  2. 0

    Why I don't get BatchUpdateException when AutoCommit is set false?

    Stack Overflow | 1 year ago | cruxion effux
    java.sql.BatchUpdateException: Conversion failed when converting the nvarchar value 'hello' to data type int.
  3. 0

    警報 alarm PK

    GitHub | 6 months ago | karateboy
    play.api.Application$$anon$1: Execution exception[[BatchUpdateException: 違反 PRIMARY KEY 條件約束 'PK_Alarm'。無法在物件 'dbo.Alarm' 中插入重複的索引鍵。重複的索引鍵值是 (A013, 2016-06-02 13:53:39.5300000, I:T20)。]]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    java.sql.BatchUpdateException using MSSql

    GitHub | 4 years ago | wir33658
    java.sql.BatchUpdateException: Ein expliziter Wert für die Identitätsspalte kann nicht in der PERSONS-Tabelle eingefügt werden, wenn IDENTITY_INSERT auf OFF festgelegt ist.
  6. 0

    Genesys InfoMart job run failure

    sggu.com | 1 year ago
    org.hibernate.exception.LockAcquisitionException: Could not execute JDBC batch update

    3 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.BatchUpdateException

      The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value.

      at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch()
    2. com.microsoft.sqlserver
      SQLServerPreparedStatement.executeBatch
      1. com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch(SQLServerPreparedStatement.java:1178)
      1 frame
    3. weblogic.jdbc.wrapper
      PreparedStatement.executeBatch
      1. weblogic.jdbc.wrapper.PreparedStatement.executeBatch(PreparedStatement.java:210)
      1 frame
    4. EclipseLink (non-OSGi)
      UnitOfWorkImpl.writeChanges
      1. org.eclipse.persistence.internal.databaseaccess.DatabasePlatform.executeBatch(DatabasePlatform.java:2101)
      2. org.eclipse.persistence.internal.databaseaccess.ParameterizedSQLBatchWritingMechanism.executeBatchedStatements(ParameterizedSQLBatchWritingMechanism.java:144)
      3. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:535)
      4. org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1717)
      5. org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:253)
      6. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:207)
      7. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:193)
      8. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:264)
      9. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelect(DatasourceCallQueryMechanism.java:246)
      10. org.eclipse.persistence.queries.DataReadQuery.executeNonCursor(DataReadQuery.java:197)
      11. org.eclipse.persistence.queries.DataReadQuery.executeDatabaseQuery(DataReadQuery.java:152)
      12. org.eclipse.persistence.queries.DataReadQuery.execute(DataReadQuery.java:137)
      13. org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2831)
      14. org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1516)
      15. org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1498)
      16. org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1449)
      17. org.eclipse.persistence.sequencing.QuerySequence.select(QuerySequence.java:309)
      18. org.eclipse.persistence.sequencing.QuerySequence.updateAndSelectSequence(QuerySequence.java:254)
      19. org.eclipse.persistence.sequencing.StandardSequence.getGeneratedValue(StandardSequence.java:62)
      20. org.eclipse.persistence.sequencing.DefaultSequence.getGeneratedValue(DefaultSequence.java:145)
      21. org.eclipse.persistence.sequencing.Sequence.getGeneratedValue(Sequence.java:225)
      22. org.eclipse.persistence.internal.sequencing.SequencingManager$NoPreallocation_State.getNextValue(SequencingManager.java:677)
      23. org.eclipse.persistence.internal.sequencing.SequencingManager.getNextValue(SequencingManager.java:1067)
      24. org.eclipse.persistence.internal.sequencing.ClientSessionSequencing.getNextValue(ClientSessionSequencing.java:70)
      25. org.eclipse.persistence.internal.descriptors.ObjectBuilder.assignSequenceNumber(ObjectBuilder.java:355)
      26. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.insertObject(DatasourceCallQueryMechanism.java:351)
      27. org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:163)
      28. org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:178)
      29. org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.insertObjectForWrite(DatabaseQueryMechanism.java:475)
      30. org.eclipse.persistence.queries.InsertObjectQuery.executeCommit(InsertObjectQuery.java:80)
      31. org.eclipse.persistence.queries.InsertObjectQuery.executeCommitWithChangeSet(InsertObjectQuery.java:91)
      32. org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.executeWriteWithChangeSet(DatabaseQueryMechanism.java:287)
      33. org.eclipse.persistence.queries.WriteObjectQuery.executeDatabaseQuery(WriteObjectQuery.java:58)
      34. org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:844)
      35. org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:743)
      36. org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:108)
      37. org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:85)
      38. org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2871)
      39. org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1516)
      40. org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1498)
      41. org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1449)
      42. org.eclipse.persistence.internal.sessions.CommitManager.commitNewObjectsForClassWithChangeSet(CommitManager.java:224)
      43. org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:123)
      44. org.eclipse.persistence.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:3800)
      45. org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1416)
      46. org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1505)
      47. org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.writeChanges(UnitOfWorkImpl.java:5502)
      47 frames
    5. oracle.tip.adapter
      DBInteraction.execute
      1. oracle.tip.adapter.db.DBInteraction.executeOutboundWrite(DBInteraction.java:927)
      2. oracle.tip.adapter.db.DBInteraction.execute(DBInteraction.java:247)
      2 frames
    6. oracle.integration.platform
      MeshImpl.request
      1. oracle.integration.platform.blocks.adapter.fw.jca.cci.JCAInteractionInvoker.executeJcaInteraction(JCAInteractionInvoker.java:357)
      2. oracle.integration.platform.blocks.adapter.fw.jca.cci.JCAInteractionInvoker.invokeJcaReference(JCAInteractionInvoker.java:572)
      3. oracle.integration.platform.blocks.adapter.fw.jca.cci.JCAInteractionInvoker.invokeSyncJcaReference(JCAInteractionInvoker.java:545)
      4. oracle.integration.platform.blocks.adapter.fw.jca.cci.JCAEndpointInteraction.performSynchronousInteraction(JCAEndpointInteraction.java:547)
      5. oracle.integration.platform.blocks.adapter.AdapterReference.request(AdapterReference.java:179)
      6. oracle.integration.platform.blocks.mesh.SynchronousMessageHandler.doRequest(SynchronousMessageHandler.java:139)
      7. oracle.integration.platform.blocks.mesh.MessageRouter.request(MessageRouter.java:182)
      8. oracle.integration.platform.blocks.mesh.MeshImpl.request(MeshImpl.java:190)
      8 frames
    7. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor2127.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      3. java.lang.reflect.Method.invoke(Method.java:597)
      3 frames
    8. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
      2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
      3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
      3 frames
    9. oracle.integration.platform
      PhaseEventAspect.invoke
      1. oracle.integration.platform.metrics.PhaseEventAspect.invoke(PhaseEventAspect.java:71)
      1 frame
    10. Spring AOP
      JdkDynamicAopProxy.invoke
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      2 frames
    11. Unknown
      $Proxy386.request
      1. $Proxy386.request(Unknown Source)
      1 frame
    12. oracle.fabric
      CubeServiceEngine.requestToMesh
      1. oracle.fabric.CubeServiceEngine.requestToMesh(CubeServiceEngine.java:862)
      1 frame
    13. com.collaxa.cube
      CubeDeliveryBean.handleInvoke
      1. com.collaxa.cube.ws.WSInvocationManager.invoke(WSInvocationManager.java:267)
      2. com.collaxa.cube.engine.ext.common.InvokeHandler.__invoke(InvokeHandler.java:1099)
      3. com.collaxa.cube.engine.ext.common.InvokeHandler.handleNormalInvoke(InvokeHandler.java:594)
      4. com.collaxa.cube.engine.ext.common.InvokeHandler.handle(InvokeHandler.java:132)
      5. com.collaxa.cube.engine.ext.bpel.common.wmp.BPELInvokeWMP.__executeStatements(BPELInvokeWMP.java:75)
      6. com.collaxa.cube.engine.ext.bpel.common.wmp.BaseBPELActivityWMP.perform(BaseBPELActivityWMP.java:173)
      7. com.collaxa.cube.engine.CubeEngine.performActivity(CubeEngine.java:2718)
      8. com.collaxa.cube.engine.CubeEngine._handleWorkItem(CubeEngine.java:1197)
      9. com.collaxa.cube.engine.CubeEngine.handleWorkItem(CubeEngine.java:1100)
      10. com.collaxa.cube.engine.dispatch.message.instance.PerformMessageHandler.handleLocal(PerformMessageHandler.java:78)
      11. com.collaxa.cube.engine.dispatch.DispatchHelper.handleLocalMessage(DispatchHelper.java:251)
      12. com.collaxa.cube.engine.dispatch.DispatchHelper.sendMemory(DispatchHelper.java:330)
      13. com.collaxa.cube.engine.CubeEngine.endRequest(CubeEngine.java:4652)
      14. com.collaxa.cube.engine.CubeEngine.endRequest(CubeEngine.java:4584)
      15. com.collaxa.cube.engine.CubeEngine._createAndInvoke(CubeEngine.java:714)
      16. com.collaxa.cube.engine.CubeEngine.createAndInvoke(CubeEngine.java:559)
      17. com.collaxa.cube.engine.delivery.DeliveryService.handleInvoke(DeliveryService.java:531)
      18. com.collaxa.cube.engine.ejb.impl.CubeDeliveryBean.handleInvoke(CubeDeliveryBean.java:319)
      18 frames
    14. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor16515.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      3. java.lang.reflect.Method.invoke(Method.java:597)
      3 frames
    15. com.bea.core
      ReflectiveMethodInvocation.proceed
      1. com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
      2. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
      3. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
      3 frames
    16. com.oracle.pitchfork
      MethodInvocationInvocationContext.proceed
      1. com.oracle.pitchfork.intercept.MethodInvocationInvocationContext.proceed(MethodInvocationInvocationContext.java:103)
      1 frame
    17. oracle.security.jps
      JpsInterceptor.intercept
      1. oracle.security.jps.ee.ejb.JpsAbsInterceptor$1.run(JpsAbsInterceptor.java:113)
      2. oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)
      3. oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)
      4. oracle.security.jps.ee.ejb.JpsAbsInterceptor.runJaasMode(JpsAbsInterceptor.java:100)
      5. oracle.security.jps.ee.ejb.JpsAbsInterceptor.intercept(JpsAbsInterceptor.java:154)
      6. oracle.security.jps.ee.ejb.JpsInterceptor.intercept(JpsInterceptor.java:113)
      6 frames
    18. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor1671.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      3. java.lang.reflect.Method.invoke(Method.java:597)
      3 frames
    19. com.bea.core
      AopUtils.invokeJoinpointUsingReflection
      1. com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
      1 frame
    20. com.oracle.pitchfork
      JeeInterceptorInterceptor.invoke
      1. com.oracle.pitchfork.intercept.JeeInterceptorInterceptor.invoke(JeeInterceptorInterceptor.java:68)
      1 frame
    21. com.bea.core
      ReflectiveMethodInvocation.proceed
      1. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      2. com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
      3. com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
      4. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      4 frames
    22. com.oracle.pitchfork
      MethodInvocationVisitorImpl.visit
      1. com.oracle.pitchfork.spi.MethodInvocationVisitorImpl.visit(MethodInvocationVisitorImpl.java:34)
      1 frame
    23. weblogic.ejb.container
      EnvironmentInterceptorCallbackImpl.callback
      1. weblogic.ejb.container.injection.EnvironmentInterceptorCallbackImpl.callback(EnvironmentInterceptorCallbackImpl.java:54)
      1 frame
    24. com.oracle.pitchfork
      EnvironmentInterceptor.invoke
      1. com.oracle.pitchfork.spi.EnvironmentInterceptor.invoke(EnvironmentInterceptor.java:42)
      1 frame
    25. com.bea.core
      JdkDynamicAopProxy.invoke
      1. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      2. com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
      3. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      4. com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
      5. com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
      6. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      7. com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      7 frames
    26. Unknown
      $Proxy368.handleInvoke
      1. $Proxy368.handleInvoke(Unknown Source)
      1 frame
    27. com.collaxa.cube
      BPELDeliveryBean_5k948i_ICubeDeliveryLocalBeanImpl.__WL_invoke
      1. com.collaxa.cube.engine.ejb.impl.bpel.BPELDeliveryBean_5k948i_ICubeDeliveryLocalBeanImpl.__WL_invoke(Unknown Source)
      1 frame
    28. weblogic.ejb.container
      SessionLocalMethodInvoker.invoke
      1. weblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:39)
      1 frame
    29. com.collaxa.cube
      BaseDispatchTask.run
      1. com.collaxa.cube.engine.ejb.impl.bpel.BPELDeliveryBean_5k948i_ICubeDeliveryLocalBeanImpl.handleInvoke(Unknown Source)
      2. com.collaxa.cube.engine.dispatch.message.invoke.InvokeInstanceMessageHandler.handle(InvokeInstanceMessageHandler.java:30)
      3. com.collaxa.cube.engine.dispatch.DispatchHelper.handleMessage(DispatchHelper.java:141)
      4. com.collaxa.cube.engine.dispatch.BaseDispatchTask.process(BaseDispatchTask.java:89)
      5. com.collaxa.cube.engine.dispatch.BaseDispatchTask.run(BaseDispatchTask.java:66)
      5 frames
    30. Java RT
      ThreadPoolExecutor$Worker.run
      1. java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
      2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:909)
      2 frames