Todo List

Hi,
What data source type do you use? I know it's not supported with Xml.

Hi David,

This is an RMDO data source. I swore it worked at one point but maybe not...?

Hi,
It's not supported with RDMO. I also verified directly the code and it's not implemented at all. I have entered a feature request.

I attempted to setup Todo lists for devices:
Using SQL server 2014 as a datasource.
Get the following error:

SqlException - The INSERT statement conflicted with the FOREIGN KEY constraint "FK__Todo__Connection__300424B4". The conflict occurred in database "MRNdatebase", table "dbo.Connections", column 'ID'.
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 Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.ExecuteNonQuery(String sql, IDbDataParameter[] parameters)
at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseTodoSubDataSource.SaveTodo(Todo todo)
at Devolutions.RemoteDesktopManager.Managers.TodoManager.SaveTodo(Todo todo)
at Devolutions.RemoteDesktopManager.Managers.TodoManager.SaveTodoAdapter(Connection connection, TodoAdapter todoAdapter)
at Devolutions.RemoteDesktopManager.Frames.FrmTodoEditor.butOk_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)

I have sent in the error report.

Also, is there a way of making ToDo lists on Groups\Folders?
Can I create a bunch of Todo's and assign them to devices or multiple devices?

Hi,
Was it for a connection where you got this error?

Was when I hit OK within Todo.

I have assigned this thread to Jeff. He will try to reproduce the issue.

Hi,

Have you tried to add a ToDo to a RDP session as example?

Could you please provide me the steps that you have made to get the error.

Best regards,
edited by jfdagenais on 8/27/2014

Just tested it on a few other systems. Issue is:
I have VM's Childed under their Host servers. So I can create TODO's on parents and individual systems, but not on childed systems or services. That is when I get the error.

So I can set a TODO on Host01 - Install updates and restart DC between 11-2
but I cannot set a TODO on the childed DC, I get the error I provided a few days ago.

Hi,
You're right it does not work for a sub connection.