I reinstalled a Relational Data Store for a Base Enterprise 10.5.1 deployment and Portal does not appear to be able to find the registered Managed Database. When loading a Portal page, it attempts to query ArcGIS Server for a list of managed databases via the Portal proxy page ( /sharing/proxy) but the proxy is giving an HTTP 500 error. Trying to load the proxy page directly in a browse shows a 403 tomcat error page. Stripping the proxy and attempting to query the ArcGIS Server REST endpoint directly returns the expected result Looking for any suggestion on resolving this problem.

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Portal proxy gives a 500 error when trying to list Relational Data Stores from GIS Server

LucasScharenbroich

I reinstalled a Relational Data Store for a Base Enterprise 10.5.1 deployment and Portal does not appear to be able to find the registered Managed Database. When loading a Portal page, it attempts to query ArcGIS Server for a list of managed databases via the Portal proxy page (<webadapter>/sharing/proxy) but the proxy is giving an HTTP 500 error.

Trying to load the proxy page directly in a browse shows a 403 tomcat error page.

Stripping the proxy and attempting to query the ArcGIS Server REST endpoint directly returns the expected result

Looking for any suggestion on resolving this problem.

Find more posts tagged with

Accepted answers

JonathanQuinn

If you're using a wildcard certificate from a domain signing authority, you need to configure Portal to trust the root domain certificate:

Configuring the portal to trust certificates from your certifying authority—Portal for ArcGIS (10.5.x) | ArcGIS Enterp…

The problem is that Portal will attempt to validate *.domain.com against the host of the services URL, services.domain.com. Since it doesn't match exactly, it checks the domain certificate. Since it doesn't trust the root certificate, the request fails. Once you import the root certificate into Portal, then you shouldn't have a problem.

All comments

JonathanQuinn

What version is this? Do you see any errors in the portal logs? You won't be able to load the proxy page in a browser yourself as it expects certain headers which are sent by Portal itself, but not by your browser when opening the full URL manually.

LucasScharenbroich

This is running 10.5.1. The errors in the log file say that the SSL certificate could not be validated, but unclear what the exact issues is. We have the same wildcard certificate installed on Portal, Server, the Data Store and the Web Adaptors.

Error. sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target.

It seems the way to fix this is to get the right certificates into the underlying Java keystore. Not too keen on doing this manually if there's a process that I can execute at the portal level to make this work.

Would un-federating and re-federating the ArcGIS Server be a way forward here? This is a test environment, so there are not too many services that would need to be re-shared.

JonathanQuinn

If you're using a wildcard certificate from a domain signing authority, you need to configure Portal to trust the root domain certificate:

Configuring the portal to trust certificates from your certifying authority—Portal for ArcGIS (10.5.x) | ArcGIS Enterp…

LucasScharenbroich

Bingo!

We had a GoDaddy intermediate bundle for IIS in p7b format that Portal was unable to import. I retrieved the .crt intermediate certificate bundle from the GoDaddy certificate Repository and was able to import that successfully.

Trust is working as expected now and Portal is showing "Feature Layer" and "Tile Layer" as item options under the "Create" drop-down menu in the My Content page as expected.

Many Thanks!

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.