Bug #65006 Error while try to generate insert statement.
Submitted: 17 Apr 2012 12:18 Modified: 11 Jun 2012 2:27
Reporter: Anton Pavlov Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2.38, 5.2.39 OS:Windows (Microsoft Windows XP Professional Service Pack 3 (build 2600))
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[17 Apr 2012 12:18] Anton Pavlov
Description:
Error while try to generate insert statement.

How to repeat:
On tables context menu select Copy to clipboard/insert statement
[17 Apr 2012 12:30] Valeriy Kravchuk
Please, send complete CREATE TABLE statement for the table used. What exact server version do you work with?
[17 Apr 2012 13:54] Anton Pavlov
Version of Worknench is 5.2.39.8757.

Statement for table creation:

delimiter $$

CREATE TABLE `alarms` (
  `AlarmID` int(11) NOT NULL,
  `AlarmCodingStandart` smallint(6) NOT NULL,
  `AlarmProbableCause` int(11) NOT NULL,
  `AlarmSeverity` smallint(6) NOT NULL,
  `PathCodingStandart` smallint(6) NOT NULL,
  `Path` varbinary(40) NOT NULL,
  `CauseAdditionalInformation` varbinary(256) DEFAULT NULL,
  `AlarmTime` datetime DEFAULT NULL,
  `AlarmTimeShift` smallint(6) DEFAULT NULL,
  `AlarmRecieveTime` datetime DEFAULT NULL,
  `AlarmRecieveTimeShift` smallint(6) DEFAULT NULL,
  `AlarmClearTime` datetime DEFAULT NULL,
  `AlarmClearTimeShift` smallint(6) DEFAULT NULL,
  `AlarmViewTime` datetime DEFAULT NULL,
  `AlarmViewTimeShift` smallint(6) DEFAULT NULL,
  `OperatorViewed` varchar(64) DEFAULT NULL,
  `OperatorComment` varchar(256) DEFAULT NULL,
  `AlarmDataString` varchar(256) DEFAULT NULL,
  `HostName` varchar(256) DEFAULT NULL,
  `SpecificProblem` varchar(256) DEFAULT NULL,
  `MonitoredAttributes` varchar(256) DEFAULT NULL,
  `ThresholdInformation` varchar(256) DEFAULT NULL,
  `UserSeverity` varchar(20) DEFAULT NULL,
  `MmtpObjectName` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`AlarmID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8$$
[17 Apr 2012 16:18] Valeriy Kravchuk
Verified just as described on 32-bit Windows XP with your table created on local MySQL server 5.5.22. Stack trace is:

Exception = System.Runtime.InteropServices.ExternalException
Message = Requested Clipboard operation did not succeed.
FullText = System.Runtime.InteropServices.ExternalException (0x800401D0): Requested Clipboard operation did not succeed.
   at System.Windows.Forms.Clipboard.ThrowIfFailed(Int32 hr)
   at System.Windows.Forms.Clipboard.SetDataObject(Object data, Boolean copy, Int32 retryTimes, Int32 retryDelay)
   at System.Windows.Forms.Clipboard.SetText(String text, TextDataFormat format)
   at System.Windows.Forms.Clipboard.SetText(String text)
   at MySQL.Forms.UtilitiesImpl.set_clipboard_text(basic_string<char\,std::char_traits<char>\,std::allocator<char> >* content)
   at MySQL.MCallback1<void\,std::basic_string<char\,std::char_traits<char>\,std::allocator<char> > const \&>.cpp_callback(basic_string<char\,std::char_traits<char>\,std::allocator<char> >* arg1)
   at mforms.Menu.handle_action(Menu* , basic_string<char\,std::char_traits<char>\,std::allocator<char> >* )
   at MySQL.Forms.MenuImpl.ItemClick(Object sender, EventArgs e)
   at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
   at System.Windows.Forms.ToolStripMenuItem.OnClick(EventArgs e)
   at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
   at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
   at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
   at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
   at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
   at System.Windows.Forms.ToolStripDropDown.OnMouseUp(MouseEventArgs mea)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   at System.Windows.Forms.ToolStrip.WndProc(Message& m)
   at System.Windows.Forms.ToolStripDropDown.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)
[11 Jun 2012 2:27] Alfredo Kojima
duplicate of bug #64881