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

Forums / Bugs & Issues / Unrecoverable sf_Permissions Exception

Unrecoverable sf_Permissions Exception

3 posts, 0 answered
  1. Randel
    Randel avatar
    50 posts
    Registered:
    30 Aug 2012
    13 Oct 2008
    Link to this post

    Sorry for the cross-post, but I think this better fits here.

    I've updated my projects from Sitefinity V3.2 to V3.5 and have now been starting to get this error, posted below.  I thought the update went ok and started adding HTML content to some Generic Content controls, HTML also posted below.   

    Project Details

    I have four projects configured to use a shared database.  Currently, there are two master pages which are used to build my Templates: Home.masterpage and Site.masterpage.  All but the default home page use Site.masterpage; the default home page uses the Home.masterpage.  

    What I was doing before this error started popping up

    I was working on adding controls and HTML content via Sitefinity’s admin tool.  I started adding the below HTML code to a Generic Content control, located on the default page.  After that gave me the error, I attempted to add it to the Home Template.

    Now if I attempt to get into any of the four project’s admin sites, I get this error.  Other then attempting to get into the database via Microsoft SQL Server Management Studio, I’m at a lost how to fix this. 

    Does anyone have any idea?

     

    Server Error in '/WisDairyCMS.Consumer' Application.


    Procedure or function sf_SecPermissions has too many arguments specified.

    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: Procedure or function sf_SecPermissions has too many arguments specified.

    Source Error:

    Line 108:

    Line 109:              PagePermission pagePerm = new PagePermission(manager.GetRootPage(), PageRights.View);

    Line 110:              bool canViewPages = pagePerm.CheckDemand();

    Line 111:

    Line 112:        if (!canViewPages)


    Source File: c:\Workspaces\WMMB\WisDairyCMS.Consumer\trunk\Sitefinity\Admin\Default.aspx.cs    Line: 110

    Stack Trace:

    [SqlException (0x80131904): Procedure or function sf_SecPermissions has too many arguments specified.]

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

       System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800118

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

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

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

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

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

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

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

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

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

       System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12

       System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() +9

       Nolics.ORMapper.DataProviders.SQLBlockBuilder.EndStatement(SQLCommandEventArgs args, DataRow row) +389

       Nolics.ORMapper.DataProviders.SQLBlockBuilder.ExecQueryProcedure(StmtContext context, DataRow queryData) +550

       Nolics.ORMapper.DataProviders.SQLBlockBuilder.ExecuteQuery(StmtContext context, DataRow queryData, Int32 maxRows, String group) +62

       Nolics.ORMapper.DataProviders.SQLDataProvider.ExecQuery(DataSet queries) +519

       Nolics.ORMapper.Base.QueryBase`1.LoadQuery(Int32 maxElements, Int32 fromElement) +275

       Nolics.ORMapper.Base.QueryBase`1.LoadAll() +20

       Telerik.Security.Data.DefaultSecurityProvider.GetPermissions(ISecured securedObject, String roleProvider) +226

       Telerik.Security.SecurityManager.GetPermissions(ISecured securedObject, String roleProvider) +14

       Telerik.Cms.Data.RootPage.GetPermissions(String roleProvider) +153

       Telerik.Cms.Data.RootPage.GetPermission(String roleProvider, String[] roles) +31

       Telerik.Security.Permissions.ApplicationPermission.CheckDemand() +423

       Admin_Default.hintsPanel_DataBound(Object sender, EventArgs e) in c:\Workspaces\WMMB\WisDairyCMS.Consumer\trunk\Sitefinity\Admin\Default.aspx.cs:110

       System.Web.UI.WebControls.BaseDataBoundControl.OnDataBound(EventArgs e) +86

       System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data) +137

       System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +29

       System.Web.UI.WebControls.DataBoundControl.PerformSelect() +149

       System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70

       Admin_Default.Page_Load(Object sender, EventArgs e) in c:\Workspaces\WMMB\WisDairyCMS.Consumer\trunk\Sitefinity\Admin\Default.aspx.cs:188

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

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

       System.Web.UI.Control.OnLoad(EventArgs e) +99

       Telerik.Cms.Web.AdminPage.OnLoad(EventArgs e) +58

       Admin_Default.OnLoad(EventArgs e) in c:\Workspaces\WMMB\WisDairyCMS.Consumer\trunk\Sitefinity\Admin\Default.aspx.cs:69

       System.Web.UI.Control.LoadRecursive() +47

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

     


    Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433 


     

     

    HTML CODE


    <div>
      <div>
        <strong>Featured Content</strong>
        <div>
          <img alt="110x75"
               sfref="~/Libraries/Test_Images/110x75.sflb.ashx" 
              
    src="/WisDairyCMS.Consumer/Libraries/Test_Images/110x75.sflb.ashx" />
        </div>
        <div>
          <div>
            <strong>Cheese of the Month</strong>
          </div>
          <div>
            This copy is for placement only and will be replaced at a later time.  It will be seriously awesome.
         
    </div>
          <div>
            <a href="%7E/default.aspx">read more</a>
          </
    div>
        </div>
      </div>
      <br/>
      <div>
        <div>
          <img alt="110x75" 
              
    sfref="~/Libraries/Test_Images/110x75.sflb.ashx"
               src="/WisDairyCMS.Consumer/Libraries/Test_Images/110x75.sflb.ashx" />
        </div>
        <div>
          <div>
            <strong>Featured Recipe</strong>
          </div>
          <div>
            This copy is for placement only and will be replaced at a later time.  It will be seriously awesome.
         
    </div>
          <div>
            <a href="%7E/default.aspx">read more</a>
          </div>
        </div>
      </div>
      <br/>
      <div>
        <div>
          <img alt="110x75" 
              
    sfref="~/Libraries/Test_Images/110x75.sflb.ashx" 
              
    src="/WisDairyCMS.Consumer/Libraries/Test_Images/110x75.sflb.ashx" />
        </div>
        <div>
          <div>
            <strong>Wine &amp; Cheese Pairing</strong>
          </div>
          <div>
            This copy is for placement only and will be replaced at a later time.  It will be seriously awesome.
         
    </div>
          <div>
            <a href="%7E/default.aspx">read more</a>
          </div>
        </div>
      </div
      <div>
        <strong>Featured Videos</strong>
        <div>
          <img alt="250x175"
               sfref="~/Libraries/Test_Images/250x175.sflb.ashx"
               src="/WisDairyCMS.Consumer/Libraries/Test_Images/250x175.sflb.ashx" />
        </div>
        <div>
          <div>
            <strong>Cheesey Stuffed Shells</strong>
            <strong>25Mins</strong>
          </div>
          <div>
            This copy is for placement only and will be replaced at a later time.  It will be seriously awesome.
           
    <br/>
            <a href="%7E/default.aspx">readmore</a>
          </div>
        </div>
      </div>
      <div>
        <strong>Downloads</strong>
        <ul>
          <li>
            <strong>Traveler's Guide to American's Dairyland</strong>
            <br/>
            The map lists Wisconsin cheese plant tours and cheese retail locations around the state.
         
    </li>
          <li>
            <strong>Cheese Variety Guide</strong>
            <br/>
            Do you love cheese but you're not familiar with a particulare cheese variety?  Refer to this handy guide for 33 popular cheese varieties from Wisconsin.
         
    </li>
          <li>
            <strong>Wisconsin Master Cheesemaking Directory</strong>
            <br/>
            Request this guide to help you learn more about these cheesemakers and how to contact them.
         
    </li>
        </ul>
        <div>
          <div>
            <img alt="85x60" 
                
    sfref="~/Libraries/Test_Images/85x60.sflb.ashx" 
                
    src="/WisDairyCMS.Consumer/Libraries/Test_Images/85x60.sflb.ashx" />
          </div>
          <div>
            <strong>WMMB NEWSLETTER</strong>
            <input id="EmailAddress" type="text" />
            <input id="SignUp" type="button" value="SIGN-UP" />
          </div>
        </div>
      </div>
    </
    div>

  2. Georgi
    Georgi avatar
    3583 posts
    Registered:
    28 Oct 2016
    14 Oct 2008
    Link to this post
    Hello Randel,

    We have replied in the other forum thread opened by you for the same issue.
    We kindly ask you to open only one thread for a given problem. Thank you for the understanding!

    Regards,
    Georgi
    the Telerik team

    Check out Telerik Trainer, the state of the art learning tool for Telerik products.
  3. Randel
    Randel avatar
    50 posts
    Registered:
    30 Aug 2012
    14 Oct 2008
    Link to this post
    Georgi,

    I do understand and with my other post not getting a quick reply, I seconded guess what forum I should have put my post in.
Register for webinar
3 posts, 0 answered