It happens to anyone and everyone, existing or new. Is it possible that the upgrade changed something on that table? I also had another issue with another church that some of the server settings were changed after the last 2 upgrades.
"Allow Snapshot Isolation: Yes" This was changed to No
"Is Read Committed Snapshot On: Yes" This was changed to No

Error

Unable to find an entry point named 'SetClrFeatureSwitchMap' in DLL 'SqlServerSpatial110.dll'.
at Microsoft.SqlServer.Types.GLNativeMethods.SetClrFeatureSwitchMap(Int32 clrFeatureSwitchMap)
at Microsoft.SqlServer.Types.SqlGeometry.IsValidExpensive()
at Microsoft.SqlServer.Types.SqlGeometry.Construct(GeoData g, Int32 srid)
at Microsoft.SqlServer.Types.SqlGeometry.GeometryFromText(OpenGisType type, SqlChars text, Int32 srid)
at Microsoft.SqlServer.Types.SqlGeometry.Parse(SqlString s)
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.Data.Entity.SqlServer.SqlSpatialServices.GeometryFromText(String wellKnownText)
at System.Data.Entity.Core.Mapping.Update.Internal.Propagator.ExtentPlaceholderCreator.InitializeSpatialTypeDefaultMap()
at System.Lazy1.CreateValue() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Lazy1.get_Value()
at System.Data.Entity.Core.Mapping.Update.Internal.Propagator.ExtentPlaceholderCreator.TryGetDefaultValue(PrimitiveType primitiveType, Object& defaultValue)
at System.Data.Entity.Core.Mapping.Update.Internal.Propagator.ExtentPlaceholderCreator.GetPropagatorResultForPrimitiveType(PrimitiveType primitiveType, PropagatorResult& result)
at System.Data.Entity.Core.Mapping.Update.Internal.Propagator.ExtentPlaceholderCreator.Visit(EdmMember node)
at System.Data.Entity.Core.Mapping.Update.Internal.Propagator.ExtentPlaceholderCreator.CreateEntitySetPlaceholder(EntitySet entitySet)
at System.Data.Entity.Core.Mapping.Update.Internal.Propagator.Visit(DbScanExpression node)
at System.Data.Entity.Core.Mapping.Update.Internal.Propagator.Visit(DbProjectExpression node)
at System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.<ProduceDynamicCommands>d__a.MoveNext()
at System.Linq.Enumerable.<ConcatIterator>d__591.MoveNext() at System.Data.Entity.Core.Mapping.Update.Internal.UpdateCommandOrderer..ctor(IEnumerable1 commands, UpdateTranslator translator)
at System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.ProduceCommands()
at System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.Update()
at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) at System.Data.Entity.Core.Objects.ObjectContext.SaveChangesToStore(SaveOptions options, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction) at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func1 operation)
at System.Data.Entity.Core.Objects.ObjectContext.SaveChangesInternal(SaveOptions options, Boolean executeInExistingTransaction)
at System.Data.Entity.Internal.InternalContext.SaveChanges()
at Rock.Data.DbContext.SaveChanges(Boolean disablePrePostProcessing)
at Rock.Model.LocationService.Get(String street1, String street2, String city, String state, String postalCode, String country, Group group, Boolean verifyLocation, Boolean createNewLocation)
at Rock.Model.LocationService.Get(String street1, String street2, String city, String state, String postalCode, String country, Boolean verifyLocation)
at RockWeb.Blocks.Crm.PersonDetail.EditGroup.<>c__DisplayClass54.<btnSave_Click>b__4b() in c:\inetpub\wwwroot\Blocks\Crm\PersonDetail\EditGroup.ascx.cs:line 1368
at Rock.Data.DbContext.WrapTransaction(Action action)
at RockWeb.Blocks.Crm.PersonDetail.EditGroup.btnSave_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\Blocks\Crm\PersonDetail\EditGroup.ascx.cs:line 1136
at System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e)
at System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Jeremy, where and what should the permissions be? The Location table has No specific permissions and the Database itself only seems to have RockUser permissions "Connect".
This makes no sense and I am able make changes via the RMS UI.

Hi Don -

Indeed, if it's merely "Connect" then rights would be pretty lean.......................

At first blush, the error posted above doesn't lead me to believe it's a Database Security Rights issue. That said, your RockUser should be configured as seen here: https://community.rockrms.com/documentation/BookContent/1#installingconfiguringsqlserver

If the user is set as "dbowner" does that clear up the problem?

Looks like the user is configured properly. I can not change DB Owner to RockUser. I get the folllowing: The proposed new database owner is already a user or aliased in the database.

I believe that suggestion, only works for an issue with the SQL 2012 SP3 & SP4 service packs. Because one or both of those service pack have an issue.

Go to the internal hosting manual and locate "Snapshot Isolation Settings". Basically, right click on the RMS database and goto properties, you will find these settings under Miscellaneous.

Angela, does the error you are seeing look like the same error shown in this reported issue: https://github.com/SparkDevNetwork/Rock/issues/3652 If not, can you create a new issue over here https://github.com/SparkDevNetwork/Rock/issues/new/choose and paste in a screenshot of what you are seeing?

Well it fixed my issue. And it has something to do with one of the latest upgrades. That is why you have been fine until now. I am surprised that your host provider can not change these settings for you. Are you able to login to your windows server directly, or do you have to do everything via FTP?

I think I saw something about RMS releasing an update to fix this.