ERROR

The connection property set was missing a required property or the property value was unrecognized. Bad login user. ArcGIS Datastore validation fails after upgrade

Last Published: December 30, 2020

Error Message

After validating ArcGIS Data Store, an exclamation mark appears and, the following error is returned in the ArcGIS Server logs:

Error:   
The connection property set was missing a required property or the property value was unrecognized. Bad Log in user Datastore validation Fails after upgrade to 10.x.
On ArcGIS Data Store, the following error is returned: 
Error:   
Type=warning, code =”110787” source “Data Store” process = “21232” thread = “1” methodName = “” machine “x" user= “” elapse = “” requestID = “” > Failed to create index on ‘{0}’ org.postgres.util.PSQLException: FATAL : no pg_hba.config entry for host “127.0.0.1”, user “hsu_tf4q2”, database “db_46pwc”, SSL off </msge> 

Cause

ArcGIS Server is configured using a domain name service (DNS) name instead of a fully qualified domain name (FQDN). Refer to ArcGIS Enterprise: Domain name service and fully qualified domain name requirements for more information.

Solution or Workaround

Retry the ArcGIS Data Store connection on all machines using a fully qualified domain name (FQDN). Follow these steps to do this:
  1. Unregister the data store. On the machine, run the Windows Command Prompt as an administrator.
  2. Navigate to the ArcGIS Data Store utilities folder using the following command:
cd Program Files\ArcGIS\DataStore\tools
  1. Run the 'unregisterdatastore' command utility to unregister the relational data store using the following command:
 unregisterdatastore.bat –stores relational –prompt yes
  1. Navigate to the Data Store Configuration Wizard for the primary ArcGIS Server machine, and re-register the primary Data Store using the fully qualified domain name of the machine. The following is a sample of a fully qualified domain name URL:
<portal>.<domain>.com
  1. After changing the domain name, validate ArcGIS Data Store. Refer to How To: Validate ArcGIS Data Store for steps to do this.

Article ID:000022992

Software:
  • ArcGIS Server

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Related Information

Discover more on this topic