1

Resolved

Add New Record Exception

description

I am getting the following exception when I am trying to add new record :-

Error: is currently unavailable. DotNetNuke.Services.Exceptions.ModuleLoadException: Invalid object name 'dbo.UserDefinedData'. ---> System.Data.SqlClient.SqlException: Invalid object name 'dbo.UserDefinedData'. 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() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) 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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlTransaction transaction, String spName, Object[] parameterValues) at DotNetNuke.Modules.UserDefinedTable.SqlDataProvider.UpdateData(Int32 rowId, IDictionary`2 values) at DotNetNuke.Modules.UserDefinedTable.UserDefinedTableController.UpdateRow(DataSet ds, Int32 rowNr, Boolean isDataToImport) at DotNetNuke.Modules.UserDefinedTable.EditForm.cmdUpdate_Click(Object sender, EventArgs e) --- End of inner exception stack trace ---


I tried to export the csv file and It shows the columns name correctly whoever, if I tried to import it again it also gives me an exception :-

Error occured during Import operation. Please make sure that you have fully valid CSV file and the delimiter is correct for this file. Invalid object name 'dbo.UserDefinedData'.


Any idea how to solve this problem ?

comments

agemagician wrote Aug 17, 2012 at 3:51 PM

I am using DNN ver. 6 and Form and List ver. 06.00.03

SCullmann wrote Aug 30, 2012 at 9:30 PM

I hope your issue is caused by the missing object qualifier in 6.0.3, which was also reported in the forums: http://www.dotnetnuke.com/Resources/Forums/forumid/56/threadid/464687/scope/posts.aspx

If yes, it will be fixed in fnl6.0.4

agemagician wrote Aug 31, 2012 at 12:30 PM

Thank you so much. I have updated it to version 6.0.4 and now It is working great :)

Thank you again.

SCullmann wrote Aug 31, 2012 at 12:55 PM

You are quick - FnL6 is not officially released yet.
Anyway, thank you for your feedback!

untamedchap wrote Sep 6, 2012 at 10:48 AM

I'm getting the same error message. . . Help?

I have DNN: 06.02.01 (253)
I have Forms & Lists: 6.0.3

ERROR MESSAGE DETAILED BELOW (when adding a record or trying to update an existing one):
" Error: is currently unavailable. DotNetNuke.Services.Exceptions.ModuleLoadException: Invalid object name 'dbo.UserDefinedData'. ---> System.Data.SqlClient.SqlException: Invalid object name 'dbo.UserDefinedData'. 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.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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlTransaction transaction, String spName, Object[] parameterValues) at DotNetNuke.Modules.UserDefinedTable.SqlDataProvider.UpdateData(Int32 rowId, IDictionary`2 values) at DotNetNuke.Modules.UserDefinedTable.UserDefinedTableController.UpdateRow(DataSet ds, Int32 rowNr, Boolean isDataToImport) at DotNetNuke.Modules.UserDefinedTable.EditForm.cmdUpdate_Click(Object sender, EventArgs e) --- End of inner exception stack trace --- "

agemagician wrote Sep 6, 2012 at 4:09 PM

@untamedchap: Upgrade your dnnfnl to version version 6.0.4 and It will work.

untamedchap wrote Sep 19, 2012 at 11:42 PM

So when is (Form and List) FNL 6.0.4 coming out?

Sign in to add a comment or to set email notifications