This discussion is archived
0 Replies Latest reply: Jul 3, 2012 2:05 AM by MaheshGx RSS

Interfaces fails twice but executes correclty from next time

MaheshGx Newbie
Currently Being Moderated
Hi,

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.

Thanks,
Mahesh

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points