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)

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]Object has been closed. (Code: 2,078) (Code: 203,275)
  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][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)

    Root Cause Analysis

    1. com.datanomic.utils.databasespecies.DatabaseException

      Problem writing insert batch to database: [FMWGEN][SQLServer JDBC Driver]Object has been closed. (Code: 2,078)

      at com.datanomic.utils.databasespecies.operations.jdbc.JDBCInserter.error()
    2. com.datanomic.utils
      JDBCInserter.flush
      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)
      3 frames
    3. com.datanomic.director
      ThreadConstrainedWorkUnit$TaskWrapper.run
      1. com.datanomic.director.exports.task.ExportWriter.closeAndFlush(ExportWriter.java:521)
      2. com.datanomic.director.runtime.data.wrappers.RecordFromMessage.closeAndFlush(RecordFromMessage.java:55)
      3. com.datanomic.director.runtime.data.util.DataPump.startPump(DataPump.java:205)
      4. com.datanomic.director.exports.task.ExportTask.runTask(ExportTask.java:200)
      5. com.datanomic.director.missionmanager.executor.ThreadResources.ThreadConstrainedWorkUnit$TaskWrapper.run(ThreadConstrainedWorkUnit.java:402)
      5 frames
    4. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:745)
      1 frame