Select to view content in your preferred language

Issue post Upgrade: Error: function sde.get_rowid

45
1
12 hours ago
SimonSchütte_ct
MVP Regular Contributor

I did an inplace upgrade from 10.9.1 to 11.5.
All data stores validate (relational datastore and oracle).
Data can be shown in Map Viewer, but it is not possible to edit/update/add data - error:

ERROR: function sde.get_rowid(character varying, character varying, integer) does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 15

My first thought was that something went wrong with the Enterprise Geodatabase which is still on version 10.9.1 because of other dependencies. As long as no new data types/functionality are used (which is not the case) Enterprise 11.5 should be able to read/write.
But it is not only an issue with the Enterprise Geodatabase, the Services based on relational Data Store return the same error.

Is this something that could be caused by an error in the inpace upgrade? If so, how do we fix it? Any ideas?

0 Kudos
1 Reply
SimonSchütte_ct
MVP Regular Contributor

I received a hint that running "...\ArcGIS\DataStore\bin\gdbupgrade" may be necessary. Will give it a try and report back. Additional hints are welcome

0 Kudos