Excel Importer not working

2
First, the Excel Importer is working OK on my development laptop, but will not work on my production server :( When I try to create a new mapping from an Excel file I get the following in the Log file: 2010-12-09 11:31:41.189 ERROR - M2EE: An unhandled error occurred in the MxRuntime. 2010-12-09 11:31:41.189 ERROR M2EEjava.lang.NoClassDefFoundError: replication/interfaces/IValueParser at excelimporter.reader.ExcelImporter.getColumns(ExcelImporter.java:53) at excelimporter.actions.GetHeaderInformationFromExcelFile.executeAction(GetHeaderInformationFromExcelFile.java:42) at excelimporter.actions.GetHeaderInformationFromExcelFile.executeAction(GetHeaderInformationFromExcelFile.java:1) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:49) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:473) at iu.b(SourceFile:155) at com.mendix.core.Core.execute(SourceFile:187) at hg.a(SourceFile:70) at kW.a(SourceFile:66) at eO.executeAction(SourceFile:96) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:49) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:473) at iu.b(SourceFile:155) at com.mendix.core.Core.execute(SourceFile:187) at dx.execute(SourceFile:183) at jy.a(SourceFile:300) at jy.a(SourceFile:232) at jy.processRequest(SourceFile:183) at fA.a(SourceFile:75) at com.mendix.core.MxRuntime.processRequest(SourceFile:893) at com.mendix.m2ee.server.handler.RuntimeHandler.handle(RuntimeHandler.java:40) 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:203) 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(Unknown Source) Caused by: java.lang.ClassNotFoundException: replication.interfaces.IValueParser at java.net.URLClassLoader$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClassInternal(Unknown Source) at excelimporter.reader.ExcelImporter.getColumns(ExcelImporter.java:53) at excelimporter.actions.GetHeaderInformationFromExcelFile.executeAction(GetHeaderInformationFromExcelFile.java:42) at excelimporter.actions.GetHeaderInformationFromExcelFile.executeAction(GetHeaderInformationFromExcelFile.java:1) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:49) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:473) at iu.b(SourceFile:155) at com.mendix.core.Core.execute(SourceFile:187) at hg.a(SourceFile:70) at kW.a(SourceFile:66) at eO.executeAction(SourceFile:96) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:49) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:473) at iu.b(SourceFile:155) at com.mendix.core.Core.execute(SourceFile:187) at dx.execute(SourceFile:183) at jy.a(SourceFile:300) at jy.a(SourceFile:232) at jy.processRequest(SourceFile:183) at fA.a(SourceFile:75) at com.mendix.core.MxRuntime.processRequest(SourceFile:893) at com.mendix.m2ee.server.handler.RuntimeHandler.handle(RuntimeHandler.java:40) 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:203) 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(Unknown Source) If I manually create the mapping, upload my excel file and trigger the import, I get similar errors: 2010-12-09 11:28:06.408 ERROR - M2EE: An unhandled error occurred in the MxRuntime. 2010-12-09 11:28:06.408 ERROR M2EEjava.lang.NoClassDefFoundError: replication/interfaces/IValueParser at excelimporter.reader.ExcelImporter.startImport(ExcelImporter.java:124) at excelimporter.actions.StartImportByTemplate.executeAction(StartImportByTemplate.java:53) at excelimporter.actions.StartImportByTemplate.executeAction(StartImportByTemplate.java:1) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:49) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:473) at iu.b(SourceFile:155) at com.mendix.core.Core.execute(SourceFile:187) at hg.a(SourceFile:70) at kW.a(SourceFile:66) at eO.executeAction(SourceFile:96) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:49) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:473) at iu.b(SourceFile:155) at com.mendix.core.Core.execute(SourceFile:187) at dx.execute(SourceFile:183) at jy.a(SourceFile:300) at jy.a(SourceFile:232) at jy.processRequest(SourceFile:183) at fA.a(SourceFile:75) at com.mendix.core.MxRuntime.processRequest(SourceFile:893) at com.mendix.m2ee.server.handler.RuntimeHandler.handle(RuntimeHandler.java:40) 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:203) 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(Unknown Source) Caused by: java.lang.ClassNotFoundException: replication.interfaces.IValueParser at java.net.URLClassLoader$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClassInternal(Unknown Source) at excelimporter.reader.ExcelImporter.startImport(ExcelImporter.java:124) at excelimporter.actions.StartImportByTemplate.executeAction(StartImportByTemplate.java:53) at excelimporter.actions.StartImportByTemplate.executeAction(StartImportByTemplate.java:1) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:49) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:473) at iu.b(SourceFile:155) at com.mendix.core.Core.execute(SourceFile:187) at hg.a(SourceFile:70) at kW.a(SourceFile:66) at eO.executeAction(SourceFile:96) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:49) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:473) at iu.b(SourceFile:155) at com.mendix.core.Core.execute(SourceFile:187) at dx.execute(SourceFile:183) at jy.a(SourceFile:300) at jy.a(SourceFile:232) at jy.processRequest(SourceFile:183) at fA.a(SourceFile:75) at com.mendix.core.MxRuntime.processRequest(SourceFile:893) at com.mendix.m2ee.server.handler.RuntimeHandler.handle(RuntimeHandler.java:40) 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:203) 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(Unknown Source) As I mentioned, this works fine on my laptop, and the replication.jar file is the same on both machines. EDIT: Could this have something to do with the configuration of the ManagedFusionRewriter? I have never got this configured properly on this server, so I am connecting through http://webservername:8088 EDIT: I have tried this on a 2nd server and have the same issue.
asked
2 answers
4

This problem arises when the userlib isn't correctly added to the classpath. You need to explicitly check that

<myprojectdir>/model/lib/userlib/*

is on the classpath (Note the "*" at the end!). This will add all the jar files. I don't know where you're hosting your project, if it's with us we can help you with this, just send your contact person an email.

This is an issue with some older mendix service consoles and other start scripts, you should either update your scripts to use userlib/* or download the latest mendix service console from our documentation pages.

answered
1

Do you have replication.jar in your userlib directory? Looks like that is missing.

answered