Details
-
Bug
-
Resolution: Fixed
-
Medium
-
10.105.3
-
6
-
Severity 2 - Major
-
No
Description
Issue Summary
We have a potential performance issue with work item imports
Customer experiences a 500 error "Query_timeout_expired" when importing work items. (They also experience "Script_timed_out" and"500_Server_Error" )
These example files are under 4Mb and less than 1000 items.
File 5 <- 500 items, 3.9MB
File 1 <- 60 items, 0.5MB
This is a source of large frustration for this customer, and they have been logging tickets about this issue since July 2020
Steps to Reproduce
It may be necessary to engage with the customer to do the import, as it's not possible to replicate on a test instance.
- Go to Features (requestgrid.asp)
- Click on More Actions
- Click on Import Features
- Browse and choose a file (I can supply)
- Click on Import Items
Expected Results
A correctly formatted file is imported successfully
Actual Results
User experiences "spinning wheel" and 500 Internal Server Error
"Query_timeout_expired" is seen in the Splunk logs.
Exception Procedure that appears to be the cause is : EXEC RPM_IMPORT_FEATURE_DETAILS
The below exception is thrown in the ASP log files:
{ [-]
ASP_function: OOFunctionsSql.LogToSqlTiming
correlationid: w8oNpc3lCHiXl9Ol8ZqLUCr6gecqtin/Bmk01O45IOM=
customer_db: Adpgpt
log_type: warning
logfrom_location: Website-ASP
sql: EXEC RPM_IMPORT_FEATURE_DETAILS ?
sqlCount: 0
sqlFunction: dbexecParamsConnectionTiming
sqlTime: 10490
timestamp: 2022-02-24T21:16:34.851000-05:00
url: https://xxx.jiraalign.com:443/ImportObjects.asp
urlverb: POST
user: xx
version: 10.105.2.23048
}
{ [-]
ASP_function: Error.asp
ErrorId: 23766
PageName: Import
correlationid: UbCUcdCXwoSQgkSwBXJn+KUXSr/pekJyBewIZ98zeyI=
customer_db: xxx
error_aspcode:
error_aspdescription:
error_category: Microsoft SQL Server Native Client 11.0
error_column: -1
error_description: Query timeout expired
error_file: /OOFunctionsSql.asp
error_line: 289
error_number: -2147217871
error_source:
log_type: exception
logfrom_location: Website-ASP
timestamp: 2022-02-24T21:18:46.601000-05:00
url: https://xxx.jiraalign.com:443/ImportObjects.asp
urlverb: POST
user: xx
version: 10.105.2.23048
}
and here
{ [-]
ASP_function: Error.asp
ErrorId: 23767
PageName: Import
correlationid: eCoTZZrOuD+EaaEcS/JI85G1TxS3mM7pf/ccHLTqzCM=
customer_db: xxx
error_aspcode: ASP 0113
error_aspdescription: The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools.
error_category: Active Server Pages
error_column: -1
error_description: Script timed out
error_file: /ImportObjects.asp
error_line: 0
error_number: -2147467259
error_source:
log_type: exception
logfrom_location: Website-ASP
timestamp: 2022-02-24T21:29:34.492000-05:00
url: https://xxx.jiraalign.com:443/ImportObjects.asp
urlverb: POST
user: xx
version: 10.105.2.23048
}
Workaround
Files of a VERY small size can SOMETIMES be imported successfully.
Attachments
Issue Links
- relates to
-
-
- Closed
-
-
-
- Closed
-
-
JIRAALIGN-1469 [JIRAALIGN-1469] Unable to import work items
- Future Consideration
-
ALIGNSP-6001 Loading...
-
-
-
-
-
-
-
-
-
-
-
- resolves
-