Adapter ODM - "ORA-12170: TNS:Connect Timeout Occurred" Error (Doc ID 1598885.1)

Last updated on JULY 08, 2014

Applies to:

Oracle Health Sciences InForm Adapter - Version 1.3.4.2 and later
Information in this document applies to any platform.

Symptoms

 When running ODM export, it fails and the following is seen by the client:

A General Error Occured ---> Oracle.DataAccess.Client.OracleException ORA-12170: TNS:Connect timeout occurred    at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure)
   at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, Object src)
   at Oracle.DataAccess.Client.OracleConnection.Open()
   at Platform.Storage.DBProvider.OpenConnection() in E:\ICEPlatform\AppServer\Storage\Providers\DBProvider.cs:line 1134
   at InFormAdapter.Framework.Common.LanguageCodeValidator.GetInFormVersion(String trial) in D:\AdapterFramework\Framework\IACommon\LanguageCodeValidator.cs:line 266
   at InFormAdapter.Framework.Common.LanguageCodeValidator.IsInternationalizedTrial(String trial) in D:\AdapterFramework\Framework\IACommon\LanguageCodeValidator.cs:line 242
   at InFormAdapter.ODM.ODMEngine.ValidateInputSchemaVersion(String trial) in D:\InformAdapter\ODM\ODMEngine.cs:line 186
   at InFormAdapter.ODM.ODMEngine.DownloadAdminDataODM(DownloadAdminDataODM obj) in D:\InformAdapter\ODM\ODMEngine.cs:line 70
   at InFormAdapter.ODM.ODMGateway.DownloadAdminDataODM(XmlElement node) in D:\InformAdapter\ODM\ODMGateway.cs:line 52
   at Adapter.Framework.Common.WebService.BigBrother.ExecuteWebMethod(WebMethodExecuter method, XmlElement xmlRequest) in D:\AdapterFramework\Framework\Common\WebServiceUtils.cs:line 57
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   at Adapter.Framework.Common.WebService.BigBrother.ExecuteWebMethod(WebMethodExecuter method, XmlElement xmlRequest) in D:\AdapterFramework\Framework\Common\WebServiceUtils.cs:line 86
   at InFormAdapter.ODM.InFormODM.DownloadAdminDataODM(XmlElement node) in D:\InformAdapter\ODM\InFormODM.asmx.cs:line 103
 Fault Detail : null

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms