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

Forums / Developing with Sitefinity / Generic Content Error.

Generic Content Error.

6 posts, 0 answered
  1. Kalpana
    Kalpana avatar
    27 posts
    Registered:
    18 Dec 2008
    19 Mar 2009
    Link to this post
    Hi

    I am using Sitefinity 3.6. I am trying to enter generic content under modules. I have created a category. When I try to add content I an error.

    Kalpana


    Data is Null. This method or property cannot be called on Null values.

    Data is Null. This method or property cannot be called on Null values.

    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.SqlTypes.SqlNullValueException: Data is Null. This method or property cannot be called on Null values.

    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:

    [SqlNullValueException: Data is Null. This method or property cannot be called on Null values.]
       System.Data.SqlClient.SqlBuffer.get_String() +4836885
       System.Data.SqlClient.SqlDataReader.GetString(Int32 i) +96
       Nolics.ORMapper.DataProviders.SqlServer2005StmtBuilder.HasProcedure(ObjectName procName) +205
       Nolics.ORMapper.DataProviders.SQLBlockBuilder.DefineCommandProcedure(OdbClassInfo dbclassInfo, SQLCrudOperations operation) +559
       Nolics.ORMapper.DataProviders.SQLBlockBuilder.DefineClass(OdbClassInfo dbClassInfo, EmitPhases phase) +197
       Nolics.ORMapper.DataProviders.SQLDataProvider.GetSchemaChanges(Boolean fRename) +553
       Nolics.ORMapper.Base.OdbDataProvider.Upgrade() +59
       Telerik.Versioning.Data.DefaultProvider.Initialize(String name, NameValueCollection config) +754
       Telerik.ManagerBase`1.InstantiateProvider(ProviderSettings providerSettings, Type providerType) +1187
       Telerik.ManagerBase`1.InstantiateProvider(ProviderSettings providerSettings) +147
       Telerik.ManagerBase`1.SetProvider(String providerName) +395
       Telerik.ManagerBase`1..ctor(String providerName) +207
       Telerik.Versioning.VersionManager..ctor(String providerName) +36
       Telerik.Cms.Engine.ContentProviderBase.get_Version() +105
       Telerik.Cms.Engine.ContentManager.get_Version() +50
       Telerik.Cms.Engine.ContentManager.CreateVersion(IContent cntItem, CultureInfo cult) +913
       Telerik.Cms.Engine.ContentManager.CreateContent(String mimeType, Guid id) +327
       Telerik.Cms.Engine.ContentManager.CreateContent(String mimeType) +76
       Telerik.Cms.Engine.WebControls.Admin.ContentItemEdit`1.SaveContent() +394
       Telerik.Cms.Engine.WebControls.Admin.ContentItemEdit`1.Button_Command(Object sender, CommandEventArgs e) +116
       System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +108
       System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) +135
       System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
       System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
       System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +175
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565
    
  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    12 Sep 2017
    23 Mar 2009
    Link to this post
    Hi Kalpana,

    The reasons for database upgrade could be missing data to the database, you are making an upgrade to different version - database schema version is not the same as Sitefinity version. Do you have connected multiple instances of Sitefinity with different versions? The database is trying to make an upgrade Stack Trace: at Nolics.ORMapper.Base.OdbDataProvider.Upgrade().
    The problem could be a result of missing stored procedures as well. If you running under medium trust your provider could have set some restrictions. Are you running this site under medium trust?


    Sincerely yours,
    Ivan Dimitrov
    the Telerik team

    Check out Telerik Trainer , the state of the art learning tool for Telerik products.
  3. Kalpana
    Kalpana avatar
    27 posts
    Registered:
    18 Dec 2008
    23 Mar 2009
    Link to this post
    Hi Ivan

    I am using the 3.6 and created the DB as oer the instructions I got from support. I created a empty DB and then connected thru the admin tool. This created the DB with the necessary tables and procedures.

    I did check the procedures and I noticed some of them were missing. We have a another Sitefinity 3.6 site and I checked the two DBs - the one throwing the error has some missing stored procedures. I am not sure how this happened.

    What would be the best way to restore the missing procedures?

    Thanks.

    Kalpana
  4. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    12 Sep 2017
    23 Mar 2009
    Link to this post
    Hello Kalpana,

    It will be useful if you tell us which stored procedures are missing. Then, I will let you know whether this could be the problem.

    Best wishes,
    Ivan Dimitrov
    the Telerik team

    Check out Telerik Trainer , the state of the art learning tool for Telerik products.
  5. Kalpana
    Kalpana avatar
    27 posts
    Registered:
    18 Dec 2008
    24 Mar 2009
    Link to this post

    Ivan

    Here are the missing procedures when I compare/query against with my working Sitefinity 3.6 site.

    Thanks.

    Kalpana

    name

    sf_WorkflowInstance_pkq
    sf_VrsBinData_pkq
    sf_LocVariables_del
    sf_VrsLockedItems_upd
    sf_Loc_Items
    sf_VersVariables_ins
    sf_VersVariables_pkq
    sf_Loc_Item_upd
    sf_Loc_Item_pkq
    sf_VrsTxtData_del
    sf_VrsBinData_ins
    sf_VrsLockedItems_ins
    sf_Activity_del
    sf_VrsTxtData_pkq
    sf_WrkVariables_ins
    sf_Loc_Item_del
    sf_VersionItem_upd
    sf_VersionItem_del
    sf_WrkVariables_upd
    sf_GetLastVersion
    sf_VersVariables_del
    sf_VrsBinData_upd
    sf_LoadWorkflows
    sf_WorkflowInstance_del
    sf_VrsLockedItems_del
    sf_LocVariables_upd
    sf_VersVariables_upd
    sf_ActivitiesByType
    sf_Loc_Data_upd
    sf_Activity_pkq
    sf_Activity_ins
    sf_Loc_Item_ins
    sf_GetVersionItems
    sf_VrsBinData_del
    sf_WrkVariables_del
    sf_WrkVariables_pkq
    sf_LocVariables_pkq
    sf_VersionItem_pkq
    sf_VrsLockedItems_pkq
    sf_VrsTxtData_upd
    sf_LocVariables_ins
    sf_Loc_Data_del
    sf_AllWorkflows
    sf_WorkflowInstance_ins
    sf_VrsTxtData_ins
    sf_Loc_Data_pkq
    sf_Activity_upd
    sf_WorkflowInstance_upd
    sf_Loc_Data_ins
    sf_VersionItem_ins
    sf_GetWorkflow
  6. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    12 Sep 2017
    26 Mar 2009
    Link to this post
    Hi Kalpana,

    The problem comes from initialization of Telerik.Versioning DefaultProvider. The stored procedures are missing due to Nolics that is trying to perform upgrade, but it fails.

    My suggestion is creating a new database for this project.

    Greetings,
    Ivan Dimitrov
    the Telerik team

    Check out Telerik Trainer , the state of the art learning tool for Telerik products.
Register for webinar
6 posts, 0 answered