Cannot register postgres table

RiccardoKlinger

Dear ESRI Community,

 

We have some tables in our postgres database. the tables were creted like:

 

CREATE TABLE IF NOT EXISTS gd_base.polygon
(
objectid integer NOT NULL,
name character varying(255) COLLATE pg_catalog."default",
shape geometry(Polygon,32632) NOT NULL,
status integer NOT NULL,
created_user character varying(255) COLLATE pg_catalog."default",
created_date timestamp without time zone,
last_edited_user character varying(255) COLLATE pg_catalog."default",
last_edited_date timestamp without time zone,
)

Unfortunately we face an issue as it states:

After, I have dropped the NOT NULL constraint using dataGrip and retried the same process it was resulting in the same issue. But the column was again marked with "NOT NULL".

After that I also removed the objectid column from the table and rerun the process, leaving the field to be used as objectid empty.

The same problem appeared. We are lost...

 

Tried with ArcGIS Por 2.9/2.8 Arcmap 10.8.1, ArcPY running on postgres12 with postgis and sde extension.

RiccardoKlinger

If someone faces similar problems:

We've removed the "NOT NULL" constraint from the shape column and it is now working. We can register our tables with an already defined objectid column and with no defined objectid column.