Home » Developer & Programmer » Reports & Discoverer » Error 500--Internal Server Error while running oracle Reports to print the pdf in 11g R2[11.1.2.2.0] (Linux,11gR2 11.1.2.2.0 oracle forms and reports)
Error 500--Internal Server Error while running oracle Reports to print the pdf in 11g R2[11.1.2.2.0] [message #666272] Wed, 25 October 2017 04:10 Go to next message
Beginner_ora
Messages: 11
Registered: February 2017
Junior Member
Hi Friends,

Iam getting following error on browser while running some Reports to generate pdf:

Error 500--Internal Server Error
From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1:
10.5.1 500 Internal Server Error
The server encountered an unexpected condition which prevented it from fulfilling the request.

Environment:
Oracle Linux 6.5
FMW forms and reports 11gR2 11.1.2.2.0
Weblogic 10.3.6
standalone

The above error is coming while running particular reports.same reports work fine sometimes and sometimes end up with the error
Same reports are working fine after few attempts(to be precise this error occurs rare initially and reaches to the point where it happens frequently untill I restart the report server.)

some times the job fails with the error [The report terminated with the error:null]

along this post I have attached the screen shot of the error which I can see after getting the report job failed

what should i do exactly?
can please anyone assist me for the same to solve the issue ?

[Updated on: Wed, 25 October 2017 04:13]

Report message to a moderator

Re: Error 500--Internal Server Error while running oracle Reports to print the pdf in 11g R2[11.1.2.2.0] [message #666281 is a reply to message #666272] Wed, 25 October 2017 07:22 Go to previous messageGo to next message
John Watson
Messages: 7150
Registered: January 2010
Location: Global Village
Senior Member
I don't see an http-500 error, I see an ORA-06503. You need to debug your code, it looks as though your function has branches that let it skip the RETURN statement. For example,
orclx> create function f1 return number as begin
  2  null;
  3  end;
  4  /

Function created.

orclx> select f1 from dual;
select f1 from dual
       *
ERROR at line 1:
ORA-06503: PL/SQL: Function returned without value
ORA-06512: at "SCOTT.F1", line 2


orclx>
Re: Error 500--Internal Server Error while running oracle Reports to print the pdf in 11g R2[11.1.2.2.0] [message #666284 is a reply to message #666281] Wed, 25 October 2017 07:44 Go to previous messageGo to next message
Beginner_ora
Messages: 11
Registered: February 2017
Junior Member
Thank-you john but I also encounter Error 500-internal server error in my browser . can you please shed some light over it
Re: Error 500--Internal Server Error while running oracle Reports to print the pdf in 11g R2[11.1.2.2.0] [message #666286 is a reply to message #666284] Wed, 25 October 2017 07:50 Go to previous messageGo to next message
John Watson
Messages: 7150
Registered: January 2010
Location: Global Village
Senior Member
No, I can't. Because (a) you have not shown the error and (b) you need to debug your code. Has it not occurred to you that the bug may be causing the 500?
Re: Error 500--Internal Server Error while running oracle Reports to print the pdf in 11g R2[11.1.2.2.0] [message #666289 is a reply to message #666286] Wed, 25 October 2017 07:59 Go to previous messageGo to next message
Littlefoot
Messages: 21239
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Attached image (by the way, why did you post vast blindness with a tiny useful information?) also suggests that some select didn't return any value (ORA-01403 - no-data-found).

First try to fix those errors. Maybe - as John suggested - fixing them will fix your 500 error.
Re: Error 500--Internal Server Error while running oracle Reports to print the pdf in 11g R2[11.1.2.2.0] [message #666290 is a reply to message #666286] Wed, 25 October 2017 08:17 Go to previous messageGo to next message
Beginner_ora
Messages: 11
Registered: February 2017
Junior Member
Error 500--Internal Server Error
From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1:
10.5.1 500 Internal Server Error
The server encountered an unexpected condition which prevented it from fulfilling the request.

This above error on browser we are facing.

I dont think it may be a bug. or may be. lets c after some work arround.
Re: Error 500--Internal Server Error while running oracle Reports to print the pdf in 11g R2[11.1.2.2.0] [message #666291 is a reply to message #666289] Wed, 25 October 2017 08:18 Go to previous messageGo to next message
Beginner_ora
Messages: 11
Registered: February 2017
Junior Member
Thank-you LittleFoot.


I understand that this ORA-16503 error may be the cause of that issue.
Re: Error 500--Internal Server Error while running oracle Reports to print the pdf in 11g R2[11.1.2.2.0] [message #666292 is a reply to message #666286] Wed, 25 October 2017 08:22 Go to previous messageGo to next message
Beginner_ora
Messages: 11
Registered: February 2017
Junior Member
Dear John,,

Also .

The report server terminated with error: null
Re: Error 500--Internal Server Error while running oracle Reports to print the pdf in 11g R2[11.1.2.2.0] [message #666332 is a reply to message #666292] Mon, 30 October 2017 07:12 Go to previous messageGo to next message
Beginner_ora
Messages: 11
Registered: February 2017
Junior Member
Hi john and LittleFoot,

the issue has been resolved since we have exported wrong .rdf file in one of our forms
Re: Error 500--Internal Server Error while running oracle Reports to print the pdf in 11g R2[11.1.2.2.0] [message #666341 is a reply to message #666332] Mon, 30 October 2017 08:29 Go to previous message
Littlefoot
Messages: 21239
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Sh*t happens.
Previous Topic: Report column running Total reset bill number wise
Next Topic: direct print to the printer
Goto Forum:
  


Current Time: Tue Nov 21 20:00:51 CST 2017

Total time taken to generate the page: 0.01301 seconds