Details
-
Bug
-
Resolution: Fixed
-
High
-
10.78
-
None
-
1
-
Severity 2 - Major
-
Batman! - Usher1
Description
Issue Summary
When attempting to load the Forecast Page, only a small number of Epics loads before the customer is presented with an error
Page loads with 4 PB's and It's erroring out "An error occurred on the server when processing the URL. Please contact the system administrator.
If you are the system administrator it's prompting to this link https://docs.microsoft.com/en-us/iis/application-frameworks/running-classic-asp-applications-on-iis-7-and-iis-8/classic-asp-not-installed-by-default-on-iis. It says classic ASP not installed
Sample screenshot:
Steps to Reproduce
1) Navigate to Forecast
2) Set Program and one PI in Tier 1.
3) Select view by Epic and View type Agile by Program
4) Expand the list
Expected Results
Page should load with results
Actual Results
Page only loads a small number of Epics and the error quoted above is seen.
Corresponding Splunk log entries show timeouts and warnings regarding the amount of time it takes to run stored procedures:
2020-09-24 19:05:45 172.28.15.52 POST /Forecast/ajax/ForecastSortReleaseTable ReleaseID=15&ViewBy=1&ViewType=1|881|800a01c9|This_key_is_already_associated_with_an_element_of_this_collection 443 13347 172.28.170.193 Mozilla/5.0+(Windows+NT+10.0;+Win64;+x64)+AppleWebKit/537.36+(KHTML,+like+Gecko)+Chrome/85.0.4183.121+Safari/537.36 https://xxxxxxx.agilecraft.com/ForecastMainPage?FirstTime=True&ReportType=FitView&stfilter=true&Programs=11&Releases=15 500 0 0 12699
Sql query warnings. For this particular occurrence, the query is almost 11 seconds long
9/24/20
2:05:45.317 PM
{ [-]
ASP_function: OOFunctionsSql.LogToSqlTiming
correlationid: 0nHuoarnsq3DivObqBqWJVL3b0p+8NEtaIRx4yuButY=
customer_db: XXXXX
log_type: warning
logfrom_location: Website-ASP
sql: EXEC RPM_GET_FORECAST_MASS_UPD_REPORT ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
sqlCount: 75
sqlFunction: SetRSParams
sqlTime: 10879
timestamp: 2020-09-24T15:05:45.317000-04:00
url: https://xxxxxxx.agilecraft.com:443/Forecast/ajax/ForecastSortReleaseTable.asp?ReleaseID=15&ViewBy=1&ViewType=1
urlverb: POST
user: 13347
version: 10.78.0.8457
}
We are seeing Timeouts as well:
9/24/20
2:03:48.451 PM
{ [-]
ASP_function: OOFunctionsSql.SetRSParamsCursor
correlationid: liUpv0Ep6iOBKY04BbdkdRMHMai9K4I8jwOzRZVBXtU=
customer_db: xxxxxx
error_description: Query timeout expired
error_id: 18034
error_number: -2147217871
error_source: Microsoft SQL Server Native Client 11.0
log_type: exception
logfrom_location: Website-ASP
sql: EXEC RPM_GET_FORECAST_MASS_UPD_REPORT ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
timestamp: 2020-09-24T15:03:48.451000-04:00
url: https://xxxxxxxx.agilecraft.com:443/Forecast/ajax/ForecastSortReleaseTable.asp?ReleaseID=15&ViewBy=1&ViewType=1
urlverb: POST
user: 6
version: 10.78.0.8457
}
Workaround
Currently there is no known workaround for this behavior. A workaround will be added here when available
Attachments
Issue Links
- resolves
-
ALIGNSP-6118 Loading...