Skip to main content
ExLibris

Knowledge Assistant

BETA
  • Subscribe by RSS
  • Back
    Rosetta

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Rosetta
    3. Knowledge Articles
    4. Additional XML tags in Dublin Core (DC) fields

    Additional XML tags in Dublin Core (DC) fields

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Symptoms
    2. Workaround
    • Product: Rosetta
    • Product Version: 6.0+

    Symptoms

    Search in permanent returns no results for IEs with DC fields containing additional XML tags (when the field is included in search columns).

    Example - SIP METS and resulting IE METS XML (view on the server) contain a DC field like: 

    <dc:title>

    this is title 

    <span>of a book</span>

    </dc:title>

    Search that should contain IE with such DC fields values will fail if the title is in selected search columns. Such IEs will not be included in the seach results,  in the server log  is:

    2019-08-26 10:25:38,956 ERROR [com.exlibris.core.repository.dao.impl.HDeControlDaoImpl] (https-jsse-nio-8443-exec-4) []  | RPS-il-dtldev08c.corp.exlibrisgroup.com | javax.persistence.QueryTimeoutException: could not execute query
            at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1351)
           ....
    Caused by: java.sql.SQLException: ORA-19025: EXTRACTVALUE returns value of only one node

            ...

    Workaround

    Ingesting SIPs containing DC records with XML reserved characters is not supported. Rosetta does not validate DC fields in general METS validation. 

    1) Escape XML reserved characters before ingest.   

    Example - SIP METS and resulting IE METS XML (view on the server)  contain escaped DC record like:

    <dc:title>

    this is title 

    &lt;span&gt;of a book&lt;/span&gt;

    </dc:title>

    2) Wrap the problematic fields values to CDATA.

    <dc:description>

    <![CDATA[

    <div>Lorem ipsum dolor sit amet</div><div><br></div><div> In convallis<i> Curabitur sagittis hendrerit ante. </i>Curabitur sagittis <b>43</b>(9) 2142-2145 (2018)<br></div><div><br></div><div> <a href="https://doi.org/XXXXX">https://doi.org/XXXX</a> (also https://arxiv.org/abs/XXXX)</div>

    ]]>

    </dc:description>

    3) Fix existing problematic data. 

    Use Rosetta Metadata update job to export problematic DC records, fix them outside Rosetta and update. 

     


    • Article last edited: 22-AUG-2019
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Why is publishing not running at the scheduled times?
      • Product Materials
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Content Type
      Knowledge Article
      Language
      English
      Product
      Rosetta
    2. Tags
      1. Dublin Core
      2. Encoding
      3. Rosetta
      4. search
      5. XML
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved