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.
