Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

InternalServerException: java.io.IOException: Broken pipe

alexmayconNov 17 2021 — edited Nov 17 2021

Hello!
I'm having the error accessing a resource that returns a media resource (json):
17-Nov-2021 18:03:16.019 SEVERE [http-nio-8080-exec-22] org.apache.catalina.core.StandardWrapperValve.invoke Servlet.service() for servlet [HttpEndPoint] in context with path [/ords] threw exception [InternalServerException [statusCode=500, logLevel=SEVERE, reasons=[An unexpected error with the following message occurred: InternalServerException [statusCode=500, logLevel=SEVERE, reasons=[]]]]] with root cause java.io.IOException: Broken pipe [...]
The full log is on file "ords-log.txt".
ords-log.txt (12.69 KB)image.pngThe query is:
image.pngOn SQL Developer the query run without errors.
ORDS Version: 21.2.4.r2431032
Apex Version: 21.2
Note: the answer is coming null with http code 200, when it should return a json.

This post has been answered by alexmaycon on Nov 17 2021
Jump to Answer
Comments
Post Details
Added on Nov 17 2021
1 comment
1,767 views