6.x: Syntax error in report definition created by SNMP Studio

Longitude's SNMP Studio has an option to create reports based on queries against Longitude's SAP database. Longitude 6.1 and higher use a newer version of the database which may produce a syntax error if a column alias is used in a "group by" in the query. For example, the original definition may have:

group by md.manageddevicedns, mobject

as the "group by" clause in the query, where mobject is defined in the select statement as: "select mo.objectname as mobject". The query should be modified to:

group by md.manageddevicedns, mo.objectname

A fix for this is in development - the workaround until the fix is available is as follows:

1. Navigate to the Longitude\applications\{snmpStudioCreatedApp}\reports\templates directory. For each report in the solution there will be a separate folder, and each folder will contain a "main.xml" file. Open each main.xml in a text editor.
2. Each main.xml will contain 3 queries. Check the "group by" clause of each query and change any column aliases used in each query to use the column name. Most often, you will need to change "mobject" to "mo.objectname".
3. Save all file changes and restart the Web UI to read in the new definitions.

Please note: To make reports from SNMP Studio applications visible, first register the application, then restart the Web UI.