Server Error in '/' Application.

Procedure or function 'UpdateServerActivity' expects parameter '@PingFailureCount', which was not supplied.
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 'UpdateServerActivity' expects parameter '@PingFailureCount', which was not supplied.

Source Error:


An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:



[SqlException (0x80131904): Procedure or function 'UpdateServerActivity' expects parameter '@PingFailureCount', which was not supplied.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +392
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +815
System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4515
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +6738737
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) +6741487
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) +586
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) +751
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +290
PetaPoco.Database.Execute(String sql, Object[] args) +470
DotNetNuke.Data.PetaPoco.PetaPocoHelper.ExecuteNonQuery(String connectionString, CommandType type, String sql, Object[] args) +23
DotNetNuke.Data.DataProvider.UpdateServerActivity(String ServerName, String IISAppName, DateTime CreatedDate, DateTime LastActivityDate) +172
DotNetNuke.Entities.Host.ServerController.UpdateServerActivity(ServerInfo server) +146
DotNetNuke.Common.Initialize.InitializeApp(HttpApplication app, Boolean& initialized) +645
DotNetNuke.Common.Initialize.Init(HttpApplication app) +175
DotNetNuke.HttpModules.RequestFilter.RequestFilterModule.FilterRequest(Object sender, EventArgs e) +206
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +165




Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.34212

I would try doing the restore again. Make sure that you completely empty the website's file directory. If you are unzipping a backup, make sure that the zip file is "unblocked" before copying files.

The error message indicates that the code is calling a database stored procedure incorrectly. So, it would appear that there is a mismatch between what is in the database and the website code. Make sure that you really did restore the old database.

I found out the hard way, read the error messages in FileZilla. The transfer to the bin folder failed on Telerik.Web.UI.dll. Once I wiggled that file in, it works.
Now I have a new error which will be a separate post if I don't find the answer.

Also I restored the database to an earlier backup and it worked.

Yes, that will get you every time!