Sign in Register
Go to solution
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • TaoistTotty 246 posts 314 karma points
    Apr 13, 2011 @ 00:37
    TaoistTotty
    0

    503 error on 4.0.3 site move

    I am seeing a 503 error for a site just moved to shared hosting.

    Have managed to get the following error information

    Server Error in '/' Application.

    The SELECT permission was denied on the object 'umbracoUser', database 'justwater', schema 'dbo'.

    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.Data.SqlClient.SqlException: The SELECT permission was denied on the object 'umbracoUser', database 'justwater', schema 'dbo'.

    Source Error:

    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.


    Stack Trace:

     

    [SqlException (0x80131904): The SELECT permission was denied on the object 'umbracoUser', database 'justwater', schema 'dbo'.]

       System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +212

       System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +245

       System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2811

       System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +58

       System.Data.SqlClient.SqlDataReader.get_MetaData() +112

       System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +6281668

       System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +6282737

       System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +424

       System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +28

       System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +211

       System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) +87

       Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) +125

       Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +194

       umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteReader(String commandText, SqlParameter[] parameters) in d:\TeamCity\buildAgent\work\7380c184e9fcd3ea\umbraco\datalayer\SqlHelpers\SqlServer\SqlServerHelper.cs:77

       umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) in d:\TeamCity\buildAgent\work\7380c184e9fcd3ea\umbraco\datalayer\SqlHelper.cs:240

     

    [SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader]

       umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) in d:\TeamCity\buildAgent\work\7380c184e9fcd3ea\umbraco\datalayer\SqlHelper.cs:246

       umbraco.BusinessLogic.User.setupUser(Int32 ID) +205

       umbraco.BusinessLogic.User.GetUser(Int32 id) +188

       umbraco.content.LoadContentFromDatabase(Boolean loadDocuments) +211

       umbraco.content.LoadContent() +83

       umbraco.content.get_XmlContentInternal() +77

       umbraco.content.get_XmlContent() +125

       umbraco.UmbracoDefault.Page_PreInit(Object sender, EventArgs e) +1116

       System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +25

       System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +42

       System.EventHandler.Invoke(Object sender, EventArgs e) +0

       System.Web.UI.Page.OnPreInit(EventArgs e) +11045870

       System.Web.UI.Page.PerformPreInit() +42

       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1256

     

    Version Information: Microsoft .NET Framework Version:2.0.50727.4952; ASP.NET Version:2.0.50727.4955

    Request Details

    Session Id:

    Request Type:

    GET

    Time of Request:

    12/04/2011 21:51:43

    Status Code:

    500

    Request Encoding:

    Unicode (UTF-8)

    Response Encoding:

    Unicode (UTF-8)

     

    Trace Information

    Category

    Message

    From First(s)

    From Last(s)

    registerIapplications

    + Adding application 'umbraco.presentation.nodeFactory.UmbracoSiteMapProviderAccessUpdate

    registerIapplications

    + Adding application 'Umbraco.Forms.Core.Services.WorkflowServiceApplication

    0.0127711762249113

    0.012771

    aspx.page

    Begin PreInit

    0.137126925349451

    0.124356

    umbracoInit

    handling request

    0.144723421552181

    0.007596

    Unhandled Execution Error


    Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader
      at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) in d:\TeamCity\buildAgent\work\7380c184e9fcd3ea\umbraco\datalayer\SqlHelper.cs:line 246
      at umbraco.BusinessLogic.User.setupUser(Int32 ID)
      at umbraco.BusinessLogic.User.GetUser(Int32 id)
      at umbraco.content.LoadContentFromDatabase(Boolean loadDocuments)
      at umbraco.content.LoadContent()
      at umbraco.content.get_XmlContentInternal()
      at umbraco.content.get_XmlContent()
      at umbraco.UmbracoDefault.Page_PreInit(Object sender, EventArgs e)
      at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
      at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
      at System.EventHandler.Invoke(Object sender, EventArgs e)
      at System.Web.UI.Page.OnPreInit(EventArgs e)
      at System.Web.UI.Page.PerformPreInit()
      at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

    0.162507804762896

    0.017784

    The hosting company is saying all the settings are correct, and have confirmed that the database connection string is correct.

    Any suggestions as to where to look?

    Regards

    TT

    Copy Link
  • Pasang Tamang 258 posts 458 karma points
    Apr 13, 2011 @ 01:34
    Pasang Tamang
    0

    Hi

    Please double check the permission for database user. As error log you provide it's showing your dababase user "umbracouser" doesn't have select permission for your database.

    Thanks

    Pnima

    Copy Link
  • TaoistTotty 246 posts 314 karma points
    Apr 13, 2011 @ 09:48
    TaoistTotty
    0

    Hi Pasang

    This is what I thought, but the hosts are saying this is not the case.

    Am upgrading the website to 4.5.2 and will see what this does.

    Many thanks

    TT

    Copy Link
  • Ove Andersen 435 posts 1541 karma points c-trib
    Apr 13, 2011 @ 09:58
    Ove Andersen
    1

    Does the user "umbracoUser" have the following rights to the "justwater" database?

    And could you check that this is not an issue with a case-sensitive username?

    Copy Link
  • TaoistTotty 246 posts 314 karma points
    Apr 13, 2011 @ 10:14
    TaoistTotty
    0

    Hi Ove

    I will ask the hosting company about this.

    They have checked the settings with the hosting company and they have confirmed everything is correct.

    Will let you know any reply/update.

    Regards

    TT

    Copy Link
  • TaoistTotty 246 posts 314 karma points
    Apr 13, 2011 @ 11:05
    TaoistTotty
    0

    Have upgraded to 4.5.2 but am still seeing same error.

    Runs on my server without a problem.

    Any suggestions?

    Regards

    TT

    Copy Link
  • Ove Andersen 435 posts 1541 karma points c-trib
    Apr 13, 2011 @ 11:11
    Ove Andersen
    1

    Well, it definately is a permissions issue with sql server.

    Have you tried to connect to the database with SQL Management Studio with the umbraco database user (the same as you have in web.config) and see what happens when you try to right click and select "Select top 1000 rows" on the "dbo.umbracoUser" table?

    Copy Link
  • TaoistTotty 246 posts 314 karma points
    Apr 13, 2011 @ 11:17
    TaoistTotty
    0

    Hi Ove

    That is good to hear, I had a feeling I was going mad.

    I have tried but the server does not allow remote connections.

    Will pass this onto the host and get them to have a look at what is happening.

    I will also post the reply here if needed.

    Thanks very much for the help.

    Regards

    TT

    Copy Link
  • TaoistTotty 246 posts 314 karma points
    Apr 13, 2011 @ 11:51
    TaoistTotty
    0

    Hi Ove

    The error with the .NET4 version was application pool not being changed to .NET4.

    The site is now working, but I am seeing an error in the media section of:

     

    Method 'get_EnableCdn' in type 'System.Web.UI.ScriptManager' from assembly 'System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' does not have an implementation. 
     Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

     Exception Details: System.TypeLoadException: Method 'get_EnableCdn' in type 'System.Web.UI.ScriptManager' from assembly 'System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' does not have an implementation.

    Source Error: 
     An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. 


    Stack Trace: 

    [TypeLoadException: Method 'get_EnableCdn' in type 'System.Web.UI.ScriptManager' from assembly 'System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' does not have an implementation.]
       System.Web.UI.UpdatePanel.get_ScriptManager() +0
       System.Web.UI.UpdatePanel.RegisterPanel() +126
       Decode.Umb.Pixlr.pixlrDataEditor.OnInit(EventArgs e) +25
       System.Web.UI.Control.InitRecursive(Control namingContainer) +133
       System.Web.UI.Control.InitRecursive(Control namingContainer) +421
       System.Web.UI.Control.InitRecursive(Control namingContainer) +421
       System.Web.UI.Control.InitRecursive(Control namingContainer) +421
       System.Web.UI.Control.InitRecursive(Control namingContainer) +421
       System.Web.UI.Control.AddedControl(Control control, Int32 index) +277
       umbraco.controls.ContentControl.addControlNew(Property p, TabPage tp, String Caption) +8818
       umbraco.controls.ContentControl.CreateChildControls() +1429
       System.Web.UI.Control.EnsureChildControls() +182
       umbraco.controls.ContentControl.OnInit(EventArgs e) +127
       System.Web.UI.Control.InitRecursive(Control namingContainer) +133
       System.Web.UI.Control.AddedControl(Control control, Int32 index) +277
       umbraco.cms.presentation.editMedia.OnInit(EventArgs e) +1270
       System.Web.UI.Control.InitRecursive(Control namingContainer) +133
    
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

    Any suggestion?

    Regards

    TT

    Copy Link
  • Ove Andersen 435 posts 1541 karma points c-trib
    Apr 13, 2011 @ 13:51
    Ove Andersen
    1

    System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' is a .NET 3.5 assembly.

    Sounds like you have references to .NET 3.5 assemblies in your web.config, but you are running on .NET 4.

    Could you check if you have a line like this in your web.config (or any other things targeting "Version=3.5.0.0")?

    <add tagPrefix="asp" namespace="System.Web.UI" assembly="System.Web.Extensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />

    If not, you need to fix your web.config.

    You can download Umbraco 4.5.2 for .NET 4 from here:
    http://umbraco.codeplex.com/releases/view/51165

    Then do the following:

    1. Backup your web.config and bin folder
    2. Right click the downloaded zip-file and click Properties -> "Unblock" and then ok.
    3. Open the web.config in the zip file in notepad or similar
    4. Copy your database, version, and any custom settings from your old web.config into the one from the zip file.
    5. Save the the new web.config in the root of your application, replacing the old one. (remember to keep your backup)
    6. Copy the contents of the bin folder from the zip file into the bin folder fo your umbraco bin folder
    And then it should work.

     

     

     

    Copy Link
  • TaoistTotty 246 posts 314 karma points
    Apr 13, 2011 @ 14:51
    TaoistTotty
    0

    Hi Ove

    Thank that worked for the backend, but the front end is not showing the Umbraco Configuration Wizard.

    Running this causes a crash just after everything has been confirmed as OK with the database settings.

    Is there a way of getting Umbraco to know it has already been installed?

    Many thanks.

    TT

    Copy Link
  • TaoistTotty 246 posts 314 karma points
    Apr 13, 2011 @ 15:03
    TaoistTotty
    1

    Hi Ove

    Forgot to copy the version.

    Thanks for all you help with this.

    Regards

    TT

    Copy Link
  • Ove Andersen 435 posts 1541 karma points c-trib
    Apr 14, 2011 @ 08:55
    Ove Andersen
    1

    No problem :)

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft