Failure job to linked oracle server (started without cause)

• Resender

  SSCertifiable

  Points: 7443

  More actions

  July 23, 2015 at 8:47 am

  #319954

  Hello folks,kind of running out of ideas on this one.

  We have a job,which runs an ssis package to collect data from an oracle source & import it into our system.

  Package works fine in bids,nothing has changed to the connector,provider whatever you can think off but it started failing with the following messages:

  ORA-00604: error occurred at recursive SQL level 1

  ORA-06502: PL/SQL: numeric or value error character string buffer too small.

  ORA-06512: line 21

  We have changed nothing to the environment.

• Resender

  SSCertifiable

  Points: 7443

  More actions

  August 4, 2015 at 6:21 am

  #1817079

  In the end I created a new proxy and it runs fine,only problem with the proxy is that it uses a user account that might be dropped in the future.