Loading...

XML

Word

Printable

Type: Bug
Resolution: Fixed
Priority: Medium
Fix Version/s: 10.114.0
Affects Version/s: 10.105.3
Component/s: Import|Export
Labels:
- bulldog

Support reference count:
6
Symptom Severity:
Severity 2 - Major
Does fix include system behavior or UI changes?:
No

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
}