powered by Jive Software

Getting SAXParseException continously while parsing ofprivacylist data

Below is the data in postgres database which is configured in openfire -

select name, list from ofprivacylist where isdefault=1;

** name | list **

-----------------±------------------------------------------------------------- -----------------------------------------------

** spark:blackList | <list xmlns=“jabber:iq:privacy” name=“spark:blackList”><item action=“allow” order=“999999”/>**

** spark:blackList | <list xmlns=“jabber:iq:privacy” name=“spark:blackList”><item action=“allow” order=“999999”/>**

** spark:blackList | <list xmlns=“jabber:iq:privacy” name=“spark:blackList”><item action=“allow” order=“999999”/>**

** spark:blackList | <list xmlns=“jabber:iq:privacy” name=“spark:blackList”><item action=“allow” order=“999999”/>**

** spark:blackList | <list xmlns=“jabber:iq:privacy” name=“spark:blackList”><item action=“allow” order=“999999”/>**

** spark:blackList | <list xmlns=“jabber:iq:privacy” name=“spark:blackList”><item action=“allow” order=“999999”/>**

**I am getting the below error - **

2012.12.07 10:06:47 org.jivesoftware.openfire.privacy.PrivacyListProvider - Error on line 1 of document : Open quote is expected for attribute “{1}” associated with an element type “xmlns”. Nested exception: Open quote is expected for attribute “{1}” associated with an element type “xmlns”.

org.dom4j.DocumentException: Error on line 1 of document : Open quote is expected for attribute “{1}” associated with an element type “xmlns”. Nested exception: Open quote is expected for attribute “{1}” associated with an element type “xmlns”.

at org.dom4j.io.SAXReader.read(SAXReader.java:482)

at org.dom4j.io.SAXReader.read(SAXReader.java:365)

at org.jivesoftware.openfire.privacy.PrivacyListProvider.loadDefaultPrivacyList(Pr ivacyListProvider.java:242)

at org.jivesoftware.openfire.privacy.PrivacyListManager.getDefaultPrivacyList(Priv acyListManager.java:157)

at org.jivesoftware.openfire.roster.Roster.broadcastPresence(Roster.java:599)

at org.jivesoftware.openfire.handler.PresenceUpdateHandler.broadcastUpdate(Presenc eUpdateHandler.java:30

This is solved now , we migrated the data from MYSQL to postgres which added extra ‘’ in one of XML which is causing the issue. Removing the ‘’ solves it.