0 Replies Latest reply: Jan 16, 2013 1:51 AM by 909384 RSS

    Database Connection Error in Informatica Workflow Task

    909384
      Hi,

      I am new in Informatica. I have created a mapping that has source of EBS instance and target of DWH. I have created a workflow and configure task properties with source and target connection. When I start task it gives error on source connection while this connection is working fine in mapping SQ. It gives following error.

      everity: ERROR
      Timestamp: 1/16/2013 11:01:37 AM
      Node: node01_enecora02.enec.gov.ae
      Thread: READER_1_1_1
      Process ID: 18126
      Message Code: RR_4036
      Message: Error connecting to database [
      Database driver error...
      Function Name : Logon
      ORA-12154: TNS:could not resolve the connect identifier specified

      Database driver error...
      Function Name : Connect
      Database Error: Failed to connect to database using user [xxapps] and connection string [source_conn].].

      source_conn is ODBC of source instance.