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

Forums / General Discussions / Could not find stored procedure 'NN_NextValue'

Could not find stored procedure 'NN_NextValue'

4 posts, 0 answered
  1. Marcus
    Marcus avatar
    45 posts
    Registered:
    02 Jul 2010
    31 Aug 2011
    Link to this post
    Hello,

    I import a local base for a host.
    But when I change my connectionString to the server hosting the following error appears in the picture attached.

    How do I solve this problem?

    Thank you.
  2. Lubomir Velkov
    Lubomir Velkov avatar
    688 posts
    Registered:
    03 Nov 2014
    02 Sep 2011
    Link to this post
    Hello Marcus,

    Is your database a database from Sitefinity 3.7 SP4 project? There must be a stored procedure named NN_NextValue with the following contents:

    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    ALTER PROCEDURE [dbo].[NN_NextValue](@CounterID nvarchar(50), @CacheSize int)
    AS BEGIN
    update [dbo].[NN_Counters]SET COUNTERVALUE = COUNTERVALUE + @CACHESIZE WHERE COUNTERID = @COUNTERID
    SELECT COUNTERVALUE - @CACHESIZE + 1 AS CURRENTVALUE, COUNTERVALUE AS MAXVALUE
       FROM [dbo].[NN_Counters] WHERE COUNTERID = @COUNTERID
    END

    Please, check that the database that you import is a proper Sitefinity 3.7 SP4 database.

    All the best,
    Lubomir Velkov
    the Telerik team

    Thank you for being the most amazing .NET community! Your unfailing support is what helps us charge forward! We'd appreciate your vote for Telerik in this year's DevProConnections Awards. We are competing in mind-blowing 20 categories and every vote counts! VOTE for Telerik NOW >>

  3. Marcus
    Marcus avatar
    45 posts
    Registered:
    02 Jul 2010
    02 Sep 2011
    Link to this post
    Hello,

    In the local database, it exists NN_NextValue.

    When I import it did not, how do I create it in the bank published?

    Thank you.

  4. Lubomir Velkov
    Lubomir Velkov avatar
    688 posts
    Registered:
    03 Nov 2014
    07 Sep 2011
    Link to this post
    Hi Marcus,

    How do you backup and restore your database? When you backup/restore it the usual way all your stored procedures will be carried over by the backup to the new place. Do you have any other stored procedures in the database after you restore it?

    Kind regards,
    Lubomir Velkov
    the Telerik team

    Thank you for being the most amazing .NET community! Your unfailing support is what helps us charge forward! We'd appreciate your vote for Telerik in this year's DevProConnections Awards. We are competing in mind-blowing 20 categories and every vote counts! VOTE for Telerik NOW >>

Register for webinar
4 posts, 0 answered