Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0018773
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Z. Othersmajoralways2011-10-13 17:182011-11-04 11:08
ReportermiruritaView Statuspublic 
Assigned Togorkaion 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision760dfdd1c999
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

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

DescriptionIn 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)
Steps To Reproduce1) Create a multicurrency debt payment in 2.50 without APR
2) Install migration tool
3) Launch migration process
Proposed Solutionorg.openbravo.erputil.aprmigrationtool.entity.MigrateSettlementPayments

after the following line
OBDal.getInstance().save(multicurrencyPaymentMethod);
insert
OBDal.getInstance().flush();

and in the line 344, after
OBDal.getInstance().save(accountPay);
insert again
OBDal.getInstance().flush();
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0019237 newgorkaion Modules cannot migrate a manual settlement in a foreign currency 

-  Notes
(0041845)
jonalegriaesarte (reporter)
2011-10-17 10:35

 Updated to major because it is solved in customer side
(0042155)
hgbot (developer)
2011-10-27 15:55

 Repository: erp/mods/org.openbravo.erputil.aprmigrationtool
Changeset: 760dfdd1c99909c9f3c825a21da94c69e5829137
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Thu Oct 27 15:53:48 2011 +0200
URL: http://code.openbravo.com/erp/mods/org.openbravo.erputil.aprmigrationtool/rev/760dfdd1c99909c9f3c825a21da94c69e5829137 [^]

Fixed issue 18773.Add flushes when payment method is created.

---
M src/org/openbravo/erputil/aprmigrationtool/dao/MigrationToolDao.java
---
(0042522)
mirurita (developer)
2011-11-04 11:08

 Detected and verified in a *Phoenix* client migration.

- Issue History
Date Modified Username Field Change
2011-10-13 17:18 mirurita New Issue
2011-10-13 17:18 mirurita Assigned To => gorkaion
2011-10-13 17:18 mirurita Modules => Core
2011-10-13 17:18 mirurita Resolution time => 1321311600
2011-10-17 10:35 jonalegriaesarte Note Added: 0041845
2011-10-17 10:35 jonalegriaesarte Severity critical => major
2011-10-17 10:35 jonalegriaesarte Description Updated View Revisions
2011-10-27 15:55 hgbot Checkin
2011-10-27 15:55 hgbot Note Added: 0042155
2011-10-27 15:55 hgbot Status new => resolved
2011-10-27 15:55 hgbot Resolution open => fixed
2011-10-27 15:55 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/mods/org.openbravo.erputil.aprmigrationtool/rev/760dfdd1c99909c9f3c825a21da94c69e5829137 [^]
2011-11-04 11:08 mirurita Note Added: 0042522
2011-11-04 11:08 mirurita Status resolved => closed
2011-12-02 16:58 dalsasua Relationship added related to 0019237

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker