Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0010284
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminoralways2009-08-14 15:302009-08-19 00:00
ReportergnuyogaView Statuspublic 
Assigned Tojpabloae 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision28920110c01a
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0010284: 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>

 

TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

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

Sree,

Is this still happening?

Thanks.
(0018971)
gnuyoga (reporter)
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 (developer)
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 (reporter)
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).

- Issue History
Date Modified Username Field Change
2009-08-14 15:30 gnuyoga New Issue
2009-08-14 15:30 gnuyoga Assigned To => alostale
2009-08-17 08:30 gnuyoga Note Added: 0018953
2009-08-17 13:22 rafaroda Note Added: 0018970
2009-08-17 13:22 rafaroda Status new => feedback
2009-08-17 13:22 rafaroda version => pi
2009-08-17 13:32 gnuyoga Note Added: 0018971
2009-08-17 13:32 gnuyoga Note Deleted: 0018953
2009-08-18 08:52 jpabloae Assigned To alostale => jpabloae
2009-08-18 08:54 hgbot Checkin
2009-08-18 08:54 hgbot Note Added: 0018985
2009-08-18 08:54 hgbot Status feedback => resolved
2009-08-18 08:54 hgbot Resolution open => fixed
2009-08-18 08:54 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/28920110c01a3f92bfbe72323f488f0487161bc5 [^]
2009-08-18 08:56 jpabloae Note Added: 0018986
2009-08-18 10:16 plujan Status resolved => closed
2009-08-19 00:00 anonymous sf_bug_id 0 => 2839906


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker