0

Hi, I am getting the following error while importing data using the template. n: Cannot insert the value NULL into column 'id', table 'SubTracker_Dev.dbo.pvmerge$ecprotocol'; column does not allow nulls. INSERT fails. An error has occurred while handling the request. [User 'anavi03' with roles 'TransTrackerUser, PVAdmin, PVUser'] -------- lh: com.mendix.core.CoreException: Document could not be imported, because: Could not commit the objects at ExcelImporter.IVK_ImportTemplateDocument (JavaAction : 'Call 'StartImportByTemplate'') Advanced stacktrace: at mA.a(SourceFile:188) Caused by: com.mendix.core.CoreException: com.mendix.core.CoreException: Document could not be imported, because: Could not commit the objects at excelimporter.reader.ExcelImporter.startImport(ExcelImporter.java:135) Caused by: com.mendix.core.CoreException: Document could not be imported, because: Could not commit the objects at excelimporter.reader.readers.ExcelReader.importData(ExcelReader.java:387) Caused by: replication.ReplicationSettings$MendixReplicationException: Could not commit the objects at replication.MetaInfo.storeChangedObjects(MetaInfo.java:877) Caused by: java.util.concurrent.ExecutionException: com.mendix.core.CoreException: Commit for CreateBatch failed at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:222) at java.util.concurrent.FutureTask.get(FutureTask.java:83) at replication.MetaInfo.storeChangedObjects(MetaInfo.java:869) at replication.MetaInfo.finished(MetaInfo.java:1212) at excelimporter.reader.readers.ExcelRowProcessor.finish(ExcelRowProcessor.java:89) at excelimporter.reader.readers.ExcelXLSXDataReader.readData(ExcelXLSXDataReader.java:50) at excelimporter.reader.readers.ExcelReader.importData(ExcelReader.java:378) at excelimporter.reader.ExcelImporter.startImport(ExcelImporter.java:125) at excelimporter.actions.StartImportByTemplate.executeAction(StartImportByTemplate.java:53) at excelimporter.actions.StartImportByTemplate.executeAction(StartImportByTemplate.java:24) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:48) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:435) at hk.b(SourceFile:156) at com.mendix.core.Core.execute(SourceFile:212) at lo.a(SourceFile:70) at mA.a(SourceFile:73) at mz.executeAction(SourceFile:101) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:48) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:435) at hk.b(SourceFile:156) at com.mendix.core.Core.execute(SourceFile:212) at gd.execute(SourceFile:184) at iI.a(SourceFile:311) at iI.a(SourceFile:240) at iI.processRequest(SourceFile:179) at iL.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: com.mendix.core.CoreException: Commit for CreateBatch failed at hS.a(SourceFile:77) Caused by: d: Exception occurred while inserting data. (SQL State: 23000, Error Code: 515) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert the value NULL into column 'id', table 'SubTracker_Dev.dbo.pvmerge$ecprotocol'; column does not allow nulls. INSERT fails. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:308) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at w.a(SourceFile:749) at w.a(SourceFile:701) at w.a(SourceFile:598) at w.a(SourceFile:546) at n.a(SourceFile:57) at fu.a(SourceFile:247) at fu.a(SourceFile:231) at fu.a(SourceFile:181) at fu.a(SourceFile:99) at l.a(SourceFile:94) at a.a(SourceFile:266) at hS.a(SourceFile:49) at hT.a(SourceFile:31) at hT.execute(SourceFile:15) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:435) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662)

asked 2012-08-22

1 answers