Troubleshooting: reviewing ORDS connections, your application server, and response times

Symptom/Issue In an internal Slack thread today, a user was trying to diagnose browser latency while attempting to connect to the ORDS landing page. Peter suggested what I thought was a pretty neat heuristic for checking connections to ORDS and your database, as well as latency. Methodology Let’s say your symptoms are either slow loading … Read more

401 Unauthorized invalid_token – troubleshooting Oracle Cloud IAM JWTs with ORDS

Symptoms You are able to request an access token from OCI IAM. Yet, when you issue the subsequent request to your target resource (an ORDS endpoint), you receive the following message (error=”invalid_token”):  Actions you’ve taken YET…you still receive this error=”invalid_token” message, it is quite possible that you have not made the JWK URL publically accessible in … Read more

Example: an ORDS API that returns a user-configured JSON object

This actually came about from a Support Request. We were troubleshooting a JWT issue, that had ORDS in the mix. Ultimately, this is looking more and more like a networking issue (maybe something to do with routing rules between the load balancer and the backend server). But in the course of our troubleshooting, we wanted … Read more

503 Service Unavailable: ORDS unable to make a connection…all connections in the Univeral connection Pool are in use – [30,30,42….]

Have you ever seen this? Have you ever seen a message like this while working with ORDS? The one where you receive a 503 Service Unavailable response code and message? This message has something to do with ORDS being unable to make a connection to the database. But if you keep reading, you’ll see even … Read more

ORDS as a JotForm webhook: An actual customer use case

Recently, we (one of our Support engineers and I) worked with a customer who had integrated various ORDS POST APIs with a web-based form application called JotForm. JotForm offers integrations for numerous workflows, some official and others you can create independently. That’s where we come in. In this example, a user would enter information into … Read more

ORDS WARNING Cannot find the real static path of

Problem description You’ve just upgraded ORDS and issued the ords serve command. As ORDS is starting up, you see the following warning (or something like it): How to fix Easy! In this case, I removed the standalone.static.path property of the ORDS Global configuration settings. WAIT JUST A MINUTE! This approach was successful because I determined … Read more

An ORDS GET request to retrieve CGI Environment variables from the PRINT_CGI_ENV PL/SQL procedure

ALERT: This is going to seem extremely out of context! But this post actually loosely relates to the ORDS Pre-hook functions section of our docs. I’m in the process of (1) working on a presentation and (2) updating this section of the docs as well (productivity trifecta for the win!), hence why we are here. … Read more

ORDS Standalone: specifying a response header with jetty.xml

NOTE: This article shows how to include a jetty.xml file in your ORDS Standalone deployment, so a user-defined response header is provided with each HTTP response. I’m also requesting that all or some of what you see below make it into our docs. The following article picks up from where this one left off. NOTE: … Read more

ORDS Standalone access logs: Jetty and customizing with XML

Did you know that you can very quickly and easily enable access logging when you are running ORDS in standalone mode (i.e., when using the embedded Jetty server)? FYI: This article is an excerpt from a living document I’ve been working on dedicated to ORDS installation, configuration, and usage (from the development/developer’s perspective). And in … Read more

ORDS Configuration options: about HTTP error responses

Reading docs can be hard We send you poor folks to our documentation, and sometimes, it’s a section we haven’t reviewed in quite some time! I don’t think this is specific to any one organization. But over the years, details get lost, forgotten, or stored in an obscure guide section, only to be reviewed once … Read more