We are seeing the same errors -
SELECT
L1."ITEM_ID" AS "ELEMENTID",
case when L3."LABEL" = 'column' then xmlcast(XMLQuery('for $i in /column/source-column[1] return $i/schema/text()' PASSING BY VALUE XMLTYPE(L2."DATA",871) RETURNING CONTENT) as varchar2(100))
when L3."LABEL" = 'join' then xmlcast(XMLQuery('for $i in /join/source-column[1] return $i/schema/text()' PASSING BY VALUE XMLTYPE(L2."DATA",871) RETURNING CONTENT) as varchar2(100))
when L3."LABEL" = 'filter' then xmlcast(XMLQuery('for $i in /filter/source-column[1] return $i/schema/text()' PASSING BY VALUE XMLTYPE(L2."DATA",871) RETURNING CONTENT) as varchar2(100))
end AS "COL01"
from
FROM
"SPOTFIRE"."LIB_CURRENT_ITEMS" L1,
"SPOTFIRE"."LIB_DATA" L2,
"SPOTFIRE"."LIB_ITEM_TYPES" L3
WHERE
(L3."TYPE_ID" = L1."ITEM_TYPE")
AND (L1."ITEM_ID" = L2."DATA_ID")
AND (L3."DISPLAY_NAME" IN ('column',
'filter',
'join'))
InformationModelServiceException at Spotfire.Dxp.Services:
Failed to execute query: ORA-31011: XML parsing failed
ORA-19213: error occurred in XML processing at lines 1
LPX-00217: invalid character 31 (U+001F)
ORA-06512: at "SYS.XMLTYPE", line 283
ORA-06512: at line 1
https://docs.oracle.com/error-help/db/ora-31011/ (HRESULT: 80131509)
Looks like something changed in the XML Type - have not found a good solution yet.