Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0027384ModulesContract Management Infrastructurepublic2014-08-20 10:402014-08-20 11:05
Reporteregoitz 
Assigned Toegoitz 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned Toegoitz
Support ticket
OBNetwork customer
Regression introduced in release
Summary0027384: The contracta management structure module should depend on Service Contract Management module
DescriptionThe contract management structure module should depend on Service Contract Management module.

Althouht the contract management structure is included on a template, the module management window allows you to install that module without the template.This causes an error when executing the rebuild because the module has refernces to a callout and a process included on the service contrat management window.
Steps To Reproduce-Install the contract management structure module
you get the following error on the rebuild.

     [java] 98136 INFO - Enabling Foreign Keys and Triggers
     [java] 98710 WARN - SQL Command failed with: ERROR: insert or update on table "ad_column" violates foreign key constraint "ad_column_ad_callout"
     [java] Detail: Key (ad_callout_id)=(99DFF0D14CDF4AD190B193D0B5CC4F07) is not present in table "ad_callout".
     [java] 98716 WARN - -- END
     [java] ALTER TABLE AD_COLUMN
     [java] ADD CONSTRAINT AD_COLUMN_AD_CALLOUT FOREIGN KEY (AD_CALLOUT_ID) REFERENCES AD_CALLOUT (AD_CALLOUT_ID)
     [java] 98824 WARN - SQL Command failed with: ERROR: insert or update on table "ad_column" violates foreign key constraint "ad_column_ad_process"
     [java] Detail: Key (ad_process_id)=(1F6F4445A7084F959D70532F656C9FDE) is not present in table "ad_process".
     [java] 98830 WARN - -- END
     [java] ALTER TABLE AD_COLUMN
     [java] ADD CONSTRAINT AD_COLUMN_AD_PROCESS FOREIGN KEY (AD_PROCESS_ID) REFERENCES AD_PROCESS (AD_PROCESS_ID) ON DELETE SET NULL
     [java] 101653 INFO - Executed 359 SQL command(s) with 2 error(s)
Proposed SolutionAdd the correct dependency
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-08-20 10:40egoitzNew Issue
2014-08-20 10:40egoitzAssigned To => vmromanos
2014-08-20 10:40egoitzResolution time => 1410732000
2014-08-20 10:49vmromanosNote Added: 0069540
2014-08-20 10:49vmromanosAssigned Tovmromanos => egoitz
2014-08-20 10:49vmromanosStatusnew => feedback
2014-08-20 11:04egoitzNote Added: 0069543
2014-08-20 11:05egoitzReview Assigned To => egoitz
2014-08-20 11:05egoitzNote Added: 0069544
2014-08-20 11:05egoitzStatusfeedback => closed

Notes
(0069540)
vmromanos   
2014-08-20 10:49   
Are you sure you get these errors when installing just the Contract Management Infrastructure module into a fresh instance?

The following commands run over the org.openbravo.contract module's code returns no matches:

fgrep -r 1F6F4445A7084F959D70532F656C9FDE *
fgrep -r 99DFF0D14CDF4AD190B193D0B5CC4F07 *
(0069543)
egoitz   
2014-08-20 11:04   
We have seen that that only happens on CS release.
could you updaet more recent releases from QA Approved to Confirmed STable
(0069544)
egoitz   
2014-08-20 11:05   
solved on 1.1.1 release