Community forum

Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.


ErikC
  •  ErikC
  • Paid support Topic Starter
2010-10-11T10:43:17Z
1st Problem


Hi Support,

I had an error today during a cloning process of a SQL connection.

This is the error:

System.Data.ConstraintException: Column 'id' is constrained to be unique.  Value '147' is already present.
   at System.Data.UniqueConstraint.CheckConstraint(DataRow row, DataRowAction action)
   at System.Data.DataTable.RaiseRowChanging(DataRowChangeEventArgs args, DataRow eRow, DataRowAction eAction, Boolean fireEvent)
   at System.Data.DataTable.SetNewRecordWorker(DataRow row, Int32 proposedRecord, DataRowAction action, Boolean isInMerge, Int32 position, Boolean fireEvent, Exception& deferredException)
   at System.Data.DataTable.InsertRow(DataRow row, Int32 proposedID, Int32 pos, Boolean fireEvent)
   at System.Data.DataRowCollection.Add(DataRow row)
   at Dictionary.ConnectionParametersDataTable.AddConnectionParametersRow(ConnectionParametersRow row)
   at frmConnectionWizard.CloneConnection(String strConnectionId)
   at ODNKNCFDHHPJPCMOFFIIHIOEPAPDAKPENFKF.LEDLLOPPDOMPIKCJPFKAMIOKAODDMGMMFFGK.HAEJEADLBDKGJJHECDIBNHOJFJBNMFFIKCHL()
   at ODNKNCFDHHPJPCMOFFIIHIOEPAPDAKPENFKF.LEDLLOPPDOMPIKCJPFKAMIOKAODDMGMMFFGK.KPCICEAMKMKJNLMLEFGLCEGPCKGFMDNFBNEL(Object , ToolClickEventArgs )
   at Infragistics.Win.UltraWinToolbars.UltraToolbarsManager.OnToolClick(ToolClickEventArgs e)
   at Infragistics.Win.UltraWinToolbars.UltraToolbarsManager.FireEvent(ToolbarEventIds id, EventArgs e)
   at Infragistics.Win.UltraWinToolbars.ToolBase.OnToolClick()
   at Infragistics.Win.UltraWinToolbars.ButtonToolUIElement.DoClickProcessing(MouseEventArgs e)
   at Infragistics.Win.UltraWinToolbars.ButtonToolUIElement.OnMouseUp(MouseEventArgs e)
   at Infragistics.Win.ControlUIElementBase.ProcessMouseUpHelper(Object sender, MouseEventArgs e)
   at Infragistics.Win.ControlUIElementBase.ProcessMouseUp(Object sender, MouseEventArgs e)
   at Infragistics.Win.Utilities.ProcessEvent(Control control, ProcessEvent eventToProcess, EventArgs e)
   at Infragistics.Win.UltraControlBase.OnMouseUp(MouseEventArgs e)
   at Infragistics.Win.UltraWinToolbars.UltraToolbarsDockArea.OnMouseUp(MouseEventArgs e)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.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)


To reproduce this error follow these steps:

1. Have some connections in the connections list. One (or more) being a SQL connection.
2. Start adding a new SQL connection, but close this window after clicking once on the next button.
3. Now select one SQL connection and press the clone button.

The error should appear.

Regards,
Erik

Uses Visualcron since 2006.
Sponsor
Forum information
ErikC
  •  ErikC
  • Paid support Topic Starter
2010-10-11T10:52:16Z
2nd Problem

When I clone a SQL connection, step through the wizzard and reopen the cloned connection, I miss a lot of settings. I only have the Datasource left...

Regards
Erik
Uses Visualcron since 2006.
ErikC
  •  ErikC
  • Paid support Topic Starter
2010-10-11T11:11:15Z
3rd Problem

When I make a new SQL connection based on an existing connection string, and press the refresh parameter button on the 'Step 2' page of the wizard, all the parameters are gone in the grid overview. This is not good, I think.

Regards
Erik
Uses Visualcron since 2006.
ErikC
  •  ErikC
  • Paid support Topic Starter
2010-10-11T14:47:07Z
ErikC wrote:

Hi Support,

I had an error today during a cloning process of a SQL connection.

This is the error:

System.Data.ConstraintException: Column 'id' is constrained to be unique.  Value '147' is already present.
   at System.Data.UniqueConstraint.CheckConstraint(DataRow row, DataRowAction action)
   at System.Data.DataTable.RaiseRowChanging(DataRowChangeEventArgs args, DataRow eRow, DataRowAction eAction, Boolean fireEvent)
   at System.Data.DataTable.SetNewRecordWorker(DataRow row, Int32 proposedRecord, DataRowAction action, Boolean isInMerge, Int32 position, Boolean fireEvent, Exception& deferredException)
   at System.Data.DataTable.InsertRow(DataRow row, Int32 proposedID, Int32 pos, Boolean fireEvent)
   at System.Data.DataRowCollection.Add(DataRow row)
   at Dictionary.ConnectionParametersDataTable.AddConnectionParametersRow(ConnectionParametersRow row)
   at frmConnectionWizard.CloneConnection(String strConnectionId)
   at ODNKNCFDHHPJPCMOFFIIHIOEPAPDAKPENFKF.LEDLLOPPDOMPIKCJPFKAMIOKAODDMGMMFFGK.HAEJEADLBDKGJJHECDIBNHOJFJBNMFFIKCHL()
   at ODNKNCFDHHPJPCMOFFIIHIOEPAPDAKPENFKF.LEDLLOPPDOMPIKCJPFKAMIOKAODDMGMMFFGK.KPCICEAMKMKJNLMLEFGLCEGPCKGFMDNFBNEL(Object , ToolClickEventArgs )
   at Infragistics.Win.UltraWinToolbars.UltraToolbarsManager.OnToolClick(ToolClickEventArgs e)
   at Infragistics.Win.UltraWinToolbars.UltraToolbarsManager.FireEvent(ToolbarEventIds id, EventArgs e)
   at Infragistics.Win.UltraWinToolbars.ToolBase.OnToolClick()
   at Infragistics.Win.UltraWinToolbars.ButtonToolUIElement.DoClickProcessing(MouseEventArgs e)
   at Infragistics.Win.UltraWinToolbars.ButtonToolUIElement.OnMouseUp(MouseEventArgs e)
   at Infragistics.Win.ControlUIElementBase.ProcessMouseUpHelper(Object sender, MouseEventArgs e)
   at Infragistics.Win.ControlUIElementBase.ProcessMouseUp(Object sender, MouseEventArgs e)
   at Infragistics.Win.Utilities.ProcessEvent(Control control, ProcessEvent eventToProcess, EventArgs e)
   at Infragistics.Win.UltraControlBase.OnMouseUp(MouseEventArgs e)
   at Infragistics.Win.UltraWinToolbars.UltraToolbarsDockArea.OnMouseUp(MouseEventArgs e)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.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)


To reproduce this error follow these steps:

1. Have some connections in the connections list. One (or more) being a SQL connection.
2. Start adding a new SQL connection, but close this window after clicking once on the next button.
3. Now select one SQL connection and press the clone button.

The error should appear.

Regards,
Erik


I can reproduce this also in version 5.5.5, so it has been there for a while.
It looks however a client problem, not a server problem.

regards
Erik
Uses Visualcron since 2006.
Support
2010-10-11T22:02:04Z
Thanks for the report Erik. This should now have been fixed for next version.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Scroll to Top