Unknown column 'awop' in 'field list' using MySQL

Forum > Integration & Database > Unknown column 'awop' in 'field list' using MySQL

n/A

postedon November 26, 2015at 10:15 AM

Version 6.2.10

Hi
if I try to store a Dataclass into a MySQL DB I receive sometimes the error message: Unknown column 'awop' in 'field list'.
Caused by: com.nm.sdk.NmEvaluatorException: Could not save structure to datasource 'bank'. java.sql.SQLException: Unknown column 'awop' in 'field list' Query: INSERT INTO "person"("awid",
While the error message is right, since there is no row awop, I have no clue where the awop is coming from. I use the SaveDataEntity so it is a generated insert Statement. Does anyone have a similar experience?

n/A

repliedon November 26, 2015at 2:45 PM

-============ Service Call Log END 131 ============-
ERROR [http-bio-127.0.0.1-8080-exec-7] com.nm.extensions.datastore.functions.SaveDataEntityFunction - Could not save structure to datasource 'bank'. java.sql.SQLException: Unknown column 'awop' in 'field list' Query: INSERT INTO "person"("awid","firstName","lastName","isOFACBolcked","nationality","passportNR","dateOfBirth","isPep") VALUES(?,?,?,?,?,?,?,?) Parameters: [2, Eric, Euerlings, false, CH, CH15563242, 3279600000, false]
java.sql.SQLException: Unknown column 'awop' in 'field list' Query: INSERT INTO "person"("awid","firstName","lastName","isOFACBolcked","nationality","passportNR","dateOfBirth","isPep") VALUES(?,?,?,?,?,?,?,?) Parameters: [2, Eric, Euerlings, false, CH, CH15563242, 3279600000, false]
at org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:363)
at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:490)
at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:403)
at com.nm.extensions.datastore.DBUtils.insertDataObject(DBUtils.java:664)
at com.nm.extensions.datastore.DBUtils.saveDataObject(DBUtils.java:777)
at com.nm.extensions.datastore.functions.SaveDataEntityFunction.calculate(SaveDataEntityFunction.java:57)
at com.nm.sdk.data.expeval.MethodCallUtils.callScriptFunction(MethodCallUtils.java:175)
at com.nm.sdk.data.expeval.nodes.FunctionNode.execute(FunctionNode.java:471)
at com.nm.sdk.data.expeval.nodes.ScriptBodyNode.execute(ScriptBodyNode.java:170)
at com.nm.exprlang.InterpreterImpl.execute(InterpreterImpl.java:405)
at com.nm.exprlang.InterpreterImpl.interpret(InterpreterImpl.java:372)
at com.nm.exprlang.InterpreterImpl.interpret(InterpreterImpl.java:359)
at com.nm.exprlang.InterpreterImpl.interpret(InterpreterImpl.java:314)
at com.nm.sdk.data.pages.views.actions.ExpressionAction.execute(ExpressionAction.java:76)
at com.nm.sdk.data.pages.views.components.Component.handleEvent(Component.java:524)
at com.nm.sdk.data.pages.views.components.Component.handleEvents(Component.java:491)
at com.nm.sdk.data.pages.views.components.Component.process(Component.java:464)
at com.nm.sdk.data.pages.views.components.If.processComponent(If.java:89)
at com.nm.sdk.data.pages.views.components.Component.process(Component.java:465)
at com.nm.sdk.data.pages.views.components.Container.processChildren(Container.java:367)
at com.nm.sdk.data.pages.views.components.Container.processComponent(Container.java:362)
at com.nm.sdk.data.pages.views.components.Component.process(Component.java:465)
at com.nm.sdk.data.pages.views.components.CustomContainer.processComponent(CustomContainer.java:202)
at com.nm.sdk.data.pages.views.components.Component.process(Component.java:465)
at com.nm.sdk.data.pages.views.components.Container.processChildren(Container.java:367)
at com.nm.sdk.data.pages.views.components.TemplateArea.processComponent(TemplateArea.java:57)
at com.nm.sdk.data.pages.views.components.Component.process(Component.java:465)
at com.nm.sdk.data.pages.views.components.Placeholder.processComponent(Placeholder.java:93)
at com.nm.sdk.data.pages.views.components.Component.process(Component.java:465)
at com.nm.sdk.data.pages.views.components.Container.processChildren(Container.java:367)
at com.nm.sdk.data.pages.views.components.Container.processComponent(Container.java:362)
at com.nm.sdk.data.pages.views.components.Component.process(Component.java:465)
at com.nm.extensions.widgets.borderlayoutmanager.BorderLayoutManager.processChildren(BorderLayoutManager.java:80)
at com.nm.sdk.data.pages.views.components.Container.processComponent(Container.java:362)
at com.nm.sdk.data.pages.views.components.Component.process(Component.java:465)
at com.nm.sdk.data.pages.views.components.CustomContainer.processComponent(CustomContainer.java:202)
at com.nm.sdk.data.pages.views.components.Component.process(Component.java:465)
at com.nm.sdk.data.pages.views.components.Container.processChildren(Container.java:367)
at com.nm.sdk.data.pages.views.components.Container.processComponent(Container.java:362)
at com.nm.sdk.data.pages.views.components.Component.process(Component.java:465)
at com.nm.sdk.data.pages.views.components.Template.processComponent(Template.java:220)
at com.nm.sdk.data.pages.views.components.Component.process(Component.java:465)
at com.nm.sdk.data.pages.views.components.Container.processChildren(Container.java:367)
at com.nm.sdk.data.pages.views.components.Container.processComponent(Container.java:362)
at com.nm.sdk.data.pages.views.components.Component.process(Component.java:465)
at com.nm.screenflow.PageServiceImpl.processPageResponse(PageServiceImpl.java:961)
at com.nm.sdk.data.workflow.model.ScreenTask.processHttpRequest(ScreenTask.java:458)
at com.nm.workspace.ProcessServlet.processWorkflowToken(ProcessServlet.java:598)
at com.nm.workspace.ProcessServlet.processWorkitem(ProcessServlet.java:314)
at com.nm.workspace.ProcessServlet.doPost(ProcessServlet.java:132)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at com.nm.servlets.AbstractHttpServlet.service(AbstractHttpServlet.java:24)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.nm.filter.AppwayServletsFilter.doFilter(AppwayServletsFilter.java:38)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.nm.filter.AppwayFilterChain.doFilter(AppwayFilterChain.java:47)
at com.nm.filter.VersioningFilter.doFilter(VersioningFilter.java:85)
at com.nm.filter.AppwayFilterChain.doFilter(AppwayFilterChain.java:43)
at com.nm.filter.AccessControlFilter.doFilter(AccessControlFilter.java:69)
at com.nm.filter.AppwayFilterChain.doFilter(AppwayFilterChain.java:43)
at com.nm.filter.ApplicationLockFilter.doFilter(ApplicationLockFilter.java:96)
at com.nm.filter.AppwayFilterChain.doFilter(AppwayFilterChain.java:43)
at com.nm.filter.ContextPathFilter.doFilter(ContextPathFilter.java:46)
at com.nm.filter.AppwayFilterChain.doFilter(AppwayFilterChain.java:43)
at com.nm.filter.CacheFilter.doFilter(CacheFilter.java:94)
at com.nm.filter.AppwayFilterChain.doFilter(AppwayFilterChain.java:43)
at com.nm.filter.FileUploadFilter.doFilter(FileUploadFilter.java:68)
at com.nm.filter.AppwayFilterChain.doFilter(AppwayFilterChain.java:43)
at com.nm.filter.UserFilter.doFilter(UserFilter.java:297)
at com.nm.filter.AppwayFilterChain.doFilter(AppwayFilterChain.java:43)
at com.nm.cluster.filter.PrintRequestFilter.doFilter(PrintRequestFilter.java:59)
at com.nm.filter.AppwayFilterChain.doFilter(AppwayFilterChain.java:43)
at com.nm.cluster.filter.ClusterFilter.doFilter(ClusterFilter.java:29)
at com.nm.filter.AppwayFilterChain.doFilter(AppwayFilterChain.java:43)
at com.nm.filter.ErrorFilter.doFilter(ErrorFilter.java:48)
at com.nm.filter.AppwayFilterChain.doFilter(AppwayFilterChain.java:43)
at com.nm.filter.DebugFilter.doFilter(DebugFilter.java:96)
at com.nm.filter.AppwayFilterChain.doFilter(AppwayFilterChain.java:43)
at com.nm.filter.StartupShutdownFilter.doFilter(StartupShutdownFilter.java:98)
at com.nm.filter.AppwayFilterChain.doFilter(AppwayFilterChain.java:43)
at com.nm.filter.MasterPasswordFilter.doFilter(MasterPasswordFilter.java:89)
at com.nm.filter.AppwayFilterChain.doFilter(AppwayFilterChain.java:43)
at com.nm.filter.ThreadLocalFilter.doFilter(ThreadLocalFilter.java:37)
at com.nm.filter.AppwayFilterChain.doFilter(AppwayFilterChain.java:43)
at com.nm.filter.EncodingFilter.doFilter(EncodingFilter.java:71)
at com.nm.filter.AppwayFilterChain.doFilter(AppwayFilterChain.java:43)
at com.nm.filter.AppwayFiltersFilter.doFilter(AppwayFiltersFilter.java:39)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
2015-11-26 14:40:03,662 WARN [http-bio-127.0.0.1-8080-exec-7] com.nm.sdk.data.pages.views.components.Component - Component Service Error: com.nm.sdk.data.pages.views.components.Button (Screen: PersonScreen > BankTemplate, Component: 18)
com.nm.sdk.NmRuntimeException: Expression Action Execution Error: SaveDataEntity($person, 'bank', true);
at com.nm.sdk.data.pages.views.actions.ExpressionAction.execute(ExpressionAction.java:82)
at com.nm.sdk.data.pages.views.components.Component.handleEvent(Component.java:524)
at com.nm.sdk.data.pages.views.components.Component.handleEvents(Component.java:491)
at com.nm.sdk.data.pages.views.components.Component.process(Component.java:464)
at com.nm.sdk.data.pages.views.components.If.processComponent(If.java:89)
at com.nm.sdk.data.pages.views.components.Component.process(Component.java:465)
at com.nm.sdk.data.pages.views.components.Container.processChildren(Container.java:367)
at com.nm.sdk.data.pages.views.components.Container.processComponent(Container.java:362)
at com.nm.sdk.data.pages.views.components.Component.process(Component.java:465)
at com.nm.sdk.data.pages.views.components.CustomContainer.processComponent(CustomContainer.java:202)
at com.nm.sdk.data.pages.views.components.Component.process(Component.java:465)
at com.nm.sdk.data.pages.views.components.Container.processChildren(Container.java:367)
at com.nm.sdk.data.pages.views.components.TemplateArea.processComponent(TemplateArea.java:57)
at com.nm.sdk.data.pages.views.components.Component.process(Component.java:465)
at com.nm.sdk.data.pages.views.components.Placeholder.processComponent(Placeholder.java:93)
at com.nm.sdk.data.pages.views.components.Component.process(Component.java:465)
at com.nm.sdk.data.pages.views.components.Container.processChildren(Container.java:367)
at com.nm.sdk.data.pages.views.components.Container.processComponent(Container.java:362)
at com.nm.sdk.data.pages.views.components.Component.process(Component.java:465)
at com.nm.extensions.widgets.borderlayoutmanager.BorderLayoutManager.processChildren(BorderLayoutManager.java:80)
at com.nm.sdk.data.pages.views.components.Container.processComponent(Container.java:362)
at com.nm.sdk.data.pages.views.components.Component.process(Component.java:465)
at com.nm.sdk.data.pages.views.components.CustomContainer.processComponent(CustomContainer.java:202)
at com.nm.sdk.data.pages.views.components.Component.process(Component.java:465)
at com.nm.sdk.data.pages.views.components.Container.processChildren(Container.java:367)
at com.nm.sdk.data.pages.views.components.Container.processComponent(Container.java:362)
at com.nm.sdk.data.pages.views.components.Component.process(Component.java:465)
at com.nm.sdk.data.pages.views.components.Template.processComponent(Template.java:220)
at com.nm.sdk.data.pages.views.components.Component.process(Component.java:465)
at com.nm.sdk.data.pages.views.components.Container.processChildren(Container.java:367)
at com.nm.sdk.data.pages.views.components.Container.processComponent(Container.java:362)
at com.nm.sdk.data.pages.views.components.Component.process(Component.java:465)
at com.nm.screenflow.PageServiceImpl.processPageResponse(PageServiceImpl.java:961)
at com.nm.sdk.data.workflow.model.ScreenTask.processHttpRequest(ScreenTask.java:458)
at com.nm.workspace.ProcessServlet.processWorkflowToken(ProcessServlet.java:598)
at com.nm.workspace.ProcessServlet.processWorkitem(ProcessServlet.java:314)
at com.nm.workspace.ProcessServlet.doPost(ProcessServlet.java:132)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at com.nm.servlets.AbstractHttpServlet.service(AbstractHttpServlet.java:24)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.nm.filter.AppwayServletsFilter.doFilter(AppwayServletsFilter.java:38)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.nm.filter.AppwayFilterChain.doFilter(AppwayFilterChain.java:47)
at com.nm.filter.VersioningFilter.doFilter(VersioningFilter.java:85)
at com.nm.filter.AppwayFilterChain.doFilter(AppwayFilterChain.java:43)
at com.nm.filter.AccessControlFilter.doFilter(AccessControlFilter.java:69)
at com.nm.filter.AppwayFilterChain.doFilter(AppwayFilterChain.java:43)
at com.nm.filter.ApplicationLockFilter.doFilter(ApplicationLockFilter.java:96)
at com.nm.filter.AppwayFilterChain.doFilter(AppwayFilterChain.java:43)
at com.nm.filter.ContextPathFilter.doFilter(ContextPathFilter.java:46)
at com.nm.filter.AppwayFilterChain.doFilter(AppwayFilterChain.java:43)
at com.nm.filter.CacheFilter.doFilter(CacheFilter.java:94)
at com.nm.filter.AppwayFilterChain.doFilter(AppwayFilterChain.java:43)
at com.nm.filter.FileUploadFilter.doFilter(FileUploadFilter.java:68)
at com.nm.filter.AppwayFilterChain.doFilter(AppwayFilterChain.java:43)
at com.nm.filter.UserFilter.doFilter(UserFilter.java:297)
at com.nm.filter.AppwayFilterChain.doFilter(AppwayFilterChain.java:43)
at com.nm.cluster.filter.PrintRequestFilter.doFilter(PrintRequestFilter.java:59)
at com.nm.filter.AppwayFilterChain.doFilter(AppwayFilterChain.java:43)
at com.nm.cluster.filter.ClusterFilter.doFilter(ClusterFilter.java:29)
at com.nm.filter.AppwayFilterChain.doFilter(AppwayFilterChain.java:43)
at com.nm.filter.ErrorFilter.doFilter(ErrorFilter.java:48)
at com.nm.filter.AppwayFilterChain.doFilter(AppwayFilterChain.java:43)
at com.nm.filter.DebugFilter.doFilter(DebugFilter.java:96)
at com.nm.filter.AppwayFilterChain.doFilter(AppwayFilterChain.java:43)
at com.nm.filter.StartupShutdownFilter.doFilter(StartupShutdownFilter.java:98)
at com.nm.filter.AppwayFilterChain.doFilter(AppwayFilterChain.java:43)
at com.nm.filter.MasterPasswordFilter.doFilter(MasterPasswordFilter.java:89)
at com.nm.filter.AppwayFilterChain.doFilter(AppwayFilterChain.java:43)
at com.nm.filter.ThreadLocalFilter.doFilter(ThreadLocalFilter.java:37)
at com.nm.filter.AppwayFilterChain.doFilter(AppwayFilterChain.java:43)
at com.nm.filter.EncodingFilter.doFilter(EncodingFilter.java:71)
at com.nm.filter.AppwayFilterChain.doFilter(AppwayFilterChain.java:43)
at com.nm.filter.AppwayFiltersFilter.doFilter(AppwayFiltersFilter.java:39)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.nm.sdk.NmEvaluatorException: Could not save structure to datasource 'bank'. java.sql.SQLException: Unknown column 'awop' in 'field list' Query: INSERT INTO "person"("awid","firstName","lastName","isOFACBolcked","nationality","passportNR","dateOfBirth","isPep") VALUES(?,?,?,?,?,?,?,?) Parameters: [2, Eric, Euerlings, false, CH, CH15563242, 3279600000, false] [token:SaveDataEntity, line:1, charpos:0, scope:null, location:LocationPath[ObjectRef-Workflow-AddPerson,elements/6,ObjectRef-Screen-PersonScreen,components/24,ObjectRef-Screen-BankTemplate,components/12,ObjectRef-Screen-PersonScreen,components/18:actions/onclick/0/property/expression]]
at com.nm.extensions.datastore.functions.SaveDataEntityFunction.calculate(SaveDataEntityFunction.java:64)
at com.nm.sdk.data.expeval.MethodCallUtils.callScriptFunction(MethodCallUtils.java:175)
at com.nm.sdk.data.expeval.nodes.FunctionNode.execute(FunctionNode.java:471)
at com.nm.sdk.data.expeval.nodes.ScriptBodyNode.execute(ScriptBodyNode.java:170)
at com.nm.exprlang.InterpreterImpl.execute(InterpreterImpl.java:405)
at com.nm.exprlang.InterpreterImpl.interpret(InterpreterImpl.java:372)
at com.nm.exprlang.InterpreterImpl.interpret(InterpreterImpl.java:359)
at com.nm.exprlang.InterpreterImpl.interpret(InterpreterImpl.java:314)
at com.nm.sdk.data.pages.views.actions.ExpressionAction.execute(ExpressionAction.java:76)
... 92 more
Caused by: java.sql.SQLException: Unknown column 'awop' in 'field list' Query: INSERT INTO "person"("awid","firstName","lastName","isOFACBolcked","nationality","passportNR","dateOfBirth","isPep") VALUES(?,?,?,?,?,?,?,?) Parameters: [2, Eric, Euerlings, false, CH, CH15563242, 3279600000, false]
at org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:363)
at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:490)
at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:403)
at com.nm.extensions.datastore.DBUtils.insertDataObject(DBUtils.java:664)
at com.nm.extensions.datastore.DBUtils.saveDataObject(DBUtils.java:777)
at com.nm.extensions.datastore.functions.SaveDataEntityFunction.calculate(SaveDataEntityFunction.java:57)
... 100 more

The code executed is this:

SaveDataEntity($person, 'bank', true)

Please sign in to add a reply