Bug #78691 Created Stored Procedures in a Schema are not visible in the Workbench Schema
Submitted: 4 Oct 2015 8:20 Modified: 12 Oct 2015 4:05
Reporter: Nikhil Satam Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S1 (Critical)
Version:6.3.4 OS:Windows (Microsoft Windows 7 Professional Service Pack 1)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[4 Oct 2015 8:20] Nikhil Satam
Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\NIK\AppData\Roaming\MySQL\Workbench\log\wb.log]

Whenever I create a SP in the selected schema, the SP gets created in the schema, but when I refresh the schema, the SP's are vanished.
When i try to create it again, it says the SP already exists, but the SP is not visible.
How can I get to see the SP's in the Workbench UI.
I am using MySQL Workbench 6.3

13:26:46 [ERR][  GRTDispatcher]: worker: task 'wizard task' has failed with error:.There was an error while applying the SQL script to the database.
13:32:41 [ERR][SqlEditorSchemaTree]: Exception retrieving node description : Type mismatch: expected type string, but got 

Logs:
sql_actions_unconnected
[63, 13:38:37] Apply changes to Proc_QuickRegisterProfile: Preparing...
[63, 13:38:39] Applying changes to Proc_QuickRegisterProfile...: 
[63, 13:38:39] : Changes applied to Proc_QuickRegisterProfile
[63, 13:38:40] Apply changes to Proc_QuickRegisterProfile: Changes applied
[64, 13:38:55] Apply changes to Proc_QuickRegisterProfile: Preparing...
[64, 13:39:20] Applying changes to Proc_QuickRegisterProfile...: 
[64, 13:39:20] : Changes applied to Proc_QuickRegisterProfile
[64, 13:39:22] Apply changes to Proc_QuickRegisterProfile: Changes applied
[65, 13:41:41] Apply changes to Proc_QuickRegisterProfile: Preparing...
[65, 13:41:42] Applying changes to Proc_QuickRegisterProfile...: 
[65, 13:41:42] : Changes applied to Proc_QuickRegisterProfile
[65, 13:41:43] Apply changes to Proc_QuickRegisterProfile: Changes applied

wb
13:26:34 [ERR][  GRTDispatcher]: exception in grt execute_task, continuing: Exception: There was an error while applying the SQL script to the database.
13:26:34 [ERR][  GRTDispatcher]: worker: task 'wizard task' has failed with error:.There was an error while applying the SQL script to the database.
13:26:46 [ERR][  GRTDispatcher]: exception in grt execute_task, continuing: Exception: There was an error while applying the SQL script to the database.
13:26:46 [ERR][  GRTDispatcher]: worker: task 'wizard task' has failed with error:.There was an error while applying the SQL script to the database.
13:32:41 [ERR][SqlEditorSchemaTree]: Exception retrieving node description : Type mismatch: expected type string, but got 

How to repeat:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\NIK\AppData\Roaming\MySQL\Workbench\log\wb.log]

Whenever I create a SP in the selected schema, the SP gets created in the schema, but when I refresh the schema, the SP's are vanished.
When i try to create it again, it says the SP already exists, but the SP is not visible.
How can I get to see the SP's in the Workbench UI.
I am using MySQL Workbench 6.3

13:26:46 [ERR][  GRTDispatcher]: worker: task 'wizard task' has failed with error:.There was an error while applying the SQL script to the database.
13:32:41 [ERR][SqlEditorSchemaTree]: Exception retrieving node description : Type mismatch: expected type string, but got 

Logs:
sql_actions_unconnected
[63, 13:38:37] Apply changes to Proc_QuickRegisterProfile: Preparing...
[63, 13:38:39] Applying changes to Proc_QuickRegisterProfile...: 
[63, 13:38:39] : Changes applied to Proc_QuickRegisterProfile
[63, 13:38:40] Apply changes to Proc_QuickRegisterProfile: Changes applied
[64, 13:38:55] Apply changes to Proc_QuickRegisterProfile: Preparing...
[64, 13:39:20] Applying changes to Proc_QuickRegisterProfile...: 
[64, 13:39:20] : Changes applied to Proc_QuickRegisterProfile
[64, 13:39:22] Apply changes to Proc_QuickRegisterProfile: Changes applied
[65, 13:41:41] Apply changes to Proc_QuickRegisterProfile: Preparing...
[65, 13:41:42] Applying changes to Proc_QuickRegisterProfile...: 
[65, 13:41:42] : Changes applied to Proc_QuickRegisterProfile
[65, 13:41:43] Apply changes to Proc_QuickRegisterProfile: Changes applied

wb
13:26:34 [ERR][  GRTDispatcher]: exception in grt execute_task, continuing: Exception: There was an error while applying the SQL script to the database.
13:26:34 [ERR][  GRTDispatcher]: worker: task 'wizard task' has failed with error:.There was an error while applying the SQL script to the database.
13:26:46 [ERR][  GRTDispatcher]: exception in grt execute_task, continuing: Exception: There was an error while applying the SQL script to the database.
13:26:46 [ERR][  GRTDispatcher]: worker: task 'wizard task' has failed with error:.There was an error while applying the SQL script to the database.
13:32:41 [ERR][SqlEditorSchemaTree]: Exception retrieving node description : Type mismatch: expected type string, but got
[4 Oct 2015 8:21] Nikhil Satam
wb.log file

Attachment: wb.log (application/octet-stream, text), 11.17 KiB.

[4 Oct 2015 8:21] Nikhil Satam
Another log file sql_Actions

Attachment: sql_actions_unconnected.log (application/octet-stream, text), 231.81 KiB.

[12 Oct 2015 4:05] MySQL Verification Team
Thank you for the bug report. Duplicate of bug https://bugs.mysql.com/bug.php?id=74708.