5.0.0.4 Error =- Active Topics Error

Apr 19, 2013 at 10:07 AM
I get this error when I try to access the active topics link....Thanks.

UserAgent: Mozilla/5.0 (compatible; MSIE 10.0; Windows NT 6.1; Trident/6.0)

DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke

ExceptionGUID: e194404f-3401-4bbf-836d-ec60cc564b2e

InnerException: Parameter count does not match Parameter Value count.

FileName:

FileLineNumber: 0

FileColumnNumber: 0

Method: Microsoft.ApplicationBlocks.Data.SqlHelper.AssignParameterValues

StackTrace:

Message: DotNetNuke.Services.Exceptions.PageLoadException: Parameter count does not match Parameter Value count. ---> System.ArgumentException: Parameter count does not match Parameter Value count. at Microsoft.ApplicationBlocks.Data.SqlHelper.AssignParameterValues(SqlParameter[] commandParameters, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.ActiveForums.Data.Common.UI_ActiveView(Int32 portalId, Int32 moduleId, Int32 userId, Int32 rowIndex, Int32 maxRows, String sort, Int32 timeFrame, String forumIds) at DotNetNuke.Modules.ActiveForums.af_grid.BindPosts(String sort) at DotNetNuke.Modules.ActiveForums.af_grid.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.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 ---
Coordinator
Apr 19, 2013 at 1:28 PM
Beta 4 includes changes to some of the stored procedures.

Did you re-run the 5.0.4 sql script from the host sql tool?
Developer
Apr 19, 2013 at 2:01 PM
I had to clear cache and recycle app pool after running the 5.0.4 script
Apr 19, 2013 at 5:45 PM
I ran the 05.00.04.SqlDataProvider from host>sql as a script. It ran successfully. I cleared the cache. The error still exists when I click on My Topics and Active Topics. Everything else works.

I also upgraded DNN to 07.00.05 (130) if that matters. Thank you.

This error for My Topics:

RawURL: /FORUMS/afv/grid/afgt/mytopics.aspx

AbsoluteURL: /Default.aspx

AbsoluteURLReferrer: http://www.website.com/FORUMS/aft/20674.aspx

UserAgent: Mozilla/5.0 (compatible; MSIE 10.0; Windows NT 6.1; WOW64; Trident/6.0)

DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke

ExceptionGUID: eb858370-e3d0-49fd-b54d-74efd6af1fb8

InnerException: Failed to convert parameter value from a String to a Boolean.

FileName:

FileLineNumber: 0

FileColumnNumber: 0

Method: System.Boolean.Parse

StackTrace:

Message: DotNetNuke.Services.Exceptions.PageLoadException: Failed to convert parameter value from a String to a Boolean. ---> System.FormatException: Failed to convert parameter value from a String to a Boolean. ---> System.FormatException: String was not recognized as a valid Boolean. at System.Boolean.Parse(String value) at System.String.System.IConvertible.ToBoolean(IFormatProvider provider) at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider) at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType) --- End of inner exception stack trace --- at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType) at System.Data.SqlClient.SqlParameter.GetCoercedValue() at System.Data.SqlClient.SqlParameter.Validate(Int32 index, Boolean isCommandProc) at System.Data.SqlClient.SqlCommand.SetUpRPCParameters(_SqlRPC rpc, Int32 startCount, Boolean inSchema, SqlParameterCollection parameters) at System.Data.SqlClient.SqlCommand.BuildRPC(Boolean inSchema, SqlParameterCollection parameters, _SqlRPC& rpc) 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.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.ActiveForums.Data.Common.UI_MyTopicsView(Int32 portalId, Int32 moduleId, Int32 userId, Int32 rowIndex, Int32 maxRows, String sort, String forumIds) at DotNetNuke.Modules.ActiveForums.af_grid.BindPosts(String sort) at DotNetNuke.Modules.ActiveForums.af_grid.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.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: ds000796
Apr 19, 2013 at 5:57 PM
Same error on a different website.

Stack Trace:


[ArgumentException: Parameter count does not match Parameter Value count.]
Microsoft.ApplicationBlocks.Data.SqlHelper.AssignParameterValues(SqlParameter[] commandParameters, Object[] parameterValues) +344
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(String connectionString, String spName, Object[] parameterValues) +70
DotNetNuke.Modules.ActiveForums.Data.Common.UI_ActiveView(Int32 PortalId, Int32 ModuleId, Int32 UserId, Int32 RowIndex, Int32 MaxRows, String Sort, Boolean IsSuper, Int32 TimeFrame, String ForumIds) +305
DotNetNuke.Modules.ActiveForums.af_grid.BindPosts(Int32 Column, String Sort) +3649
DotNetNuke.Modules.ActiveForums.af_grid.OnLoad(EventArgs e) +202
System.Web.UI.Control.LoadRecursive() +74
System.Web.UI.Control.LoadRecursive() +146
System.Web.UI.Control.LoadRecursive() +146
System.Web.UI.Control.LoadRecursive() +146
System.Web.UI.Control.LoadRecursive() +146
System.Web.UI.Control.LoadRecursive() +146
System.Web.UI.Control.LoadRecursive() +146
System.Web.UI.Control.LoadRecursive() +146
System.Web.UI.Control.LoadRecursive() +146
System.Web.UI.Control.LoadRecursive() +146
System.Web.UI.Control.LoadRecursive() +146
System.Web.UI.Control.LoadRecursive() +146
System.Web.UI.Control.LoadRecursive() +146
System.Web.UI.Control.LoadRecursive() +146
System.Web.UI.Control.LoadRecursive() +146
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2207

[PageLoadException: Parameter count does not match Parameter Value count.]
DotNetNuke.Services.Exceptions.Exceptions.ProcessPageLoadException(Exception exc, String URL) +430
DotNetNuke.Framework.PageBase.OnError(EventArgs e) +631
System.Web.UI.Page.HandleError(Exception e) +86
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +8422
System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +253
System.Web.UI.Page.ProcessRequest() +78
System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) +21
System.Web.UI.Page.ProcessRequest(HttpContext context) +49
ASP.default_aspx.ProcessRequest(HttpContext context) +4
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +100
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75
Coordinator
Apr 19, 2013 at 6:13 PM
"Parameter count does not match Parameter Value count."

If you are seeing that error, it means that the database and the code are out of sync.

To correct this, I'd do the following.

1) Do a repair install
2) Rerun the 5.0.4 SQL Script
3) Recycle the app pool.
Apr 19, 2013 at 6:14 PM
Thanks. That helped. Its working now.