+1-888-365-2779
Try Now
More in this section

Forums / Bugs & Issues / Oracle Maximum Sessions

Oracle Maximum Sessions

4 posts, 0 answered
  1. Jacques
    Jacques avatar
    427 posts
    Registered:
    28 Jun 2007
    12 Aug 2010
    Link to this post
    Anyone using Sitefinity on Oracle experience issues with Maximum Sessions being reached? Seems to happen predominantly when Search bots access the site.

    Regards,
    Jacques
  2. Jacques
    Jacques avatar
    427 posts
    Registered:
    28 Jun 2007
    16 Aug 2010
    Link to this post
    Anyone experiencing similar problems?

    This problem with connections to the database seems to occur mostly when search bots or WebTrends tries to access the system.

    Thanks,
    Jacques
  3. Jacques
    Jacques avatar
    427 posts
    Registered:
    28 Jun 2007
    16 Aug 2010
    Link to this post
    Here is another example where WebTrends is trying to access a relevant resource, yet an exception is still being thrown:

    8/13/2010 9:52:14 AM [UNKNOWN]
    ************************************************************************************
    ID: a0bde4ce-0c31-490b-b03e-6f12cb40dba8; Code: 3005; Occurrence: 4; Sequence: 65
    ------------------------------------------------------------------------------------

    Application information:
        Machine name: hidden
        OS Version: Microsoft Windows NT 5.2.3790 Service Pack 2
        Product Version: 3.7.2096.2
        Application Path: hidden
        Debug: True

    Process information:
        Process ID: 23844
        Process Name: w3wp

    Request information:
        Request URL: /products/business-insurance/overview.aspx
        Rewrite URL: http://www.thedominion.ca/sitefinity/cmsentrypoint.aspx
        Url Referrer:     Is Authenticated: False
        Authentication Type:
        User:
        User Agent: WebTrends/3.0 (WinNT)
        User Address: 172.16.1.106

    Variables:
        SF_Crawler: False
        AspSessionIDManagerInitializeRequestCalled: True
        Sitefinity.UrlChahged: True
        cmspageid: 41141397-72e7-4d35-af6e-9b10d3ce88cd
        CmsHttpRequest: /products/business-insurance/overview.aspx
        RadControlRandomNumber: 0
        cmsurlcontext: Overview

    - L0 -------------------------------------------------------------------------------

    Exception Type: System.Data.OracleClient.OracleException

    Message: ORA-03135: connection lost contact


    Source: System.Data.OracleClient

    Stack Trace:
       at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
       at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
       at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
       at System.Data.OracleClient.OracleConnection.Open()
       at Nolics.ORMapper.DataProviders.OracleProvider.newConnection(String connectionString)
       at Nolics.ORMapper.DataProviders.SQLDataProvider.GetConnection()
       at Telerik.DataAccess.GCOracleProvider.GetSQLBuilder()
       at Nolics.ORMapper.DataProviders.SQLDataProvider.ExecuteKeyQuery(DataSet queries, Boolean fPrimaryKey)
       at Nolics.ORMapper.DataProviders.SQLDataProvider.QueryByPrimaryKey(DataSet keys)
       at Nolics.ORMapper.Base.PrimeryKeyQuery.LoadPKQuery()
       at Nolics.ORMapper.Base.OdbClass.LoadByPrimaryKey(IOdbClass primaryKey, OdbDataProvider provider, ObDataCache cache)
       at Telerik.Cms.Engine.Data.Providers.DefaultProvider.GetContent(Guid id, String itemInfo)
       at Telerik.Cms.Engine.Data.Providers.DefaultProvider.GetContent(Guid id)
       at Telerik.Cms.Engine.ContentManager.GetContent(Guid id)
       at Telerik.Cms.Engine.WebControls.GenericContent.get_SharedContent()
       at Telerik.Cms.Engine.WebControls.GenericContent.Render(HtmlTextWriter writer)
       at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
       at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter)
       at System.Web.UI.Control.RenderControl(HtmlTextWriter writer)
       at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
       at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer)
       at System.Web.UI.Control.Render(HtmlTextWriter writer)
       at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
       at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter)
       at System.Web.UI.Control.RenderControl(HtmlTextWriter writer)
       at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
       at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer)
       at System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer)
       at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer)
       at System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTextWriter output)
       at System.Web.UI.Adapters.ControlAdapter.Render(HtmlTextWriter writer)
       at Telerik.Cms.Web.FormAdapter.Render(HtmlTextWriter writer)
       at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
       at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter)
       at System.Web.UI.HtmlControls.HtmlForm.RenderControl(HtmlTextWriter writer)
       at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
       at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer)
       at System.Web.UI.Control.Render(HtmlTextWriter writer)
       at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
       at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter)
       at System.Web.UI.Control.RenderControl(HtmlTextWriter writer)
       at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
       at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer)
       at System.Web.UI.Page.Render(HtmlTextWriter writer)
       at Telerik.Web.UI.RadAjaxPage.Render(HtmlTextWriter writer)
       at Telerik.Cms.Web.InternalPage.Render(HtmlTextWriter writer)
       at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
       at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter)
       at System.Web.UI.Control.RenderControl(HtmlTextWriter writer)
       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
    ------------------------------------------------------------------------------------
  4. Jacques
    Jacques avatar
    427 posts
    Registered:
    28 Jun 2007
    16 Aug 2010
    Link to this post
    Also as a result of these exceptions that are occurring we have the following event that will occur from time to time:

    ISAPI 'C:\Windows\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll' reported itself as unhealthy for the following reason: 'Deadlock detected'.

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Register for webinar
4 posts, 0 answered