[opencms-dev] OpenCms 5, Database import SAXParseExceptioin

[Marc Johnen]

Thank you Christian and Jon,

it turned out, that there were indeed null-bytes in the import.

Greetings
Marc


Christian Steinert wrote:
> 
> 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
> 
> 
> _______________________________________________
> 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
> 
> 

-- 
View this message in context: http://www.nabble.com/OpenCms-5%2C-Database-import-SAXParseExceptioin-tp22440838p22667341.html
Sent from the OpenCMS - Dev mailing list archive at Nabble.com.