Missing TABLE_ID_GENERATOR in SDE

Meroni — Thu, 26 Jan 2023 15:00:35 GMT

Hi, I am trying to create a feature class and schemaBuilder.Build() yields the following error:

CreateAnnotationFeatureClass
test_t
Error: The table already exists.

However, there is no table test_t in the SDE. After researching a bit I stumbled upon the following link https://support.esri.com/en/technical-article/000006563 . The workaround should solve the problem (at least that is what I believe). The problem is that the SDE has no sequences and the workaround mentions that I have to call

SELECT last_number FROM user_sequences WHERE sequence_name = 'TABLE_ID_GENERATOR';

However, since there are no sequences I can't even complete the first step of the workaround.

Question is, why are there no sequences in my SDE?

Re: Missing TABLE_ID_GENERATOR in SDE

Aashis — Fri, 27 Jan 2023 15:22:09 GMT

Probably the DBMS is caching some information about the feature class.

I would begin troubleshooting by manually removing the entry of the feature class from the GDB_ITEMS table and then recreate it.

topic Re: Missing TABLE_ID_GENERATOR in SDE in ArcGIS Pro SDK Questions

Missing TABLE_ID_GENERATOR in SDE

Re: Missing TABLE_ID_GENERATOR in SDE