BusinessObjects Board

Informatica (Connect String Error)

Facing below error when running a task in Informatica workflow, Any suggestions to overcome ?

Severity Timestamp Node Thread Message Code Message
ERROR 10/16/2019 8:54:28 AM node01_2t READER_1_1_1 RR_4036 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 [xyz_user] and connection string [8d].].

I have tested creating with odbc driver its working fine there and
I have tested and ran the query from source qualifier and db, its working fine

skanth0311 (BOB member since 2019-10-18)