Datastore. Missing table sde_logfiles

[PatricWiström]

Hi!

We are having some problems with datastore in our 11.3 Enterprise environment. In the postgres-logfile it constantly complains about not finding the table sde_logfiles. I can confirm that the table does not exist in the schema where it is supposed to be. The schema is the managed username for the relational data store.

"ERROR: relation "hsu_xxxxx.sde_logfiles" does not exist at character 29"
"STATEMENT: SELECT logfile_data_id FROM hsu_xxxxx.SDE_logfiles LIMIT 0"

Every 3-5 second this gets logged.

When comparing with our test-environment the table does exist in that schema and there is no error-messages in the log-file.

Anyone has an idea? Thanks in advance!

[DenisPithon]

Hi,

Same error here (PostgreSQL 15, ArcGis 11.3 Enterprise)

ERROR: relation "xyz.sde_logfiles" does not exist at character 29
STATEMENT: SELECT logfile_data_id FROM xyz.SDE_logfiles LIMIT 0

any ideas ?

Hace a good day.

Denis

[George_Thompson]

Those tables are probably system tables created by the datastore, especially if someone creates a selection with a hosted layer.

See this doc for more information on log files in PostgreSQL (go to the very bottom of the page): https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-postgresql/geodatabase-system...

I think behind the scenes, the datastore is an enterprise geodatabase managed by your Enterprise deployment.

I think that some of those messages are more red-herring and not an issue.

You can reach out to support and see if there is something else they may know about.