topic Re: Publish scene fails - ERROR 001887: Failed to create couchdb database: Failed to execute (Publish Portal Sevice) in 3D Questions

Publish scene fails - ERROR 001887: Failed to create couchdb database: Failed to execute (Publish Portal Sevice)

Harald_ØysteinLund1 — Mon, 07 Jan 2019 11:19:27 GMT

When we try to publish a 3D scene with ArcGIS Portal 10.6, we are getting the following error:

ERROR 001887: Failed to create couchdb database: Failed to execute (Publish Portal Sevice).

We are using SSL and have tried all of the suggested approaches to handle SSL between ArcGIS Server Host machine and DataStore machine.

1. Adding requesting URLs to trusted sites - not working

2. Enabling SSLv3 - not working

3. Also made sure that writing request also uses SSL. - not working

Turning of SSL is not an option.

Upgrading to 10.6.1 is not an option at this point.

Is there any one else struggling with this out there?

Re: Publish scene fails - ERROR 001887: Failed to create couchdb database: Failed to execute (Publish Portal Sevice)

RussRoberts — Mon, 07 Jan 2019 14:24:03 GMT

If you have disabled SSLv3 and you are still seeing this issue.

look at your Internet Explorer privacy settings. If security level is medium / high it prevent it. To resolve this issue:

Stop Server
On the Server machine open Internet Explorer (ensure you login as the server account before opening IE or use Run As different user and log into IE using server account. This is important)
In IE Options dialog go to Security tab and select Trusted Sites
In the Trusted Sites dialog uncheck Require server verification (https) option
Enter server and data store machine http and https URLs as shown below:
http://<subdomain.domain.com> and
https://<subdomain.douman.com>
Add similar URLs for the datastore machine (if installed on a different machine)
Once done re-start server.

Re: Publish scene fails - ERROR 001887: Failed to create couchdb database: Failed to execute (Publish Portal Sevice)

Harald_ØysteinLund1 — Mon, 07 Jan 2019 14:57:39 GMT

Yes we have tried this, but meanwhile we have seen that we forgot to run the updatelicense command. After doing so and now got a bit further, but there is a problem with primary/standby issue here. ERROR 001886: Failed to create scene service. ERROR: code 500. This operation must be performed on the primary data store machine. Not allowed on the standby machine. Generic Server Error. Internal server error. Failed to execute (Publish Portal Service).

Oddly everything seems correct set up, but the tilecache datastore and the spatial datastore has different primary machines. It fails when we try to set the same server as primary for both of them, but that fails as well. May be because of the operation may have been interrupted.

After a changing allowed inbound ip to communicate with the two Datastore serveres, missing the ip of each of the datastore servers was the reason for the problem with setting primary/standby of the datastore. So main reason, missing update of license and then the security tightening that was done, had forgot to allow internal communication between the two datastore servers on the datastore port.