Copy UN FGDB to SDE fails due to missing database sequence

Brian_Laws — Tue, 08 Jul 2025 16:12:12 GMT

I believe I have successfully set up a Sanitary Utility Network in a file geodatabase and I am attempting to migrate it to our Enterprise geodatabase following the help on configuring a multiuser environment from the Foundation help page. I copy the Utility Network feature dataset from the FGDB and paste it into the Enterprise Database connection that has been set up for the user I wish to be the Utility Network owner in the Catalog pane in ArcGIS Pro (version 3.4.3). It goes through the copy process for a few minutes and then stops with the following error:

I did modify some other database sequences for some of the Generate ID attribute rules, but I never touched this sequence. I thought maybe I deleted this one by mistake, so then I try to recreate it and I get the error that the sequence already exists. I also checked the attribute rule that it references to make sure the spelling of the sequence name never changed and it is still named the same.

Any help regarding fixing this error or working around it would be much appreciated!

Re: Copy UN FGDB to SDE fails due to missing database sequence

Brian_Laws — Thu, 10 Jul 2025 18:09:42 GMT

I've made progress with this error . . . I found that there WERE some missing database sequences in the stated attribute rule that I hadn't updated with the new sequence names I created, but it wasn't the sequence that was listed in the error. Once I updated the attribute rule with the correct sequence names I didn't get that error anymore.

topic Copy UN FGDB to SDE fails due to missing database sequence in ArcGIS Utility Network Questions

Copy UN FGDB to SDE fails due to missing database sequence

Re: Copy UN FGDB to SDE fails due to missing database sequence