Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0037491ModulesResource and Reservation Management for Contractspublic2017-12-15 11:542017-12-26 12:50
Reporterngarcia 
Assigned Tomarkmm82 
PriorityurgentSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned Tovmromanos
Support ticket49892
OBNetwork customerOBPS
Regression introduced in release
Summary0037491: Cannot compile environment if Resource and Reservation Management for Contracts is installed
DescriptionCannot compile environment if Resource and Reservation Management for Contracts is installed

An element was removed from Resource And Reservations Management Module
Steps To ReproduceAs system admin role:
   Go to Module Management window and install Resource and Reservation Management for Contracts Template

Check the following error message is shown when compiling:

SQL Command failed with: ERROR: insert or update on table "obuiapp_parameter" violates foreign key constraint "obuiapp_parameter_ad_element"
Detail: Key (ad_element_id)=(1459F00FC4404DED9A523FC46F80214E) is not present in table "ad_element".
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
caused by defect 0033464 closed Sanjota Openbravo ERP Modules Automation. Modules fixes 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-12-15 11:54ngarciaNew Issue
2017-12-15 11:54ngarciaAssigned To => Triage Finance
2017-12-15 11:54ngarciaSupport ticket => 49892
2017-12-15 11:54ngarciaOBNetwork customer => Yes
2017-12-15 11:54ngarciaIssue Monitored: networkb
2017-12-15 12:02ngarciaRelationship addedcaused by 0033464
2017-12-15 12:03ngarciaResolution time => 1483570800
2017-12-15 12:04ngarciaDescription Updatedbug_revision_view_page.php?rev_id=16463#r16463
2017-12-15 12:33dmiguelezResolution time1483570800 => 1515106800
2017-12-15 12:35dmiguelezAssigned ToTriage Finance => markmm82
2017-12-15 15:11markmm82Statusnew => scheduled
2017-12-26 12:48hgbotCheckin
2017-12-26 12:48hgbotNote Added: 0101254
2017-12-26 12:48hgbotStatusscheduled => resolved
2017-12-26 12:48hgbotResolutionopen => fixed
2017-12-26 12:48hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.module.resources.contract/rev/ee8fc98c5221b982e6b4d2bd1334614a09425c78 [^]
2017-12-26 12:50vmromanosReview Assigned To => vmromanos
2017-12-26 12:50vmromanosNote Added: 0101255
2017-12-26 12:50vmromanosStatusresolved => closed

Notes
(0101254)
hgbot   
2017-12-26 12:48   
Repository: erp/pmods/org.openbravo.module.resources.contract
Changeset: ee8fc98c5221b982e6b4d2bd1334614a09425c78
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Tue Dec 26 12:44:40 2017 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.resources.contract/rev/ee8fc98c5221b982e6b4d2bd1334614a09425c78 [^]

Fixed bug 37491: compilation issue due to missing ad_element_id

As part of solution of issue 33464, an element was removed from Resource And Reservations
Management Module without take into account it was used on Resource and Reservation Management
for Contracts. It causes that when this last one is installed then it is not
possible to compile the system and a reference error is shown.

To fix that, the removed element was added again, but this time to the org.openbravo.module.resources.contract module, but it's the only one that really uses it.

---
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src-db/database/sourcedata/AD_MODULE.xml
---
(0101255)
vmromanos   
2017-12-26 12:50   
Code review + testing OK

Fixed in Resource and Reservation Management for Contracts 1.1.100 or above