Copied to clipboard

Flag this post as spam?

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


  • Danny Leech 36 posts 114 karma points
    Feb 17, 2015 @ 19:28
    Danny Leech
    0

    Preview gives internal server error

    Hi, I'm getting an error when trying to preview a page in v7.2.1. The published version of the page works fine but browsing to /umbraco/preview/?id=xxxx gives the following error "The page cannot be displayed because an internal server error has occurred."

    Any thoughts?

    Regards, Danny

  • Jan Skovgaard 11264 posts 23592 karma points MVP 9x admin c-trib
    Feb 17, 2015 @ 20:54
    Jan Skovgaard
    0

    Hi Danny

    Have you tried looking in the /App_Data/Logs files to see if it reveals anything marked with ERROR or WARNING? How about the event viewer log on the webserver? (If you have access).

    Preview should just work out of the box unless you have done some kind of customization of course.

    /Jan

  • Tony Thompson 18 posts 90 karma points
    Jul 20, 2016 @ 11:52
    Tony Thompson
    0

    Did you ever resolve this Danny? I have a similar problem but Event viewer in Windows shows nothing.

    The message is slightly different on mine:

    500 - Internal server error. There is a problem with the resource you are looking for, and it cannot be displayed.

    Umbraco version 7.4.3 assembly: 1.0.5948.18141

    Here is the log it produced:

    2016-07-20 12:55:49,110 [P3908/D5/T124] ERROR umbraco.DataLayer.SqlHelper`1[[System.Data.SqlServerCe.SqlCeParameter, System.Data.SqlServerCe, Version=4.0.0.1, Culture=neutral, PublicKeyToken=89845dcd8080cc91]] - Error executing query SELECT umbracoNode.Id,umbracoNode.Text, isNull(CMSDocument.Published,0) as Published, DocType.Text as nodeTypeName from umbracoNode Left Join cmsDocument ON umbracoNode.Id = cmsDocument.NodeId and Published = 1 INNER JOIN cmsContent ON umbracoNode.Id = cmsContent.NodeId INNER JOIN umbracoNode DocType ON cmsContent.contentType = DocType.Id and DocType.nodeObjectType = 'a2cb7800-f571-4787-9638-bc48539a0efb' INNER JOIN cmsContentType ON cmsContent.contentType = cmsContentType.NodeId WHERE (umbracoNode.nodeObjectType = 'c66ba18e-eaf3-4cff-8a22-41b16d66a972')AND umbracoNode.ParentId <> -20And cmsContentType.alias = @Alias And isNull(CMSDocument.Published,0) = @Published SqlCE4Umbraco.SqlCeProviderException: Error running Reader: SQL Statement: SELECT umbracoNode.Id,umbracoNode.Text, isNull(CMSDocument.Published,0) as Published, DocType.Text as nodeTypeName from umbracoNode Left Join cmsDocument ON umbracoNode.Id = cmsDocument.NodeId and Published = 1 INNER JOIN cmsContent ON umbracoNode.Id = cmsContent.NodeId INNER JOIN umbracoNode DocType ON cmsContent.contentType = DocType.Id and DocType.nodeObjectType = 'a2cb7800-f571-4787-9638-bc48539a0efb' INNER JOIN cmsContentType ON cmsContent.contentType = cmsContentType.NodeId WHERE (umbracoNode.nodeObjectType = 'c66ba18e-eaf3-4cff-8a22-41b16d66a972')AND umbracoNode.ParentId <> -20And cmsContentType.alias = @Alias And isNull(CMSDocument.Published,0) = @Published

    Exception: System.Data.SqlServerCe.SqlCeException (0x80004005): The number of arguments specified for the function is not correct. [ Minimum argument count = 1, Maximum argument count = 1,Name of function(if known) = isNull ] at System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr) at System.Data.SqlServerCe.SqlCeCommand.CompileQueryPlan() at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options) at SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters) at SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters) at SqlCE4Umbraco.SqlCEHelper.ExecuteReader(String commandText, SqlCeParameter[] parameters) at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) 2016-07-20 12:55:49,126 [P3908/D5/T124] ERROR Umbraco.Core.UmbracoApplicationBase - An unhandled exception occurred System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> umbraco.DataLayer.SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader ---> SqlCE4Umbraco.SqlCeProviderException: Error running Reader: SQL Statement: SELECT umbracoNode.Id,umbracoNode.Text, isNull(CMSDocument.Published,0) as Published, DocType.Text as nodeTypeName from umbracoNode Left Join cmsDocument ON umbracoNode.Id = cmsDocument.NodeId and Published = 1 INNER JOIN cmsContent ON umbracoNode.Id = cmsContent.NodeId INNER JOIN umbracoNode DocType ON cmsContent.contentType = DocType.Id and DocType.nodeObjectType = 'a2cb7800-f571-4787-9638-bc48539a0efb' INNER JOIN cmsContentType ON cmsContent.contentType = cmsContentType.NodeId WHERE (umbracoNode.nodeObjectType = 'c66ba18e-eaf3-4cff-8a22-41b16d66a972')AND umbracoNode.ParentId <> -20And cmsContentType.alias = @Alias And isNull(CMSDocument.Published,0) = @Published

    Exception: System.Data.SqlServerCe.SqlCeException (0x80004005): The number of arguments specified for the function is not correct. [ Minimum argument count = 1, Maximum argument count = 1,Name of function(if known) = isNull ] at System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr) at System.Data.SqlServerCe.SqlCeCommand.CompileQueryPlan() at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options) at SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters) at SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters) at SqlCE4Umbraco.SqlCEHelper.ExecuteReader(String commandText, SqlCeParameter[] parameters) at umbraco.DataLayer.SqlHelper1.ExecuteReader(String commandText, IParameter[] parameters) --- End of inner exception stack trace --- at umbraco.DataLayer.SqlHelper1.ExecuteReader(String commandText, IParameter[] parameters) at SmartBlogLibraries.smartBlogManagement.GetAllDocuments(SearchTerm searchTerm) at SmartBlogLibraries.smartBlogManagement.showResults(EventArgs e) at SmartBlogLibraries.smartBlogManagement.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

  • M N 125 posts 212 karma points
    Dec 07, 2018 @ 18:45
    M N
    0

    Hey all, did anyone ever find a solution to this issue? Apparently still an issue in 7.12.3 but this stopped working some time back for most of our sites and I don't recall when as we never internally use the Preview function. However, we have some editors asking about it so I thought I'd investigate.

    Preview just displays a white page, no content returned. Here's what i know

    • The index.html and index.htm are in the < files > area of web.config default docs, as others said this helped/worked. Not for us unfortunately
    • Net tab is showing a 500 Internal Server Error
    • No Umbraco logs are generated when I "Preview" a node
    • I have toggled remove trailing slash requirements to no avail
    • I have tested locally and non - no dice on any machine
    • Enabled trace in web.config - this doesn't seem to do anything

    It's a bit tough as I'm unable to show any logs or find a real reason why this is actually failing.

    Any advice welcome.

  • M N 125 posts 212 karma points
    Dec 14, 2018 @ 17:19
    M N
    0

    Quick update as I spent a couple more hours on this yesterday. Here's console debug - this generates NO logs in Umbraco..

    enter image description here

    Also, here is an IIS log entry for a /preview request, with identifying info removed.

    enter image description here

    Anyone have any other trouble shooting ideas?

  • M N 125 posts 212 karma points
    Dec 14, 2018 @ 18:26
    M N
    0

    Ok one last update, need a break from this..

    I managed to get the Preview to throw a 403 instead of a 500 by enabling the Try Skip IIS (Developer -> Health Check).

    Now I am receiving a 403 (permission denied). I attempted to use the last suggestion here https://our.umbraco.com/forum/umbraco-7/using-umbraco-7/74377-403-error-on-preview

    But that results in a 404. I have checked IIS and ensured that index.html and index.htm are there. My App Pool is set to FULL trust, Anonymous authentication is set to use the application pool.

    I'm actively logged in here, why would preview throw a 403?

Please Sign in or register to post replies

Write your reply to:

Draft