com.datanomic.director.runtime.data.RecordWriteException: Error writing to export OpenFin.oa_cisstatus to EDQ_Output SQL: Problem writing insert batch to database: [FMWGEN][SQLServer JDBC Driver][SQLServer]The conversion of a datetimeoffset data type to a datetime data type resulted in an out-of-range value. (Code: 2,078) (Code: 203,051)

Oracle Community | Oliver Lockett | 1 year ago
  1. 0

    EDQ integration with QAS

    Oracle Community | 1 year ago | Oliver Lockett
    com.datanomic.director.runtime.data.RecordWriteException: Error writing to export OpenFin.oa_cisstatus to EDQ_Output SQL: Problem writing insert batch to database: [FMWGEN][SQLServer JDBC Driver][SQLServer]The conversion of a datetimeoffset data type to a datetime data type resulted in an out-of-range value. (Code: 2,078) (Code: 203,051)
  2. 0

    EDQ integration with QAS

    Oracle Community | 1 year ago | Oliver Lockett
    com.datanomic.director.runtime.data.RecordWriteException: Error writing to export OpenFin.oa_cisstatus to EDQ_Output SQL: Problem writing insert batch to database: [FMWGEN][SQLServer JDBC Driver]Object has been closed. (Code: 2,078) (Code: 203,275)

    Root Cause Analysis

    1. com.datanomic.utils.databasespecies.DatabaseException

      Problem writing insert batch to database: [FMWGEN][SQLServer JDBC Driver][SQLServer]The conversion of a datetimeoffset data type to a datetime data type resulted in an out-of-range value. (Code: 2,078)

      at com.datanomic.utils.databasespecies.operations.jdbc.JDBCInserter.error()
    2. com.datanomic.utils
      JDBCInserter.done
      1. com.datanomic.utils.databasespecies.operations.jdbc.JDBCInserter.error(JDBCInserter.java:787)
      2. com.datanomic.utils.databasespecies.operations.jdbc.JDBCInserter.flushImpl(JDBCInserter.java:730)
      3. com.datanomic.utils.databasespecies.operations.jdbc.JDBCInserter.flush(JDBCInserter.java:660)
      4. com.datanomic.utils.databasespecies.operations.jdbc.JDBCInserter.doneImpl(JDBCInserter.java:707)
      5. com.datanomic.utils.databasespecies.operations.jdbc.JDBCInserter.done(JDBCInserter.java:641)
      5 frames
    3. com.datanomic.director
      ThreadConstrainedWorkUnit$TaskWrapper.run
      1. com.datanomic.director.exports.task.ExportWriter.write(ExportWriter.java:483)
      2. com.datanomic.director.runtime.data.wrappers.RecordFromMessage.write(RecordFromMessage.java:45)
      3. com.datanomic.director.runtime.data.util.DataPump$Worker.doStuff(DataPump.java:429)
      4. com.datanomic.director.runtime.data.util.DataPump$Worker.run(DataPump.java:385)
      5. com.datanomic.director.runtime.data.util.DataPump$Worker.runHere(DataPump.java:338)
      6. com.datanomic.director.runtime.data.util.DataPump.startPump(DataPump.java:203)
      7. com.datanomic.director.exports.task.ExportTask.runTask(ExportTask.java:200)
      8. com.datanomic.director.missionmanager.executor.ThreadResources.ThreadConstrainedWorkUnit$TaskWrapper.run(ThreadConstrainedWorkUnit.java:402)
      8 frames
    4. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:745)
      1 frame