Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0020179ModulesAPR Migration Toolpublic2012-04-02 12:182012-09-04 18:04
Reporteregoitz 
Assigned Tojecharri 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned Toegoitz
Support ticket
OBNetwork customer
Regression introduced in release
Summary0020179: Not possible to execute the migration tool when migratin to mp8 release or higher
DescriptionWhen migrating from 2.50 to Openbravo3 mp8 or higher, it is not possible to execute the migration tool.
Steps To Reproduce-Starting on 2.50 migrate to Openbravo 3mp8 and try to run migration tool.
Proposed SolutionProblem happens on the insert on insertOrigPaymentSchedule method.
To solve:
1-Remove from the insert the columns receivedAmount and outstandingAmount that does not exist on the table.

To improve the performance:
2-Change the parameter of method insertOrigPaymentSchedule from String to FIN_PaymentSchedule object.
3-Use as argument fps object instead of fps.getId()
4-Change on the insertOrigPaymentSchedule the string in order to make the insert as "Insert into values" and not "insert select". Each value can be obtained from fps argument with proper methods.
5-ONce the insert is changed to use values and not a select, the line OBDal.getInstance().flush();
used before calling to insertOrigPaymentSchedule method could be removed
6-Finally:

Add a try before starting the invoices loop ( for (Invoice inv : invoiceList))
and then
change
 if (fps != null)
with
 if (fps != null and tableExists)
Additional Information
TagsRegression
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-04-02 12:18egoitzNew Issue
2012-04-02 12:18egoitzAssigned To => mirurita
2012-04-02 12:26egoitzTag Attached: Regression
2012-04-02 12:26egoitzAssigned Tomirurita => jecharri
2012-04-02 12:42egoitzNote Added: 0047304
2012-04-02 12:42egoitzProposed Solution updated
2012-04-02 13:02egoitzProposed Solution updated
2012-04-03 10:22hgbotCheckin
2012-04-03 10:22hgbotNote Added: 0047329
2012-04-03 10:22hgbotStatusnew => resolved
2012-04-03 10:22hgbotResolutionopen => fixed
2012-04-03 10:22hgbotFixed in SCM revision => http://code.openbravo.com/erp/mods/org.openbravo.erputil.aprmigrationtool/rev/c630f77de6c2a51380cd87e51598dbedb61ce849 [^]
2012-04-03 12:39hgbotCheckin
2012-04-03 12:39hgbotNote Added: 0047333
2012-09-04 18:04egoitzClosed by => egoitz
2012-09-04 18:04egoitzNote Added: 0051837
2012-09-04 18:04egoitzStatusresolved => closed

Notes
(0047304)
egoitz   
2012-04-02 12:42   
Regressión introduced by https://code.openbravo.com/erp/mods/org.openbravo.erputil.aprmigrationtool/rev/dcca2ae4ada5 [^]
(0047329)
hgbot   
2012-04-03 10:22   
Repository: erp/mods/org.openbravo.erputil.aprmigrationtool
Changeset: c630f77de6c2a51380cd87e51598dbedb61ce849
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Tue Apr 03 10:04:29 2012 +0200
URL: http://code.openbravo.com/erp/mods/org.openbravo.erputil.aprmigrationtool/rev/c630f77de6c2a51380cd87e51598dbedb61ce849 [^]

Fixes issue 20179: Not possible to execute the migration tool when migratin to mp8 release or higher

---
M src/org/openbravo/erputil/aprmigrationtool/entity/MigrateInvoice.java
---
(0047333)
hgbot   
2012-04-03 12:39   
Repository: erp/mods/org.openbravo.erputil.aprmigrationtool
Changeset: a241e9cc52d2ef1006f3a27dca88704089e08692
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Tue Apr 03 12:37:41 2012 +0200
URL: http://code.openbravo.com/erp/mods/org.openbravo.erputil.aprmigrationtool/rev/a241e9cc52d2ef1006f3a27dca88704089e08692 [^]

issue 20179: Not possible to execute the migration tool when migratin to mp8 release or higher

---
M src/org/openbravo/erputil/aprmigrationtool/entity/MigrateInvoice.java
---
(0051837)
egoitz   
2012-09-04 18:04   
verified on a real migration