We are unable to connect oracle data base server which is hosted in different server from the ignio prod worker server but working fine in UAT.
And able to establish connection from the PowerShell script console in prod.
Receiving the following in the worker-diagnostic.log : ORA-12154; TNS;could not resolve the connect identifier specified
2.When we try to trigger the Sendmail capability in the prod, we are receiving the error as “Exception while sending mailjavax.mail.internet.AddressException:Local address contains or whitespace in string “Emailid sender””but working fine in UAT.
1. If you are using Oracle listener with SID for connection string then check if oracle client installed on worker trying to lookup TNSNAMES.ORA usually at Windows path <Oracle Client Path>\Network\Admin
2. Strange that it worked in UAT, but only change may be Ignio capability version/config or client Prod SMTP relay. Please check if you’re using special characters other than @ in the sender email address. May need to enable UTF-8 encoding at Sendmail configuration side.
