Focal Point
HTTP 500 error while running a report in MRE from Developer Studio

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9751082892

September 05, 2008, 12:07 AM
Chirag
HTTP 500 error while running a report in MRE from Developer Studio
Hi,
I am getting following error while executing reports in Managed Reporting Environment.

An HTTP 500 error has been returned when attempting to communicate with the WebFOCUS web components. The application server log contains information on why this error has occurred. Contact your WebFOCUS Administrator or Information Builders Customer Support Services for further assistance.

I checked various many blogs for following error. I tried the suggested method. I deleted personal.xml file. But, it doesn't work out. Can somebody please suggest anything i can do to get it working.

Thanks,
Chirag


7.6.11
Linux
Excel, HTML, PDF

September 05, 2008, 04:56 AM
GamP
Try to locate the servlet log file. It may contain some more information about what is going on. If you're using tomcat, it is located in tomcat's program directory, subdir logs.
The error can be in any one of the files, most likely one is the stderr file.
If something like this happens to me, first thing I do is to stop tomcat, delete all files in the logs directory, restart tomcat and reproduce the problem. That way you will have a fresh set of files to work with.

Hope this helps ...


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
September 05, 2008, 05:04 AM
hammo1j
Have you tried HTTP 500 Help ?



Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2
Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
September 05, 2008, 06:03 AM
<JG>
Check the Tomcat log to see what errors you are getting.
September 05, 2008, 07:23 AM
Chirag
I have tried HTTP 500 help. I deleted personal.xml file and checked again. But with no luck.
JG, I am using Websphere application server and IHS server.

Thanks,
Chirag


7.6.11
Linux
Excel, HTML, PDF

September 05, 2008, 08:17 AM
hammo1j
You will have to give us the code and the servlet trace.

I assume you can successfully run the same code as applications from ds for instance.



Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2
Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
September 05, 2008, 11:30 AM
Darin Lee
For issues like this, I would open a case with Technical Support. That's what they are there for.


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
September 05, 2008, 11:45 AM
<JG>
Chirag,

You still need to look at the application server log because that is where the
error detail will give you a probable cause.

Look at the error message.

"The application server log contains information on why this error has occurred.""
September 05, 2008, 02:18 PM
Francis Mariani
This error occurs for many different reasons, usually a coding issue. I would use the process of elimination. If it's a long program with many HOLD files before the final report, I'd stick a -EXIT after the first END staement. The the program works, move the -EXIT to after the next END, until you arrive to the piece of code that generates the error. Simplify that piece of code, then keep adding the lines back until the error occurs - you may then see what the problem is. On the other hand, could it be a timeout issue, the program running too long?


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server