Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0011705Openbravo ERP00. Application dictionarypublic2009-12-09 12:582010-02-16 21:52
Reporteriperdomo 
Assigned Tomarvintm 
PriorityurgentSeverityminorReproducibilitysometimes
StatusclosedResolutionfixed 
PlatformOS20OS Version2.6.28-gentoo-r5
Product Versionpi 
Target Version2.50MP12Fixed in Version2.50MP12 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0011705: AD_Module_Log table shouldn't have a reference to AD_Module table
DescriptionThe AD_Module_Log table is a log table, and in the AD has TableDir reference to AD_Module table. That creates a reference that is not enforced in database but a DAL level.
If you try to use it you could end in problems like this one:
No row with the given identifier exists: [ADModule#FEFDF506B4B143A2A58CC76FBE7FCFD7]

There that module id is an uninstalled module.
Steps To Reproduce* Install a module
* Uninstall it
* Try to access the ADModuleLog through DAL, eg. via REST
http://localhost:8880/openbravo/ws/dal/ModuleLog [^]
Proposed Solution* Change the reference to String in the AD_Module_ID column
Additional Information
TagsNo tags attached.
Relationships
related to defect 0011716 closed iperdomo pi module integrity test failed 
related to defect 0012254 closed shuehner API check build 290 fails - part2 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-12-09 12:58iperdomoNew Issue
2009-12-09 12:58iperdomoAssigned To => iperdomo
2009-12-09 12:58iperdomoStatusnew => scheduled
2009-12-09 12:58iperdomofix_in_branch => pi
2009-12-09 13:01hgbotCheckin
2009-12-09 13:01hgbotNote Added: 0022581
2009-12-09 13:01hgbotStatusscheduled => resolved
2009-12-09 13:01hgbotResolutionopen => fixed
2009-12-09 13:01hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/90377f5799210f0a123e0e14f5fc8b67e3401bac [^]
2009-12-09 14:47hgbotCheckin
2009-12-09 14:47hgbotNote Added: 0022590
2009-12-09 14:47hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/90377f5799210f0a123e0e14f5fc8b67e3401bac [^] => http://code.openbravo.com/erp/devel/pi/rev/14a04cc774eedaff4263f174967308cb5b54c70e [^]
2009-12-10 09:35iperdomoRelationship addedrelated to 0011716
2009-12-10 12:32mtaalNote Added: 0022627
2009-12-10 12:32mtaalStatusresolved => closed
2009-12-10 12:32mtaalFixed in Version => 2.50MP10
2009-12-11 00:00anonymoussf_bug_id0 => 2912327
2009-12-11 06:35hudsonbotCheckin
2009-12-11 06:35hudsonbotNote Added: 0022670
2009-12-11 06:38hudsonbotCheckin
2009-12-11 06:38hudsonbotNote Added: 0022677
2009-12-11 12:06iperdomoNote Added: 0022697
2009-12-11 12:06iperdomoStatusclosed => new
2009-12-11 12:06iperdomoResolutionfixed => open
2009-12-11 12:06iperdomoFixed in Version2.50MP10 =>
2009-12-11 12:06iperdomoAssigned Toiperdomo => marvintm
2009-12-11 16:37hgbotCheckin
2009-12-11 16:37hgbotNote Added: 0022713
2009-12-11 16:37hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/14a04cc774eedaff4263f174967308cb5b54c70e [^] => http://code.openbravo.com/erp/devel/pi/rev/01eeefac3d18a76f5eae05d48937e528edfeff27 [^]
2009-12-14 12:07hgbotCheckin
2009-12-14 12:07hgbotNote Added: 0022742
2009-12-14 12:07hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/01eeefac3d18a76f5eae05d48937e528edfeff27 [^] => http://code.openbravo.com/erp/devel/api-checks/rev/583614cfc880fcc36620b2ad96f5af40e2f3328e [^]
2009-12-14 12:07hgbotCheckin
2009-12-14 12:07hgbotNote Added: 0022743
2009-12-14 12:07hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/api-checks/rev/583614cfc880fcc36620b2ad96f5af40e2f3328e [^] => http://code.openbravo.com/erp/devel/api-checks/rev/975b4dc86d7ef4d2b551cb7cb5b0754191a3f25f [^]
2009-12-15 04:56hudsonbotCheckin
2009-12-15 04:56hudsonbotNote Added: 0022788
2009-12-18 09:56jpabloaeNote Added: 0022930
2009-12-31 12:40iperdomoStatusnew => scheduled
2009-12-31 12:41iperdomoTarget Version => 2.50MP12
2009-12-31 12:41iperdomofix_in_branchpi =>
2010-02-12 15:51hgbotCheckin
2010-02-12 15:51hgbotNote Added: 0024212
2010-02-12 15:51hgbotStatusscheduled => resolved
2010-02-12 15:51hgbotResolutionopen => fixed
2010-02-12 15:51hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/api-checks/rev/975b4dc86d7ef4d2b551cb7cb5b0754191a3f25f [^] => http://code.openbravo.com/erp/devel/pi/rev/1b734ec2a8ccbe311234eb69c0606a02b3293438 [^]
2010-02-12 20:03shuehnerRelationship addedrelated to 0012254
2010-02-15 17:39hudsonbotCheckin
2010-02-15 17:39hudsonbotNote Added: 0024362
2010-02-16 21:52iperdomoNote Added: 0024445
2010-02-16 21:52iperdomoStatusresolved => closed
2010-02-16 21:52iperdomoFixed in Version => 2.50MP12

Notes
(0022581)
hgbot   
2009-12-09 13:01   
Repository: erp/devel/pi
Changeset: 90377f5799210f0a123e0e14f5fc8b67e3401bac
Author: Iván Perdomo <ivan.perdomo <at> openbravo.com>
Date: Wed Dec 09 13:00:41 2009 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/90377f5799210f0a123e0e14f5fc8b67e3401bac [^]

Fixes issue 11705: Changed reference to String

---
M src-db/database/sourcedata/AD_COLUMN.xml
---
(0022590)
hgbot   
2009-12-09 14:47   
Repository: erp/devel/pi
Changeset: 14a04cc774eedaff4263f174967308cb5b54c70e
Author: Iván Perdomo <ivan.perdomo <at> openbravo.com>
Date: Wed Dec 09 14:46:46 2009 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/14a04cc774eedaff4263f174967308cb5b54c70e [^]

Related to issue 11705. Fixes unstable build 570

---
M src-db/database/sourcedata/AD_COLUMN.xml
---
(0022627)
mtaal   
2009-12-10 12:32   
Tested and works fine now.
(0022670)
hudsonbot   
2009-12-11 06:35   
---
A changeset related to this issue has passed a series of tests and has been promoted to main:

Changeset: http://code.openbravo.com/erp/devel/main/rev/789f4e19eaf7 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
---
(0022677)
hudsonbot   
2009-12-11 06:38   
---
An OBX is generated including a changeset related to this issue and is available at:

OBX: http://builds.openbravo.com/erp/obx/core/OpenbravoERP-2.50CI.15682.obx [^]
---
(0022697)
iperdomo   
2009-12-11 12:06   
This fix breaks the upgrade to 2.50MP10
(0022713)
hgbot   
2009-12-11 16:37   
Repository: erp/devel/pi
Changeset: 01eeefac3d18a76f5eae05d48937e528edfeff27
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Fri Dec 11 16:37:09 2009 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/01eeefac3d18a76f5eae05d48937e528edfeff27 [^]

Reverted change to fix issue 11705, so that upgrade to MP10 works correctly.

---
M src-db/database/sourcedata/AD_COLUMN.xml
---
(0022742)
hgbot   
2009-12-14 12:07   
Repository: erp/devel/api-checks
Changeset: 583614cfc880fcc36620b2ad96f5af40e2f3328e
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Mon Dec 14 10:38:20 2009 +0100
URL: http://code.openbravo.com/erp/devel/api-checks/rev/583614cfc880fcc36620b2ad96f5af40e2f3328e [^]

Related to issue 11705 (reverted API change)

---

---
(0022743)
hgbot   
2009-12-14 12:07   
Repository: erp/devel/api-checks
Changeset: 975b4dc86d7ef4d2b551cb7cb5b0754191a3f25f
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Mon Dec 14 12:07:26 2009 +0100
URL: http://code.openbravo.com/erp/devel/api-checks/rev/975b4dc86d7ef4d2b551cb7cb5b0754191a3f25f [^]

Related to issue 11705 (reverted API change)

---
M java/reference/250.japi.gz
---
(0022788)
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 [^]
---
(0022930)
jpabloae   
2009-12-18 09:56   
The API change text has been removed from the API changes document:
http://wiki.openbravo.com/wiki/index.php?title=ERP%2F2.50%2FAPI_changes&diff=47576&oldid=47569 [^]
(0024212)
hgbot   
2010-02-12 15:51   
Repository: erp/devel/pi
Changeset: 1b734ec2a8ccbe311234eb69c0606a02b3293438
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Fri Feb 12 15:21:58 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/1b734ec2a8ccbe311234eb69c0606a02b3293438 [^]

Fixed issue 11705 (reapplied previous patch, which before couldn't be used because of dbsourcemanager issues).

---
M src-db/database/sourcedata/AD_COLUMN.xml
---
(0024362)
hudsonbot   
2010-02-15 17:39   
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/1b734ec2a8cc [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/2596487a564c [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.16391.obx [^]
(0024445)
iperdomo   
2010-02-16 21:52   
Tested on pi @ rev. f554d18c5f2f

Accessing the ModuleLog entity
http://localhost:8880/openbravo/ws/dal/ModuleLog [^]