0018773: Violated constraint fin_finacc_paymentmethod_un when you try to migrate a multicurrency debt payment (Settlement step)

Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Revisions: Issue #18773		[ Back to Issue ]
Summary	0018773: Violated constraint fin_finacc_paymentmethod_un when you try to migrate a multicurrency debt payment (Settlement step)

Revision	2011-10-17 10:35 by jonalegriaesarte
Description	In Settlement step if the process tries to migrate a multicurrency debt payment it creates specific payment method and associates to the financial account. As the flush() is not done, when checking if the payment method already exists in the financial account the query returns false and tries to insert again. "Entity: FinancialMgmtDebtPayment. Entidad: Operon. Información de registro: false - GL-LOHMANN - Lohmann Precision Die Cutting, LCC - P - -2073.32000 - 14-09-2010 Entity: FinancialMgmtDebtPayment. Entidad: Operon. Información de registro: false - GL-LOHMANN - Lohmann Precision Die Cutting, LCC - P - -2073.32000 - 14-09-2010 Entity: FinancialMgmtDebtPayment. Entidad: Operon. Información de registro: false - GL-LOHMANN - Lohmann Precision Die Cutting, LCC - P - -2073.32000 - 14-09-2010 ERROR: duplicate key value violates unique constraint "fin_finacc_paymentmethod_un" org.openbravo.erputil.aprmigrationtool.utility.MigrationException: ERROR: duplicate key value violates unique constraint "fin_finacc_paymentmethod_un" at org.openbravo.erputil.aprmigrationtool.entity.MigrateSettlementPayments.migrateClient(MigrateSettlementPayments.java:83) at org.openbravo.erputil.aprmigrationtool.entity.Entity.migrate(Entity.java:97) at org.openbravo.erputil.aprmigrationtool.entity.MigrationTool.migrationProcess(MigrationTool.java:91) at org.openbravo.erputil.aprmigrationtool.ad_forms.MigrationTool.process(MigrationTool.java:177) at org.openbravo.erputil.aprmigrationtool.ad_forms.MigrationTool.doPost(MigrationTool.java:67) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:225) at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:429) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:81) at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46) at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:103) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:429) at org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(AjpAprProtocol.java:384) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1665) at java.lang.Thread.run(Thread.java:662)

Revision	2011-10-17 10:35 by jonalegriaesarte
Description	In Settlement step if the process tries to migrate a multicurrency debt payment it creates specific payment method and associates to the financial account. As the flush() is not done, when checking if the payment method already exists in the financial account the query returns false and tries to insert again. "Entity: FinancialMgmtDebtPayment. Entidad: Operon. Información de registro: false - GL-LOHMANN - Lohmann Precision Die Cutting, LCC - P - -2073.32000 - 14-09-2010 Entity: FinancialMgmtDebtPayment. Entidad: Operon. Información de registro: false - GL-LOHMANN - Lohmann Precision Die Cutting, LCC - P - -2073.32000 - 14-09-2010 Entity: FinancialMgmtDebtPayment. Entidad: Operon. Información de registro: false - GL-LOHMANN - Lohmann Precision Die Cutting, LCC - P - -2073.32000 - 14-09-2010 ERROR: duplicate key value violates unique constraint "fin_finacc_paymentmethod_un" org.openbravo.erputil.aprmigrationtool.utility.MigrationException: ERROR: duplicate key value violates unique constraint "fin_finacc_paymentmethod_un" at org.openbravo.erputil.aprmigrationtool.entity.MigrateSettlementPayments.migrateClient(MigrateSettlementPayments.java:83) at org.openbravo.erputil.aprmigrationtool.entity.Entity.migrate(Entity.java:97) at org.openbravo.erputil.aprmigrationtool.entity.MigrationTool.migrationProcess(MigrationTool.java:91) at org.openbravo.erputil.aprmigrationtool.ad_forms.MigrationTool.process(MigrationTool.java:177) at org.openbravo.erputil.aprmigrationtool.ad_forms.MigrationTool.doPost(MigrationTool.java:67) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:225) at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:429) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:81) at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46) at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:103) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:429) at org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(AjpAprProtocol.java:384) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1665) at java.lang.Thread.run(Thread.java:662)