Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0011735Openbravo ERPY. DBSourceManagerpublic2009-12-11 10:102009-12-15 04:56
marvintm 
marvintm 
immediatemajorhave not tried
closedfixed 
5
 
2.50MP10 
Core
No
0011735: rebuild shows lots of error messages if upgrading from an earlier version of Openbravo
If update.database is done on a database which doesn't yet have the ad_error_log table, lots of messages like these are shown:

[java] Processing Foreign key Foreign key [name=CACCTSCHEMA_DEFAULT; onupdate=null; ondelete=cascade; foreign table=C_ACCTSCHEMA; 1 references] (removed from table C_ACCTSCHEMA_DEFAULT)
     [java] Error while trying to insert into log table
     [java] Processing Foreign key Foreign key [name=DEPRECACCT_CSCHEMADEFAULT; onupdate=null; ondelete=null; foreign table=C_VALIDCOMBINATION; 1 references] (removed from table C_ACCTSCHEMA_DEFAULT)
     [java] Error while trying to insert into log table
     [java] Processing Foreign key Foreign key [name=DIPOSALLOSS_CSCHEMADEFAULT; onupdate=null; ondelete=null; foreign table=C_VALIDCOMBINATION; 1 references] (removed from table C_ACCTSCHEMA_DEFAULT)
     [java] Error while trying to insert into log table
     [java] Processing Foreign key Foreign key [name=DISPOSALGAIN_CSCHEMADEFAULT; onupdate=null; ondelete=null; foreign table=C_VALIDCOMBINATION; 1 references] (removed from table C_ACCTSCHEMA_DEFAULT)
     [java] Error while trying to insert into log table
     [java] Processing Foreign key Foreign key [name=VC_BASSET_CSCHEMADEFAULT; onupdate=null; ondelete=null; foreign table=C_VALIDCOMBINATION; 1 references] (removed from table C_ACCTSCHEMA_DEFAULT)
     [java] Error while trying to insert into log table
     [java] Processing Foreign key Foreign key [name=VC_BEXPENSE_CSCHEMADEFAULT; onupdate=null; ondelete=null; foreign table=C_VALIDCOMBINATION; 1 references] (removed from table C_ACCTSCHEMA_DEFAULT)
     [java] Error while trying to insert into log table
     [java] Processing Foreign key Foreign key [name=VC_BINTERESTEXP_CSCHEMADEFAULT; onupdate=null; ondelete=null; foreign table=C_VALIDCOMBINATION; 1 references] (removed from table C_ACCTSCHEMA_DEFAULT)
     [java] Error while trying to insert into log table

This is due to insertions being done in a table (ad_error_log) which doesn't yet exist.
- Go to a version of Openbravo which doesn't have the ad_error_log table yet (like MP8), and do install.source.
- Update to current version of pi.
- Do update.database. The error messages will appear.
No tags attached.
Issue History
2009-12-11 10:10marvintmNew Issue
2009-12-11 10:10marvintmAssigned To => marvintm
2009-12-11 10:11hgbotCheckin
2009-12-11 10:11hgbotNote Added: 0022690
2009-12-11 10:11hgbotStatusnew => resolved
2009-12-11 10:11hgbotResolutionopen => fixed
2009-12-11 10:11hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/e55979c65024d84b619281af1eac1681881686f2 [^]
2009-12-11 11:17alostaleStatusresolved => closed
2009-12-12 00:00anonymoussf_bug_id0 => 2913001
2009-12-15 04:56hudsonbotCheckin
2009-12-15 04:56hudsonbotNote Added: 0022786

Notes
(0022690)
hgbot   
2009-12-11 10:11   
Repository: erp/devel/pi
Changeset: e55979c65024d84b619281af1eac1681881686f2
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Fri Dec 11 10:11:07 2009 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/e55979c65024d84b619281af1eac1681881686f2 [^]

Fixed issue 11735. Errors will not be shown on update.database from a previous version of Core.

---
M src-core/src/org/openbravo/utils/OBRebuildAppender.java
---
(0022786)
hudsonbot   
2009-12-15 04:56   
---
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/e7ad8a48210d [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/obx/core/OpenbravoERP-2.50CI.15705.obx [^]
---