Hi I have this error message on Control panel -> Module configuration, just exactly like this post http://www.datasprings.com/Products...p; (I will post the error message down the bottom) 

I tried all the tips and suggestions on that post, it did not work out work me. Same error remains. I replied on that post hoping to get any help and seems that post it is out of attention. I am using the Collection which has the Dynamic Views 2.0. So i was told by Candace(thanks Candace) that this version of Dynamic view should be fine, indicating I should not have this error. But I still gets the error. 

Could you please help me out? Any help will be appreciated. 

Thanks
Alan

Error: is currently unavailable. DotNetNuke.Services.Exceptions.ModuleLoadException: Invalid column name 'ModuleTitle'. ---> System.Data.SqlClient.SqlException: Invalid column name 'ModuleTitle'. 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.DNN.Modules.DynamicViews.Data.SqlDataProvider.GetDynamicForms(Int32 PortalID) at DataSprings.DNN.Modules.DynamicViews.Business.DynamicViewsController.GetDynamicForms(Int32 PortalId) at DataSprings.DNN.Modules.DynamicViews.Settings.RefreshDynamicForms() at DataSprings.DNN.Modules.DynamicViews.Settings.LoadMySettings() --- End of inner exception stack trace ---

Hello Alan,

Can you please go to Host -> SQL and try to run this query:

Alter Procedure {databaseOwner}[{objectQualifier}DataSprings_DynamicViews_LoadDynamicForms]
@PortalID Int
AS

Select A.ModuleID, B.ModuleTitle + ' / ModuleID: ' + Cast(A.ModuleID as nvarchar(7)) As ModuleTitle from {databaseOwner}[{objectQualifier}Modules] A
Inner Join {databaseOwner}[{objectQualifier}TabModules] B on A.ModuleID = B.ModuleID
Where ModuleDefID In (Select ModuleDefID from {databaseOwner}[{objectQualifier}ModuleDefinitions] where FriendlyName like '%Dynamic Forms%')
AND PortalID = @PortalID
AND A.IsDeleted =0

If this query results in an error from Host-> SQL saying it doesn't exist, then run this query:

Create Procedure {databaseOwner}[{objectQualifier}DataSprings_DynamicViews_LoadDynamicForms]
@PortalID Int
AS

Select A.ModuleID, B.ModuleTitle + ' / ModuleID: ' + Cast(A.ModuleID as nvarchar(7)) As ModuleTitle from {databaseOwner}[{objectQualifier}Modules] A
Inner Join {databaseOwner}[{objectQualifier}TabModules] B on A.ModuleID = B.ModuleID
Where ModuleDefID In (Select ModuleDefID from {databaseOwner}[{objectQualifier}ModuleDefinitions] where FriendlyName like '%Dynamic Forms%')
AND PortalID = @PortalID
AND A.IsDeleted =0


After getting a successful query message, please go back to your Dynamic View and try to use a form instance.

If you have any questions please let me know.

Thanks,

Ryan

Hi Ryan,

Thanks for much for your help. That has fixed the error. No error showing anymore.
Appreciated very much. Impressed by you Dev team.

Thanks
Alan

Hi Ryan,

Sorry, forgot to ask, will this approach impact the future upgrade of dynamic view, or DNN.
Or do we still need to do this fix after we upgraded the DNN and Dynamic view?

Thanks
Alan

Hello Alan,

I believe this is a Dynamic Views 1.0 error, and for DNN version 5.5.1 there has been a change in the name of the column module title. I believe this error will still exist in Dynamic Views 2.0 but we're creating a patch to account for this.

If you have any questions please let us know.

Thanks,

Ryan

Hi Ryan,

Thanks very much for letting me know. Appreciate it. That's good to hear.

Thanks again for your help.

Alan

There is an issue that I am not set as the database dbo and have another login so the stored procedure does not have 'dbo.DataSprings_DynamicViews_LoadDynamicForms' but 'qef.DataSprings_DynamicViews_LoadDynamicForms'

So Im still getting the error even though the procedure is in there:

Error: is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: The stored procedure 'dbo.DataSprings_DynamicViews_LoadDynamicForms' doesn't exist. ---> System.InvalidOperationException: The stored procedure 'dbo.DataSprings_DynamicViews_LoadDynamicForms' 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.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DataSprings.DNN.Modules.DynamicViews.Data.SqlDataProvider.GetDynamicForms(Int32 PortalID) at DataSprings.DNN.Modules.DynamicViews.Business.DynamicViewsController.GetDynamicForms(Int32 PortalId) at DataSprings.DNN.Modules.DynamicViews.Settings.RefreshDynamicForms() at DataSprings.DNN.Modules.DynamicViews.Settings.LoadMySettings() --- End of inner exception stack trace ---

Nevermind I forced the dbo. in the owner and it worked.

Disregard

Hello Sentient,

I'm glad to hear everything is working for you.

If anyone has any questions please let me know.

Thanks,

Ryan

Ryan, we are getting the same error message. Using DNN 5.05.01 and ran the SQL queries included above -- but did not get resolution. Any ideas?

An error has occurred.
DotNetNuke.Services.Exceptions.ModuleLoadException: Invalid column name 'ModuleTitle'. ---> System.Data.SqlClient.SqlException: Invalid column name 'ModuleTitle'. 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.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddModule(Int32 ContentItemID, Int32 PortalID, Int32 ModuleDefID, Boolean AllTabs, DateTime StartDate, DateTime EndDate, Boolean InheritViewPermissions, Boolean IsDeleted, Int32 createdByUserID) at DotNetNuke.Entities.Modules.ModuleController.AddModuleInternal(ModuleInfo objModule) at DotNetNuke.Entities.Modules.ModuleController.AddModule(ModuleInfo objModule) at DotNetNuke.UI.ControlPanels.ControlPanelBase.AddNewModule(String title, Int32 desktopModuleId, String paneName, Int32 position, ViewPermissionType permissionType, String align) at DotNetNuke.UI.ControlPanels.IconBar.AddModule_Click(Object sender, EventArgs e) --- End of inner exception stack trace ---

Hello Dan,

Sorry for the tardy response.

Can you please run this query under your Host -> SQL:


Alter Procedure {databaseOwner}[{objectQualifier}DataSprings_DynamicViews_LoadDynamicForms]
@PortalID Int
AS

Select A.ModuleID, A.ModuleTitle + ' / ModuleID: ' + Cast(A.ModuleID as nvarchar(7)) As ModuleTitle from {databaseOwner}[{objectQualifier}Modules] A
Inner Join {databaseOwner}[{objectQualifier}TabModules] B on A.ModuleID = B.ModuleID
Where ModuleDefID In (Select ModuleDefID from {databaseOwner}[{objectQualifier}ModuleDefinitions] where FriendlyName like '%Dynamic Forms%')
AND PortalID = @PortalID
AND A.IsDeleted =0

If this query results in an error from Host-> SQL saying it doesn't exist, then run this query:

Create Procedure {databaseOwner}[{objectQualifier}DataSprings_DynamicViews_LoadDynamicForms]
@PortalID Int
AS

Select A.ModuleID, A.ModuleTitle + ' / ModuleID: ' + Cast(A.ModuleID as nvarchar(7)) As ModuleTitle from {databaseOwner}[{objectQualifier}Modules] A
Inner Join {databaseOwner}[{objectQualifier}TabModules] B on A.ModuleID = B.ModuleID
Where ModuleDefID In (Select ModuleDefID from {databaseOwner}[{objectQualifier}ModuleDefinitions] where FriendlyName like '%Dynamic Forms%')
AND PortalID = @PortalID
AND A.IsDeleted =0


I altered this query, even though it looks the same, but please run this to see if this will fix you up.

If you have any questions please let us know.

Thanks and sorry again for the tardy response,

Ryan

I'm having this issue with attempting to place an instance of Interactive User Import. The SQL solution here seems to be specific to Dynamic Views. Is there a corresponding fix that will work with Interactive User Import?

Hello Ken,

Do you receive a similar error for Interactive User Import?? Can you please copy/paste the error into this forum thread?

This way I can pin point the location of where this error is being invoked and then provide you a fix.

If you have any questions please let me know.

Thanks,

Ryan

I am getting this same error on DNN 5.6.2 running Dynamic Views 2.10.1.  I tried running both queries and received errors on both.

Hi Nathan,

Please review this blog post that cores the query you need. I believe this is dependent on what version of DotNetNuke you have installed and I think the version you have installed is probably newer then when Ryan made this post.

http://www.datasprings.com/news/blo...tial-issue

Did you previously upgrade DotNetNuke from an earlier version? If so, maybe the version of this procedure you had to create needs changed since the upgrade? You should be able to look in the SQL Data Provider files and get that file / execute that file for this procedure.

IS this the query that gives you an error (the same error you posted?)
http://www.datasprings.com/portals/...xample.txt

If so I can also dig up and find the newer stored procedure however it should be part of your Dynamic Views installation file.


Thanks!

-Chad

OK, I'm getting something simular after a site was upgraded from DNN 5 to DNN 7.

Error: is currently unavailable. DotNetNuke.Services.Exceptions.ModuleLoadException: Invalid column name 'ModuleTitle'. ---> System.Data.SqlClient.SqlException: Invalid column name 'ModuleTitle'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() 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, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) 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.DNN.Modules.DynamicViews.Data.SqlDataProvider.GetDynamicForms(Int32 PortalID) at DataSprings.DNN.Modules.DynamicViews.Business.DynamicViewsController.GetDynamicForms(Int32 PortalId) at DataSprings.DNN.Modules.DynamicViews.Settings.RefreshDynamicViews() at DataSprings.DNN.Modules.DynamicViews.Settings.LoadMySettings() --- End of inner exception stack trace ---

I unfortunately didn't do the upgrade (hosting provider did) and I wasn't involved in the process. From what I can tell they upgrade to Dynamic Views 3.0.30 (not sure what version it was before but either 1 or 2 most likely).

I went ahead and upgrade to 3.1 which did fix some of the other issues I was having but not this.

This only shows up on the Module Configuration page edit view. The real bad part is the configuration loads to the defaults / blank. So if you hit save, you lose everything. YOu can go back and re-enter everything and hit save and it will stick. But if you got back to modify the configuration, it is blank again with this error.

Any ideas?

H Justin,

Can you run this under Host/SQL and see if this works for you? Then go to host/host settings and click "Restart Application".

ALTER Procedure {databaseOwner}[{objectQualifier}DataSprings_DynamicViews_LoadDynamicForms]
@PortalID Int
AS

Select A.ModuleID, B.ModuleTitle + ' / ModuleID: ' + Cast(A.ModuleID as nvarchar(7)) As ModuleTitle from {databaseOwner}[{objectQualifier}Modules] A
Inner Join {databaseOwner}[{objectQualifier}TabModules] B on A.ModuleID = B.ModuleID
Where ModuleDefID In (Select ModuleDefID from {databaseOwner}[{objectQualifier}ModuleDefinitions] where FriendlyName like '%Dynamic Forms%')
AND PortalID = @PortalID
AND A.IsDeleted =0
GO


Thanks,

Chad

Thanks Chad!

That fixed it.