report generation timeout



Infrastructure & Operations
Infrastructure: Tools
3 years ago
3 years ago


(Reporter: adamm, Unassigned)




When attempting to generate a report from the inventory database using the available options of screen or csv output, the query/script is timed out by the webserver. 

The user's browser reports: 

"Service Unavailable

The service is temporarily unavailable. Please try again later."

Is there something wrong with the server/app, or does the max query time setting just need to be lengthened?


3 years ago
Assignee: nobody → infra
Component: WebOps: Inventory → Infrastructure: Tools
QA Contact: smani → rtucker
Basically depending on the queries entered, they can get extremely resource intensive.
I can pretty easily generate more complicated reports by hand though.

My suggestion is we won'tfix this as inventory is set to be deprecated and I can generate a report for you by hand.

/cc cshields for his comment

Comment 2

3 years ago
Rob, can you please generate a list of all production systems in Inventory?
Can you be specific about the fields you need in the report please?

Comment 4

3 years ago
Just hostname and allocated to, please.
(In reply to Adam Muntner :adamm from comment #4)
> Just hostname and allocated to, please.

I've sent you a report. It has a few extra columns, but you should be able to easily disregard.
I haven't heard any complaints about the report I sent. 
going to close this out
Last Resolved: 3 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.