Uploaded image for project: 'Jira Align'
  1. Jira Align
  2. JIRAALIGN-3334

Error on Server when non-Super Admin expands Objectives/Themes/Epics Section of a Program Increment

XMLWordPrintable

    • 4
    • Severity 2 - Major
    • No

      Issue Summary

      When a non-Super Admin expands the themes/epics section of a program increment, "Error on Server" is returned. Also, the count of items present on the message "There are x Items assigned to the Programs you don't have access to." seems to be off by +1, as it doesn't match the number present on the section header.

      Steps to Reproduce

      1. Login to JA as a super admin.
      2. Navigate to program increments.
      3. Click on any of them to open slide out and expand objectives/themes/epics. The data is displayed when we expand.
      4. Log out and login as a non-Super admin.
      5. Follow the same steps. When you expand objectives/themes/epics, "Error on Server" is returned.

       

      Note: This works fine when a Super Admin impersonates a non-Super Admin.

      Expected Results

      Objectives/Themes/Epics expands and displays data associated with the Program Increment.

      Actual Results

      Error on Server is returned on UI.

      The below exception is thrown in splunk:

      6/16/21
      3:36:51.114 PM	
      { [-]
         Exception: System.Data.SqlClient.SqlException (0x80131904): The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP, OFFSET or FOR XML is also specified.
         at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
         at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
         at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
         at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
         at System.Data.SqlClient.SqlDataReader.get_MetaData()
         at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
         at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
         at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
         at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
         at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
         at Dapper.SqlMapper.ExecuteReaderWithFlagsFallback(IDbCommand cmd, Boolean wasClosed, CommandBehavior behavior)
         at Dapper.SqlMapper.<QueryImpl>d__138`1.MoveNext()
         at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
         at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
         at Dapper.SqlMapper.Query[T](IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Boolean buffered, Nullable`1 commandTimeout, Nullable`1 commandType)
         at AgileCraft.DataAccess.UnitOfWork.FromSql[TEntity](String sql, Object parameters, IDbTransaction transaction, CommandType type)
         at AgileCraft.Services.ReleaseSlideoutService.GetCount(String sql, Object parameters)
         at Website.Api.Controllers.ReleaseSlideoutController.<EpicsCount>d__7.MoveNext() in C:\projects\awesomesauce-mlaxn\AgileCraft\WebsiteSLN\Website\Api\Controllers\ReleaseSlideoutController.cs:line 58
      --- End of stack trace from previous location where exception was thrown ---
         at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
         at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
         at System.Threading.Tasks.TaskHelpersExtensions.<CastToObject>d__1`1.MoveNext()
      --- End of stack trace from previous location where exception was thrown ---
         at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
         at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
         at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__1.MoveNext()
      --- End of stack trace from previous location where exception was thrown ---
         at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
         at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
         at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__5.MoveNext()
      --- End of stack trace from previous location where exception was thrown ---
         at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
         at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
         at System.Web.Http.Filters.AuthorizationFilterAttribute.<ExecuteAuthorizationFilterAsyncCore>d__3.MoveNext()
      --- End of stack trace from previous location where exception was thrown ---
         at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
         at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
         at AgileCraft.Api.Security.AddChallengeOnUnauthorizedResult.<ExecuteAsync>d__9.MoveNext() in C:\projects\awesomesauce-mlaxn\AgileCraft\WebsiteSLN\Website\Api\Security\AddChallengeOnUnauthorizedResult.cs:line 25
      --- End of stack trace from previous location where exception was thrown ---
         at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
         at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
         at System.Web.Http.Controllers.AuthenticationFilterResult.<ExecuteAsync>d__5.MoveNext()
      --- End of stack trace from previous location where exception was thrown ---
         at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
         at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
         at System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__6.MoveNext()
      ClientConnectionId:9f34e167-0263-4896-afc3-aaef3377b023
      Error Number:1033,State:1,Class:15
         Level: Fatal
         MessageTemplate: API
         Properties: { [-]
           HttpRequestId: ba22e836-2555-4066-b632-71b7574290bd
           HttpRequestRawUrl: /api/ReleaseSlideout/115/Epics/Count
           HttpRequestType: GET
           HttpRequestUrl: https://instance.jiraalign.com/api/ReleaseSlideout/115/Epics/Count
           Path: https://instance.jiraalign.com/api/ReleaseSlideout/115/Epics/Count
           UserName: 6172
           customer_db: instance
           logfrom_location: Website-ASPNET
           server: PR-US-02-WEB-Q4
           version: 10.95.0.17604
         }
         RenderedMessage: API
         Timestamp: 2021-06-16T11:36:51.1141675-04:00
      }
      

      Workaround

      Currently there is no known workaround for this behavior. A workaround will be added here when available

            dfuller@atlassian.com Don Fuller
            2dd0052fba6f Sudeep Bale Ramakrishnappa (Inactive)
            Votes:
            6 Vote for this issue
            Watchers:
            9 Start watching this issue

              Created:
              Updated:
              Resolved: