0 Replies Latest reply on Sep 12, 2013 9:27 AM by 3faef7bd-63bb-4a4e-8c20-99cd22adcb86

    ora-04052 when deploying a map



      I am new and following  the "Oracle Warehouse Builder 11gR2: Getting Started 2011" book

      I have 3 kind of data (1-oracle  2-sql  3-flat file)

      and use ODBC module for SQL Server with  user and password and location for sql data

      now i faced this error when deploy the stage_map (that contain the sql table)

      ORA-04052: error occurred when looking up remote object DBO.Regions@ACMEPOS@ACME_POS_LOCATION1

      ORA-00604: error occurred at recursive SQL level 1

      ORA-02019: connection description for remote database not found

      ORA-00933: SQL command not properly ended


      i know user and password and sevice name and location for oracle data base is different

      please help me