Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0020179 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Modules] APR Migration Tool | major | always | 2012-04-02 12:18 | 2012-09-04 18:04 | |||
| Reporter | egoitz | View Status | public | |||||
| Assigned To | jecharri | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | c630f77de6c2 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Regression date | ||||||||
| Regression introduced by commit | ||||||||
| Regression level | ||||||||
| Review Assigned To | egoitz | |||||||
| Regression introduced in release | ||||||||
| Summary | 0020179: Not possible to execute the migration tool when migratin to mp8 release or higher | |||||||
| Description | When 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 Solution | Problem 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) | |||||||
| Tags | Regression | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0047304) egoitz (manager) 2012-04-02 12:42 |
Regressión introduced by https://code.openbravo.com/erp/mods/org.openbravo.erputil.aprmigrationtool/rev/dcca2ae4ada5 [^] |
|
(0047329) hgbot (developer) 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 (developer) 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 (manager) 2012-09-04 18:04 |
verified on a real migration |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2012-04-02 12:18 | egoitz | New Issue | |
| 2012-04-02 12:18 | egoitz | Assigned To | => mirurita |
| 2012-04-02 12:26 | egoitz | Tag Attached: Regression | |
| 2012-04-02 12:26 | egoitz | Assigned To | mirurita => jecharri |
| 2012-04-02 12:42 | egoitz | Note Added: 0047304 | |
| 2012-04-02 12:42 | egoitz | Proposed Solution updated | |
| 2012-04-02 13:02 | egoitz | Proposed Solution updated | |
| 2012-04-03 10:22 | hgbot | Checkin | |
| 2012-04-03 10:22 | hgbot | Note Added: 0047329 | |
| 2012-04-03 10:22 | hgbot | Status | new => resolved |
| 2012-04-03 10:22 | hgbot | Resolution | open => fixed |
| 2012-04-03 10:22 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/mods/org.openbravo.erputil.aprmigrationtool/rev/c630f77de6c2a51380cd87e51598dbedb61ce849 [^] |
| 2012-04-03 12:39 | hgbot | Checkin | |
| 2012-04-03 12:39 | hgbot | Note Added: 0047333 | |
| 2012-09-04 18:04 | egoitz | Closed by | => egoitz |
| 2012-09-04 18:04 | egoitz | Note Added: 0051837 | |
| 2012-09-04 18:04 | egoitz | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |