c# Connection request timed out" string

rtavix · Julho 13, 2018

Amigos, boa tarde! Estou recebendo a seguinte mensagem de erro:

Mensagem "Solicitação de conexão tem tempo limite". + OracleLogicalTransaction {Oracle.ManagedDataAccess.Client.OracleLogicalTransaction} Oracle.ManagedDataAccess.Client.OracleLogicalTransaction. Fonte: seqüência de caracteres "Oracle Data Provider para .NET, Driver gerenciado". ($ exception) .StackTrace: em OracleInternal.ConnectionPool.PoolManager`3.Get (ConnectionString csWithDiffOrNewPwd, Boolean bGetForApp, CriteriaCtx CriteriaCtx, Cadeia affinityInstanceName, Boolean bForceMatch) em OracleInternal.ConnectionPool.OraclePoolManager.Get (ConnectionString csWithNewPassword, Boolean bGetForApp, CriteriaCtx criteriaCtx, String affinityInstanceName, Boolean bForceMatch) em OracleInternal.ConnectionPool.OracleConnectionDispenser`3.Get (ConnectionString cs, PM conPM, ConnectionString pmCS, SecureString protectedPassword, SecureString protectedProxyPassword,

em NHibernate.Tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.Prepare () em NHibernate.Tool.hbm2ddl.SchemaMetadataUpdater.GetReservedWords (Dialect dialect, IConnectionHelper connectionHelper) em NHibernate.Tool.hbm2ddl.SchemaMetadataUpdater.Update (ISessionFactory sessionFactory) em NHibernate.Impl.SessionFactoryImpl. .ctor (Configuração cfg, mapeamento IMapping, configurações Settings, ouvintes EventListeners)

em NHibernate.Cfg.Configuration.BuildSessionFactory () em SDPJDominio.DataAccess.NhibernateHelper.HelpThreading () na D: \ Repositório SVN \ SDP \ SDPJ \ filiais \ SDPJ-V3.1.0 \ SDPJ-102 \ SDPJDominio \ DataAccess \ NhibernateHelper.cs : linha 41 em SDPJView.ImportacaoProcessoView.ImportacaoProcesso. <> c__DisplayClass20_0. <ProcessamentoTabela> b__0 (Dados do objeto) na D: \ Repositório SVN \ SDP \ SDPJ \ ramais \ 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 ()

DataAccess, NhibernateHelp:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using NHibernate.Mapping.Attributes;
using NHibernate.Cfg;
using NHibernate;
using System.IO;
using NHibernate.Context;
using System.Reflection;
using Oracle.ManagedDataAccess.Client;

namespace SDPJDominio.DataAccess
{
    public class NhibernateHelper
    {
        private ISessionFactory sessionFactory;


        public static ISession GetSession ()
        {
            if (! CurrentSessionContext.HasBind (Instance.GetSessionFactory ()))
                CurrentSessionContext.Bind (Instance.GetSessionFactory (). OpenSession ());
            
            return Instance.GetSessionFactory (). GetCurrentSession ();
        }
        
        public static ISessionFactory HelpThreading ()
        {
            MemoryStream stream = new System.IO.MemoryStream ();
            HbmSerializer.Default.Validate = true;
            //HbmSerializer.Default.Serialize(stream, AppDomain.CurrentDomain.GetAssemblies () .Where (w => w.FullName.Contains ("SDPJDomain").) FirstOrDefault ());
            HbmSerializer.Default.Serialize (stream, System.Reflection.Assembly.GetExecutingAssembly ());
            stream.Position = 0;
            Configuration configuration = new Configuration ();
            configuration.Configure ();
            configuration.SetProperty ("connection.connection_string", ConfigNhibernate.getConfig ());
            configuration.SetProperty ("current_session_context_class", "thread_static");
            configuration.AddInputStream (stream);
            stream.Close ();
            Instance.sessionFactory = configuration.BuildSessionFactory ();
            return Instance.sessionFactory;
        }

public NhibernateHelper ()
        {
            MemoryStream stream = new System.IO.MemoryStream ();
            HbmSerializer.Default.Validate = true;
            HbmSerializer.Default.Serialize (stream, System.Reflection.Assembly.GetExecutingAssembly ());
            stream.Position = 0;
            Configuration configuration = new Configuration ();
            configuration.Configure ();
            configuration.SetProperty ("connection.connection_string", ConfigNhibernate.getConfig ()); // add this line
            configuration.AddInputStream (stream);
            stream.Close ();

            sessionFactory = configuration.BuildSessionFactory ();
        }

        public static ISessionFactory SessionFactory
        {
            get {return Instance.sessionFactory; }
        }

        private ISessionFactory GetSessionFactory ()
        {
            return sessionFactory;
        }

        public static NhibernateHelper Instance
        {
            get
            {
                return CreateSessionGenerator.
            }
        }

        public static ISession OpenSession ()
        {
            return Instance.GetSessionFactory (). OpenSession ();
        }

        public static void ReloadSession (object obj)
        {
            SessionRefresh (obj);
        }

        public static ISession SessionCurrent
        {
            get
            {
                
                if (! CurrentSessionContext.HasBind (Instance.GetSessionFactory ()))
                    return null;
                return Instance.GetSessionFactory (). GetCurrentSession ();
            }
        }

        class CreateSessionKey
        {
            internal static readonly NhibernateHelperSession Manager = new NhibernateHelper ();
        }


    }
}

line: 209

Action <object> processing = (data) =>
            {
                NHibernate.Context.ThreadStaticSessionContext.Bind (NhibernateHelper.HelpThreading ().OpenSession ());
            }

WebConfig:

<?xml version="1.0" encoding="utf-8"?>
<configuration>
	<configSections>
		<section name="extnet" type="Ext.Net.GlobalConfig" requirePermission="false" />
		<sectionGroup name="applicationSettings" type="System.Configuration.ApplicationSettingsGroup, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
			<section name="SDPJView.Properties.Settings" type="System.Configuration.ClientSettingsSection, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
		</sectionGroup>
		<sectionGroup name="businessObjects">
			<sectionGroup name="crystalReports">
				<section name="rptBuildProvider" type="CrystalDecisions.Shared.RptBuildProviderHandler, CrystalDecisions.Shared, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304, Custom=null" />
				<section name="crystalReportViewer" type="System.Configuration.NameValueSectionHandler" />
			</sectionGroup>
		</sectionGroup>
		<section name="oracle.manageddataaccess.client" type="OracleInternal.Common.ODPMSectionHandler, Oracle.ManagedDataAccess, Version=4.122.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342" />
	</configSections>

	<extnet theme="Gray" />

    <location path="Content/temp">
        <system.web>
            <authorization>
                <allow users="?" />
            </authorization>
        </system.web>
    </location>
	<location path="Content/css">
		<system.web>
			<authorization>
				<allow users="?" />
			</authorization>
		</system.web>
	</location>
	<location path="Content/img_SDPJ">
		<system.web>
			<authorization>
				<allow users="?" />
			</authorization>
		</system.web>
	</location>
	<location path="Autenticacao">  
		<system.web>
			<authorization>
				<allow users="?" />
			</authorization>
		</system.web>
	</location>
	<appSettings>
		<add key="CodigoSistema" value="SDPJ" />
		<add key="CodigoModulo" value="INTRANET" />
		<add key="CrystalImageCleaner-AutoStart" value="true" />
		<add key="CrystalImageCleaner-Sleep" value="60000" />
		<add key="CrystalImageCleaner-Age" value="120000" />
	</appSettings>
	<connectionStrings>
		<add name="ADConnectionString" connectionString="LDAP://net.sefaz.es.gov.br" />
		<add name="ConnectionString" connectionString="DATA SOURCE=DAPP;PASSWORD=A#$##$$;USER ID=APL_SDP" providerName="Oracle.DataAccess.Client" />
	</connectionStrings>
	<businessObjects>
		<crystalReports>
			<rptBuildProvider>
				<add embedRptInResource="true" />
			</rptBuildProvider>
			<crystalReportViewer>
				<add key="ResourceUri" value="../../aspnet_client/system_web/4_0_30319/crystalreportviewers13" />
			</crystalReportViewer>
		</crystalReports>
	</businessObjects>
	<system.web>
		<!-- 
            Set compilation debug="true" to insert debugging 
            symbols into the compiled page. Because this 
            affects performance, set this value to true only 
            during development.
        -->
		<siteMap defaultProvider="XmlSiteMapProvider" enabled="true">
			<providers>
				<add name="XmlSiteMapProvider" description="Default SiteMap provider" type="System.Web.XmlSiteMapProvider" siteMapFile="~/Content/Navigation.sitemap" securityTrimmingEnabled="true" />
			</providers>
		</siteMap>
		<compilation debug="true">
			<assemblies>
				<add assembly="System.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
				<add assembly="System.Web.Extensions.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
				<add assembly="System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" />
				<add assembly="CrystalDecisions.CrystalReports.Engine, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" />
				<add assembly="CrystalDecisions.ReportSource, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" />
				<add assembly="CrystalDecisions.Shared, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" />
				<add assembly="CrystalDecisions.Web, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" />
				<add assembly="CrystalDecisions.ReportAppServer.ClientDoc, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" />
				<add assembly="Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
				<add assembly="Microsoft.ReportViewer.Common, Version=10.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
				<add assembly="Microsoft.Build.Framework, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
				<add assembly="System.Management, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
			</assemblies>
		</compilation>
		<globalization fileEncoding="utf-8" requestEncoding="utf-8" responseEncoding="utf-8" culture="pt-br" />
		<!--<globalization enableClientBasedCulture="false" requestEncoding="utf-8" responseEncoding="utf-8" fileEncoding="iso-8859-1" responseHeaderEncoding="utf-8" resourceProviderFactoryType="string" enableBestFitResponseEncoding="true" culture="pt-BR" uiCulture="pt-BR"/>-->
		<!--
            The <authentication> section enables configuration 
            of the security authentication mode used by 
            ASP.NET to identify an incoming user. 
        -->
		<authorization>
			<deny users="?" />
		</authorization>
		<authentication mode="Forms">
			<forms loginUrl="~/Autenticacao/Login.aspx" timeout="20" defaultUrl="~/Default.aspx" slidingExpiration="true" />
		</authentication>

		<sessionState timeout="10" />
		<machineKey validationKey="C50B3C89CB21F4F1422FF158A5B42D0E8DB8CB5CDA1742572A487D9401E3400267682B202B746511891C1BAF47F8D25C07F6C39A104696DB51F17C529AD3CABE" decryptionKey="8A9BE8FD67AF6979E7D20198CFEA50DD3D3799C77AF2B72F" validation="SHA1" />
		<membership defaultProvider="SDPJMembershipProvider">
			<providers>
				<clear />
				<add name="SDPJMembershipProvider" type="SDPJView.Seguranca.SDPJMembershipProvider" connectionStringName="ADConnectionString" writeExceptionsToEventLog="false" applicationName="/SDPJView" />
			</providers>
		</membership>
		<!--
            The <customErrors> section enables configuration 
            of what to do if/when an unhandled error occurs 
            during the execution of a request. Specifically, 
            it enables developers to configure html error pages 
            to be displayed in place of a error stack trace.

        <customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
            <error statusCode="403" redirect="NoAccess.htm" />
            <error statusCode="404" redirect="FileNotFound.htm" />
        </customErrors>
        -->
		<customErrors mode="Off" />
		<!--<pages validateRequest="false" controlRenderingCompatibilityVersion="3.5" clientIDMode="AutoID"/>-->
		<pages controlRenderingCompatibilityVersion="4.0" clientIDMode="AutoID">
			<controls>
				<add assembly="Ext.Net" namespace="Ext.Net" tagPrefix="ext" />
			</controls>
		</pages>
		<httpHandlers>
			<add path="*/ext.axd" verb="*" type="Ext.Net.ResourceHandler" validate="false" />
			<add verb="GET" path="CrystalImageHandler.aspx" type="CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" />
		</httpHandlers>
		<httpModules>
			<add name="DirectRequestModule" type="Ext.Net.DirectRequestModule, Ext.Net" />
		</httpModules>
		<httpRuntime maxRequestLength="102400" />
	</system.web>
	<!-- 
        The system.webServer section is required for running ASP.NET AJAX under Internet
        Information Services 7.0.  It is not necessary for previous version of IIS.
    -->
	<system.webServer>
		<httpErrors errorMode="Detailed" />
		<asp scriptErrorSentToBrowser="true" />
		<validation validateIntegratedModeConfiguration="false" />
		<modules runAllManagedModulesForAllRequests="true">
			<add name="DirectRequestModule" preCondition="managedHandler" type="Ext.Net.DirectRequestModule, Ext.Net" />
		</modules>
		<handlers accessPolicy="Read, Execute, Script">
			<add name="CrystalImageHandler.aspx_GET" verb="GET" path="CrystalImageHandler.aspx" type="CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" preCondition="integratedMode" />
			<add name="DirectRequestHandler" verb="*" path="*/ext.axd" preCondition="integratedMode" type="Ext.Net.ResourceHandler" />
			<add name="AboMapperCustom-9501872-V4" path="*.axd" verb="*" modules="IsapiModule" scriptProcessor="C:\Windows\Microsoft.NET\Framework\v4.0.30319\aspnet_isapi.dll" resourceType="Unspecified" preCondition="classicMode,runtimeVersionv4.0,bitness32" />
			<add name="AboMapperCustom-9501871-V4.0" path="*.aspx" verb="*" modules="IsapiModule" scriptProcessor="C:\Windows\Microsoft.NET\Framework\v4.0.30319\aspnet_isapi.dll" resourceType="Unspecified" preCondition="classicMode,runtimeVersionv4.0,bitness32" />
			<add name="AboMapperCustom-9501870-V4.0" path="*.asmx" verb="*" modules="IsapiModule" scriptProcessor="C:\Windows\Microsoft.NET\Framework\v4.0.30319\aspnet_isapi.dll" resourceType="Unspecified" preCondition="classicMode,runtimeVersionv4.0,bitness32" />
			<add name="AboMapperCustom-9501869-V4.0" path="*.ashx" verb="*" modules="IsapiModule" scriptProcessor="C:\Windows\Microsoft.NET\Framework\v4.0.30319\aspnet_isapi.dll" resourceType="Unspecified" preCondition="classicMode,runtimeVersionv4.0,bitness32" />
			<add name="AboMapperCustom-9501868-V4.0" path="*.ascx" verb="*" modules="IsapiModule" scriptProcessor="C:\Windows\Microsoft.NET\Framework\v4.0.30319\aspnet_isapi.dll" resourceType="Unspecified" preCondition="classicMode,runtimeVersionv4.0,bitness32" />
			<add name="AboMapperCustom-9501867-V4.0" path="*.asax" verb="*" modules="IsapiModule" scriptProcessor="C:\Windows\Microsoft.NET\Framework\v4.0.30319\aspnet_isapi.dll" resourceType="Unspecified" preCondition="classicMode,runtimeVersionv4.0,bitness32" />
			<add name="ScriptResource" path="ScriptResource.axd" verb="GET,HEAD" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" resourceType="Unspecified" requireAccess="Script" preCondition="integratedMode" />
		</handlers>
	</system.webServer>
	<runtime>
		<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
			<dependentAssembly>
				<assemblyIdentity name="AjaxControlToolkit" publicKeyToken="28f01b0e84b6d53e" culture="neutral" />
				<bindingRedirect oldVersion="0.0.0.0-3.0.30930.28736" newVersion="4.1.50508.0" />
			</dependentAssembly>
			<dependentAssembly>
				<assemblyIdentity name="Newtonsoft.Json" publicKeyToken="30ad4fe6b2a6aeed" />
				<bindingRedirect oldVersion="1.0.0.0-4.5.10" newVersion="4.5.11" />
			</dependentAssembly>
			<dependentAssembly>
				<assemblyIdentity name="Ext.Net.Utilities" publicKeyToken="2c34ac34702a3c23" />
				<bindingRedirect oldVersion="0.0.0.0-2.2.0" newVersion="2.2.1" />
			</dependentAssembly>
			<dependentAssembly>
				<assemblyIdentity name="Transformer.NET" publicKeyToken="e274d618e7c603a7" />
				<bindingRedirect oldVersion="0.0.0.0-2.1.0" newVersion="2.1.1" />
			</dependentAssembly>
			<dependentAssembly>
				<publisherPolicy apply="no" />
				<assemblyIdentity name="Oracle.ManagedDataAccess" publicKeyToken="89b483f429c47342" culture="neutral" />
			</dependentAssembly>
			<dependentAssembly>
				<assemblyIdentity name="CrystalDecisions.CrystalReports.Engine" publicKeyToken="692fbea5521e1304" culture="neutral" />
				<bindingRedirect oldVersion="0.0.0.0-13.0.2000.0" newVersion="13.0.2000.0" />
			</dependentAssembly>
			<dependentAssembly>
				<assemblyIdentity name="CrystalDecisions.Shared" publicKeyToken="692fbea5521e1304" culture="neutral" />
				<bindingRedirect oldVersion="0.0.0.0-13.0.3500.0" newVersion="13.0.3500.0" />
			</dependentAssembly>
			<dependentAssembly>
				<assemblyIdentity name="CrystalDecisions.ReportSource" publicKeyToken="692fbea5521e1304" culture="neutral" />
				<bindingRedirect oldVersion="0.0.0.0-13.0.2000.0" newVersion="13.0.2000.0" />
			</dependentAssembly>
			<dependentAssembly>
				<assemblyIdentity name="NHibernate" publicKeyToken="aa95f207798dfdb4" culture="neutral" />
				<bindingRedirect oldVersion="0.0.0.0-4.1.0.4000" newVersion="4.1.0.4000" />
			</dependentAssembly>
			<dependentAssembly>
				<assemblyIdentity name="Iesi.Collections" publicKeyToken="aa95f207798dfdb4" culture="neutral" />
				<bindingRedirect oldVersion="0.0.0.0-4.0.0.0" newVersion="4.0.0.0" />
			</dependentAssembly>
			<dependentAssembly>
				<assemblyIdentity name="Castle.Core" publicKeyToken="407dd0808d44fbdc" culture="neutral" />
				<bindingRedirect oldVersion="0.0.0.0-1.1.0.0" newVersion="1.1.0.0" />
			</dependentAssembly>
		</assemblyBinding>
	</runtime>
	<system.serviceModel>
		<bindings>
   <basicHttpBinding>
    <binding name="IntegrationWSBindingP" closeTimeout="00:10:50" openTimeout="00:10:05" receiveTimeout="00:10:05" sendTimeout="00:10:05" maxReceivedMessageSize="10000000">
     <security mode="Transport" />
    </binding>
    <binding name="IntegrationWSBindingH" closeTimeout="00:10:50" openTimeout="00:10:05" receiveTimeout="00:10:05" sendTimeout="00:10:05" maxReceivedMessageSize="10000000" />
   </basicHttpBinding>
  </bindings>
		<client>
   <endpoint address="https://portalinternet.banestes.com.br/br.com.banestes.djw.integration.server/IntegrationWSPort" binding="basicHttpBinding" bindingConfiguration="IntegrationWSBindingP" contract="IntegracaoBanestesProducao.IntegrationWS" name="IntegrationWSPort" />
   <endpoint address="http://portalinternet.h.banestes.com.br/br.com.banestes.djw.integration.server/IntegrationWSPort" binding="basicHttpBinding" bindingConfiguration="IntegrationWSBindingH" contract="IntegracaoBanestesHomologacao.IntegrationWS" name="IntegrationWSPort1" />
  </client>
		<serviceHostingEnvironment aspNetCompatibilityEnabled="true" />
		<standardEndpoints>
			<webScriptEndpoint>
				<standardEndpoint name="" crossDomainScriptAccessEnabled="true" />
			</webScriptEndpoint>
		</standardEndpoints>
	</system.serviceModel>
	
</configuration>

Entrar

Arquivado

c# Connection request timed out" string

Recommended Posts

rtavix 0

Compartilhar este post

Link para o post

Compartilhar em outros sites

PHP+Codeigniter - Adicionar Registro Plano de Contas

Javascript - Passar Parâmetros para uma Função.

PHP - Consulta MySql para prazo de dias

Conteúdo Similar

Este projeto é apoiado pelas empresas

Fóruns

Tempo Real

Informação importante