Select to view content in your preferred language

Invalid object name 'db.schema.SDE_logfiles'.

1260
2
09-25-2019 02:14 PM
DamianHouseknecht
Occasional Contributor

I set up an extended event session to capture errors while testing a new version of our application and I'm gettting thousands (hundreds of thousands) of errors like "Invalid object name 'db.schema.SDE_logfiles'."  Our dbtune table for the DB in question has the logfile_defaults session_temp_table set to 1 which from my understanding should be directing the GDB to create sde_logfiles in tempdb.  My question is, why is ArcGIS still looking for the logfile table under the users schema and how can I go about resolving this?  I've attached an image of all of our Logfile_Default config.

Thanks,

Damian.

2 Replies
Cristian_Galindo
Frequent Contributor

Now it is 2022, is there any information related to this issue?

0 Kudos
MarceloMarques
Esri Regular Contributor

The ArcGIS application still checks into the connected user schema for the sde log files tables because of compatibility with older versions of the Geodatabase that do not use the tempdb to store the sde log file tables, this is an intended behavior as designed, perhaps in a distant future this behavior in the ArcGIS application might change, but currently it is required for compatibility with old geodatabase versions.

| Marcelo Marques | Esri Principal Product Engineer | Cloud & Database Administrator | OCP - Oracle Certified Professional | "In 1992, I embarked on my journey with Esri Technology, and since 1997, I have been working with ArcSDE Geodatabases, right from its initial release. Over the past 32 years, my passion for GIS has only grown stronger." | “ I do not fear computers. I fear the lack of them." Isaac Isimov |