Error while deleting from the database The following error occurred while executing this line: /opt/code/main/openbravo/build.xml:490: The following error occurred while executing this line: /opt/code/main/openbravo/src-db/database/build.xml:132: org.apache.ddlutils.DatabaseOperationException: Error while deleting from the database /opt/code/main/openbravo/build.xml:568: The following error occurred while executing this line: /opt/code/main/openbravo/build.xml:490: The following error occurred while executing this line: /opt/code/main/openbravo/src-db/database/build.xml:132: org.apache.ddlutils.DatabaseOperationException: Error while deleting from the database/opt/code/main/openbravo/build.xml:568: The following error occurred while executing this line: /opt/code/main/openbravo/build.xml:490: The following error occurred while executing this line: /opt/code/main/openbravo/src-db/database/build.xml:132: org.apache.ddlutils.DatabaseOperationException: Error while deleting from the database at org.apache.tools.ant.ProjectHelper.addLocationToBuildException(ProjectHelper.java:508) at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:418) at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288) at sun.reflect.GeneratedMethodAccessor776.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.Target.execute(Target.java:357) at org.apache.tools.ant.Target.performTasks(Target.java:385) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337) at org.apache.tools.ant.Project.executeTarget(Project.java:1306) at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41) at org.apache.tools.ant.Project.executeTargets(Project.java:1189) at org.openbravo.erpCommon.utility.AntExecutor.runTask(AntExecutor.java:222) at org.openbravo.erpCommon.ad_process.ApplyModules.startApply(ApplyModules.java:221) at org.openbravo.erpCommon.ad_process.ApplyModules.doPost(ApplyModules.java:63) at javax.servlet.http.HttpServlet.service(Unknown Source) at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:225) at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:331) at javax.servlet.http.HttpServlet.service(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source) at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source) at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source) at org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:79) at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46) at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:85) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source) at org.apache.catalina.core.StandardWrapperValve.invoke(Unknown Source) at org.apache.catalina.core.StandardContextValve.invoke(Unknown Source) at org.apache.catalina.core.StandardHostValve.invoke(Unknown Source) at org.apache.catalina.valves.ErrorReportValve.invoke(Unknown Source) at org.apache.catalina.core.StandardEngineValve.invoke(Unknown Source) at org.apache.catalina.connector.CoyoteAdapter.service(Unknown Source) at org.apache.coyote.ajp.AjpAprProcessor.process(Unknown Source) at org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(Unknown Source) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(Unknown Source) at java.lang.Thread.run(Thread.java:619) Caused by: /opt/code/main/openbravo/build.xml:490: The following error occurred while executing this line: /opt/code/main/openbravo/src-db/database/build.xml:132: org.apache.ddlutils.DatabaseOperationException: Error while deleting from the database at org.apache.tools.ant.ProjectHelper.addLocationToBuildException(ProjectHelper.java:508) at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:418) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288) at sun.reflect.GeneratedMethodAccessor776.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.Target.execute(Target.java:357) at org.apache.tools.ant.Target.performTasks(Target.java:385) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337) at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38) at org.apache.tools.ant.Project.executeTargets(Project.java:1189) at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:416) ... 43 more Caused by: /opt/code/main/openbravo/src-db/database/build.xml:132: org.apache.ddlutils.DatabaseOperationException: Error while deleting from the database at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:116) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.Target.execute(Target.java:357) at org.apache.tools.ant.Target.performTasks(Target.java:385) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337) at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38) at org.apache.tools.ant.Project.executeTargets(Project.java:1189) at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:416) ... 55 more Caused by: org.apache.ddlutils.DatabaseOperationException: Error while deleting from the database at org.apache.ddlutils.platform.PlatformImplBase.delete(PlatformImplBase.java:2223) at org.apache.ddlutils.platform.PlatformImplBase.alterData(PlatformImplBase.java:736) at org.openbravo.ddlutils.task.AlterDatabaseDataMod.doExecute(AlterDatabaseDataMod.java:290) at org.openbravo.dal.core.DalInitializingTask.execute(DalInitializingTask.java:116) at org.openbravo.ddlutils.task.BaseDalInitializingTask.execute(BaseDalInitializingTask.java:79) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288) at sun.reflect.GeneratedMethodAccessor776.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) ... 62 more Caused by: org.postgresql.util.PSQLException: ERROR: update or delete on table "ad_process" violates foreign key constraint "ad_process_request_ad_process" on table "ad_process_request" Detail: Key (ad_process_id)=(0202F5D291A84E9D9DF9EFD75FEB5E30) is still referenced from table "ad_process_request". at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:305) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101) at org.apache.ddlutils.platform.PlatformImplBase.delete(PlatformImplBase.java:2220) ... 71 more --- Nested Exception --- /opt/code/main/openbravo/build.xml:490: The following error occurred while executing this line: /opt/code/main/openbravo/src-db/database/build.xml:132: org.apache.ddlutils.DatabaseOperationException: Error while deleting from the database at org.apache.tools.ant.ProjectHelper.addLocationToBuildException(ProjectHelper.java:508) at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:418) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288) at sun.reflect.GeneratedMethodAccessor776.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.Target.execute(Target.java:357) at org.apache.tools.ant.Target.performTasks(Target.java:385) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337) at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38) at org.apache.tools.ant.Project.executeTargets(Project.java:1189) at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:416) at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288) at sun.reflect.GeneratedMethodAccessor776.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.Target.execute(Target.java:357) at org.apache.tools.ant.Target.performTasks(Target.java:385) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337) at org.apache.tools.ant.Project.executeTarget(Project.java:1306) at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41) at org.apache.tools.ant.Project.executeTargets(Project.java:1189) at org.openbravo.erpCommon.utility.AntExecutor.runTask(AntExecutor.java:222) at org.openbravo.erpCommon.ad_process.ApplyModules.startApply(ApplyModules.java:221) at org.openbravo.erpCommon.ad_process.ApplyModules.doPost(ApplyModules.java:63) at javax.servlet.http.HttpServlet.service(Unknown Source) at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:225) at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:331) at javax.servlet.http.HttpServlet.service(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source) at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source) at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source) at org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:79) at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46) at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:85) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source) at org.apache.catalina.core.StandardWrapperValve.invoke(Unknown Source) at org.apache.catalina.core.StandardContextValve.invoke(Unknown Source) at org.apache.catalina.core.StandardHostValve.invoke(Unknown Source) at org.apache.catalina.valves.ErrorReportValve.invoke(Unknown Source) at org.apache.catalina.core.StandardEngineValve.invoke(Unknown Source) at org.apache.catalina.connector.CoyoteAdapter.service(Unknown Source) at org.apache.coyote.ajp.AjpAprProcessor.process(Unknown Source) at org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(Unknown Source) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(Unknown Source) at java.lang.Thread.run(Thread.java:619) Caused by: /opt/code/main/openbravo/src-db/database/build.xml:132: org.apache.ddlutils.DatabaseOperationException: Error while deleting from the database at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:116) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.Target.execute(Target.java:357) at org.apache.tools.ant.Target.performTasks(Target.java:385) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337) at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38) at org.apache.tools.ant.Project.executeTargets(Project.java:1189) at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:416) ... 55 more Caused by: org.apache.ddlutils.DatabaseOperationException: Error while deleting from the database at org.apache.ddlutils.platform.PlatformImplBase.delete(PlatformImplBase.java:2223) at org.apache.ddlutils.platform.PlatformImplBase.alterData(PlatformImplBase.java:736) at org.openbravo.ddlutils.task.AlterDatabaseDataMod.doExecute(AlterDatabaseDataMod.java:290) at org.openbravo.dal.core.DalInitializingTask.execute(DalInitializingTask.java:116) at org.openbravo.ddlutils.task.BaseDalInitializingTask.execute(BaseDalInitializingTask.java:79) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288) at sun.reflect.GeneratedMethodAccessor776.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) ... 62 more Caused by: org.postgresql.util.PSQLException: ERROR: update or delete on table "ad_process" violates foreign key constraint "ad_process_request_ad_process" on table "ad_process_request" Detail: Key (ad_process_id)=(0202F5D291A84E9D9DF9EFD75FEB5E30) is still referenced from table "ad_process_request". at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:305) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101) at org.apache.ddlutils.platform.PlatformImplBase.delete(PlatformImplBase.java:2220) ... 71 more --- Nested Exception --- /opt/code/main/openbravo/src-db/database/build.xml:132: org.apache.ddlutils.DatabaseOperationException: Error while deleting from the database at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:116) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.Target.execute(Target.java:357) at org.apache.tools.ant.Target.performTasks(Target.java:385) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337) at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38) at org.apache.tools.ant.Project.executeTargets(Project.java:1189) at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:416) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288) at sun.reflect.GeneratedMethodAccessor776.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.Target.execute(Target.java:357) at org.apache.tools.ant.Target.performTasks(Target.java:385) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337) at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38) at org.apache.tools.ant.Project.executeTargets(Project.java:1189) at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:416) at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288) at sun.reflect.GeneratedMethodAccessor776.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.Target.execute(Target.java:357) at org.apache.tools.ant.Target.performTasks(Target.java:385) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337) at org.apache.tools.ant.Project.executeTarget(Project.java:1306) at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41) at org.apache.tools.ant.Project.executeTargets(Project.java:1189) at org.openbravo.erpCommon.utility.AntExecutor.runTask(AntExecutor.java:222) at org.openbravo.erpCommon.ad_process.ApplyModules.startApply(ApplyModules.java:221) at org.openbravo.erpCommon.ad_process.ApplyModules.doPost(ApplyModules.java:63) at javax.servlet.http.HttpServlet.service(Unknown Source) at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:225) at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:331) at javax.servlet.http.HttpServlet.service(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source) at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source) at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source) at org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:79) at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46) at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:85) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source) at org.apache.catalina.core.StandardWrapperValve.invoke(Unknown Source) at org.apache.catalina.core.StandardContextValve.invoke(Unknown Source) at org.apache.catalina.core.StandardHostValve.invoke(Unknown Source) at org.apache.catalina.valves.ErrorReportValve.invoke(Unknown Source) at org.apache.catalina.core.StandardEngineValve.invoke(Unknown Source) at org.apache.catalina.connector.CoyoteAdapter.service(Unknown Source) at org.apache.coyote.ajp.AjpAprProcessor.process(Unknown Source) at org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(Unknown Source) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(Unknown Source) at java.lang.Thread.run(Thread.java:619) Caused by: org.apache.ddlutils.DatabaseOperationException: Error while deleting from the database at org.apache.ddlutils.platform.PlatformImplBase.delete(PlatformImplBase.java:2223) at org.apache.ddlutils.platform.PlatformImplBase.alterData(PlatformImplBase.java:736) at org.openbravo.ddlutils.task.AlterDatabaseDataMod.doExecute(AlterDatabaseDataMod.java:290) at org.openbravo.dal.core.DalInitializingTask.execute(DalInitializingTask.java:116) at org.openbravo.ddlutils.task.BaseDalInitializingTask.execute(BaseDalInitializingTask.java:79) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288) at sun.reflect.GeneratedMethodAccessor776.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) ... 62 more Caused by: org.postgresql.util.PSQLException: ERROR: update or delete on table "ad_process" violates foreign key constraint "ad_process_request_ad_process" on table "ad_process_request" Detail: Key (ad_process_id)=(0202F5D291A84E9D9DF9EFD75FEB5E30) is still referenced from table "ad_process_request". at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:305) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101) at org.apache.ddlutils.platform.PlatformImplBase.delete(PlatformImplBase.java:2220) ... 71 more --- Nested Exception --- org.apache.ddlutils.DatabaseOperationException: Error while deleting from the database at org.apache.ddlutils.platform.PlatformImplBase.delete(PlatformImplBase.java:2223) at org.apache.ddlutils.platform.PlatformImplBase.alterData(PlatformImplBase.java:736) at org.openbravo.ddlutils.task.AlterDatabaseDataMod.doExecute(AlterDatabaseDataMod.java:290) at org.openbravo.dal.core.DalInitializingTask.execute(DalInitializingTask.java:116) at org.openbravo.ddlutils.task.BaseDalInitializingTask.execute(BaseDalInitializingTask.java:79) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288) at sun.reflect.GeneratedMethodAccessor776.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.Target.execute(Target.java:357) at org.apache.tools.ant.Target.performTasks(Target.java:385) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337) at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38) at org.apache.tools.ant.Project.executeTargets(Project.java:1189) at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:416) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288) at sun.reflect.GeneratedMethodAccessor776.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.Target.execute(Target.java:357) at org.apache.tools.ant.Target.performTasks(Target.java:385) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337) at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38) at org.apache.tools.ant.Project.executeTargets(Project.java:1189) at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:416) at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288) at sun.reflect.GeneratedMethodAccessor776.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.Target.execute(Target.java:357) at org.apache.tools.ant.Target.performTasks(Target.java:385) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337) at org.apache.tools.ant.Project.executeTarget(Project.java:1306) at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41) at org.apache.tools.ant.Project.executeTargets(Project.java:1189) at org.openbravo.erpCommon.utility.AntExecutor.runTask(AntExecutor.java:222) at org.openbravo.erpCommon.ad_process.ApplyModules.startApply(ApplyModules.java:221) at org.openbravo.erpCommon.ad_process.ApplyModules.doPost(ApplyModules.java:63) at javax.servlet.http.HttpServlet.service(Unknown Source) at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:225) at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:331) at javax.servlet.http.HttpServlet.service(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source) at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source) at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source) at org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:79) at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46) at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:85) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source) at org.apache.catalina.core.StandardWrapperValve.invoke(Unknown Source) at org.apache.catalina.core.StandardContextValve.invoke(Unknown Source) at org.apache.catalina.core.StandardHostValve.invoke(Unknown Source) at org.apache.catalina.valves.ErrorReportValve.invoke(Unknown Source) at org.apache.catalina.core.StandardEngineValve.invoke(Unknown Source) at org.apache.catalina.connector.CoyoteAdapter.service(Unknown Source) at org.apache.coyote.ajp.AjpAprProcessor.process(Unknown Source) at org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(Unknown Source) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(Unknown Source) at java.lang.Thread.run(Thread.java:619) Caused by: org.postgresql.util.PSQLException: ERROR: update or delete on table "ad_process" violates foreign key constraint "ad_process_request_ad_process" on table "ad_process_request" Detail: Key (ad_process_id)=(0202F5D291A84E9D9DF9EFD75FEB5E30) is still referenced from table "ad_process_request". at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:305) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101) at org.apache.ddlutils.platform.PlatformImplBase.delete(PlatformImplBase.java:2220) ... 71 more le ADWindow Data changes we will perform: Row removed from table [AD_ELEMENT]: Row removed from table [AD_ELEMENT]: Row removed from table [AD_MENU]: Row removed from table [AD_MENU]: Row removed from table [AD_MODULE_DBPREFIX]: Row removed from table [AD_MODEL_OBJECT]: Row removed from table [AD_MODEL_OBJECT]: Row removed from table [AD_MODEL_OBJECT_MAPPING]: Row removed from table [AD_MODEL_OBJECT_MAPPING]: Row removed from table [AD_MODEL_OBJECT_MAPPING]: Row removed from table [AD_MODEL_OBJECT_MAPPING]: Row removed from table [AD_COLUMN]: Row removed from table [AD_COLUMN]: Row removed from table [AD_COLUMN]: Row removed from table [AD_COLUMN]: Row removed from table [AD_COLUMN]: Row removed from table [AD_COLUMN]: Row removed from table [AD_COLUMN]: Row removed from table [AD_COLUMN]: Row removed from table [AD_COLUMN]: Row removed from table [AD_COLUMN]: Row removed from table [AD_COLUMN]: Row removed from table [AD_COLUMN]: Row removed from table [AD_COLUMN]: Row removed from table [AD_COLUMN]: Row removed from table [AD_PACKAGE]: Row removed from table [AD_MODULE]: Row removed from table [AD_TAB]: Row removed from table [AD_FIELD]: Row removed from table [AD_FIELD]: Row removed from table [AD_FIELD]: Row removed from table [AD_FIELD]: Row removed from table [AD_FIELD]: Row removed from table [AD_FIELD]: Row removed from table [AD_FIELD]: Row removed from table [AD_FIELD]: Row removed from table [AD_FIELD]: Row removed from table [AD_FIELD]: Row removed from table [AD_MODULE_DEPENDENCY]: Row removed from table [AD_TABLE]: Row removed from table [AD_TREENODE]: Row removed from table [AD_TREENODE]: Row removed from table [AD_WINDOW]: Comparing databases to find data differences Updating database model... Processing Trigger Trigger [name=HW_TABLE1_TRG; ] (removed from database PostgreSql server) Processing Table HW_TABLE1 (removed) Executed 6 SQL command(s) with 0 error(s) Model update complete. Updating database data... Disabling foreign keys Executed 165 SQL command(s) with 0 error(s) Disabling triggers Executed 128 SQL command(s) with 0 error(s) Updating database data for module Rooms Scheduling System Removing invalid rows. Executed 130 SQL command(s) with 0 error(s) Executing update final script (NOT NULLs and dropping temporary tables) Processing Table ROOMS_ROOM (removed) Processing Table ROOMS_ROOMATTEND (removed) Processing Table ROOMS_ROOMSCHEDULE (removed) Executed 0 SQL command(s) with 0 error(s) Updating database data for module Hello world Process Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design Call to HttpBaseServlet.service *********************Base path: src-loc *********************Base path: src-loc/design