can not create Feature Class due to connection lost

yockee — Tue, 15 Oct 2024 01:01:20 GMT

I am using Arcgis enterprise 11.0, Arcgis pro 11.0 and Postgresql 13..

Suddenly, I can't create feature class, can't even identify object. The error are:

ERROR 999999: Something unexpected caused the tool to fail. Contact Esri Technical Support (http://esriurl.com/support) to Report a Bug, and refer to the error help for potential solutions or workarounds.
Database user name and current user schema do not match. [Connection to PostgreSQL server is lost. :SQLSTATE=] [dbgis.tgk_city.testfc123456]
Underlying DBMS error [no connection to the server
:SQLSTATE=ž] [dbgis.sde.GDB_Items]
Failure to access the DBMS server [Failure to access the DBMS server]
Underlying DBMS error [no connection to the server
:SQLSTATE=ž] [dbgis.sde.GDB_Items]

Then I restart the ArcMap. I can open the geodatabase from Arcgis Pro. I can see all the feature classes. I can do "identify" to an object. But, when I want to create FC, that error comes up again. I can NOT connect to the geodatabase any longer. Even accessing from PGAdmin does not work too ! The connection suddenly just closed.

Then, I restarted the Database, the Physical Server (its on AWS) and Arcgis Pro. I can connect again. I can see all the Feature classes. But, when I want to add a new FC, its just dropping connection just in the end of the process.

I was able to do many things in the past weeks, such as:

- creating new Feature Class

- adding new attributes

- adding data, editing, copying and pasting

- giving data access permission to specific users

it seems that there is problem in maintaining the connection.

Please help.

Re: can not create Feature Class due to connection lost

VinceAngelo — Wed, 16 Oct 2024 15:58:34 GMT

Whenever something new comes up, the question to ask is "What changed?" The error message is indicating login/schema issues, so in this case, what changed in the database? Did someone alter the login/schema mappings? Has there been a database rev update?\

- V

topic can not create Feature Class due to connection lost in Geodatabase Questions

can not create Feature Class due to connection lost

Re: can not create Feature Class due to connection lost