Hi Gents
Have been very happy using UDT for a while but I now have an issue deleting columns in a well established UDT - with about 500 rows - each row is made up of 12 colums - mix of date, text, ints & true/false.
When I try to delete any column it takes 20 seconds then shows a red exclamation symbol with the following text >> An error has occurred. - Error: Manage User Defined Table is currently unavailable.
Apart from this the table appears to work fine - new rows can be added - filtering and paging works fine etc.
If I check the event log I get the following after the delete fails.
ModuleId: 400
ModuleDefId: 95
FriendlyName: Manage User Defined Table
ModuleControlSource: DesktopModules/UserDefinedTable/ManageUserDefinedTable.ascx
AssemblyVersion: 04.05.01
PortalID: 0
PortalName:
UserID: 2
UserName: admin
ActiveTabID: 114
ActiveTabName: udt test copy
RawURL: /Home/udttestcopy/tabid/114/ctl/Manage/mid/400/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://www.xxxxxx.co.uk/Home/udttestcopy/tabid/114/ctl/Manage/mid/400/Default.aspx
UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 5d997246-44a8-4f84-bc28-ba993a60fa35
InnerException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.OnError
StackTrace:
Message: DotNetNuke.Services.Exceptions.ModuleLoadException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated. ---> System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated. 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(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.UserDefinedTable.SqlDataProvider.DeleteData(Int32 UserDefinedRowId, Int32 UserDefinedFieldId) at DotNetNuke.Modules.UserDefinedTable.UserDefinedTableController.DeleteField(Int32 ModuleId, Int32 UserDefinedFieldID) at DotNetNuke.Modules.UserDefinedTable.ManageUserDefinedTable.grdFields_DeleteCommand(Object source, DataGridCommandEventArgs e) --- End of inner exception stack trace ---
Source:
Server Name: xxxxxxxxxxxxxxx
My setup is as follows
DNN 4.5.1
UDT 3.4
IIS6.0
SQL2000 - on separate server - connection string OK as far as I know - other Modules OK
Browsers - same results on various versions of IE
As a test I have tried to copy the whole page and module to a new page but each time I try it hangs half way through the progress bar. If I stop the process the new test page exists but with only half the data rows. I cannot delete columns from this test page either - same error.
If I create a new UDT instance and add some columns and a couple of data rows I can delete columns fine, so the problem exists only in my established table?
I have tried to export the data and import into a new UDT but this also fails with a similar message?
So any ideas gents.
Many thanks in advance for your help on this otherwise great module...
Chris.