0 Replies Latest reply: Jul 3, 2012 4:05 AM by MaheshGx RSS

    Interfaces fails twice but executes correclty from next time


      I have interfaces which are coping data from MS Access tables to oracle tables.
      NOw here i am facing somewhat strange issue.
      I have 3 environments Dev,Test and PROD.
      Now when i am moving scenarios from TEST to PROD ,the interfaces fails for first 2 times giving following error

      ODI-1227: Task SrcSet0 (Loading) fails on the source MICROSOFT_ACCESS connection MTP_Products.
      Caused By: java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid string or buffer length
           at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)
           at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
           at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(JdbcOdbc.java:3907)
           at sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(JdbcOdbcResultSet.java:5698)
           at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:354)

      and executes correctly next time.
      Although i have specified fields data types and its legth more than required.

      Let me know if anyone has come across such issues or anyone has idea about something like it.
      Help appreciated.