none
[Error] Execution (1: 20): ORA-02019: connection description for remote database not found

    Question

  • Hi all,

     

    My package has been failing since last 2 runs...Its getting data from Oracle source. This package has 6 data flow tasks and all source tables are from same database (in oracle)  but different views. and even destination DB is same...Now one of the Dataflow task is failing...so i opened Oracle toad and ran below query

     

    SELECT * FROM Test.v_qualities 

     WHERE  record_date BETWEEN to_date('12/21/2011','mm/dd/yyyy hh:mi:ss am') AND to_date('12/22/2011','mm/dd/yyyy hh:mi:ss am')

     

    I'm getting an error msg like 

    [Error] Execution (1: 20): ORA-02019: connection description for remote database not found .

     

    If connection is wrong all other dataflow tasks should fail but that's not happening...I'm suspecting i guess there is some problem in this view..all other data flow task are using different views but same database.

     

    please let me know what might be the reason.

     

    Thanks,

    Jyo

    Thursday, December 22, 2011 8:06 PM

Answers

All replies