Lion Soft Inc.

Excel Reporting Solution Provider

  • Home
  • Products
    • Tools for Oracle Reports
      • Rep2excel
      • Rep2excel Server
      • RepExpert
    • EasyHA Monitoring Tools
    • GTD Excel Report Server
    • Command Line Send Email Component
  • Purchase
    • Rep2excel & Rep2excel Server
    • RepExpert
  • FAQ
    • Rep2excel & RepExpert
    • EasyHA
  • Blog
    • Excel Reporting
    • Monitoring
    • Rep2excel

About the TimeOut directive in Apache configuration file

September 10, 2015 williamsvoon Rep2excel

Rep2excel is tool that can convert oracle reports in to native Microsoft excel format. The Win32-Rep2excel support CGI interface, and then customer deploy it in cgi-bin folder of Apache server. The Rep2excel can be called by other computers via browser, and return the excel file.

HTTP 500 Error

Some customers report problem when Rep2excel converts large oracle report file. In the browser, the end users see the http 500 error page:

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, user@domain.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

The administrator of apache check the error log, it shows message similar to:

[Tue Sep 08 16:19:53 2015] [error] [client 172.27.67.113] Premature end of script headers: Rep2excel.exe, referer: http://server-name/cgi-bin/rep2excel.exe?job=getwebpage&pagename=index

Troubleshooting

 

First I suggest the users run Rep2excel by command line, and convert the same oracle report file. If the excel file is generated without error, and it takes more than 5 minutes to generate the excel file, you are better off configuring the TimeOut directive in httpd.conf of Apache server.

TimeOut Directive

Description:

Amount of time the server will wait for certain events before failing a request

Syntax:

TimeOut seconds

Default:

TimeOut 300

Context:

server config, virtual host

Status:

Core

Module:

core

The TimeOut directive defines the length of time Apache will wait for I/O in various circumstances:

  1. When reading data from the client, the length of time to wait for a TCP packet to arrive if the read buffer is empty.
  2. When writing data to the client, the length of time to wait for an acknowledgement of a packet if the send buffer is full.
  3. In mod_cgi, the length of time to wait for output from a CGI script.

Solutions

  1. Edit httpd.conf, the file is available in conf folder, for example: C:\Program Files\Apache Software Foundation\Apache2.2\conf
  2. Add timeout=1500 to httpd.conf under server or virtual host context. 1500 means 25 minutes, please increase it as per your needs.
  3. Save httpd.conf and restart Apache.

Other solution

 

The java edition of Rep2excel runs 5-10 times faster than Win32-Rep2excel. You can upgrade to java-Rep2excel in case your oracle report file is very large, or you want to save time.

 

The java-Rep2excel works on Windows, Linux and Unix.

Recent Posts

  • True Silent Printing PDF on Web based Application
  • Print report from your html page without ActiveX add-on
  • How to send email from command line through Gmail or hotmail account in windows
  • About the TimeOut directive in Apache configuration file
  • How to run java-rep2excel as Windows service

Archives

  • June 2016
  • May 2016
  • September 2015
  • August 2015
  • July 2015

Categories

  • Command Line Email
  • Excel Reporting
  • GTD Printing Tool
  • Monitoring
  • Rep2excel

Contact us

To contact our sales office regarding product/pricing inquiries, please send email to sales@lv2000.com.

You can also click the link below to send us message quickly.

Menu

  • Send us a message

Support

Feedback, questions and bug reports are welcome.
Customer support: support@lv2000.com.

Archives

  • June 2016
  • May 2016
  • September 2015
  • August 2015
  • July 2015

Categories

  • Command Line Email
  • Excel Reporting
  • GTD Printing Tool
  • Monitoring
  • Rep2excel

Recent Posts

  • True Silent Printing PDF on Web based Application June 23, 2016
  • Print report from your html page without ActiveX add-on May 27, 2016
© Lion Soft Inc.