topic Re: Suddenly Can't Publish Feature Services? v10.3 in ArcGIS Enterprise Questions

Suddenly Can't Publish Feature Services? v10.3

Anonymous User — Thu, 06 Aug 2015 23:02:25 GMT

I just tried to publish a feature service, and I get two errors:

First, in Desktop, I get this error:

"Packaging succeeded, but publishing failed. ERROR 001369: Failed to create the service. Please consult the GP Results Window for enhanced error description or contact your administrator for the server logs." (no useful info in GP results window)

Then, I log into Server Manager, and the service is there, but is stopped. I try to start it, and get these errors:

Error executing tool.: ERROR 001369: Failed to create the service. Failed to execute (Publish Service Definition).

Failed to create the service.: ERROR: Service failed to start, Internal server error.

Core server call to create service failed.

Initialization failed.

The Layer:'LayerName' in Map:'Dataframe' is invalid. The base table definition string "tablename" is invalid. Failure to access the DBMS server.

I can publish the same data as a simple Mapping-only service successfully. To my knowledge, nothing about the permissions on the server have changed.

Any idea how to start troubleshooting? Also note: everything is configured appropriately for the feature service capabilities, there are no errors on analysis, etc.

Thanks!

SQL Server 2008 R2/AGS 10.3

Re: Suddenly Can't Publish Feature Services? v10.3

JayantaPoddar — Fri, 07 Aug 2015 05:49:33 GMT

Hello Marianne,

How are you connecting to ArcGIS Server?

If web-adaptor is already configured in your machine, access the ArcGIS Server using the following URL

From ArcCatalog

http://<FullMachineName>/<WebAdaptorName>

Accessing Manager from Web-browser

http://<FullMachineName>/<WebAdaptorName>/Manager

*Do not use any port no.

Also make sure that the database is registered in ArcGIS Server data store.

Re: Suddenly Can't Publish Feature Services? v10.3

Anonymous User — Fri, 07 Aug 2015 16:24:43 GMT

Jayanta: thank for the response. There appears to be no problem with the connection parameters or the registered store. A service with only Mapping will publish successfully; it is only when I add Feature Access that this problem occurs.

EDIT: at this stage, I thought that the Mapping-only services were OK, as the publication mxd reported a successful publish process. However, I later discovered via the JavaScript viewer at the REST endpoint that the Mapping-only services were not rendering. Further digging revealed the service's status in AGSManager was "Stopping..." and would not be started.

Re: Suddenly Can't Publish Feature Services? v10.3

PhilipSlater — Fri, 07 Aug 2015 16:31:52 GMT

Not sure if this is helpful, but in a Portal world...

Common problems and solutions—Portal for ArcGIS (10.3 and 10.3.1) | ArcGIS for Server

my apologies in advance if it isn't.

Re: Suddenly Can't Publish Feature Services? v10.3

Anonymous User — Fri, 07 Aug 2015 16:37:45 GMT

Thanks Philip. I did see that, but we don't have Portal configured. To be thorough, I removed underscores from the service name, leaving only regular English letters. There was no effect.

Re: Suddenly Can't Publish Feature Services? v10.3

RebeccaStrauch__GISP — Fri, 07 Aug 2015 16:51:52 GMT

Marianne,

Did you analyze the MXD during the publishing process to se if there were any layers that it didn't like?

Also, do you have your DMBS layer registered in you ArcGIS Server's DataStore, and does it show a green check if you validate the connection??

I don't have any on our 10.3 test machine, but this is what it looks like on 10.2.2

Re: Suddenly Can't Publish Feature Services? v10.3

Anonymous User — Fri, 07 Aug 2015 16:54:14 GMT

Thanks for the reply. There were no errors on analysis, and all data stores validate successfully.

Re: Suddenly Can't Publish Feature Services? v10.3

RebeccaStrauch__GISP — Fri, 07 Aug 2015 17:29:41 GMT

Since the map server can be published, I would guess it is a permission issue for the feature service. I don't have enough experience to help much with thie, but you may want to read thru ArcGIS Help (10.2, 10.2.1, and 10.2.2) if you haven't already (in case links aren't working correctly yet in GeoNet http://resources.arcgis.com/en/help/main/10.2/index.html#//015400000393000000

Re: Suddenly Can't Publish Feature Services? v10.3

JayantaPoddar — Fri, 07 Aug 2015 17:37:11 GMT

Marianne,

Did you create an enterprise geodatabase?

Re: Suddenly Can't Publish Feature Services? v10.3

StevenGraf1 — Fri, 07 Aug 2015 17:41:28 GMT

For feature access, all data should be published from the same location. This might be causing the error. To see the list of locations, click the List by Source button in the Table of Contents.

A permissions issue would surely pop up in the error inspector window so I'm guessing that isn't the issue.

Hope this helps.

-Steven

Re: Suddenly Can't Publish Feature Services? v10.3

Anonymous User — Fri, 07 Aug 2015 17:53:21 GMT

Thanks Steven. There is only a single data source in the mxd, and I'm using data which I know to be associated with pre-existing services which are running correctly.

I thought permissions initially, too, but I'm not aware of any changes having been made to permissions, and this system has been working for some time.

I forgot to include the message I get in ArcGIS Server when I try to start the service:

Service failed to start

ServiceName.MapServer:

machine.domain.name

Can not open file path\arcgisserver\directories\arcgissystem\arcgisinput\ServiceName\extracted\v101\ServiceName.msd. The system cannot find the path specified. Probable cause: The file is inaccessible to Server.

So, it says "Server" can't get to the file. BUT, didn't "Server" create the file? The service gets created, but simply won't start.

Re: Suddenly Can't Publish Feature Services? v10.3

RebeccaStrauch__GISP — Fri, 07 Aug 2015 18:05:14 GMT

It might be referring to the actual server, not ArcGIS Server.

some things to check, has the IP address hasn't changed on any of your servers lately? Or do you have invalid characters in the layer name? Error 001359 when publishing map service to ArcGIS server 10.1 - Geographic Information Systems Stack Exchange

Re: Suddenly Can't Publish Feature Services? v10.3

StevenGraf1 — Fri, 07 Aug 2015 18:07:57 GMT

Have you restarted the ArcGIS Server instance from the services menu? If that didn't work, you may try restarting the machine ArcGIS Server is installed on.

You could also install 10.3.1 and see if that fixes the issue.

What version of MXD are you using? You might try opening a new MXD and copying the layers from the old to the new and publish from there.

-Steven

Re: Suddenly Can't Publish Feature Services? v10.3

Anonymous User — Fri, 07 Aug 2015 20:06:07 GMT

No special characters, and if the IP address was the issue, no services would publish at all. In this case, a service with Mapping capability only will publish and start successfully. It is only Feature Access capability which is affected.

Re: Suddenly Can't Publish Feature Services? v10.3

Anonymous User — Fri, 07 Aug 2015 20:08:06 GMT

The problem doesn't exist in my test environment (also v10.3) and this has all been working fine until recently; I'm trying to figure out what change could have occurred to cause the problem. The problem occurs with new and old mxds.

I appreciate the replies, everyone! Looks like Esri support is the next step. I'll post an update when it is resolved. Thanks again.

Re: Suddenly Can't Publish Feature Services? v10.3

Caroline_Akoth — Fri, 25 Sep 2015 12:24:11 GMT

Hi Marianne Farretta How did you eventually solve this? I'm having the same error message trying to overwrite a service i had previously published

Re: Suddenly Can't Publish Feature Services? v10.3

ScottPrindle — Fri, 25 Sep 2015 21:56:46 GMT

Hey Marianne,

In the MXD, are you using OS Authentication or Database Authentication for the database connection properties? If you are using DB authentication, are these settings the same as what's used in the Data Store? If you are using SQL Server and OS authentication, has the "arcgis" account been added in SQL Server Management Studio and given the necessary permissions to view and modify the data? If you uncheck all of the capabilities for a feature service except for Query, are you able to publish?

Thanks,

Scott

Re: Suddenly Can't Publish Feature Services? v10.3

Anonymous User — Mon, 28 Sep 2015 23:08:48 GMT

Here is the update:

In my scenario, there are two systems: one "internal" and one "public." The data

is replicated from internal SDE to public SDE, then a map/feature service is

published using the internal SDE as the Publisher database, and the external SDE

as the Server database.

At one point, all of the passwords in the internal SDE were changed at once. At that time, I

updated the appropriate SDE connection files and re-imported them to the ArcGIS

Server data stores. When this problem presented, and all other options were exhausted, I did that step again. This resolved the issue, though I'm still trying to figure out exactly why.

There are a few things about this scenario which still don't add up for me. First, I could not reproduce this error in either test or development environments, and second, the internal database credentials should not have been a factor at all. This points to an anomaly in the production environment, or a variable I haven't yet considered.

Scott: database authentication, unchecking all except Query: still failed. Map service would publish, but wouldn't render (discovered this after my initial post). Feature services would be created, but would not start.

Re: Suddenly Can't Publish Feature Services? v10.3

ScottPrindle — Thu, 08 Oct 2015 22:43:48 GMT

Marianne,

I'm glad to hear that you were able to resolve the issue by updating the database connection files and the server's data store again. It's hard to say what exactly happened, since repeating the same steps resolved it. As far as we can tell, ArcGIS Server had some trouble with the database users/passwords that were provided.

Attempting to publish the service with just the Query capability was meant to show if we had a problem with editing permissions for the publisher or server connection file. Since it still failed to publish, it appears one of the connection files was causing the issue, but we can't definitively say why.

Thanks,

Scott

Re: Suddenly Can't Publish Feature Services? v10.3

JayJohnson3 — Sat, 12 Dec 2015 22:59:28 GMT

I encountered this same error when publishing a feature service by sharing from ArcMap. I was able to publish the map service without feature access just fine. I discovered that I could enable feature access, to include all operations, if I logged into our ArcGIS Server Manager web interface. There, I could edit the map service and then save & restart it successfully.

Jay