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
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  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