Themes : Browsing to the Themes grid results in a Whoops error message

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: High
    • 10.90
    • Affects Version/s: 10.89, 10.90
    • Component/s: other - grids
    • None

      Issue Summary

      When browsing to the Themes grid, user is presented with a Whoops error message.

      Steps to Reproduce

      1. In the Configuration Bar (aka Tier1 filter), click Advanced Configurations (cogs icon)
      2. Click Reset All button
      3. Scroll down and select a STRATEGIC SNAPSHOT
      4. Click Apply Settings button
      5. Browse to the Themes grid
      6. Notice the Whoops error message

      Expected Results

      • The Themes grid is presented

      Actual Results

      • A Whoops error message is displayed

      By following Community article The Dreaded "Whoops..." Error, the following error can be collected in DevTools/Console:

      ErrorID:<id>,	ErrorType:	-2147217900
      SQL:	EXEC RPM_GET_THEME_LIST 10, 1,N'And theme.[ThemeID] 34,48,49) ','theme.[ThemeID] DESC', '34','14','1159'
      Error:	Error in SetRS: EXEC RPM_GET_THEME_LIST 10, 1,N'And theme.[ThemeID] 34,48,49) ','theme.[ThemeID] DESC', '34','14','1159' Error=(Incorrect syntax near '34'.)
      Page:	https://instance.jiraalign.com:443/ThemeGrid.asp?FirstTime=True
      Date:	2021-03-16 11:28:35
      User:	<userId> <user's name> 

      Workaround

      • In the Configuration bar, remove STRATEGIC SNAPSHOT from Advanced Configurations (cog icon), then apply settings.

            Assignee:
            Jessica Wolfe (Inactive)
            Reporter:
            Rodrigo Cortez
            Votes:
            2 Vote for this issue
            Watchers:
            9 Start watching this issue

              Created:
              Updated:
              Resolved: