When attempting to view the form results the message below is logged and the results are not displayed. I tried uninstalling and reinstalling the module to no avail. Any help or suggestions? Thank you for your time.

 

Regards,

Christopher Koeber

 

AssemblyVersion: 04.04.00
PortalID: 0
PortalName: Wesley Theological Seminary Support Services
UserID: 1
UserName: host
ActiveTabID: 83
ActiveTabName: Documentation
RawURL: /Documentation/tabid/83/ctl/ViewFormsResults/mid/498/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer:
UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: ffb1309f-271d-4e65-8dcc-a4e7e84652c0
InnerException: Invalid object name 'DynamicForms_Question'.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.OnError
StackTrace:
Message: DotNetNuke.Services.Exceptions.PageLoadException: Invalid object name 'DynamicForms_Question'. ---> System.Data.SqlClient.SqlException: Invalid object name 'DynamicForms_Question'. 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 DataSprings.Modules.DynamicForms.SqlDataProvider.GetDynamicResponseByModule(Int32 ModuleID) at DataSprings.Modules.DynamicForms.DynamicResponseController.GetDynamicResponseModule(Int32 ModuleID) at DataSprings.Modules.DynamicForms.ViewFormResults.loadGrid() 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 ---
Source:
Server Name: XXX

Christopher,

We discovered an issue with a SQL query not including the correct object qualifier parameter within the SQL script. Since it sounds like your installation uses an object qualifier (i.e. dnn_ prefix for all tables) this would cause the issue. I will send you over the correct install to uninstall/reinstall. If you still continue to have issues after that let me know.

-Chad

Thanks! That fixed the issue.
Regards,
Christopher Koeber

Hello!
I've exactly the same problem with the view of the results.
Can you help me?
Thanks
Mselle