Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0009776 | Openbravo ERP | 05. Production management | public | 2009-07-06 12:03 | 2009-07-16 17:55 |
|
| Reporter | joan | |
| Assigned To | rafaroda | |
| Priority | normal | Severity | critical | Reproducibility | always |
| Status | closed | Resolution | duplicate | |
| Platform | | OS | 30 | OS Version | Debian Etch |
| Product Version | 2.50MP2 | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | No |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0009776: Upgrade 2.40 -> 2.50 Does not mantain the data on ma_sequenceproduct |
| Description | When i try to upgrade from 2.40 to 2.50 everything goes smooth but the data on ma_sequenceproduct table disapear, im not sure if this happens because i've added a field called 'line' or if it does not do propertly the upgrade. But it is really critical for my update. (because there is data lose). Im not sure if this happens in another table, but should be checked. |
| Steps To Reproduce | Install 2.40
Create a Process Plan with io products
Upgrade from 2.40 to 2.50 following the wiki http://wiki.openbravo.com/wiki/ERP/2.50/Upgrading_From_2.40 [^]
see that there is no io produts on the list.
-------------------- If this works then
Install 2.40
Add a field called line in the database
Add the field to the io products tab in the window ProcessPlan
Create a Process Plan with io products, with line number completed
Upgrade from 2.40 to 2.50 following the wiki http://wiki.openbravo.com/wiki/ERP/2.50/Upgrading_From_2.40 [^]
see that there is no io produts on the list. |
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | depends on | defect | 0009650 | | closed | marvintm | Upgrade from 2.40 to 2.50MP1, foreign key changes update problem. |
|
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2009-07-06 12:03 | joan | New Issue | |
| 2009-07-06 12:03 | joan | Assigned To | => rafaroda |
| 2009-07-10 12:08 | joan | Note Added: 0018093 | |
| 2009-07-10 12:08 | joan | Note Edited: 0018093 | |
| 2009-07-10 14:27 | joan | Note Added: 0018107 | |
| 2009-07-10 14:28 | joan | Note Edited: 0018107 | |
| 2009-07-13 13:30 | psarobe | Relationship added | depends on 0009650 |
| 2009-07-13 13:30 | psarobe | Status | new => closed |
| 2009-07-13 13:30 | psarobe | Resolution | open => duplicate |
| 2009-07-16 17:55 | anonymous | sf_bug_id | 0 => 2822586 |
|
Notes |
|
|
(0018093)
|
|
joan
|
|
2009-07-10 12:08
|
|
Ob 2.40 , posgreSQL 8.3
>ant export.database
Buildfile: build.xml
init:
code.rev:
[loadfile] /opt/newupgrade/Ob240Old/.svn/entries doesn't exist
export.database:
init:
database.lib:
clean:
[delete] Deleting directory /opt/newupgrade/Ob240Old/src-db/build/classes
[delete] Deleting directory /opt/newupgrade/Ob240Old/src-db/build/lib
[delete] Deleting directory /opt/newupgrade/Ob240Old/src-db/docs
init:
[mkdir] Created dir: /opt/newupgrade/Ob240Old/src-db/build/classes
[mkdir] Created dir: /opt/newupgrade/Ob240Old/src-db/build/lib
[mkdir] Created dir: /opt/newupgrade/Ob240Old/src-db/docs
compile:
[javac] Compiling 4 source files to /opt/newupgrade/Ob240Old/src-db/build/classes
build.jar:
[jar] Building jar: /opt/newupgrade/Ob240Old/src-db/build/lib/dbmanager.jar
jar:
[copy] Copying 1 file to /opt/newupgrade/Ob240Old/src-db/database/lib
export.database.structure:
[exportdatabase] Database code revision: 0008149#
[exportdatabase] Source code revision: #0#
[exportdatabase] Subversion code revision not found.
[exportdatabase] Reading tables...
[exportdatabase] Reading views...
[exportdatabase] Reading sequences...
[exportdatabase] Reading triggers...
[exportdatabase] Reading functions...
[exportdatabase] Sorting foreign keys and checks...
[exportdatabase] Starting function and trigger standardization.
[exportdatabase] Database [name=PostgreSql server; 424 tables; 0 sequences; 56 views; 231 functions; 163 triggers]
export.database.data:
[exportdata] Database code revision: 0008149#
[exportdata] Source code revision: #0#
[exportdata] Subversion code revision not found.
[exportdata] Reading tables...
[exportdata] Reading views...
[exportdata] Reading sequences...
[exportdata] Reading triggers...
[exportdata] Reading functions...
[exportdata] Sorting foreign keys and checks...
[exportdata] Starting function and trigger standardization.
[exportdata] Model loaded from database.
BUILD SUCCESSFUL
Total time: 2 minutes 31 seconds
>ant update.database
Buildfile: build.xml
init:
code.rev:
[loadfile] /opt/newupgrade/Ob240Old/.svn/entries doesn't exist
update.database:
init:
database.lib:
clean:
[delete] Deleting directory /opt/newupgrade/Ob240Old/src-db/build/classes
[delete] Deleting directory /opt/newupgrade/Ob240Old/src-db/build/lib
[delete] Deleting directory /opt/newupgrade/Ob240Old/src-db/docs
init:
[mkdir] Created dir: /opt/newupgrade/Ob240Old/src-db/build/classes
[mkdir] Created dir: /opt/newupgrade/Ob240Old/src-db/build/lib
[mkdir] Created dir: /opt/newupgrade/Ob240Old/src-db/docs
compile:
[javac] Compiling 4 source files to /opt/newupgrade/Ob240Old/src-db/build/classes
build.jar:
[jar] Building jar: /opt/newupgrade/Ob240Old/src-db/build/lib/dbmanager.jar
jar:
[copy] Copying 1 file to /opt/newupgrade/Ob240Old/src-db/database/lib
update.database:
[alterdatabasedata] Executing default prescript
[alterdatabasedata] Executed 108 SQL command(s) with 0 error(s)
[alterdatabasedata] Reading tables...
[alterdatabasedata] Reading views...
[alterdatabasedata] Reading sequences...
[alterdatabasedata] Reading triggers...
[alterdatabasedata] Reading functions...
[alterdatabasedata] Sorting foreign keys and checks...
[alterdatabasedata] Starting function and trigger standardization.
[alterdatabasedata] Original model loaded from database.
[alterdatabasedata] Processing View View [name=C_INVOICE_CANDIDATE_V; ] (created for the database PostgreSql server)
[alterdatabasedata] Executed 1 SQL command(s) with 0 error(s)
[alterdatabasedata] Executed 326 SQL command(s) with 0 error(s)
[alterdatabasedata] Executed 2148 SQL command(s) with 0 error(s)
[alterdatabasedata] Executed 68 SQL command(s) with 0 error(s)
[alterdatabasedata] Executed 154 SQL command(s) with 0 error(s)
[alterdatabasedata] Executed 326 SQL command(s) with 0 error(s)
[alterdatabasedata] Executed 2148 SQL command(s) with 0 error(s)
[alterdatabasedata] Processing View View [name=C_INVOICE_CANDIDATE_V; ] (created for the database PostgreSql server)
[alterdatabasedata] Executed 65 SQL command(s) with 0 error(s)
[alterdatabasedata] Executing default postscript
[alterdatabasedata] Executed 6 SQL command(s) with 0 error(s)
database.postcreate.POSTGRE:
[sql] Executing commands
[sql] 8 of 8 SQL statements executed successfully
BUILD SUCCESSFUL
Total time: 5 minutes 15 seconds
And my ma_sequenceproduct gets empty!.
|
|
|
|
(0018107)
|
|
joan
|
2009-07-10 14:27
(edited on: 2009-07-10 14:28) |
|
Ok, solved!, it was my mistake, I've set the cascade setting on delete over a uom_id field , andlooks like when it does update.database cleans the table uom_id and deletes the table asociated because the ondeletecascade setting.
Sorry was my mistake
this is the "not use anymore constraint"
<foreign-key foreignTable="M_PRODUCT_UOM" name="MPRODUCTUOMID_MASEQPRODUCT" onDelete="cascade">
<reference local="M_PRODUCT_UOM_ID" foreign="M_PRODUCT_UOM_ID"/>
</foreign-key>
btw, this problems seams to be related with this issue
https://issues.openbravo.com/view.php?id=9650 [^]
|
|