Gateway Time-out 504 while export the CSV Reports

[williamrobert1983]

Hi all,

I am getting Gateway Time-out 504 error when i am trying to export CSV using OTRS Search option.

If i export more then 1000 tickets , i am getting the gateway error. how to resolve the issue?

Do i change any configuration in admin as well as apache? please advice me.

OTRS is running Linux Server with apache.

Thanks,
William

[swilliamrobert1982]

Any one advice please about this issue

[tto]

Any one advice please about this issue

use the command line (otrs.GenerateStats.pl) in order to get your report. It looks like your report just takes too long and the webserver cancels the request. Reconfiguring your apache won't solve the problem.

regards, T.

[swilliamrobert1982]

Hi Thanks for your reply. How can we use for front end csv export instead of using command line. Because, all customers using Search option to get csv reports.

[tto]

Hi Thanks for your reply. How can we use for front end csv export instead of using command line. Because, all customers using Search option to get csv reports.

Your customers use the reporting tool? That's not quite default. Customer users usually do not have access to the agent frontend (where the reporting is). However, the ticket search should be more restricted and not like a "*"-search. The only option you have is to increase the apache-/webserver time out for requests. That might help, but the problem is going to reoccur. You should rethink your reporting approach. There's no way around it.

regards, T.

[swilliamrobert1982]

Hi thanks. actually not a customers. Agents. anyway thanks for reply.

[reneeb]

Once upon a time (;-)) I wrote an extension for a customer that allows the customer to start a report via Agent interface, but the result was emailed to him/her. This was done by running a background process that was decoupled from the webserver... You could do something similar too.