topic Geodatabase Administration - Locks error Failed to process XML data, possibly due to data corruption in Geodatabase Questions

Geodatabase Administration - Locks error Failed to process XML data, possibly due to data corruption

MarkFredrickson — Mon, 07 Dec 2020 20:43:37 GMT

Version 10.6.1 on Oracle 11.2.0.4

My python script failed due to schema locking error. I tried to view the locks but I got the error:

"Locks error Failed to process XML data, possibly due to data corruption"

I looked at the sde.table_locks table and 2896 tables are locked. I looked at our development server and no tables are locked. The XML corruption really concerns me. Where is this file and can it be fixed?

Re: Geodatabase Administration - Locks error Failed to process XML data, possibly due to data corruption

BillFox — Mon, 07 Dec 2020 23:37:16 GMT

Did you do a state zero compression yet?

Re: Geodatabase Administration - Locks error Failed to process XML data, possibly due to data corruption

MarkFredrickson — Tue, 08 Dec 2020 13:47:19 GMT

Thanks. No I have not.
I followed the links and tried but it looks like a task reserved for the
System Administrator.
I am still poking around looking for the XML associated with the Schema
Locks.

Re: Geodatabase Administration - Locks error Failed to process XML data, possibly due to data corruption

George_Thompson — Tue, 08 Dec 2020 14:41:46 GMT

I would NOT modify / edit / etc. any XML file that you find. It could cause more corruption of the Enterprise Geodatabase that may not be recoverable.

Are you connecting as the SDE user when looking at the locks?

Are there any other issues in the GDB currently?

This may be best to contact technical support and work with an analyst.

Re: Geodatabase Administration - Locks error Failed to process XML data, possibly due to data corruption

MarkFredrickson — Tue, 08 Dec 2020 20:51:19 GMT

Yes I contacted ESRI today. Another user had this issue posted, but it does
not look like it was resolved.