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

Forums / Deployment / Enum conversion failed as the property/field is not nullable and no value has been read from the database.

Enum conversion failed as the property/field is not nullable and no value has been read from the database.

3 posts, 0 answered
  1. Nick
    Nick avatar
    2 posts
    Registered:
    27 Nov 2013
    05 Dec 2013
    Link to this post

    I am attempting to publish the Corporate Starter Kit to Azure.  My plan is to modify it once it is deployed.  The only changes I have made so far are those required for the manual deployment and some web.config changes related to the handlers and modules as the default web.config in the Corporate Starter Kit doesnt work with IIS 7.5.  It works fine on my local system with my database deployed on my local system.  However once I move my database to Azure and point my local project at it I get the failure mentioned in the my last post.  The same is true when I deploy my project to azure.  Thanks in advance anything you can do to help me out here is greatly appreciated.   The error I am getting is below.

    Server Error in '/' Application.

    Enum conversion failed as the property/field is not nullable and no value has been read from the database.

    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.InvalidOperationException: Enum conversion failed as the property/field is not nullable and no value has been read from the database.



    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:



    [InvalidOperationException: Enum conversion failed as the property/field is not nullable and no value has been read from the database.]
       OpenAccessRuntime.Data.EnumConverter.Read(DataHolder& holder) +470
       OpenAccessRuntime.Relational.RelationalGenericState.copyPass1Fields(ResultSet rs, FetchGroupField[] fetchGroups, Int32 firstCol) +346
    
    [DataStoreException: Error reading field Telerik.Sitefinity.Pages.Model.PageTemplate.framework from ResultSet: System.InvalidOperationException: Enum conversion failed as the property/field is not nullable and no value has been read from the database.
       at OpenAccessRuntime.Data.EnumConverter.Read(DataHolder& holder)
       at OpenAccessRuntime.Relational.RelationalGenericState.copyPass1Fields(ResultSet rs, FetchGroupField[] fetchGroups, Int32 firstCol) System.InvalidOperationException: Enum conversion failed as the property/field is not nullable and no value has been read from the database.
       at OpenAccessRuntime.Data.EnumConverter.Read(DataHolder& holder)
       at OpenAccessRuntime.Relational.RelationalGenericState.copyPass1Fields(ResultSet rs, FetchGroupField[] fetchGroups, Int32 firstCol)]
       OpenAccessRuntime.ExceptionWrapper.Throw() +13
       OpenAccessRuntime.DataObjects.PCStateMan.handleException(Exception x) +101
       OpenAccessRuntime.DataObjects.PCStateMan.getObjectFieldImp(PersistenceCapable pc, FieldMetaData fmd, Object currentValue) +183
       Telerik.Sitefinity.Pages.Model.PageData.OpenAccessEnhancedGettemplate(PageData owner) +86
       Telerik.Sitefinity.Pages.Model.PageData.get_Template() +18
       Telerik.Sitefinity.Web.PageSiteNode..ctor(SiteMapBase provider, PageNode pageNode, String pageProviderName) +3115
       Telerik.Sitefinity.Web.SiteMapBase.FindSiteMapNodeFromKey(String key, Boolean ifAccessible) +1402
       Telerik.Sitefinity.Web.SiteMapBase.FindSiteMapNode(String rawUrl, Boolean ifAccessible, Boolean unresolveUrl, Boolean& isAdditionalUrl, String[]& urlParameters) +599
       Telerik.Sitefinity.Web.SitefinityRoute.FindSiteMapNode(String& virtualPath, SiteMapBase siteMapProvider, Boolean& isAdditional, String[]& pars, Boolean skipSubSiteCheck) +512
       Telerik.Sitefinity.Web.SitefinityRoute.GetRouteData(HttpContextBase httpContext) +257
       System.Web.Routing.RouteCollection.GetRouteData(HttpContextBase httpContext) +355
       System.Web.Routing.UrlRoutingModule.PostResolveRequestCache(HttpContextBase context) +75
       System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +80
       System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +270
    



    Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.2026

     

  2. Nick
    Nick avatar
    2 posts
    Registered:
    27 Nov 2013
    05 Dec 2013
    Link to this post
    I am expecting this is something very simple that could be azure related.  However I am not very familiar with azure so starting here for assistance.
  3. Stanislav Velikov
    Stanislav Velikov avatar
    1113 posts
    Registered:
    08 Dec 2016
    09 Dec 2013
    Link to this post
    Hello,

    To resolve the issue execute the below query against the database uploaded in Azure
    update sf_page_templates
    set framework = 0
    where framework is null
    This will make all templates have their column framework have default value 0 instead of NULL, the default value for the column is null and this works locally, however when SQL Azure handles this it requires not nullable value.
    After this restart the site and the problem will be no more.

    The column framework was inappropriately populated with Null value which causes a problem, we haven`t determined the cause for this.

    Regards,
    Stanislav Velikov
    Telerik
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
3 posts, 0 answered