Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0017466Openbravo ERPA. Platformpublic2011-06-02 13:482011-06-09 16:09
Reporterjpabloae 
Assigned Tomarvintm 
PriorityimmediateSeveritycriticalReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Versionpi 
Target Version3.0MP0Fixed in Version3.0MP0 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0017466: Upgrade error from 3.0RC7
DescriptionUpgrading from 3.0RC7 fails with this error:

update.database.java:
     [java] Executing database update process without checking changes in local files.
     [java] 0 INFO - Database connection: jdbc:postgresql://localhost:5432/int_upgrade_pgsql. [^] User: int_upgrade_pgsql
     [java] 1034 INFO - Executing full update.database
     [java] 1049 INFO - Reading tables...
     [java] 8143 INFO - Reading views...
     [java] 8274 INFO - Reading sequences...
     [java] 8280 INFO - Reading triggers...
     [java] 8325 INFO - Reading functions...
     [java] 8729 INFO - Sorting foreign keys, indexes and checks...
     [java] 8999 INFO - Starting function and trigger standardization.
     [java] 59405 INFO - Checking datatypes from the model loaded from the database
     [java] 59421 INFO - Original model loaded from database.
     [java] 68294 INFO - Checking datatypes from the model loaded from XML files
     [java] 68348 INFO - Loading data from XML files
     [java] 73260 INFO - Loading and applying configuration scripts
     [java] 73276 INFO - Applying structure part of configuration script: org.openbravo.v3
     [java] 73278 INFO - Loading configuration script: /srv/hudson/workspace/int-upgrade-pgsql/SANDBOX/main/modules/org.openbravo.v3/src-db/database/configScript.xml
     [java] Checking if database structure was modified locally.
     [java] Checking if data has changed in the application dictionary.
     [java] 74574 ERROR - Error while updating in the database : ERROR: column "upgrade_available" of relation "ad_module" does not exist
     [java] Position: 727
     [java] org.postgresql.util.PSQLException: ERROR: column "upgrade_available" of relation "ad_module" does not exist
     [java] Position: 727
     [java] org.apache.ddlutils.DatabaseOperationException: Error while updating in the database : ERROR: column "upgrade_available" of relation "ad_module" does not exist
     [java] Position: 727
     [java] at org.apache.ddlutils.platform.PlatformImplBase.privateupdate(PlatformImplBase.java:1964)
     [java] at org.apache.ddlutils.platform.PlatformImplBase.updateinsert(PlatformImplBase.java:1527)
     [java] at org.openbravo.ddlutils.util.DBSMOBUtil.moveModuleDataFromInstTables(DBSMOBUtil.java:676)
     [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:145)
     [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
     [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
     [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
     [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
     [java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:86)
     [java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:38)
     [java] Caused by: org.postgresql.util.PSQLException: ERROR: column "upgrade_available" of relation "ad_module" does not exist
     [java] Position: 727
     [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
     [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
     [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
     [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
     [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
     [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334)
     [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
     [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
     [java] at org.apache.ddlutils.platform.PlatformImplBase.privateupdate(PlatformImplBase.java:1958)
     [java] ... 5 more
     [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
     [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334)
     [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
     [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
     [java] at org.apache.ddlutils.platform.PlatformImplBase.privateupdate(PlatformImplBase.java:1958)
     [java] at org.apache.ddlutils.platform.PlatformImplBase.updateinsert(PlatformImplBase.java:1527)
     [java] at org.openbravo.ddlutils.util.DBSMOBUtil.moveModuleDataFromInstTables(DBSMOBUtil.java:676)
     [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:145)
     [java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:86)
     [java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:38)
     [java] Error while moving data from install tables.
     [java] 74594 INFO - Executing default prescript
     [java] 75108 INFO - Executed 118 SQL command(s) successfully
     [java] 75125 INFO - Updating database model...
     [java] 86318 INFO - Executed 815 SQL command(s) successfully
     [java] 86331 INFO - Executed 5 forced SQL command(s) successfully
     [java] 86333 INFO - Model update complete.
     [java] 86335 INFO - Disabling foreign keys
     [java] 92187 INFO - Executed 2125 SQL command(s) successfully
     [java] 92200 INFO - Disabling triggers
     [java] 93386 INFO - Executed 534 SQL command(s) successfully
     [java] 94432 INFO - Executed 560 SQL command(s) successfully
Steps To Reproduce1. install.source in 3.0RC7
2. Upgrade to the distribution created from tip.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-06-02 13:48jpabloaeNew Issue
2011-06-02 13:48jpabloaeAssigned To => alostale
2011-06-02 13:48jpabloaeModules => Core
2011-06-02 13:48jpabloaeOBNetwork customer => No
2011-06-02 14:03alostaleStatusnew => scheduled
2011-06-02 14:03alostaleAssigned Toalostale => marvintm
2011-06-02 14:03alostalefix_in_branch => pi
2011-06-02 19:17dmitry_mezentsevStatusscheduled => resolved
2011-06-02 19:17dmitry_mezentsevFixed in Version => 3.0MP0
2011-06-02 19:17dmitry_mezentsevFixed in SCM revision => https://code.openbravo.com/erp/devel/pi/rev/866ee1af74ac [^]
2011-06-02 19:17dmitry_mezentsevResolutionopen => fixed
2011-06-09 16:01shuehnerNote Added: 0038199
2011-06-09 16:09shuehnerNote Added: 0038200
2011-06-09 16:09shuehnerStatusresolved => closed

Notes
(0038199)
shuehner   
2011-06-09 16:01   
https://code.openbravo.com/erp/devel/dbsm-main/rev/876554edb8bb [^]
(0038200)
shuehner   
2011-06-09 16:09   
dbsm code-change reviewed and looks fine as new position of move data is after table structure update which ensures that newly added columns exist. (which are used in the move). Functionally not extra tested as already been done as the builds.openbravo.com test which found this issue is no longer failing.