topic Re: Copy or Export/Import XML fail due to DBMS sequence not found in ArcGIS Pro Questions

Copy or Export/Import XML fail due to DBMS sequence not found

JBeasley — Wed, 04 Jan 2023 15:44:17 GMT

Using ArcGIS Pro 3.0.3

There is a database sequence used in an attribute rule applied to an attribute in the feature class I wish to export to a file geodatabase. When connected as the owner of the sequence, the copy succeeds. When connected as any other user, the copy fails.

I am copying a feature class from an SDE to a FGDB using data management's Copy , and get this error:

000260: DBMS sequence not found

I've also tried import to XML (on feature dataset containing the feature class) and import XML to a file geodatabase. I get this error:

ERROR 002899: The sequence name is invalid.

We have gone into SSMS to grant permissions to the specific users but see no change in behavior. The other users are able to perform edits (which trigger the attribute rule) with no problems. Seems to be a permissions issue, but since the attribute rule referencing the sequence still succeeds during edits and the permissions have been updated specifically for the sequence, I am out of ideas.

Re: Copy or Export/Import XML fail due to DBMS sequence not found

jschuckert — Mon, 25 Sep 2023 18:17:24 GMT

Did you find a resolution to this? I am encountering the same issue simply trying to export XML of layer.

Jared

Re: Copy or Export/Import XML fail due to DBMS sequence not found

JBeasley — Wed, 27 Sep 2023 13:23:45 GMT

I did not, but I recently upgraded to Pro 3.1.3 and am not seeing the behavior anymore. It occurred in all other 3.1.x subversions, so I am not confident this "fix" will persist, but for now it is good again.

Re: Copy or Export/Import XML fail due to DBMS sequence not found

DrewDowling — Tue, 21 Jan 2025 21:40:56 GMT

Getting this error using 3.2.4 so it didn't persist.

A bug has been filed

https://support.esri.com/en-us/bug/the-import-xml-workspace-document-geoprocessing-tool-fa-bug-000168009