idea Disable Schema locking on Shared Services in ArcGIS Enterprise Ideas

Disable Schema locking on Shared Services

Geographic_Mythos — Mon, 06 May 2024 13:24:04 GMT

While working on some migrating services from an older ArcGIS Server site to a new set of machines, I wanted to take advantage of using the 'Shared Services' model for a larger amount of our less utilized services.

Something we frequently enjoy using, so that we do not have extra maintenance to do with these largely unmodified services, is set them to disable Schema Locking. The data is infrequently refreshed, and does not have frequent changes to it's underlying data structure.

Why is it I am able to choose to be able to disable Schema Locking for my other services in Enterprise, but not have the option to have those Shared Services be changed to non-locking services as well?

Can the 'Shared Services' have an option to be non-Schema Locking?

Re: Disable Schema locking on Shared Services

TanuHoque — Mon, 06 May 2024 17:43:45 GMT

@Geographic_Mythos

Our goal is to provide an option that would allow you to control that schema locking for shared instances in 11.3. Please note this option will get applied to **all** shared instances. Either all shared instances are enabled with schema locking or disable. You won't be able to do that for per service basis.

I'm not sure which enterprise release you have. Technically schema locking is disabled for all shared instances, the Manager site doesn't provide any UI option to change that settings. That should change in 11.3.

having schema locking disabled is what you are asking for. Pls let me if I got it wrong. If so, then the current state should be working for you, no?

thanks

Re: Disable Schema locking on Shared Services

Geographic_Mythos — Mon, 06 May 2024 17:49:56 GMT

@TanuHoque I believe you got it correct. I want the option to disable Schema Locking for Shared Instances.

I currently have 11.2 Enterprise deployments we are moving to from a much older release.

Glad to hear it is coming with 11.3. I am fine with it being an all or nothing solution for my needs presently.

Re: Disable Schema locking on Shared Services

TanuHoque — Mon, 06 May 2024 18:01:04 GMT

@Geographic_Mythos

I want the option to disable Schema Locking for Shared Instances.

Then you should be all good for your workflow. If I recall correctly, in 11.2 'schema locking' is disabled for all shared instances -- that also means that shared instances don't hold any schema locks.

Re: Disable Schema locking on Shared Services

GIS_Spellblade — Tue, 09 Jul 2024 17:59:17 GMT

@TanuHoque instead of making a deployment choose between schema locking on shared services, wouldn't it offer more flexibility to have two buckets of shared services, one with locking and one without?

I'm unsure what the architecture looks like on the backend to know if this is a herculean task.

EDIT:

Let's make it happen! Woooooo!

https://community.esri.com/t5/arcgis-enterprise-ideas/bifurcate-shared-services-pools-into-schema/idi-p/1503149/jump-to/first-unread-message

Re: Disable Schema locking on Shared Services

TanuHoque — Tue, 09 Jul 2024 17:15:59 GMT

@GIS_Spellblade

That is a great suggestion. Would you mind log a new idea in here https://community.esri.com/t5/arcgis-enterprise-ideas/idb-p/arcgis-enterprise-ideas?

thanks a lot

Re: Disable Schema locking on Shared Services

TanuHoque — Tue, 09 Jul 2024 18:23:56 GMT

thanks @GIS_Spellblade for posting the new idea

https://community.esri.com/t5/arcgis-enterprise-ideas/bifurcate-shared-services-pools-into-schema/idi-p/1503149