I am trying to update a single column of a versioned view using Sql. We are using a Microsoft SQL Server geodatabase. The production Geodatabase version is 10.0. The development Geodatabase version is 10.3.1.
The update query would look something like this:
UPDATE [Meter_evw] SET Zone_name = 'example' WHERE ObjectId = 1;
Running this query results in the following error:
Could not find stored procedure '<DatabaseName>.<Schema>.SDE_get_globals'.
If I run the same query on our development geodatabase (basically an exact copy, however it's version is 10.3.1) I have no issues, everything works as expected.
I know for a fact that I used ArcMap 10.3.1 to register the Meter FeatureClass (on the production Geodatabase) in question as versioned.
My suspicion is that the mismatch between the ArcMap version and the Geodatabase version when the versioned views were created has caused this issue. Is that correct? If so what is the best way to fix it?
I have two ideas:
- Upgrade the production database to 10.3.1
- Use ArcMap 10.3.1 to remove the versioned views, and use ArcMap 10.0 to add the versioned views back.
Are there better options and is this even the correct direction?
Thanks,
Daniel