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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0027384
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] Contract Management Infrastructuremajoralways2014-08-20 10:402014-08-20 11:05
ReporteregoitzView Statuspublic 
Assigned Toegoitz 
PriorityurgentResolutionopenFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned Toegoitz
Regression introduced in release
Summary

0027384: 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
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0069540)
vmromanos (manager)
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 (manager)
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 (manager)
2014-08-20 11:05

solved on 1.1.1 release

- Issue History
Date Modified Username Field Change
2014-08-20 10:40 egoitz New Issue
2014-08-20 10:40 egoitz Assigned To => vmromanos
2014-08-20 10:40 egoitz Resolution time => 1410732000
2014-08-20 10:49 vmromanos Note Added: 0069540
2014-08-20 10:49 vmromanos Assigned To vmromanos => egoitz
2014-08-20 10:49 vmromanos Status new => feedback
2014-08-20 11:04 egoitz Note Added: 0069543
2014-08-20 11:05 egoitz Review Assigned To => egoitz
2014-08-20 11:05 egoitz Note Added: 0069544
2014-08-20 11:05 egoitz Status feedback => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker