Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0011735Openbravo ERPY. DBSourceManagerpublic2009-12-11 10:102009-12-15 04:56
Reportermarvintm 
Assigned Tomarvintm 
PriorityimmediateSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version2.50MP10Fixed in Version 
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
Summary0011735: rebuild shows lots of error messages if upgrading from an earlier version of Openbravo
DescriptionIf 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.
Steps To Reproduce- 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.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-12-11 10:10marvintmNew Issue
2009-12-11 10:10marvintmAssigned To => marvintm
2009-12-11 10:10marvintmOBNetwork customer => No
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 [^]
---