Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0008127Openbravo ERPA. Platformpublic2009-03-13 22:032009-03-18 11:03
jpabloae 
marvintm 
normalmajoralways
closedduplicate 
30Gentoo - 2.6.26
2.40MP3 
 
Core
No
0008127: Problems updating from 2.40 to 2.40MP3 with 8 languages in DB
We have a 2.40 database with 8 imported languages: English, Bulgarian, French, Italian, Spanish, Romanian, Polish, Portuguese. There are no more customizations, neither in database nor in sources.

When upgrading to 2.40MP3 there are 2 issues:

1) After running the update.customized.database task, although the process end with a "BUILD SUCCESSFUL" message there are some previous error. I don't know if they are relevant, but there are errors like:

[altercustomizeddatabasedata] SQL Command failed with: ERROR: cannot change number of columns in view
[altercustomizeddatabasedata] Executed 1 forced SQL command(s) with 1 error(s)

Full log attached (update.customized.database_2.40-2.40mp3.log.gz). See lines 278-289 and 450-460.

2) After updating the database, the "ant compile.complete" task fails with an error:

    [javac] Compiling 909 source files to /home/jpabloae/tmp/r2.40mp3/build/classes
    [javac] /home/jpabloae/tmp/r2.40mp3/srcAD/org/openbravo/erpWindows/EmployeeExpenses/Lines.java:434: cannot find symbol
    [javac] symbol : class LinesData
    [javac] location: class org.openbravo.erpWindows.EmployeeExpenses.Lines
    [javac] LinesData getEditVariables(Connection con, VariablesSecureApp vars, String strPC_BPartner_ID) throws IOException,ServletException {
    [javac] ^
    [javac] /home/jpabloae/tmp/r2.40mp3/srcAD/org/openbravo/erpWindows/EmployeeExpenses/Lines.java:453: cannot find symbol

This is clean installation (plus 7 languages), so it probably has to do with the database update.

Full log attached (core.wad.trl.complete.war-2.40mp3.log.gz).
1. Check out the 2.40 tag and run "ant install.source".
2. Import the 7 additional languages. As this is not an immediate task, send me an e-mail an I'll provide you a PostgreSQL dump file if needed.
3. Check out the 2.40MP3 tag and run the setup tool to point to the 2.40 database.
4. Copy tags/r2.40/src-db/database into tags/r2.40mp3/src-db/originalDatabase.
5. Run "ant update.customized.database". You'll get a successful message but some errors are shown.
6. Run "ant core.lib wad.lib trl.lib compile.complete". The compilation fails.
No tags attached.
duplicate of backport 0007256 closed marvintm update.database fails on postgres from r11171 .. >= 11171 (i.e. current 11997) 
gz core.wad.trl.complete.war-2.40mp3.log.gz (23,723) 2009-03-13 22:03
https://issues.openbravo.com/file_download.php?file_id=991&type=bug
gz update.customized.database_2.40-2.40mp3.log.gz (3,519) 2009-03-13 22:04
https://issues.openbravo.com/file_download.php?file_id=992&type=bug
Issue History
2009-03-13 22:03jpabloaeNew Issue
2009-03-13 22:03jpabloaeAssigned To => rafaroda
2009-03-13 22:03jpabloaeFile Added: core.wad.trl.complete.war-2.40mp3.log.gz
2009-03-13 22:03jpabloaeRegression testing => No
2009-03-13 22:04jpabloaeFile Added: update.customized.database_2.40-2.40mp3.log.gz
2009-03-13 22:04jpabloaeversion => 2.40MP3
2009-03-13 22:04jpabloaeAssigned Torafaroda => marvintm
2009-03-13 22:06jpabloaeDescription Updated
2009-03-13 22:07jpabloaeDescription Updated
2009-03-13 22:08jpabloaeProposed Solution updated
2009-03-13 22:09jpabloaeDescription Updated
2009-03-16 17:14marvintmRelationship addedduplicate of 0007256
2009-03-16 17:14marvintmStatusnew => closed
2009-03-16 17:14marvintmNote Added: 0014699
2009-03-16 17:14marvintmDuplicate ID0 => 7256
2009-03-16 17:14marvintmResolutionopen => duplicate
2009-03-18 11:03anonymoussf_bug_id0 => 2691473

Notes
(0014699)
marvintm   
2009-03-16 17:14   
This was a duplicate of issue 7256. It should be fixed now.