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

Forums / Bugs & Issues / Bug : website crashes and throws DB login error

Bug : website crashes and throws DB login error

2 posts, 0 answered
  1. Luke Andersen
    Luke Andersen avatar
    1 posts
    Registered:
    14 Dec 2009
    21 Jul 2010
    Link to this post
    Hi all,

    I have been having an intermittent issue since upgrading an exisiting SiteFinity site from 3.2 to 3.2 SP2.
    The upgrade was required in order to get the image library paging working correctly as part of the SP2 fixes.
    However I am finding that in the live environment the site will stop working maybe 3-4 times a week at random times and throws the error below. Although the message states the error as 'login has failed' the database and login are always operating fine. I have found that this can be resolved by simpily restarting the App Pool for the site and also restarting the website within IIS. However due to the intermittent nature of the issue the site can be down for several hours before this process can be carried out. I have checked the server logs and the only message(s) that occur at or around the same time refer to the recycle process on the App Pool, but as this is a standard part of IIS I can't see how this is related. Any help would be greatly appreciated.

    Exception Type: System.TypeInitializationException

    Message: The type initializer for 'Telerik.Cms.CmsWorkflowService' threw an exception.

    Source: Telerik.Cms

    Stack Trace:
       at Telerik.Cms.CmsWorkflowService.Initialize()
       at Telerik.Cms.CmsManager.OnInitialized()
       at Telerik.ManagerBase`1.Initialize()
       at Telerik.ManagerBase`1..ctor(String providerName)
       at Telerik.ManagerBase`1..ctor()
       at Telerik.Cms.CmsManager..ctor()
       at Telerik.Cms.Web.UrlHelper..cctor()
    ------------------------------------------------------------------------------------
    - L1 -------------------------------------------------------------------------------

    Exception Type: System.Data.SqlClient.SqlException

    Message: Cannot open database "Database" requested by the login. The login failed.
    Login failed for user 'sa'.

    Source: .Net SqlClient Data Provider

    Stack Trace:
       at Nolics.ORMapper.DataProviders.SQLDataProvider.Open()
       at Telerik.DataAccess.NolicsHelper.SetConnection(String connectionName, String providerName)
       at Telerik.Cms.Data.DefaultProvider.Initialize(String name, NameValueCollection config)
       at Telerik.ManagerBase`1.InstantiateProvider(ProviderSettings providerSettings, Type providerType)
       at Telerik.ManagerBase`1.InstantiateProvider(ProviderSettings providerSettings)
       at Telerik.ManagerBase`1.SetProvider(String providerName)
       at Telerik.ManagerBase`1..ctor(String providerName)
       at Telerik.ManagerBase`1..ctor()
       at Telerik.Cms.CmsWorkflowService..ctor()
       at Telerik.Cms.CmsWorkflowService..cctor()
  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    25 Nov 2016
    21 Jul 2010
    Link to this post
    Hi Luke Andersen,

    The issue could not come from the data provider. Something is wrong with your SQL server. You could additionally create a simple control that opens SQL connection and trigger it on each minute. You could also increase the time for AppPool recycling and AppPool memory limits.

    Best wishes,
    Ivan Dimitrov
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
2 posts, 0 answered