nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Mixed Data Stores

StevenGriffith

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

Encontre mais publicações marcadas com

Accepted answers

All comments

ScottBailey

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.

JeffSmith

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.

MarkHoover

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.

JeffSmith

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.

JayBoyd

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

Anonymous User

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

EvanJohnson

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

TrevorBurgan

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

PaulMaddock1

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.

PropertiesCurtin1

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.

RandallWilliams

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.

LarryMasters

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.

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.