Deleting Radio Channels hangs TVServer Setup (1 Viewer)

[grubi]

When trying to delete a radio channel via TVServer setup the app hangs and the channel is not being deleted. Same for "clear" button.

grubi.

 

[gemx]

Could you please provide some logs (tv.log, error.log)?
Also the svn rev. could be of interest.

 

[grubi]

Could you please provide some logs (tv.log, error.log)?
Also the svn rev. could be of interest.

It's rev. 15939.
Checked this multiple times by recreating the whole db.
Seems that radio channels can be deleted directly after installation and channel scan, but then after reboot when the "all channels" group was being created deletion fails and the display is not refreshed. If you then kill the setuptv and restart it you can see that the channel was removed from the channel mapping but is still present. From which log do you think any additional information can be gathered?

Regards,
grubi.

 

[SciDoctor]

This is the error log I get with the same problem SVN 15947

18/09/2007 21:24:32 1 Exception :Error: StatementErrorUnclassified
Gentle.Common.GentleException: delete from Channel where idChannel = @idChannel; ---> System.Data.SqlClient.SqlException: The DELETE statement conflicted with the REFERENCE constraint "FK_RadioGroupMap_Channel". The conflict occurred in database "TvLibrary", table "dbo.RadioGroupMap", column 'idChannel'.
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 Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)
--- End of inner exception stack trace ---
at Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)
at Gentle.Framework.PersistenceBroker.Execute(Object obj, StatementType st, IDbConnection conn, IDbTransaction tr)
at Gentle.Framework.PersistenceBroker.Remove(Object obj, IDbTransaction dbTransaction)
at Gentle.Framework.Persistent.Remove()
at TvDatabase.Channel.Delete()
at SetupTv.Sections.RadioChannels.mpButtonDel_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)System.Data.SqlClient.SqlException: The DELETE statement conflicted with the REFERENCE constraint "FK_RadioGroupMap_Channel". The conflict occurred in database "TvLibrary", table "dbo.RadioGroupMap", column 'idChannel'.
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 Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)
18/09/2007 21:24:32 1 Exception :delete from Channel where idChannel = @idChannel;
18/09/2007 21:24:32 1 site :Gentle.Framework.SqlResult Execute(System.Data.IDbConnection, System.Data.IDbTransaction)
18/09/2007 21:24:32 1 source :Gentle.Framework
18/09/2007 21:24:32 1 stacktrace: at Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)
at Gentle.Framework.PersistenceBroker.Execute(Object obj, StatementType st, IDbConnection conn, IDbTransaction tr)
at Gentle.Framework.PersistenceBroker.Remove(Object obj, IDbTransaction dbTransaction)
at Gentle.Framework.Persistent.Remove()
at TvDatabase.Channel.Delete()
at SetupTv.Sections.RadioChannels.mpButtonDel_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

 

[grubi]

Log is showing clearly what's going on.
Channel has to be removed from radio group map before deletion due to foreign key constraint.

grubi.

 

[gemx]

Fixed in rev. 15964

 

[grubi]

Fixed in rev. 15964