This project is read-only.

Sageframe v4.0 installation error

Jul 17, 2014 at 12:22 PM
im trying to install sageframe v4.0 on winserver 2008 r2.
The test configuraion step was success, on choosing default theme on clicking on get started, the following error is occuring:-
Server Error in '/sage' Application.
Could not find stored procedure 'dbo.usp_GetSettingValueByIndividualKey'.
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: Could not find stored procedure 'dbo.usp_GetSettingValueByIndividualKey'.

Source Error:

The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:
  1. Add a "Debug=true" directive at the top of the file that generated the error. Example:
<%@ Page Language="C#" Debug="true" %>


2) Add the following section to the configuration file of your application:

   <compilation debug="true"/>

Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.

Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario.

Stack Trace:

[SqlException (0x80131904): Could not find stored procedure 'dbo.usp_GetSettingValueByIndividualKey'.]
SageFrame.Web.SageFrameConfig.GetSettingValueByIndividualKey(String settingKey) +262
SageFrame.Framework.PageBase.InitializeCulture() +213
ASP.default_aspx.__BuildControlTree(default_aspx __ctrl) +31
ASP.default_aspx.FrameworkInitialize() +29
System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +48
System.Web.UI.Page.ProcessRequest() +72
System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) +21
System.Web.UI.Page.ProcessRequest(HttpContext context) +58
ASP.default_aspx.ProcessRequest(HttpContext context) +4
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +341
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +69
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.17929 
Jul 29, 2014 at 11:43 AM
Hello Shivprasd

"Could not find stored procedure 'dbo.usp_GetSettingValueByIndividualKey' " means that Schema hasn't run well in the database and hence no stored procedure is executed. The error well Explained about this.

Sageframe v4.0 has not been released yet. If this is SageFrame V3.0 you are talking about then use MSSQL 2008 or above.

On version.config file please set --> key="IsInstalled" value="false" ,if the value has became "true" to reinstall SageFrame.

Bijay Baniya
Aug 4, 2014 at 11:14 PM
Edited Aug 4, 2014 at 11:18 PM
I am getting the same error. I use Sql Server 2008 Express and a fresh install.
Is this a sql server error or SageFrame error? I tried to install SageFrame several time. I am using webmatrix 3.0 to install it.

How can I solve this problem?