locked
"Connection request timed out" string (Error) RRS feed

  • Question

  • User662762443 posted

    Friends, good afternoon! I am getting the following error message:

    Message "Connection request has timeout". + OracleLogicalTransaction {Oracle.ManagedDataAccess.Client.OracleLogicalTransaction} Oracle.ManagedDataAccess.Client.OracleLogicalTransaction. Source: "Oracle Data Provider for .NET, Managed Driver" string. ($ exception) .StackTrace: in at OracleInternal.ConnectionPool.PoolManager`3.Get (ConnectionString csWithDiffOrNewPwd, Boolean bGetForApp, CriteriaCtx CriteriaCtx, String affinityInstanceName, Boolean bForceMatch) in OracleInternal.ConnectionPool.OraclePoolManager.Get (ConnectionString csWithNewPassword, Boolean bGetForApp, CriteriaCtx criteriaCtx, String affinityInstanceName, Boolean bForceMatch) in OracleInternal.ConnectionPool.OracleConnectionDispenser`3.Get (ConnectionString cs, PM conPM, ConnectionString pmCS, SecureString securedPassword, SecureString securedProxyPassword, CriteriaCtx criteriaCtx) in Oracle.ManagedDataAccess.Client.OracleConnection.Open () in NHibernate.Connection.DriverConnectionProvider.GetConnection ()

    in NHibernate.Tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.Prepare () in NHibernate.Tool.hbm2ddl.SchemaMetadataUpdater.GetReservedWords (Dialect dialect, IConnectionHelper connectionHelper) in NHibernate.Tool.hbm2ddl.SchemaMetadataUpdater.Update (ISessionFactory sessionFactory) in NHibernate.Impl.SessionFactoryImpl..ctor (Configuration cfg, IMapping mapping, Settings settings, EventListeners listeners)

    em NHibernate.Cfg.Configuration.BuildSessionFactory() em SDPJDominio.DataAccess.NhibernateHelper.HelpThreading() na D:\Repositório SVN\SDP\SDPJ\branches\SDPJ-V3.1.0\SDPJ-102\SDPJDominio\DataAccess\NhibernateHelper.cs:linha 41 em SDPJView.ImportacaoProcessoView.ImportacaoProcesso.<>c__DisplayClass20_0.<ProcessamentoTabela>b__0(Object dados) na D:\Repositório SVN\SDP\SDPJ\branches\SDPJ-V3.1.0\SDPJ-102\SDPJView\ImportacaoProcessoView\ImportacaoProcesso.aspx.cs:linha 209 em System.Threading.Tasks.Task.InnerInvoke() em System.Threading.Tasks.Task.Execute()

    Thursday, July 12, 2018 9:57 PM

Answers

  • User36583972 posted


    Hi rtaVix,

    May be you can set a large connection timeout using connection string.

    For more detailed : Oracle ManagedDataAccess - Connection Request Timed out - Pooling

    You can refer the DA924's suggestion, visit the related Oracle Forum for getting suitable help.

    Note: This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.


    Best Regards,

    Yong Lu

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, July 13, 2018 7:55 AM

All replies

  • User1120430333 posted

    It's probably where you need to post.

    https://community.oracle.com/community/database/developer-tools/windows_and_.net/odp.net

    Friday, July 13, 2018 12:52 AM
  • User662762443 posted

    Friend and everyone who is looking at this topic, I already signed up in the other oracle community to help me post, but no one has yet answered about this strange problem. I need to resolve with a certain speed on this fact, if you are interested in helping me, I thank you all from here. Regards, RtaVix

    Friday, July 13, 2018 2:20 AM
  • User36583972 posted


    Hi rtaVix,

    May be you can set a large connection timeout using connection string.

    For more detailed : Oracle ManagedDataAccess - Connection Request Timed out - Pooling

    You can refer the DA924's suggestion, visit the related Oracle Forum for getting suitable help.

    Note: This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.


    Best Regards,

    Yong Lu

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, July 13, 2018 7:55 AM
  • User662762443 posted

    Friend, I realized that even using the threads, I'm consuming too much in my queries in that part of my code:

    Friday, July 13, 2018 1:52 PM