Existing tags are not displayed when adding a tag to an agent (4378117)

From the Agent Status dashboard, when trying to add a tag to an agent, existing tags are not listed.

The following message can be seen in the Foglight Management Server (FMS) log.

ERROR [http-exec-24] com.quest.wcf.core.context.ContextUtils - Error getting value of context entry with key: tags
com.quest.wcf.core.module.runtimevalue.RuntimeValueException: com.quest.wcf.publicapi.code.FunctionInvocationException: Failed to invoke method "findAllTags" for Java Function definition id=system:wcf_common_ui_table.findTagsByCategory using class=com.quest.wcf.components.table2.TaggingFunctions in view: 'system:wcf_common_ui_table.nested' in top-level view: 'system:administration_agents_agent_status.updatePageWrapper' for user: 'username'
at com.quest.wcf.core.module.runtimevalue.impl.InvokeFunction.evaluate(InvokeFunction.java:97)
...
Caused by: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
...
Caused by: Error : 933, Position : 65, Sql = select distinct mtag from tagging_service_mapping where mtype=:1 1, OriginalSql = select distinct mtag from tagging_service_mapping where mtype=?1, Error Msg = ORA-00933: SQL command not properly ended

Similar messages can be displayed for other Foglight backend repository databases; for example:

PostgreSQL
Caused by: java.lang.IllegalStateException: org.postgresql.util.PSQLException: ERROR: could not determine data type of parameter $2

SQL Server
Caused by: java.lang.IllegalStateException: com.microsoft.sqlserver.jdbc.SQLServerException: Must declare the scalar variable "@P01".

WORKAROUND

None.

STATUS

This issue has been logged as defect FOG-10192 and waiting for fix in a future release of Foglight.