Failure job to linked oracle server (started without cause)

  • Resender

    SSCertifiable

    Points: 7285

    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: 7285

    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.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply