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

Forums / Bugs & Issues / Procedure or function sf_CmsWebControl_ins has too many arguments specified

Procedure or function sf_CmsWebControl_ins has too many arguments specified

10 posts, 0 answered
  1. Vaughn
    Vaughn avatar
    8 posts
    Registered:
    21 Oct 2010
    25 Jan 2011
    Link to this post
    I had edited an article a few days ago and it was working fine when I last touched it.

    The page previews fine in the admin section prior to editing, and works fine on the user side. But when I press the edit button, the entire admin interface crashes with the following error:
    "System.Data.SqlClient.SqlException:  Procedure or function sf_CmsWebControl_ins has too many arguments specified"
    [SqlException (0x80131904): Procedure or function sf_CmsWebControl_ins has too many arguments specified.]
       Nolics.ORMapper.DataProviders.SQLBlockBuilder.EndStatement(SQLCommandEventArgs args, DataRow row) +503
       Nolics.ORMapper.DataProviders.SQLBlockBuilder.ExecCommandProcedure(StmtContext context, DataRow data) +712
       Nolics.ORMapper.DataProviders.SQLBlockBuilder.ExecuteCommand(StmtContext context, DataRow data) +76
       Nolics.ORMapper.DataProviders.SQLDataProvider.Update(DataSet updateData) +466
       Nolics.ORMapper.Base.Transaction.Commit(Boolean fCleanIfSuccess) +910
       Telerik.Cms.Data.StagedPage.CheckOut(Boolean increaseVersion) +384
       Telerik.Cms.Data.StagedPage.CheckOut() +26
       Telerik.Cms.Web.EditPage.OnPreInit(EventArgs e) +1119
       System.Web.UI.Page.PerformPreInit() +31
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +282 
    I can't get back in to edit the page to fix whatever is wrong, so I'm kind of stuck.

    Any ideas?
  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    25 Nov 2016
    25 Jan 2011
    Link to this post
    Hello Vaughn,

    This error is thrown because there is a difference of the database schema version and the version of Sitefinity on your site. Most common reason for this is that you have two Sitefinity websites running on different versions of Sitefinity connected to the same database. When a website is restarted it checks the database schema version and if it does not match the Sitefinity version it performs an upgrade/downgrade to match the database scheme to the Sitefinity version. If you have two websites connected to the same DB they should be using the same Sitefinity versions, otherwise when one of the sites is restarted it will change the db and then when the other site makes a request to the DB the db will not match and you will get this error.

    Best wishes,
    Ivan Dimitrov
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  3. Vaughn
    Vaughn avatar
    8 posts
    Registered:
    21 Oct 2010
    25 Jan 2011
    Link to this post
    Ivan-

    Thank you for your quick reply. I'm only running the one site. Perhaps something went wrong when I upgraded from 3.7SP3 to 3.7SP4? That was over a month ago though.

    Can you suggest where I should look in Sitefinity and in the db to check if there is a mismatch?

    Vaughn

    EDIT:
    From meta tags:  <meta name="Generator" content="Sitefinity 3.7.2136.2:0" />

    From Database:
    Application   Name   Value
    _   SchemaVersion   2136
  4. Vaughn
    Vaughn avatar
    8 posts
    Registered:
    21 Oct 2010
    25 Jan 2011
    Link to this post
    Ivan-

    I was able to get back into the document by restoring a previous version of the page. The thing is, I inspected the content, and I can't see any problem with the "bad" version.

    If you can provide any further ideas what might have caused this, I would like to know. I am concerned about stability.

    Vaughn
  5. Vaughn
    Vaughn avatar
    8 posts
    Registered:
    21 Oct 2010
    26 Jan 2011
    Link to this post
    Ivan-

    It is happening again on a different page.  It does not look like I have a site/db schema mismatch. Do you have any suggestions what to look at?

    Vaughn
  6. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    25 Nov 2016
    26 Jan 2011
    Link to this post
    Hello Vaughn,

    Have you upgraded the project recently? Can you paste the <dataAccess> node from your web.config and let me know the database server - type, version you use?

    Best wishes,
    Ivan Dimitrov
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  7. Vaughn
    Vaughn avatar
    8 posts
    Registered:
    21 Oct 2010
    26 Jan 2011
    Link to this post
    Ivan-

    I upgraded at least a month ago.

    Here is the info you asked for:
    <dataAccess defaultConnection="DefaultConnection">
        <connections>
            <add name="DefaultConnection" driver="Telerik.DataAccess.Providers.ExtendedSqlServer2005Provider, Telerik.DataAccess" connectionStringName="Sitefinity"/>
            <add name="GenericContentConnection" driver="Telerik.Cms.Engine.Data.Providers.GCSql2005Provider, Telerik.Cms.Engine.Data" connectionStringName="Sitefinity"/>
        </connections>
    </dataAccess>

    NT INTEL X86 5.2 (3790)
    Microsoft SQL Server Enterprise Edition  9.0.1399 RTM
  8. Radoslav Georgiev
    Radoslav Georgiev avatar
    3370 posts
    Registered:
    01 Feb 2016
    31 Jan 2011
    Link to this post
    Hello Vaughn,

    It seems that you have another project connected to the same database (probably some local development project). When this project makes a request to the database it donwgrades it and causes the problem.

    Regards,
    Radoslav Georgiev
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  9. Vaughn
    Vaughn avatar
    8 posts
    Registered:
    21 Oct 2010
    31 Jan 2011
    Link to this post
    Radoslav,

    What are you basing your diagnosis of multiple websites on? To the best of my knowledge, I am the only one working on this site, and there is only the one site configured to access this DB.

    Vaughn
  10. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    25 Nov 2016
    02 Feb 2011
    Link to this post
    Hi Vaughn,

    You can also open sf_CmsVariables and change the SchemaVersion for instance to 1. Then request the project. Open the database table sf_CmsVariables and check SchemaVersion value. Next time when the error is thrown check SchemaVersion value and if this is different from this one that was set last time then you are making some downgrade and upgrade.

    Another option some missing or corrupted stored procedures which are result of the migration. You could install a Blank project and compare the store procedures from it.


    Regards,
    Ivan Dimitrov
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Register for webinar
10 posts, 0 answered