Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010284Openbravo ERPA. Platformpublic2009-08-14 15:302009-08-19 00:00
Reportergnuyoga 
Assigned Tojpabloae 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed 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
Summary0010284: db consistency test is failing
Descriptiondb consistency test is failing

http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/134/console [^]

update ad_module set isindevelopment='N' where ad_module_id='0';

UPDATE 1

M src-db/database/model/tables/AD_SESSION.xml

M src-db/database/sourcedata/AD_TEXTINTERFACES.xml

diff -r 8b660ee052d1 src-db/database/model/tables/AD_SESSION.xml

--- a/src-db/database/model/tables/AD_SESSION.xml Fri Aug 14 14:30:04 2009 +0200

+++ b/src-db/database/model/tables/AD_SESSION.xml Fri Aug 14 15:05:26 2009 +0200

@@ -59,6 +59,6 @@

       <foreign-key foreignTable="AD_ORG" name="ADORG_ADSESSION">

         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>

       </foreign-key>

- <check name="AD_SESSION_ACTIVE_CHK"><![CDATA[SESSION_ACTIVE IN ('Y','N')]]></check>

+ <check name="AD_SESSION_ACTIVE_CHK"><![CDATA[SESSION_ACTIVE IN ('Y', 'N')]]></check>

     </table>

   </database>

diff -r 8b660ee052d1 src-db/database/sourcedata/AD_TEXTINTERFACES.xml

--- a/src-db/database/sourcedata/AD_TEXTINTERFACES.xml Fri Aug 14 14:30:04 2009 +0200

+++ b/src-db/database/sourcedata/AD_TEXTINTERFACES.xml Fri Aug 14 15:05:26 2009 +0200

@@ -4426,7 +4426,7 @@

 <!--803637--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>

 <!--803637--> <TEXT><![CDATA[Attribute]]></TEXT>

 <!--803637--> <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportProductionPDF.fo]]></FILENAME>

-<!--803637--> <ISUSED><![CDATA[Y]]></ISUSED>

+<!--803637--> <ISUSED><![CDATA[N]]></ISUSED>

 <!--803637--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>

 <!--803637--></AD_TEXTINTERFACES>

 

@@ -13377,7 +13377,7 @@

 <!--808473--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>

 <!--808473--> <TEXT><![CDATA[Totals]]></TEXT>

 <!--808473--> <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportInvoiceDiscountJR.jrxml]]></FILENAME>

-<!--808473--> <ISUSED><![CDATA[Y]]></ISUSED>

+<!--808473--> <ISUSED><![CDATA[N]]></ISUSED>

 <!--808473--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>

 <!--808473--></AD_TEXTINTERFACES>

 

@@ -14004,7 +14004,7 @@

 <!--809756--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>

 <!--809756--> <TEXT><![CDATA[Totals]]></TEXT>

 <!--809756--> <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportProjectProfitabilityJR.jrxml]]></FILENAME>

-<!--809756--> <ISUSED><![CDATA[Y]]></ISUSED>

+<!--809756--> <ISUSED><![CDATA[N]]></ISUSED>

 <!--809756--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>

 <!--809756--></AD_TEXTINTERFACES>

 

Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-08-14 15:30gnuyogaNew Issue
2009-08-14 15:30gnuyogaAssigned To => alostale
2009-08-14 15:30gnuyogaOBNetwork customer => No
2009-08-17 08:30gnuyogaNote Added: 0018953
2009-08-17 13:22rafarodaNote Added: 0018970
2009-08-17 13:22rafarodaStatusnew => feedback
2009-08-17 13:22rafarodaversion => pi
2009-08-17 13:32gnuyogaNote Added: 0018971
2009-08-17 13:32gnuyogaNote Deleted: 0018953
2009-08-18 08:52jpabloaeAssigned Toalostale => jpabloae
2009-08-18 08:54hgbotCheckin
2009-08-18 08:54hgbotNote Added: 0018985
2009-08-18 08:54hgbotStatusfeedback => resolved
2009-08-18 08:54hgbotResolutionopen => fixed
2009-08-18 08:54hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/28920110c01a3f92bfbe72323f488f0487161bc5 [^]
2009-08-18 08:56jpabloaeNote Added: 0018986
2009-08-18 10:16plujanStatusresolved => closed
2009-08-19 00:00anonymoussf_bug_id0 => 2839906

Notes
(0018970)
rafaroda   
2009-08-17 13:22   
Sree,

Is this still happening?

Thanks.
(0018971)
gnuyoga   
2009-08-17 13:32   
rafa,

Yes

http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/137/console [^]

error is here http://gnuyoga.pastebin.com/m34819770 [^]
(0018985)
hgbot   
2009-08-18 08:54   
Repository: erp/devel/pi
Changeset: 28920110c01a3f92bfbe72323f488f0487161bc5
Author: Juan Pablo Aroztegi <juanpablo.aroztegi <at> openbravo.com>
Date: Tue Aug 18 08:52:42 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/28920110c01a3f92bfbe72323f488f0487161bc5 [^]

Fixes issue 10284: db consistency test is failing

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_TEXTINTERFACES.xml
---
(0018986)
jpabloae   
2009-08-18 08:56   
I've pushed the diff to solve this inconsistency, caused by formal changes. This should not be necessary, though. From now on we'll find the culprit and make them follow the rules (not editing by hand, sun sync terminology, etc).