"Connection request timed out" string (Error)

  • Thread starter Thread starter rta_vix
  • Start date Start date
R

rta_vix

Guest
Friends, 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 (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.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) in NHibernate.Cfg.Configuration.BuildSessionFactory()

in SDPJDominio.DataAccess.NhibernateHelper.HelpThreading()

D:\Repositório SVN\SDP\SDPJ\branches\SDPJ-V3.1.0\SDPJ-102\SDPJDominio\DataAccess\NhibernateHelper.cs:linha 41

in SDPJView.ImportacaoProcessoView.ImportacaoProcesso.<>c__DisplayClass20_0.<ProcessamentoTabela>b__0(Object dados)

D:\RepositórioSVN\SDP\SDPJ\branches\SDPJV3.1.0\SDPJ102\SDPJView\ImportacaoProcessoView\ImportacaoProcesso.aspx.cs:

line 209 in System.Threading.Tasks.Task.InnerInvoke()

in 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>


Help me!

Continue reading...
 
Back
Top