Bug #62317 dbDesigner 4 Import

• Submitted: 1 Sep 2011 8:59
• Modified: 3 Feb 2015 4:01
• Reporter: François COLLIAUX
• Status: Closed
• Category: MySQL Workbench: Modeling
• Severity: S2 (Serious)
• Version: 5.2.34
• OS: Any (XP SP3, Mac OS X)
• CPU Architecture: Any
• Tags: column, DBdesigner, import

[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.