We are trying to publish a simple map service using enterprise geodatabase in ArcGIS Server 10.6.1 (in a federated environment) and getting Error 001487. 1st time the publishing was successful and data was copied in the server. From next time onward it is failing. ArcGIS service account has full access in arcgissystem/arcgisinput.
The issue is occurring with particular one geodatabase.
Some more troubleshooting steps:
In Geoprocessing > Results > Current Session > Upload Service Definition > Messages it is Error-001487 and error001369.
We tried server connectiona nd db connection but no luck
Publishing Tool is fine
When I copied feature layer in FDGB and tried to publish it is giving error when I am trying to register the layer's data source in server
What if you simply copy the feature class from the FGDB to the server, instead of attempting to reference it?
If you are able to copy data to the server, I suspect something is up with the PublishingToolsEx service. Can you verify that this service is running? This service is hidden from Server Manager and the only way to check it's status is through the Server Admin endpoint.
I can publish from other database. Only one particular database is giving trouble. It worked for first time when I opted for not to register data source and let the data copied in the server. After that it started failing.
Our client was facing the issue before I tried.
I assume you are using Oracle DBMS.
The account you are using for the database connection on the map service is the schema owner?
If not, try to use the schema owner for testing purposes.