Bug #54356 Formatting query fails with unsupported template format name toUpper
Submitted: 9 Jun 2010 7:42 Modified: 24 Jan 2011 19:20
Reporter: Kay Roepke Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Enterprise Monitor: Web Severity:S3 (Non-critical)
Version:2.2.1.1721 OS:Any
Assigned to: Kay Roepke CPU Architecture:Any
Tags: formatter

[9 Jun 2010 7:42] Kay Roepke 
Description:
A series of queries could not be HTML formatted because of an exception during the template processing.
2010-06-07 17:10:19,830 ERROR [http-18080-10:com.mysql.merlin.ui.actions.monitor.queryAnalysis.QuerySummaryInfo] error formatting example group statement id: 56 sql=[<omitted for privacy reasons>]
com.mysql.etools.exception.InternalErrorException: E0001: InternalErrorException: [<omitted for privacy reasons>, Could not format query.: unsupported format name toUpper]
	at com.mysql.merlin.ui.helper.sqlformatter.SQLFormatter.formatAsHTML(SQLFormatter.java:49)
	at com.mysql.merlin.ui.containers.QueryContainer.getQueryTextFormatted(QueryContainer.java:165)
[..snipped uninteresting part of stack..]

How to repeat:
Undetermined yet.

Suggested fix:
Fix usage of the StringTemplate format name in the templates.
[23 Nov 2010 18:05] Enterprise Tools JIRA Robot 
Marcos Palacios writes: 
Verified fixed in Monitor build 2.2.4.1758 with agent build 2.2.4.1760.
[26 Nov 2010 1:07] Roel Van de Paar 
Kay, Andy, Marcos, anyone,

Could you confirm the fix for this bug is in 2.3 also?
[29 Nov 2010 20:51] Marcos Palacios 
I can see the same test also passes with 2.3 GA.
[24 Jan 2011 19:20] John Russell 
Added to 2.2.4 change log:

HTML formatting for queries could fail with an exception.