TransWikia.com

Problems with sde.next_rowid, ArcMap still uses 'old' values

Geographic Information Systems Asked on March 11, 2021

Due to reasons beyond the scope of this question, I’m forced to import data into an SQL Server SDE database using SQL statements (importing using ArcGIS is not possible). The data already contains ObjectID values that I need to keep.

My idea was to create empty featureclasses first, then import the data, and finally execute sde.next_rowid several times to increase the ObjectID value for objects that will be inserted later. For example, if the data already has ID’s 10–20, I need to execute sde.next_rowid 20 times, so that a new record will get ID 21.

Importing the data works, and executing sde.next_rowid too, or at least it seems so: I can see that the values for fields base_id and last_id in the i<reg_id> table are increased. However, if I insert data using ArcMap or ArcGIS Pro, new ObjectIDs still start counting at 1.

  • The GeoDatabase is version 10.8
  • SQL Server is version 2019

(Restarting ArcMap or Pro does not fix this)

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP