Remote database hanging on connect - Front- & Back-End Development - Front- & Back-End Development - Progress Community
 Front- & Back-End Development

Remote database hanging on connect

  • Remote database hanging on connect
  • I'm working with a client to develop a Sitefinity 4.0 site.  I am creating some user controls and custom functionality.  I am currently using a 30-day trial of 4.0.  The genenator tag is rending as: Sitefinity 4.0.1098.0 SE

    Sitefinity works great when I connect to a local database.  But, when I give the site a remote IP and start the site on localhost, it hangs.  It does not timeout on the database connection, just a blank browser screen while the browser waits for a response.  This goes on for a long time and does not timeout.

    Any ideas?  Is this a security feature since it is a Trial copy?

  • Hello Caedmon,

    There should not be such a issue if you use remote SQL sever. Can you check from where the delay comes from? You can use fiddler or Http Watch. These tools can give you more information about the request and response. Also, make sure that the remote SQL server is up end running and it allows remote connections. If the browser hangs, most probably there is some issue with the connection. I was able to replicate similar issue if stop my local instance of the SQL where I have a project working with this instance.

    All the best,
    Ivan Dimitrov
    the Telerik team
    Registration for Q1 2011 What’s New Webinar Week is now open. Mark your calendar for the week starting March 21st and book your seat for a walk through all the exciting stuff we ship with the new release!
  • It seems that it was an extremely lagged connection.  Strange that it wasn't timing out faster.  Later in the day it began working correctly.

    Thanks much for all of your help.  I have not interacted with a vendor that was so quick to respond to their customers on a forum.  

    Thanks again!
  • Hello,

    I'm dealing with the "same" issue. Sometimes, after some work on the back-end and with some others users working at the same time, the browser keep waiting a response and it doesn't come back....

    The DB is serving requests, so the DB is not the problem. 

    I checked the logs and I found this:

    Timestamp: 8/8/2011 12:09:28 PM

    Message: HandlingInstanceID: 4143117c-0580-43a9-8228-bcd471187a72
    An exception of type 'System.ArgumentException' occurred and was caught.
    08/08/2011 08:09:28
    Type : System.ArgumentException, mscorlib, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089
    Message : Invalid type specified Telerik.Sitefinity.Security.Data.SecurityDataProvider
    Source : Telerik.Sitefinity
    Help link : 
    ParamName : 
    Data : System.Collections.ListDictionaryInternal
    TargetSite : TProviderBase InstantiateProvider(Telerik.Sitefinity.Configuration.IDataProviderSettings, System.Type, Telerik.Sitefinity.Abstractions.ExceptionPolicyName, Telerik.Sitefinity.Data.ManagerBase`1[TProviderBase])
    Stack Trace :    at Telerik.Sitefinity.Data.ManagerBase`1.InstantiateProvider(IDataProviderSettings providerSettings, Type providerType, ExceptionPolicyName policy, ManagerBase`1 manager)

    Additional Info:

    MachineName : machinename
    TimeStamp : 8/8/2011 12:09:28 PM
    FullName : Telerik.Sitefinity.Utilities, Version=4.1.1395.0, Culture=neutral, PublicKeyToken=b28c218413bdf563
    AppDomainName : /LM/W3SVC/1696818070/Root-1-129572789213592707
    ThreadIdentity : username
    Requested URL : /Sitefinity

    Category: ErrorLog

    Priority: 0

    EventId: 9010

    Severity: Warning

    Title:Enterprise Library Exception Handling

    Machine: machinename

    App Domain: /LM/W3SVC/1696818070/Root-1-129572789213592707

    ProcessId: 26348

    Process Name: c:\windows\system32\inetsrv\w3wp.exe

    Thread Name: 

    Win32 ThreadId:20944

    Extended Properties: 

    What can I do ?


  • Hi John,

    The stack shows that the error occurs when the configuration files are loaded. Most probably you went to Administration >> Settings >> Advanced and the data provider settings could not be initialized properly because somewhere you have used a type which is not proper. For example you set Telerik.Sitefinity.Security.Data.SecurityDataProvider as a RoleProvider or MembershipProvider type. The error doesn't show which config file has been modified, but you can check App_Data/Sitefinity/Configurations and check all configs. We generate only the configuration files that are changed, so you can easily track your modifications.

    Telerik.Sitefinity.Security.Data.SecurityDataProvider is not a valid type but this is the correct type, so the only reason for this error is changes in the configurations.

    Best wishes,
    Ivan Dimitrov
    the Telerik team
    Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get now >>
  • Thanks Ivan,

    After some tests I think I have two problems that are not related at all. 

    1. The website is hanging randomly (not often but this is a serious problem). I cannot replicate the issue yet. What can this be ?

    2. The error appearing in the log (previous post) is coming every time a user log in at the back-end. None of the config files are being updated when this happens, but the site continues to work.

    I'm sending you the DataConfig.config. Could you tell me if everything is ok in it ? If so, what else could I check ?

    <?xml version="1.0" encoding="utf-8"?>
    <dataConfig initialized="True">
    <add connectionString="data source=SQL_SERVER;initial catalog=DB_NAME;User ID=SQL_USER_LOGIN;Password=SQL_USER_PASS" providerName="System.Data.SqlClient" dbType="MsSql" name="Sitefinity" />
  • Hello John,

    The problem is not in the data config. Check the SecurityConfig if you have changed something related to the membership and role providers.

    Ivan Dimitrov
    the Telerik team
    Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get now >>
  • Hello Ivan,

    I haven't changed anything related to the membership or role providers ever..
    Below the SecurityConfig.config content:

    <?xml version="1.0" encoding="utf-8"?>
    <securityConfig xmlns:config="urn:telerik:sitefinity:configuration" xmlns:type="urn:telerik:sitefinity:configuration:type" config:version="4.1.1395.0" validationKey="9116BD1C3CF1DB1081A140FFB71EBE51581595FADFDE0DE75E12E329F4C7196FB27D005FA69973A97DD7F70EBA7744A791DFE59B3C4990CC033ADD42FAABEAA6" decryptionKey="18EA5BDAC69B40A032BBFF6BB62C043D4960E026148DA388A337DAC36848375F">
    <role id="50fe4dcd-f4be-4003-90ae-9986df54d2e0" name="Everyone" />
    <role id="152817b0-d3f8-49f9-b278-b9e84b0f1b4d" name="Anonymous" />
    <role id="70618a4e-f160-44e7-b370-f7264e92970d" name="Authenticated" />
    <role id="6750d532-89e6-4767-881b-5749fc93fe43" name="Owner" />
    <role id="b24a1efd-7944-4bcb-a4f1-0042dbbcdcb7" name="Administrators" />
    <role id="873d90e7-abc0-453f-a156-dd1550b4da71" name="BackendUsers" />
    <role id="c8ad9aa7-0d5c-434a-b230-91e21d6e6b1d" name="Authors" />
    <role id="587aab65-268b-4487-9c8e-24e4f651ffc9" name="Editors" />
    <role id="e1db745d-0174-43c1-a7ed-f607dc95b5f6" name="Designers" />
    <add version="4.1.1395.0" name="OpenAccessDataProvider" />
    <add description="" resourceClassId="" enabled="True" version="4.0.1210.0" name="XmlDataProvider" />

    I made a full text search of «SecurityDataProvider» in ALL solution files. No such string. So I don't understand where this error comes from...
    Do you ?

    Thanks, John.
  • Hello John,

    I don't have other explanation for this error and this is what I see in the debug mode  and our code. This type is correct, so the only assumption I can made are related to some changes in the configurations.
    You can try to comment

    <add version="4.1.1395.0" name="OpenAccessDataProvider" />
    <add description="" resourceClassId="" enabled="True" version="4.0.1210.0" name="XmlDataProvider" />

    because you should see the lines above only if the provers are changes. Also in both the lines there is difference between the version  - the first provider shows build 1395, since the second shows 1210.

    I see that you use an older version, so you can try to upgrade.

    All the best,
    Ivan Dimitrov
    the Telerik team
    Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get now >>