LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: lae_errors

This post has been created for discussion of error code brain.node.office.excel.mismatchedNamedMetadata.

Please reply to this thread with any description of error conditions, diagnostic information, and recommended resolutions.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: s_oosting

Hi,

I'm trying to publish a table in Excel. But it won't work. The error logfile I have is the following:

Error loading log for node: Output Excel
Log file: temp.nlmaincx06.21344.292.1478599522984.5821a3173a 343e8f.log
Path: c:\Lavastorm\LAETemp\tmp\admin\POS+analyse+Decathl on\default\temp.nlmaincx06.21344.292.1478599522984 .5821a3173a343e8f.log
A SAX parsing error occurred while reading null at line 32 column 80: Unable to add tag (logEvent) to tag (record).

At Line 32, Column 80.

Stack Trace:
com.lavastorm.logging.format.xml.XmlSaxLogReader.p lay(XmlSaxLogReader.java:78))
com.lavastorm.logging.logViewer.LogViewer.loadLog( LogViewer.java:207))
com.lavastorm.logging.logViewer.LogViewer.loadNode Logs(LogViewer.java:493))
com.lavastorm.logging.logViewer.LogViewer.loadLogs FromConfig(LogViewer.java:245))
com.lavastorm.logging.logViewer.LogViewer.loadLogs FromConfig(LogViewer.java:213))
com.lavastorm.logging.logViewer.LogViewer.main(Log Viewer.java:653))
Caused by: Unable to add tag (logEvent) to tag (record).

At Line 32, Column 80.

Stack Trace:
com.lavastorm.logging.format.xml.SAXParseException Generator.illegalTagException(SAXParseExceptionGen erator.java:111))
com.lavastorm.logging.format.xml.XmlLogElement.ill egalTagException(XmlLogElement.java:29))
com.lavastorm.logging.format.xml.v1.XmlLogRecordDe tailV1.add(XmlLogRecordDetailV1.java:72))
com.lavastorm.logging.format.xml.XmlSaxHandler.sta rtElement(XmlSaxHandler.java:121))
com.sun.org.apache.xerces.internal.parsers.Abstrac tSAXParser.startElement(AbstractSAXParser.java:509 ))
com.sun.org.apache.xerces.internal.impl.xs.XMLSche maValidator.startElement(XMLSchemaValidator.java:7 49))
com.sun.org.apache.xerces.internal.impl.XMLDocumen tFragmentScannerImpl.scanStartElement(XMLDocumentF ragmentScannerImpl.java:1362))
com.sun.org.apache.xerces.internal.impl.XMLDocumen tFragmentScannerImpl$FragmentContentDriver.next(XM LDocumentFragmentScannerImpl.java:2770))
com.sun.org.apache.xerces.internal.impl.XMLDocumen tScannerImpl.next(XMLDocumentScannerImpl.java:606) )
com.sun.org.apache.xerces.internal.impl.XMLDocumen tFragmentScannerImpl.scanDocument(XMLDocumentFragm entScannerImpl.java:510))
com.sun.org.apache.xerces.internal.parsers.XML11Co nfiguration.parse(XML11Configuration.java:848))
com.sun.org.apache.xerces.internal.parsers.XML11Co nfiguration.parse(XML11Configuration.java:777))
com.sun.org.apache.xerces.internal.parsers.XMLPars er.parse(XMLParser.java:141))
com.sun.org.apache.xerces.internal.parsers.Abstrac tSAXParser.parse(AbstractSAXParser.java:1213))
com.sun.org.apache.xerces.internal.jaxp.SAXParserI mpl$JAXPSAXParser.parse(SAXParserImpl.java:649))
com.lavastorm.logging.format.xml.XmlSaxLogReader.p lay(XmlSaxLogReader.java:70))
com.lavastorm.logging.logViewer.LogViewer.loadLog( LogViewer.java:207))
com.lavastorm.logging.logViewer.LogViewer.loadNode Logs(LogViewer.java:493))
com.lavastorm.logging.logViewer.LogViewer.loadLogs FromConfig(LogViewer.java:245))
com.lavastorm.logging.logViewer.LogViewer.loadLogs FromConfig(LogViewer.java:213))
com.lavastorm.logging.logViewer.LogViewer.main(Log Viewer.java:653))

Thanks in advance.

Stefano

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: awilliams1024

Hi Stefano,

I have asked my colleagues whether but there does not appear to be any specific solution to this. It may be a problem with definition of the OutputSpec.
Are you trying to write a single table to an simple Excel file or are you writing to a macro enabled file, or are you using a template file?

To better diagnose the issue, it would be useful to have a data flow with a small (sanitized) sample of your tabular data and the configured Output Excel node.

Regards,
Adrian

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: boussif1

Hi Lavastorm support,

am getting the same error when trying to load data into an SQL table.

Error loading log for node: Upload to STG Table
Log file: 1630Upload_to_STG_Table.log

A SAX parsing error occurred while reading null at line 1,135 column 73: Unable to add tag (logEvent) to tag (record).

At Line 1135, Column 73.

Stack Trace:
com.lavastorm.logging.format.xml.XmlSaxLogReader.p lay(XmlSaxLogReader.java:78))
com.lavastorm.logging.logViewer.LogViewer.loadLog( LogViewer.java:207))
com.lavastorm.logging.logViewer.LogViewer.loadNode Logs(LogViewer.java:493))
com.lavastorm.logging.logViewer.LogViewer.loadLogs FromConfig(LogViewer.java:245))
com.lavastorm.logging.logViewer.LogViewer.loadLogs FromConfig(LogViewer.java:213))
com.lavastorm.logging.logViewer.LogViewer.main(Log Viewer.java:653))
Caused by: Unable to add tag (logEvent) to tag (record).

At Line 1135, Column 73.

Stack Trace:
com.lavastorm.logging.format.xml.SAXParseException Generator.illegalTagException(SAXParseExceptionGen erator.java:111))
com.lavastorm.logging.format.xml.XmlLogElement.ill egalTagException(XmlLogElement.java:29))
com.lavastorm.logging.format.xml.v1.XmlLogRecordDe tailV1.add(XmlLogRecordDetailV1.java:72))
com.lavastorm.logging.format.xml.XmlSaxHandler.sta rtElement(XmlSaxHandler.java:121))
com.sun.org.apache.xerces.internal.parsers.Abstrac tSAXParser.startElement(AbstractSAXParser.java:509 ))
com.sun.org.apache.xerces.internal.impl.xs.XMLSche maValidator.startElement(XMLSchemaValidator.java:7 49))
com.sun.org.apache.xerces.internal.impl.XMLDocumen tFragmentScannerImpl.scanStartElement(XMLDocumentF ragmentScannerImpl.java:1362))
com.sun.org.apache.xerces.internal.impl.XMLDocumen tFragmentScannerImpl$FragmentContentDriver.next(XM LDocumentFragmentScannerImpl.java:2770))
com.sun.org.apache.xerces.internal.impl.XMLDocumen tScannerImpl.next(XMLDocumentScannerImpl.java:606) )
com.sun.org.apache.xerces.internal.impl.XMLDocumen tFragmentScannerImpl.scanDocument(XMLDocumentFragm entScannerImpl.java:510))
com.sun.org.apache.xerces.internal.parsers.XML11Co nfiguration.parse(XML11Configuration.java:848))
com.sun.org.apache.xerces.internal.parsers.XML11Co nfiguration.parse(XML11Configuration.java:777))
com.sun.org.apache.xerces.internal.parsers.XMLPars er.parse(XMLParser.java:141))
com.sun.org.apache.xerces.internal.parsers.Abstrac tSAXParser.parse(AbstractSAXParser.java:1213))
com.sun.org.apache.xerces.internal.jaxp.SAXParserI mpl$JAXPSAXParser.parse(SAXParserImpl.java:649))
com.lavastorm.logging.format.xml.XmlSaxLogReader.p lay(XmlSaxLogReader.java:70))
com.lavastorm.logging.logViewer.LogViewer.loadLog( LogViewer.java:207))
com.lavastorm.logging.logViewer.LogViewer.loadNode Logs(LogViewer.java:493))
com.lavastorm.logging.logViewer.LogViewer.loadLogs FromConfig(LogViewer.java:245))
com.lavastorm.logging.logViewer.LogViewer.loadLogs FromConfig(LogViewer.java:213))
com.lavastorm.logging.logViewer.LogViewer.main(Log Viewer.java:653))


any idea, what is causing this?