Failed to import webgisdr site failed to update database

MohammedAbdul — Wed, 14 May 2025 14:18:47 GMT

Dears,

we have created WEBGISDR site from production with backup_restore_mode =backup,

now trying to import it in DR site(backup_restore_mode=backup) which has the same admin credentials,same arcgis enterprise version 11.1 and main site url ,services url is same in DR and PROD except admin urls internal loadbalancer urls.and content location is different

All arcgis servers are imported except portal Throws error "

InPortal(WEBGISDR log) : ” {"error":{"code":500,"details":null,"message":"Failed to import site. Failed to update the federated servers. Failed to update the database.."}}”

In log found:

Refresh service webhook processor http post response :{"status":"error","messages":["Server machine 'https://xyz:7443/arcgis/sharing/rest/community/self' returned an error. 'Invalid token.'"],"code":498}

Server request cannot be verified for account: 0123456789ABCDEF ,Request url: xyz:7443/arcgis/sharing/rest/community/self Server Id : UnCvLIT3D0Qy9giG , Serverkey recieved 'true'.

Unable to validate Server request using 'serverKey', Request mode 'https', ServerKey recieved fec8d016e00a4d0fbf637b4876b128e7, Server SecretKey determined f4ceac19ecb84fff96935cc92b761acd.

inPGSQL below error:

2025-05-04 10:15:04.426 PDT [1356] FATAL: no pg_hba.conf entry for host "::1", user "xyz", database "xyz", no encryption
2025-05-04 10:15:04.426 PDT [1356] DETAIL: Client IP address resolved to "PortalP2", forward lookup matches.
2025-05-04 10:15:31.757 PDT [1316] FATAL: no PostgreSQL user name specified in startup packet
2025-05-04 10:15:31.784 PDT [7940] FATAL: no PostgreSQL user name specified in startup packet
2025-05-04 10:15:36.034 PDT [9848] FATAL: no PostgreSQL user name specified in startup packet
2025-05-04 10:15:36.057 PDT [8908] FATAL: no PostgreSQL user name specified in startup packet

I Tried to modify file in pg_hba.conf file with line below but still same above error is thrown.

same service account is used for both PROD and DR site

# PostgreSQL Client Authentication Configuration File
# ===================================================

# TYPE DATABASE USER ADDRESS METHOD

# IPv4 local connections:
host all all 0.0.0.0/0 trust
host replication all 0.0.0.0/0 trust
#host all GISUNPAdmin 127.0.0.1/32 scram-sha-256
#host replication GISUNPAdmin 127.0.0.1/32 scram-sha-256
# IPv6 local connections:
host all all ::1/0 trust
host replication all ::1/0 trust
#host all GISUNPAdmin ::1/128 scram-sha-256
#host replication GISUNPAdmin ::1/128 scram-sha-256

05.14.25 Update:

The post is now resolved

Solution:

Two steps were performed

1.unregister Standby portal server

2.Change content directory Location from NAS Storage to Primary portal server C Drive default location

Then run the Import WEGGISDR tool,it successfully imported Prod Portal and federated servers.

Once import is done then I copied the content to nas storage and then joined the standby portal server .

IT Worked greatly.

Re: Failed to import webgisdr site failed to update database

LavanyaVasudevanNES — Tue, 06 May 2025 23:57:54 GMT

Just a thought: Are you using the same service account and does the service account have access to all the folders where the three components are stored?

topic Re: Failed to import webgisdr site failed to update database in ArcGIS Enterprise Questions

Failed to import webgisdr site failed to update database

Re: Failed to import webgisdr site failed to update database