Forum

Thursday, November 20, 2008

Web Site Search

.NET Programming
ASP.NET Website Design
DotNetNuke Modules
Photography
Videography
Video Editing

Home

About Us

Forum

Downloads

Bill's Blog

Projects

Forum

WESNet Designs Discussion Forum

All visitors to this site may view forum posts. Only registered users may create new posts or reply to existing posts.

Forum Home

WESNet Designs Projects

ePrayer Module

Error when addi...

Error when adding ePrayer to page

6/9/2008 4:09:29 AM

njuaire

3 posts

Error when adding ePrayer to page
(United States)

I get the following error when adding the module to a page:

The stored procedure 'dbo.oslc_WESNet_EPrayer_GetNewRequests' doesn't exist.

There are alot of procedures created with the WESNet prefix...but that one doesnt exist. I re-installed and it shows that the SQLDataProviders were read and executed and the entire module install was clean.

Any insight?

6/9/2008 8:08:31 AM

admin

17 posts

www.wesnetdesigns.com

Re: Error when adding ePrayer to page
(United States)

Thank you for reporting this error. After you did the re-install, was the stored procedure correctly created or is it still missing when you dropped an instance of the module on a page of your site? If it is still missing, please check your site's Admin => Event Viewer to see if there were any errors during the install. Also, check to see if a stored procedure without the oslc_ objectQualifier was created in the database.

Bill

6/10/2008 8:32:53 AM

njuaire

3 posts

Re: Error when adding ePrayer to page
(United States)

There was an error during install...here are the exceptions thrown on the re-install and adding it to a page:

AssemblyVersion: 04.06.02
PortalID: 0
PortalName: Our Savior's Lutheran Church
UserID: 1
UserName: oslcdnnhost
ActiveTabID: 145
ActiveTabName: Prayer Request
RawURL: /PrayerRequest/tabid/145/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://65.175.107.83/PrayerRequest/tabid/145/Default.aspx
UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; InfoPath.1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 2eda0312-490f-48a0-bab5-06d489684a1d
InnerException: The stored procedure 'dbo.oslc_WESNet_EPrayer_GetNewRequests' doesn't exist.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlCommand.DeriveParameters
StackTrace:
Message: DotNetNuke.Services.Exceptions.PageLoadException: The stored procedure 'dbo.oslc_WESNet_EPrayer_GetNewRequests' doesn't exist. ---> System.InvalidOperationException: The stored procedure 'dbo.oslc_WESNet_EPrayer_GetNewRequests' doesn't exist. at System.Data.SqlClient.SqlCommand.DeriveParameters() at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at WESNet.DNN.Modules.EPrayer.SqlDataProvider.GetNewRequests(Int32 ModuleID, Int32 DaysForNew, Int32 MaxRows, Int32 UserID) at WESNet.DNN.Modules.EPrayer.EPrayerController.GetNewRequests(Int32 ModuleID, Int32 DaysForNew, Int32 MaxRows, Int32 UserID) at WESNet.DNN.Modules.EPrayer.NewestPosts.BindNewRequests() at WESNet.DNN.Modules.EPrayer.NewestPosts.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---
Source:
Server Name: NT28

6/10/2008 6:27:12 AM General Exception oslcdnnhost AssemblyVersion: 04.06.02; PortalID: 0; PortalNa ...

AssemblyVersion: 04.06.02
PortalID: 0
PortalName: Our Savior's Lutheran Church
UserID: 1
UserName: oslcdnnhost
ActiveTabID: 145
ActiveTabName: Prayer Request
RawURL: /PrayerRequest/tabid/145/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://65.175.107.83/PrayerRequest/tabid/145/Default.aspx
UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; InfoPath.1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 572f0671-c135-4be7-aff2-5a51e942e773
InnerException: Invalid object name 'oslc_WESNet_EPrayer_Moderators'. Invalid object name 'oslc_WESNet_EPrayer_Moderators'. Invalid object name 'oslc_WESNet_EPrayer_Users'.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.OnError
StackTrace:
Message: System.Data.SqlClient.SqlException: Invalid object name 'oslc_WESNet_EPrayer_Moderators'. Invalid object name 'oslc_WESNet_EPrayer_Moderators'. Invalid object name 'oslc_WESNet_EPrayer_Users'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at WESNet.DNN.Modules.EPrayer.SqlDataProvider.GetUser(Int32 ModuleId, Int32 UserID) at WESNet.DNN.Modules.EPrayer.EPrayerController.GetUser(Int32 ModuleId, Int32 UserID, Boolean IgnoreCache) at WESNet.DNN.Modules.EPrayer.EPrayerModuleBase.Page_Init(Object sender, EventArgs e) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Control.OnInit(EventArgs e) at System.Web.UI.UserControl.OnInit(EventArgs e) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.AddedControl(Control control, Int32 index) at System.Web.UI.ControlCollection.Add(Control child) at DotNetNuke.UI.Skins.Skin.InjectModule(Control objPane, ModuleInfo objModule, PortalSettings PortalSettings)
Source:
Server Name: NT28

6/10/2008 6:27:03 AM Module Created oslcdnnhost Our Savior's Lutheran Church ModuleId: 609; ModuleTitle: ePrayer; TabModuleID ...

ModuleId: 609
ModuleTitle: ePrayer
TabModuleID: -1
TabID: 145
PortalID: 0
ModuleDefId: 133
FriendlyName:
IconFile:
Visibility: Maximized
ContainerSrc:
Server Name: NT28

6/10/2008 6:27:03 AM Module Created oslcdnnhost Our Savior's Lutheran Church ModuleId: 608; ModuleTitle: ePrayer Newest Posts; < ...

ModuleId: 608
ModuleTitle: ePrayer Newest Posts
TabModuleID: -1
TabID: 145
PortalID: 0
ModuleDefId: 132
FriendlyName:
IconFile:
Visibility: Maximized
ContainerSrc:
Server Name: NT28

6/10/2008 6:24:37 AM Scheduler Event Completed TYPE: DotNetNuke.Services.Search.SearchEngineScheduler; THRE ...

TYPE: DotNetNuke.Services.Search.SearchEngineScheduler
THREAD ID: 5
NEXT START: 6/10/2008 6:54:34 AM
SOURCE: STARTED_FROM_TIMER
ACTIVE THREADS: 0
FREE THREADS: 1
READER TIMEOUTS: 0
WRITER TIMEOUTS: 0
IN PROGRESS: 0
IN QUEUE: 9
Server Name: NT28

6/10/2008 6:24:34 AM Scheduler Event Completed TYPE: DotNetNuke.Modules.Events.EventNotification; THREAD ID ...

TYPE: DotNetNuke.Modules.Events.EventNotification
THREAD ID: 7
NEXT START: 6/10/2008 6:54:34 AM
SOURCE: STARTED_FROM_TIMER
ACTIVE THREADS: 1
FREE THREADS: 0
READER TIMEOUTS: 0
WRITER TIMEOUTS: 0
IN PROGRESS: 1
IN QUEUE: 8
Server Name: NT28

6/10/2008 6:24:34 AM Scheduler Event Completed TYPE: DotNetNuke.Services.Log.EventLog.SendLogNotifications;  ...

TYPE: DotNetNuke.Services.Log.EventLog.SendLogNotifications
THREAD ID: 1
NEXT START: 6/10/2008 6:29:02 AM
SOURCE: STARTED_FROM_TIMER
ACTIVE THREADS: 2
FREE THREADS: -1
READER TIMEOUTS: 0
WRITER TIMEOUTS: 0
IN PROGRESS: 2
IN QUEUE: 7
Server Name: NT28

6/10/2008 6:24:32 AM Module Updated Module Upgraded: WESNet.DNN.Modules.EPrayer.EPrayerController;  ...

Module Upgraded: WESNet.DNN.Modules.EPrayer.EPrayerController
Version: 04.02.01
Server Name: NT28

6/10/2008 6:24:32 AM Module Updated Module Upgraded: WESNet.DNN.Modules.EPrayer.EPrayerController;  ...

Module Upgraded: WESNet.DNN.Modules.EPrayer.EPrayerController
Version: 04.01.01
Server Name: NT28

6/10/2008 6:24:32 AM Module Updated Module Upgraded: WESNet.DNN.Modules.EPrayer.EPrayerController;  ...

Module Upgraded: WESNet.DNN.Modules.EPrayer.EPrayerController
Version: 04.02.00
Server Name: NT28

6/10/2008 6:24:32 AM Module Updated Module Upgraded: WESNet.DNN.Modules.EPrayer.EPrayerController;  ...

Module Upgraded: WESNet.DNN.Modules.EPrayer.EPrayerController
Version: 04.01.00
Server Name: NT28

6/10/2008 6:24:32 AM Module Updated Module Upgraded: WESNet.DNN.Modules.EPrayer.EPrayerController;  ...

Module Upgraded: WESNet.DNN.Modules.EPrayer.EPrayerController
Version: 04.00.00
Results: 04.00.00 - EPRAYER_SPECIAL permissions Post and Moderate successfully added
Server Name: NT28

6/10/2008 6:24:31 AM Module Updated Module Upgraded: WESNet.DNN.Modules.EPrayer.EPrayerController;  ...

Module Upgraded: WESNet.DNN.Modules.EPrayer.EPrayerController
Version: 04.02.01
Results: 04.02.01 - Temporary email template file D:\home\oslclakeoswego.org\wwwroot\DesktopModules\WESNet_EPrayer\Templates\TempEMail.xml renamed to D:\home\oslclakeoswego.org\wwwroot\DesktopModules\WESNet_EPrayer\Templates\EMail.xml
Server Name: NT28

6/10/2008 6:24:31 AM Application Started ...

Server Name: NT28

6/10/2008 6:22:03 AM General Exception AssemblyVersion: 04.06.02; PortalID: -1; PortalN ...

AssemblyVersion: 04.06.02
PortalID: -1
PortalName:
UserID: -1
UserName:
ActiveTabID: -1
ActiveTabName:
RawURL: /Host/Module Definitions/tabid/18/portalid/0/Default.aspx
AbsoluteURL: /Host/Module%20Definitions/tabid/18/portalid/0/Default.aspx
AbsoluteURLReferrer: http://65.175.107.83/Host/Module%20Definitions/tabid/18/ctl/Edit/mid/322/desktopmoduleid/82/portalid/0/Default.aspx
UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; InfoPath.1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: bce6eaf4-a41a-4f65-8d62-f2273b675844
InnerException: Could not load type 'WESNet.DNN.Modules.EPrayer.EPrayerController'.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Web.Compilation.BuildManager.GetType
StackTrace:
Message: System.Web.HttpException: Could not load type 'WESNet.DNN.Modules.EPrayer.EPrayerController'. at System.Web.Compilation.BuildManager.GetType(String typeName, Boolean throwOnError, Boolean ignoreCase) at DotNetNuke.Framework.Reflection.CreateType(String TypeName, String CacheKey, Boolean UseCache, Boolean IgnoreErrors)
Source:
Server Name: NT28