RE: nbsp error while running db upgrade script from 6.2 to 7.2

Shoaib D, modified 5 Years ago. New Member Posts: 6 Join Date: 6/5/20 Recent Posts
Caused by: com.liferay.portal.kernel.xml.DocumentException: Error on line 317 of document  : The entity "nbsp" was referenced, but not declared. Nested exception: The entity "nbsp" was referenced, but not declared.
    at com.liferay.portal.xml.SAXReaderImpl.read(SAXReaderImpl.java:406)
    at com.liferay.portal.xml.SAXReaderImpl.read(SAXReaderImpl.java:381)
    at com.liferay.portal.xml.SAXReaderImpl.read(SAXReaderImpl.java:417)
    at com.liferay.portal.kernel.xml.SAXReaderUtil.read(SAXReaderUtil.java:159)
    at com.liferay.journal.internal.upgrade.v0_0_5.UpgradeJournal.convertStaticContentToDynamic(UpgradeJournal.java:256)
    at com.liferay.journal.internal.upgrade.v0_0_5.UpgradeJournal.updateJournalArticles(UpgradeJournal.java:582)
    at com.liferay.journal.internal.upgrade.v0_0_5.UpgradeJournal.updateJournalArticles(UpgradeJournal.java:562)
    at com.liferay.journal.internal.upgrade.v0_0_5.UpgradeJournal.doUpgrade(UpgradeJournal.java:309)
    at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:96)
    ... 26 more
Caused by: org.dom4j.DocumentException: Error on line 317 of document  : The entity "nbsp" was referenced, but not declared. Nested exception: The entity "nbsp" was referenced, but not declared.
    at org.dom4j.io.SAXReader.read(SAXReader.java:482)
    at org.dom4j.io.SAXReader.read(SAXReader.java:365)
    at com.liferay.portal.xml.SAXReaderImpl.read(SAXReaderImpl.java:403)
    ... 34 more

While running the db script, I receive the above error.
As a pre requisite tried checking randomly on few xml based columns for nbsp string. Did not find anything.Please let me kn ow if someone has faced something similar and resolution.
thumbnail
Alberto Chaparro Terleira, modified 5 Years ago. Liferay Master Posts: 560 Join Date: 4/25/11 Recent Posts
Hi Shoaib,
Probably you have a journal article with a reference to an old DDM Structure. Please find in the journal Article records with the string "nbsp" in the content field, probably they can be removed or updated (use the UI preferably).
I hope it helps.