Bug #51993 Manage Import / Export Failure
Submitted: 12 Mar 2010 13:20 Modified: 12 Mar 2010 15:16
Reporter: Alexander Fuchs Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S1 (Critical)
Version:5.2.16 OS:Windows
Assigned to: CPU Architecture:Any

[12 Mar 2010 13:20] Alexander Fuchs
Description:
Exception = System.Runtime.InteropServices.SEHException
Message = Eine externe Komponente hat eine Ausnahme ausgelöst.
FullText = System.Runtime.InteropServices.SEHException: Eine externe Komponente hat eine Ausnahme ausgelöst.
   bei MySQL.Forms.DrawBoxImpl.drawbox_mouse_click(Object sender, MouseEventArgs e)
   bei System.Windows.Forms.Control.OnMouseClick(MouseEventArgs e)
   bei System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   bei System.Windows.Forms.Control.WndProc(Message& m)
   bei System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   bei System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   bei System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

How to repeat:
This Error occures when i choose a DB from the list and click the OK button for 'Manage Import/Export' in 'Server Administration'.
[12 Mar 2010 13:31] Alexander Fuchs
I also tried to delete and recreate new connections but nothing helps... :/
[12 Mar 2010 13:33] Johannes Taxacher
Does it work to launch the administration section for that profile by just doubleclicking the corresponding item in the server-instances-list (and then clicking the import/export tab)?
could you maybe attach your connections.xml file (found in c:\Users\<username>\AppData\Roaming\MySQL\Workbench)
thanks in advance.
[12 Mar 2010 13:43] Alexander Fuchs
no this also dont works - Could not connect to target database: error calling WbAdmin.openAdministrator

Traceback (most recent call last):
  File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_grt.py", line 149, in openAdministrator
    do_open_administrator(server_instance)
  File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_grt.py", line 125, in do_open_administrator
    adminTab = AdministratorTab(server_instance)
  File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_grt.py", line 95, in __init__
    self.configuration = wb_admin_configuration.WbAdminConfiguration(server_instance_settings, self.ctrl_be, self.monitor)
  File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_configuration.py", line 60, in __init__
    sys_config_path = self.ctrl_be.get_config_file_path()
  File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_control_be.py", line 667, in get_config_file_path
    return self.expand_path_variables(self.settings.serverInfo['sys.config.path'].strip(" \r\t\n\b"))
AttributeError: 'NoneType' object has no attribute 'strip'

Cennection XML:

- <value type="object" struct-name="db.mgmt.Connection" id="{C38D44AF-A4AD-4B28-9C32-A984FC8B225C}" struct-checksum="0xefea20d5">
  <link type="object" struct-name="db.mgmt.Driver" key="driver">com.mysql.rdbms.mysql.driver.native</link> 
  <value type="string" key="hostIdentifier">Mysql@XXX:3306</value> 
  <value _ptr_="0C35D188" type="dict" key="modules" /> 
- <value _ptr_="0C35DBA8" type="dict" key="parameterValues">
  <value type="string" key="%userName%::Mysql@%hostName%:%port%">%userName%::Mysql@%hostName%:%port%</value> 
  <value type="string" key="hostName">XXX</value> 
  <value type="int" key="port">3306</value> 
  <value type="string" key="schema" /> 
  <value type="string" key="userName">XXX</value> 
  </value>
  <value type="string" key="name">af-it.at</value> 
  </value>

this connection works fine in the SQL Development Area.
[12 Mar 2010 14:58] MySQL Verification Team
Thank you for the bug report. Duplicate of bug: http://bugs.mysql.com/bug.php?id=51477.
[12 Mar 2010 15:16] Alexander Fuchs
so is there a solution available...?
[30 Jan 2013 12:25] paulo silva
I recreate new connections and works.