Bug
An immediate calculation rule calling a database sequence using the NextSequenceValue() function in ArcGIS Arcade only works for the schema owner of the database sequence and fails for other database users.
| Bug ID Number | BUG-000124487 |
|---|---|
| Submitted | August 13, 2019 |
| Last Modified | April 16, 2026 |
| Applies to | ArcGIS Pro |
| Version found | 2.4 |
| Operating System | N/A |
| Operating System Version | N/A |
| Status | As Designed |
Additional Information
This is as designed, sequences need to be fully qualified when referenced in NextSequenceValue.Workaround
Fully qualifying the sequence name with the object owner allows other editors to use the sequence. The Arcade expression is as follows:Â NextSequenceValue('OWNER.SEQUENCE_NAME').
Steps to Reproduce
Bug ID: BUG-000124487
Software:
- ArcGIS Pro
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App