topic Re: Mixed Data Stores in ArcGIS Enterprise Questions

Mixed Data Stores

StevenGriffith — Fri, 28 Sep 2012 19:54:13 GMT

I'm getting the following error when trying to publish a service to a 10.1 server:

"Invalid service definition. Cannot have "mixed" data stores with a feature or geocode service."

The service I'm trying to publish has one feature data set with two layers, both are from the same geodatabase. (SQL Server)

Any idea of what ArcMap could be complaining about??

Steve G.
County of SLO

Re: Mixed Data Stores

ScottBailey — Fri, 16 Nov 2012 18:17:34 GMT

Do you ever solve this I am having the same problem but I only have feature class so I don't see how it is considered "mixed" Dataset.

Re: Mixed Data Stores

JeffSmith — Mon, 19 Nov 2012 17:11:58 GMT

Is the data in your feature class from a version 9.3.1 SDE geodatabase? There was a known issue creating a 10.1 feature service against 9.3.1 data that may have produced a similar error message to what you are seeing. This was fixed in 10.1 SP1.

Re: Mixed Data Stores

MarkHoover — Tue, 22 Jan 2013 17:27:25 GMT

I am at Service Pack 1 and the data is from a 10.1 SDE geodatabase, but I am seeing this same error message. All of the datasets (in my case 4) are from the same SQL Server and same database. A truly perplexing error, at least in terms of the error message generated.

One thing to note is that this service features a standalone table and a join, but I have published other services with both of these special attributes without issue.

Re: Mixed Data Stores

JeffSmith — Wed, 23 Jan 2013 16:44:35 GMT

You might try exporting the data you want to use in your feature service to a fgdb and then importing it back to your SDE gdb (perhaps in a new feature class or table). I'm not sure exactly what ArcGIS Server uses to analyze the data prior to allowing you to enable feature access but I have seen instances where this procedure "cleans" the data so it is not viewed as being from mixed data stores.

Re: Mixed Data Stores

JayBoyd — Tue, 23 Sep 2014 21:03:49 GMT

I received the Cannot have "mixed" data stores with a feature or geocode service message today when I tried to publish a 10.2.2 feature service with data updates enabled. My map document only has one layer and that layer's data source is an ArcSDE Enterprise Geodatabase. I found that the issue was an image element that was added to the layout to display a logo on printed maps. ArcMap must package up the image and upload it to the server just as it would any layer source data that is not registered with the server. Once I deleted the image element from the layout I was able to publish my feature service.

Jay

Re: Mixed Data Stores

Anonymous User — Wed, 24 Sep 2014 17:57:53 GMT

Jay, thanks for posting this comment. I just experienced the same error today, running 10.2.2. I never would have guessed to delete the image elements in the layout window, but after I did this, it published successfully!

Brendan

Re: Mixed Data Stores

EvanJohnson — Mon, 13 Oct 2014 19:15:31 GMT

You are the man Jay. This has been perplexing me so much over the last week...

Re: Mixed Data Stores

TrevorBurgan — Wed, 24 Jun 2015 17:04:51 GMT

Yep, this was exactly my problem too. I would never of guessed that the images in the Layout window would cause this!

Re: Mixed Data Stores

PaulMaddock1 — Thu, 23 Jul 2015 14:23:29 GMT

Jay,

How did you discover the solution to this problem? I scoured through the documentation on Feature Services and couldn't find the answer.

Thanks for posting this solution.

Re: Mixed Data Stores

Anonymous User — Thu, 29 Oct 2015 18:58:07 GMT

That's it, Jay! Thank you!! A true miss for the "Analyze" button on the Service Editor window....

Re: Mixed Data Stores

PropertiesCurtin1 — Fri, 19 Jan 2018 07:57:23 GMT

This issue still exists in 10.5 where it presents, in my case, as "ERROR 1369: Failed to create the service" in ArcMap.

The server log shows "Failed to create the service.: Invalid service definition. Cannot have "mixed" data stores with a feature service"

Removing images from the layout window does resolve the problem. The problem only occurs when "Feature Access" for the service is ticked as one of the Capabilities.

Re: Mixed Data Stores

RandallWilliams — Fri, 19 Jan 2018 17:17:52 GMT

If you've removed everything from the map document except for data that all resides within the same database, I'd open a new arcmap session and drag the layers from map doc 'a' into new map doc 'b', then attempt to republish. Sometimes map documents hold onto old data references when they shouldn't.

Re: Mixed Data Stores

LarryMasters — Wed, 16 Jan 2019 16:14:22 GMT

I had a different problem. I built a mapping service in Portal to show how the app would look. Just wanted to show and get feed back from future users. I built it in a file DB so i could make changes easier. Well, when it came time to actually go into production with a feature service, I imported it into my SDE DB and changed the source on the Map document. That through my error. The advice to create a new map document with new data source was correct. Once I did that, all was well.