Help needed with SQL select from XMLTABLE

hello sages

For the last 9-10 years I have been pulling Euro exchange rates from the
European Central Bank
using the following partly comprehensible SQL..
This SQl statements started failing a week or so ago.
I admit to an (almost complete) ignorance of the XMLTABLE SQL function
and would greatly appreciate a pointer or two (or three)
TIA
Gad

insert into GAD/EXCHGRATEF select RATE_TIME as DATE,'EUR' as
BASECURR, CURRENCY as CURRCDE, RATE as EURRATE, RATE as
CURRRATE, 'European Central Bank' as SOURCE

from (SELECT my_cube.rate_time, my_cube.currency, my_cube.rate

FROM XMLTABLE(XMLNAMESPACES( DEFAULT '
http://www.ecb.int/vocabulary/2002-08-01/ eurofxref' , '
http://www.gesmes.org/xml/2002-08-01' AS "gesmes" ) ,

'gesmes:Envelope/Cube/Cube/Cube' PASSING XMLPARSE(DOCUMENT
SYSTOOLS.HTTPGETBLOB( '
https://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml' , '' )
)

COLUMNS currency CHAR(3) PATH '@currency' , rate DECIMAL(10,4) PATH
'@rate' , rate_time DATE PATH '../@time' ) my_cube ) tmp