un tables prefix in sde geodatabase

Question

Hello,

I recently had to drop my test UN database in order to recreate it with a newly configured asset package.

Everything went smooth, but, when trying to restart my UN services, I had this error :

[DBMS table not found] [UN_806_DirtyAreas].

And indeed I noticed that now, all the UN system tables are prefixed by un_6_ instead of un_806_...

Is it a known behavior ? How can I restart or replace my services with the correct name ? I have to delete and republish them ?

--> Postegresql 14.6, UN 3.1, AGE 11.1

RobertKrisher · Accepted Answer

The UN system tables do reference an internal identifier that isn't preserved when you create a new database or copy/paste items between databases.

If you open the map that you used to publish your original service and fix any broken layers, you can use that to overwrite your original service. If you don't have your original map (uh oh!) you can either recreate it (taking care to preserve your layer ids) or you can browse the file system of your ArcGIS Server machine to download a copy of the map that was used to publish the service.