[opencms-dev] OpenCms 5, Database import SAXParseExceptioin

[Christian Steinert]

You should look for null bytes 0x00 in your exported files and remove them before trying the import again.
Older versions of jtidy had the habit of sometimes introducing them.

Best Regards
Christian

> 
> Hello everyone,
> for a migration-project I needed to install an OpenCms Version 5.0.1 (tomcat
> 4.1.39 , MySql 4.0.27, 
> j2sdk1.4.2_19). When I try to import the the old database (-export) I get
> the below standing error-
> message.
> I made an export of the db myself (just from the documentation-folder) which
> I can re-import without
> any problems.
> Does anybody have a clue what's goin on?
> Thank you and greetings
> Marc Johnen
> 
> Importing database ...
> Exception com.opencms.core.CmsException: 0 Unknown exception. Detailed
> error: CmsException ID: 0.
> root cause was org.xml.sax.SAXParseException: An invalid XML character
> (Unicode: 0x0) was found in the CDATA section.
> at
> com.opencms.file.genericSql.CmsResourceBroker.getFirstTagFromManifest(CmsResourceBroker.java:8078)
> at
> com.opencms.file.genericSql.CmsResourceBroker.importResources(CmsResourceBroker.java:4150)
> at com.opencms.file.CmsObject.importResources(CmsObject.java:2167)
> at
> com.opencms.workplace.CmsAdminDatabaseImportThread.run(CmsAdminDatabaseImportThread.java:74)
> >-----------
> >Root cause:
> >org.xml.sax.SAXParseException: An invalid XML character (Unicode: 0x0) was
> found in the CDATA section.
> > at org.apache.xerces.framework.XMLParser.reportError(XMLParser.java:1213)
> > at
> > org.apache.xerces.framework.XMLDocumentScanner.reportFatalXMLError(XMLDocumentScanner.java:588)
> > at
> > org.apache.xerces.framework.XMLDocumentScanner$ContentDispatcher.dispatch(XMLDocumentScanner.java:1300)
> > at
> > org.apache.xerces.framework.XMLDocumentScanner.parseSome(XMLDocumentScanner.java:381)
> > at org.apache.xerces.framework.XMLParser.parse(XMLParser.java:1098)
> > at
> > com.opencms.template.CmsXmlXercesParser.parse(CmsXmlXercesParser.java:173)
> > at
> > com.opencms.template.CmsXmlXercesParser.parse(CmsXmlXercesParser.java:151)
> > at
> > com.opencms.file.genericSql.CmsResourceBroker.getFirstTagFromManifest(CmsResourceBroker.java:8074)
> > at
> > com.opencms.file.genericSql.CmsResourceBroker.importResources(CmsResourceBroker.java:4150)
> > at com.opencms.file.CmsObject.importResources(CmsObject.java:2167)
> > at
> > com.opencms.workplace.CmsAdminDatabaseImportThread.run(CmsAdminDatabaseImportThread.java:74)
> org.xml.sax.SAXParseException: An invalid XML character (Unicode: 0x0) was
> found in the CDATA section.
> at org.apache.xerces.framework.XMLParser.reportError(XMLParser.java:1213)
> at
> org.apache.xerces.framework.XMLDocumentScanner.reportFatalXMLError(XMLDocumentScanner.java:588)
> at
> org.apache.xerces.framework.XMLDocumentScanner$ContentDispatcher.dispatch(XMLDocumentScanner.java:1300)
> at
> org.apache.xerces.framework.XMLDocumentScanner.parseSome(XMLDocumentScanner.java:381)
> at org.apache.xerces.framework.XMLParser.parse(XMLParser.java:1098)
> at
> com.opencms.template.CmsXmlXercesParser.parse(CmsXmlXercesParser.java:173)
> at
> com.opencms.template.CmsXmlXercesParser.parse(CmsXmlXercesParser.java:151)
> at
> com.opencms.file.genericSql.CmsResourceBroker.getFirstTagFromManifest(CmsResourceBroker.java:8074)
> at
> com.opencms.file.genericSql.CmsResourceBroker.importResources(CmsResourceBroker.java:4150)
> at com.opencms.file.CmsObject.importResources(CmsObject.java:2167)
> at
> com.opencms.workplace.CmsAdminDatabaseImportThread.run(CmsAdminDatabaseImportThread.java:74)
> -- 
> View this message in context: http://www.nabble.com/OpenCms-5%2C-Database-import-SAXParseExceptioin-tp22440838p22440838.html
> Sent from the OpenCMS - Dev mailing list archive at Nabble.com.
> 
> 
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev
> 


____________________________________________________________________
Psssst! Schon vom neuen WEB.DE MultiMessenger gehört? 
Der kann`s mit allen: http://www.produkte.web.de/messenger/?did=3123