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

594
2
01-04-2023 06:37 AM
Labels (2)
JBeasley
New Contributor III

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.

2 Replies
jschuckert
New Contributor III

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

Jared

0 Kudos
JBeasley
New Contributor III

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. 

0 Kudos