<!--[if gte mso 9]> Normal 0 unctuationKerning/> false false false oNotPromoteQF/> EN-US X-NONE X-NONE ontGrowAutofit/> ontVertAlignCellWithSp/> ontBreakConstrainedForcedTables/> ontVertAlignInTxbx/> MicrosoftInternetExplorer4 Our department recently purchased Dynamic Forms 4.0 Enterprise edition. We have multiple individual installations of websites throughout our division, one of which is DNN 04.09.05. We were running a very old version of Dynamic Forms (3.1ish?) and I decided to update to the latest version using 23595_23601_DataSprings_DynamicForms_Module40_00_12_EnterpriseEdition_NoTelerik_DNN48PLUS.

The installation went fine (I can provide the log if needed) and after some testing, I began building a new form for a project. When I went to view the results (something I didn’t look at while testing) I received the following error:

A critical error has occurred. Parameter count does not match Parameter Value count.

 

I looked at the log and received the following message:

 

AssemblyVersion : 04.09.05
PortalID: 0
PortalName: Office of the Dean of Students
UserID: 32
UserName: ------
ActiveTabID: 298
ActiveTabName: Neutral Observer Program
RawURL: /NeutralObserverProgram/tabid/298/ctl/ViewFormsResults/mid/695/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://uodos.uoregon.edu/NeutralObserverProgram/tabid/298/Default.aspx
UserAgent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:8.0.1) Gecko/20100101 Firefox/8.0.1
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 89167e1f-c9df-400e-b511-f920c178c1b8
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.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DataSprings.Modules.DynamicForms.SqlDataProvider.GetDynamicResponseByModule(Int32 ModuleID, Int32 intSaveForLater) at DataSprings.Modules.DynamicForms.DynamicResponseController.GetDynamicResponseModule(Int32 ModuleID, Int32 intSaveForLater) at DataSprings.Modules.DynamicForms.ViewFormResults.loadGrid(Int32 PageSize) at DataSprings.Modules.DynamicForms.ViewFormResults.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.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---

I made a backup of the installation prior to the upgrade last night, but since that time have had editors login and make changes. Is there a way to fix this, or gracefully downgrade to a previous version? It’s critical that I get the form’s back as soon as possible so that our users can access the results.

 

Any help you can provide would be greatly appreciated.

Billy

An update:

I uninstalled the module and attemped a reinstall, reset IIS and tried again and I still received the error.

Billy,

Hi. Can you tell me:

1. What is the exact filename that you are installing? There is a version that supports 4.x and a version that supports 5.x and 6.x and they have their own installation files. I think you want the file that says "NoTelerik" in it.

2. Probably more importantly - The latest versions of Dynamic Forms and Dynamic Registration (and all of our modules) all require SQL Server 2005 or higher. So if you are running on SQL Server 2000 then this would cause a problem. It sounds like a stored procedure is not getting created or saved properly.

Thanks,

Chad

Hey Chad,

I am using the following file:
23595_23601_DataSprings_DynamicForms_Module40_00_12_EnterpriseEdition_NoTelerik_DNN48PLUS

The server that we are running the database on is SQL Server 2005.

Thanks for your help,

Hi Billy,

Do you know of any specific errors you received during the installation originally? It sounds like a stored procedure did not get created but I am not really sure which one from this error.

Just based on the actual error you might try this:

1. Go to Host/SQL and run this query:
CREATE PROCEDURE dbo.[DynamicForms_GetDynamicResponseByModuleID]
@ModuleID as int,
@intSaveForLater Integer
AS
select distinct dqr.UniqueResponseID, ResponseDateTime from dbo.[DynamicForms_QuestionResponse] as dqr, dbo.[DynamicForms_Question] as dq
where dqr.DynamicQuestionID=dq.DynamicQuestionID
and dq.Moduleid=@ModuleID
and dq.HideFromResults =0
and ((@intSaveForLater = 0) or (@intSaveForLater = 1 AND dqr.SaveForLater = 0) or (@intSaveForLater = 2 AND dqr.SaveForLater = -1))
Order By ResponseDateTime desc

2. Go to Host, Host Settings and click "Restart Application".

This should fix you up based on the error you posted but the bigger issue would be "are there more of these" because I don't know of anyone else reporting this, so I am wondering if this stored procedure did not get updated, are there others that did not get updated?

The other thing is, its possible that you are running on SQL Server 2005 but are you sure the compatibility mode is set to 2005? Was this a database that was originally upgraded from SQL Server 2000? If so I have seen instances where the SQL Server mode does not get properly set to 2005 even if its running on 2005 and even if it shows that its set to a compatibility mode of 90 in the SLQ Server UI.

Thanks,

Chad

Hey Chad,

As far as I could tell the Database was set to 2005 compatibility. I spoke with a co-worker who said she didn't believe it was ever on a 2000 server. It seems from your post that it's possible there would be a mis-report from SQL Server potentially, but as far as we can tell it should be compatible with 2005.

I tried running the procedure and received an error. I didn't get much detail from DNN but when running this via MS Sql Management Studio I received the following:

Msg 207, Level 16, State 1, Procedure DynamicForms_GetDynamicResponseByModuleID, Line 9
Invalid column name 'SaveForLater'.
Msg 207, Level 16, State 1, Procedure DynamicForms_GetDynamicResponseByModuleID, Line 9
Invalid column name 'SaveForLater'.

Based from the procedure provided I was able to confirm that the column name "SaveForLater" is not present. I also checked on the procedure and it appears it is in fact present, but with the following SQL when I view it via "Modify"

USE [****]
GO
/****** Object: StoredProcedure [dbo].[DynamicForms_GetDynamicResponseByModuleID] Script Date: 02/06/2012 13:48:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[DynamicForms_GetDynamicResponseByModuleID]
@ModuleID as int
AS
select distinct dqr.UniqueResponseID, ResponseDateTime from dbo.[DynamicForms_QuestionResponse] as dqr, dbo.[DynamicForms_Question] as dq
where dqr.DynamicQuestionID=dq.DynamicQuestionID
and dq.Moduleid=@ModuleID
and dq.HideFromResults =0
Order By ResponseDateTime desc




I think I might uninstall 4.0 and re-install an older version (3.1 I believe) so that I can get this back up and running. Thank you for the help.

Hmmm... That seems very strange... This was added in at a later time but still a couple versions back (and within the SQL there should be an alter statement). The only thing that I could imagine might happen would be if the SQL database user you were using had rights to create tables but not modify them (since this column was added at a later day and time then the very first SQL statement the database user would need rights to be able to ALTER tables and not just CREATE tables which is a separate permission I think?). That is the only thing I can think of at this time.

If you look in the 04.00.00.SqlDataProvider file at the top you will see this:


if not exists (select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME like '%dynamicforms_questionresponse%' and COLUMN_NAME = 'SaveForLater')
BEGIN
Alter Table {databaseOwner}[{objectQualifier}DynamicForms_QuestionResponse]
Add SaveForLater Integer null
END
GO

Update {databaseOwner}[{objectQualifier}DynamicForms_QuestionResponse]
Set SaveForLater = 0
GO

So for some reason that ALTER statement is not getting executed?

-Chad




Thanks,

Chad

Hey Chad,

Thank you for your help. I had to abandon trying to use 4.0 because I was running out of time, so I reverted back to 3.1 which worked fine.

Thanks for trying to help out with this issue.