I've installed Monitor 2025.0, and now my Oracle SDE observers are broken for the metrics and inventory observers. I'm connected via the SDE account, so that shouldn't be an issue. I've also unregistered one of the now broken Oracle SDE database components, and reregistered, and no dice. Here is the observer error I'm getting:
LevelTimeCode
MessageResourceDetails
|
|
WITH UNFILTERED_TABLES AS ( SELECT GI.PHYSICALNAME AS "table_name", CASE WHEN GI.DEFINITION IS NULL THEN 'other' WHEN XMLQUERY('/*/ShapeType' PASSING XMLTYPE(GI.DEFINITION) RETURNING CONTENT) IS NULL THEN NULL WHEN INSTR(LOWER(XMLQUERY('/*/ShapeType/text()' PASSING XMLTYPE(GI.DEFINITION) RETURNING CONTENT)), 'point') > 0 THEN 'point' WHEN INSTR(LOWER(XMLQUERY('/*/ShapeType/text()' PASSING XMLTYPE(GI.DEFINITION) RETURNING CONTENT)), 'line') > 0 THEN 'line' WHEN INSTR(LOWER(XMLQUERY('/*/ShapeType/text()' PASSING XMLTYPE(GI.DEFINITION) RETURNING CONTENT)), 'polygon') > 0 THEN 'polygon' ELSE 'other' END AS "geometry_type", CASE WHEN BITAND(TR.OBJECT_FLAGS, POWER(2, 3)) <> 0 THEN 'traditional' WHEN BITAND(TR.OBJECT_FLAGS, POWER(2, 25)) <> 0 |
