Unable to add a database connection as a data store item to Portal for ArcGIS

Description

Starting with Portal for ArcGIS 10.7.1, data sources can be added as a data store item to Portal for ArcGIS, allowing it to be shared with any of Portal's federated servers.

In some cases, adding a database connection as an item fails, freezing the software during the import process.

If Portal does not have a designated hosting server, this process fails within the Portal GUI. Opening Developer Tools in a web browser displays the following JavaScript error:

Error:   
Uncaught TypeError: Cannot read property 'adminUrl' of undefined
at Object._uploadConnectionFile (content.js:3415)
at Object._processConnectionFile (content.js:3412)

Cause

Portal for ArcGIS does not have a designated hosting server.

Solution or Workaround

Designate a hosting server for Portal for ArcGIS. Refer to Specify the hosting server for steps to do this.

Note:
Alternatively, register the database connection as a data store in ArcGIS Server, and use the Federate Data Item admin API to add this data store as a data store item in Portal.