0

When selecting a parser microflow with string-input & String-output for a String-type attribute everything works fine. When selecting a parser microflow with int/long-input & int/long-output for an integer-type attribute an error occurs. Depending on the number of columns in the uploaded excel sheet the error refers to a particular cell. The int/long input/output parser I selected was used on the 2nd column of an excel sheet with 4 columns giving "Error found in row of cell nr: D2". Removing to columns gives rise to "Error found in row of cell nr: B2". When selecting a parser microflow with Date/time-input & Date/time-output for a Date/time-type attribute no problems occur. Question: why only trouble with int/long; is there a work-around available? Stack Trace: An error has occurred while handling the request. [User 'Anonymous_168f9028-5272-4e27-9c76-fe479d0ce240' with roles 'Administrator'] lg: com.mendix.core.CoreException: Document could not be imported, because: Unable to store Excel row. Error found in row of cell nr: B2 at ExcelImporter.IVK_ImportTemplateDocument (JavaAction : 'Call 'StartImportByTemplate'') Advanced stacktrace: at mz.a(SourceFile:188) Caused by: com.mendix.core.CoreException: com.mendix.core.CoreException: Document could not be imported, because: Unable to store Excel row. Error found in row of cell nr: B2 at excelimporter.reader.ExcelImporter.startImport(ExcelImporter.java:135 Caused by: com.mendix.core.CoreException: Document could not be imported, because: Unable to store Excel row. Error found in row of cell nr: B2 at excelimporter.reader.readers.ExcelReader.importData(ExcelReader.java:390) Caused by: org.xml.sax.SAXException: Unable to store Excel row. Error found in row of cell nr: B2 at excelimporter.reader.readers.ExcelXLSXDataReader$SheetHandler.endElement(ExcelXLSXDataReader.java:308) at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source) at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at excelimporter.reader.readers.ExcelXLSXDataReader.readData(ExcelXLSXDataReader.java:50) at excelimporter.reader.readers.ExcelReader.importData(ExcelReader.java:381) at excelimporter.reader.ExcelImporter.startImport(ExcelImporter.java:125) at excelimporter.actions.StartImportByTemplate.executeAction(StartImportByTemplate.java:53) at excelimporter.actions.StartImportByTemplate.executeAction(StartImportByTemplate.java:1) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:48) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:435) at hj.b(SourceFile:156) at com.mendix.core.Core.execute(SourceFile:212) at ln.a(SourceFile:70) at mz.a(SourceFile:73) at my.executeAction(SourceFile:101) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:48) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:435) at hj.b(SourceFile:156) at com.mendix.core.Core.execute(SourceFile:212) at gc.execute(SourceFile:184) at iH.a(SourceFile:311) at iH.a(SourceFile:240) at iH.processRequest(SourceFile:179) at iK.a(SourceFile:71) at com.mendix.core.MxRuntime.processRequest(SourceFile:856) at com.mendix.m2ee.server.handler.RuntimeHandler.handle(RuntimeHandler.java:43) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:113) at org.eclipse.jetty.server.Server.handle(Server.java:334) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:559) at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1007) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:747) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:209) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:406) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:462) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:436) at java.lang.Thread.run(Thread.java:662) Caused by: replication.ValueParser$ParseException: The value in column: 1 was processed by a microflow. But an invalid value was returned, the type was expected to be a Integer but the returned value is of type: Long at excelimporter.reader.readers.replication.ExcelValueParser.getValue(ExcelValueParser.java:140) at excelimporter.reader.readers.ExcelRowProcessor.processValues(ExcelRowProcessor.java:48) at excelimporter.reader.readers.ExcelXLSXDataReader$SheetHandler.endElement(ExcelXLSXDataReader.java:306) at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source) at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at excelimporter.reader.readers.ExcelXLSXDataReader.readData(ExcelXLSXDataReader.java:50) at excelimporter.reader.readers.ExcelReader.importData(ExcelReader.java:381) at excelimporter.reader.ExcelImporter.startImport(ExcelImporter.java:125) at excelimporter.actions.StartImportByTemplate.executeAction(StartImportByTemplate.java:53) at excelimporter.actions.StartImportByTemplate.executeAction(StartImportByTemplate.java:1) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:48) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:435) at hj.b(SourceFile:156) at com.mendix.core.Core.execute(SourceFile:212) at ln.a(SourceFile:70) at mz.a(SourceFile:73) at my.executeAction(SourceFile:101) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:48) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:435) at hj.b(SourceFile:156) at com.mendix.core.Core.execute(SourceFile:212) at gc.execute(SourceFile:184) at iH.a(SourceFile:311) at iH.a(SourceFile:240) at iH.processRequest(SourceFile:179) at iK.a(SourceFile:71) at com.mendix.core.MxRuntime.processRequest(SourceFile:856) at com.mendix.m2ee.server.handler.RuntimeHandler.handle(RuntimeHandler.java:43) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:113) at org.eclipse.jetty.server.Server.handle(Server.java:334) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:559) at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1007) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:747) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:209) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:406) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:462) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:436) at java.lang.Thread.run(Thread.java:662)

asked 2012-07-13

1 answers