Bug #62317 dbDesigner 4 Import
Submitted: 1 Sep 2011 8:59 Modified: 3 Feb 2015 4:01
Reporter: François COLLIAUX Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S2 (Serious)
Version:5.2.34 OS:Any (XP SP3, Mac OS X)
Assigned to: CPU Architecture:Any
Tags: column, DBdesigner, import
Triage: Needs Triage: D1 (Critical)

[1 Sep 2011 8:59] François COLLIAUX
Description:
When importing dbDesigner 4 model into a new workbench model.
1rst try : Workbench crash
2nd try : Error during import => no such column XXXX (XXXX is not a column and only referenced as string value in insert SQL in the model).

How to repeat:
Import model with insert orders
[1 Sep 2011 10:23] Valeriy Kravchuk
Please, upload some sample model that demonstrates the problem.
[1 Sep 2011 10:45] François COLLIAUX
After replacing all StandardInserts in the XML file, Workbench stop crashing and reporting error.

Sample old value :
StandardInserts="INSERT INTO Applications (codeApplication, libelleApplication) VALUES(\aSEPS\a, \aXXXX : Gestion Dossier\a);\nINSERT INTO Applications (codeApplication, libelleApplication) VALUES(\aYYYY\a, \aGestion Commande\a);\n"

New value :
StandardInserts="\n"
[1 Sep 2011 18:02] Rafael Antonio Bedoy Torres
Can you please share with us your model in order to verify your bug? if you mark it as "private" such uploads can only be seen and accessed by internal developers.

Thanks in advance!
[2 Sep 2011 14:58] Valeriy Kravchuk
Verified using uploaded private .xml file with pre-release of 5.2.35 on Mac OS X also.
[7 Feb 2014 16:19] Rafael Antonio Bedoy Torres
Posted by developer:
 
Still failing on 6.1.2.11647:

Stack:
Exception = System.Exception
Message = not handled
FullText = System.Exception: not handled
   at MySQL.GUI.Workbench.ModelOverviewForm.RefreshNodeInfo(NodeId node)
   at MySQL.GUI.Workbench.ModelOverviewForm.RefreshGUI(RefreshType refresh, String str, IntPtr ptr)
   at MySQL.GUI.Workbench.MainForm.ForwardRefreshToAllDocuments(RefreshType refresh, String str, IntPtr ptr)
   at MySQL.GUI.Workbench.MainForm.RefreshGUI(RefreshType refresh, String str, IntPtr ptr)
   at MySQL.Workbench.WbFrontendCallbacks.refresh_gui_wrapper(RefreshType refresh, basic_string<char\,std::char_traits<char>\,std::allocator<char> >* str, UInt32 ptr)
   at boost.detail.function.void_function_invoker3<void (__cdecl*)(enum wb::RefreshType,std::basic_string<char,std::char_traits<char>,std::allocator<char> > const &,unsigned int),void,enum wb::RefreshType,std::basic_string<char,std::char_traits<char>,std::allocator<char> >,unsigned int>.invoke(function_buffer* function_ptr, RefreshType a0, basic_string<char\,std::char_traits<char>\,std::allocator<char> >* a1, UInt32 a2)
   at wb.WBContext.flush_idle_tasks(WBContext* )
   at MySQL.Workbench.WbContext.flush_idle_tasks()
   at MySQL.GUI.Workbench.Program.timer_Tick(Object sender, EventArgs e)
[3 Feb 2015 4:01] Philip Olson
Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 6.2.5 release, and here's the changelog entry:

Importing a DBDesigner 4 model containing INSERT statements could crash
MySQL Workbench.

Thank you for the bug report.