Unable to access OpenAPI query builder

Document ID : KB000101551
Last Modified Date : 14/06/2018
Show Technical Document Details
Issue:
We are unable to access the OpenAPI query builder in this instance of PM 3.5. When you try to load the page, you get redirected to the SSO sign-in and that page is giving an HTTP 500 error.
It is only when doing the query builder that this happens, though - the normal sign-in to CAPC works fine.
Environment:
capm 3.x
Cause:
In this environment, port 8581 is blocked by the firewall, and port 80 is being used.
the firewall then redirects the request to port 8581.

The code we use to create the url for the metadata used in the odata api requires port 8581 to be in the address.
Without it, the url defaults to a dev environment.
Resolution:
open port 8581 on the firewall.
or
use ssh tunnels to bypass the firewall.