0

Hi all, I'm experiencing an error message in Mendix, when adding a new row to the entity 'Users' (this entity was created). While it did work, it now suddenly gives me the error given below. Regenerating the New/Edit forms does not solve the problem; The edit function does work It's not a permission problem, with all security disabled, it still gives me the following error. Error message: com.mendix.core.CoreException: Exception occurred in action '[CreateAction:: Context:Context::[Session [8791c9e6-6c0f-49b2-84e9-7c0ec57b1c1b]], objectType: +MyFirstModule.Users]', all database changes executed by this action were rolled back at com.mendix.core.actionmanagement.CoreAction.d(SourceFile:553) Caused by: com.mendix.core.CoreRuntimeException: ac: Exception occurred while inserting data. (SQL State: 42577, Error Code: -5577) at it.b(SourceFile:213) Caused by: ac: Exception occurred while inserting data. (SQL State: 42577, Error Code: -5577) Caused by: java.sql.SQLException: duplicate column name in column list: status at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source) at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source) at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:508) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:400) at aw.a(SourceFile:730) at aw.a(SourceFile:659) at aw.a(SourceFile:607) at iB.a(SourceFile:61) at aq.a(SourceFile:249) at aq.a(SourceFile:233) at aq.a(SourceFile:183) at aq.a(SourceFile:101) at jC.a(SourceFile:96) at jm.a(SourceFile:241) at bU.a(SourceFile:81) at bU.executeAction(SourceFile:26) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:49) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:473) at it.b(SourceFile:209) at bO.a(SourceFile:113) at bO.executeAction(SourceFile:30) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:49) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:473) at it.b(SourceFile:155) at com.mendix.core.Core.create(SourceFile:512) at lG.execute(SourceFile:39) at ju.a(SourceFile:299) at ju.a(SourceFile:230) at ju.processRequest(SourceFile:174) at fC.a(SourceFile:71) at com.mendix.core.MxRuntime.processRequest(SourceFile:916) at com.mendix.m2ee.server.handler.RuntimeHandler.handle(RuntimeHandler.java:42) 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:619) Caused by: org.hsqldb.HsqlException: duplicate column name in column list: status at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.ParserDQL.readSimpleColumnNames(Unknown Source) at org.hsqldb.ParserDML.compileInsertStatement(Unknown Source) at org.hsqldb.ParserCommand.compilePart(Unknown Source) at org.hsqldb.ParserCommand.compileStatement(Unknown Source) at org.hsqldb.Session.compileStatement(Unknown Source) at org.hsqldb.StatementManager.compile(Unknown Source) at org.hsqldb.Session.execute(Unknown Source) at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source) at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source) at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:508) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:400) at aw.a(SourceFile:730) at aw.a(SourceFile:659) at aw.a(SourceFile:607) at iB.a(SourceFile:61) at aq.a(SourceFile:249) at aq.a(SourceFile:233) at aq.a(SourceFile:183) at aq.a(SourceFile:101) at jC.a(SourceFile:96) at jm.a(SourceFile:241) at bU.a(SourceFile:81) at bU.executeAction(SourceFile:26) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:49) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:473) at it.b(SourceFile:209) at bO.a(SourceFile:113) at bO.executeAction(SourceFile:30) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:49) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:473) at it.b(SourceFile:155) at com.mendix.core.Core.create(SourceFile:512) at lG.execute(SourceFile:39) at ju.a(SourceFile:299) at ju.a(SourceFile:230) at ju.processRequest(SourceFile:174) at fC.a(SourceFile:71) at com.mendix.core.MxRuntime.processRequest(SourceFile:916) at com.mendix.m2ee.server.handler.RuntimeHandler.handle(RuntimeHandler.java:42) 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:619) Any solution? Jim

asked 2011-06-29

1 answers