Strategic Snapshots: Editing a snapshot with a non-Super Admin user leads to a Whoops error

Issue Summary

A Whoops error is thrown in Strategic Snapshots StrategyGrid.asp page when editing a snapshot with a non-Super Admin user.

Splunk error:

{ [-]
   ASP_function: OOFunctionsSql.SetRSParamsCursor
   correlationid: wr843RBaPbjRm0xmN0rcnoQT1KPm0d5TYRFI4trc9no=
   customer_db: instance
   error_description: Column 'tblRelease.PlanType' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
   error_id: 39901
   error_number: -2147217900
   error_source: Microsoft SQL Server Native Client 11.0
   log_type: exception
   logfrom_location: Website-ASP
   sql:  SELECT DISTINCT t1.ReleaseDesc, t1.ReleaseID, t2.ReleaseID AS selectedReleaseID, t1.PlanType,  SUM(CASE WHEN s1.Uniq != ? THEN 0 ELSE 1 END) AS SameProgram FROM tblRelease t1  LEFT OUTER JOIN (SELECT ReleaseID FROM tblStrategyRelease WHERE StrategyID = ?) t2 ON t1.ReleaseID = t2.ReleaseID INNER JOIN tblIterationReportGroup t3 ON t3.PortfolioID = t1.Program INNER JOIN sysmemberTeamRole s1 ON s1.TeamID = t3.TeamID WHERE t1.ReleaseID NOT IN (SELECT val FROM dbo.[fnSplitStringBySeparator](?, ',')) AND (s1.Uniq = ? OR t2.ReleaseID IS NOT NULL) GROUP BY t1.ReleaseID, t2.ReleaseID, t1.ReleaseDesc ORDER BY ReleaseDesc
   timestamp: 2021-01-19T11:32:54.391000-05:00
   url: https://instance.jiraalign.com:443/AddStrategy.asp?FirstTime=True&AddNew=True&StrategyID=48&TabID=1
   urlverb: GET
   user: 2324
   version: 10.87.0.13682
}

Steps to Reproduce

1. Log in to Jira Align as a non-Super Admin
2. Browse to Strategic Snapshots StrategyGrid.asp page
3. Click Add Snapshot to create new item
4. Fill in data as necessary
5. Click Save & Close button
6. Try to open the snapshot created on the previous step
7. Notice the Whoops error message

Expected Results

• The snapshot is open flawlessly

Actual Results

• A Whoops error message is thrown if logged user is not a Super Admin (RoleID!=9)

Workaround

• Edit Snapshots using a Super Admin (RoleID=9) account