java.sql.SQLDataException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Conversion failed when converting date and/or time from character string.

Oracle Community | 061e24b5-efa5-4f2f-bbde-510501f8fcad | 3 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    problem with jdev adapter, polling

    Oracle Community | 3 years ago | 061e24b5-efa5-4f2f-bbde-510501f8fcad
    java.sql.SQLDataException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Conversion failed when converting date and/or time from character string.

    Root Cause Analysis

    1. java.sql.SQLDataException

      [FMWGEN][SQLServer JDBC Driver][SQLServer]Conversion failed when converting date and/or time from character string.

      at weblogic.jdbc.sqlserverbase.ddb_.b()
    2. weblogic.jdbc.sqlserverbase
      ddb9.a
      1. weblogic.jdbc.sqlserverbase.ddb_.b(Unknown Source)
      2. weblogic.jdbc.sqlserverbase.ddb_.a(Unknown Source)
      3. weblogic.jdbc.sqlserverbase.ddb9.b(Unknown Source)
      4. weblogic.jdbc.sqlserverbase.ddb9.a(Unknown Source)
      4 frames
    3. weblogic.jdbc.sqlserver
      ddj.m
      1. weblogic.jdbc.sqlserver.tds.ddr.v(Unknown Source)
      2. weblogic.jdbc.sqlserver.tds.ddr.a(Unknown Source)
      3. weblogic.jdbc.sqlserver.tds.ddq.a(Unknown Source)
      4. weblogic.jdbc.sqlserver.tds.ddr.a(Unknown Source)
      5. weblogic.jdbc.sqlserver.ddj.m(Unknown Source)
      5 frames
    4. weblogic.jdbc.sqlserverbase
      ddde.executeQuery
      1. weblogic.jdbc.sqlserverbase.ddel.e(Unknown Source)
      2. weblogic.jdbc.sqlserverbase.ddel.a(Unknown Source)
      3. weblogic.jdbc.sqlserverbase.ddde.a(Unknown Source)
      4. weblogic.jdbc.sqlserverbase.ddel.v(Unknown Source)
      5. weblogic.jdbc.sqlserverbase.ddel.u(Unknown Source)
      6. weblogic.jdbc.sqlserverbase.ddde.executeQuery(Unknown Source)
      6 frames
    5. weblogic.jdbc.wrapper
      PreparedStatement.executeQuery
      1. weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:135)
      1 frame
    6. EclipseLink (non-OSGi)
      AbstractSession.executeQuery
      1. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:931)
      2. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:607)
      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.ServerSession.executeCall(ServerSession.java:566)
      6. org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:207)
      7. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:207)
      8. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:193)
      9. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.cursorSelectAllRows(DatasourceCallQueryMechanism.java:75)
      10. org.eclipse.persistence.queries.CursoredStreamPolicy.execute(CursoredStreamPolicy.java:64)
      11. org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:408)
      12. org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1081)
      13. org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:844)
      14. org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1040)
      15. org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:392)
      16. org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2831)
      17. org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1516)
      18. org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1498)
      18 frames
    7. oracle.tip.adapter
      InboundWorkWrapper.run
      1. oracle.tip.adapter.db.inbound.AbstractSequencingPollingStrategy.poll(AbstractSequencingPollingStrategy.java:610)
      2. oracle.tip.adapter.db.InboundWork.runOnce(InboundWork.java:747)
      3. oracle.tip.adapter.db.InboundWork.run(InboundWork.java:620)
      4. oracle.tip.adapter.db.inbound.InboundWorkWrapper.run(InboundWorkWrapper.java:43)
      4 frames
    8. weblogic.work
      ExecuteThread.run
      1. weblogic.work.ContextWrap.run(ContextWrap.java:41)
      2. weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:531)
      3. weblogic.work.ExecuteThread.execute(ExecuteThread.java:252)
      4. weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
      4 frames