Symptoms

Rosetta CMS Resolver delivery deep link does not work in Rosetta SP 9.0. 

Defect Status

The issue is fixed in Rosetta SP 9.1

Replication Steps

CMS resolver URL from Aleph uses URL like 

https://<delivery load balancer host>:<delivery load balancer port>/delivery/action/cmsResolver.do?cmsSystem=<system>&cmsRecordId=<recordId>[&displayType=list&columns=<column_a,column_b> | &displayType=thumbnails]

which generated errors like 

ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http-nio-1801-exec-1) [] ORA-19224: XPTY0004 - XQuery static type mismatch: expected - node()* got - xs:string

Workaround

Please kindly reach out to Rosetta support if you suspect that your Rosetta integraiton with Aleph is affected by this issue. 

• Article last edited: 20-MAY-2026