Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009856Openbravo ERPZ. Otherspublic2009-07-13 16:332009-07-22 00:00
Reportershuehner 
Assigned Toeduardo_Argal 
PriorityimmediateSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
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
Summary0009856: API check: build 74 fails - part1
DescriptionThis api check build fails:

http://builds.openbravo.com/job/erp_devel_pi-module-integrity-test/74/console [^]

This issue track the first of three problems:
  Check Constraint addition: table: AD_ORG_ACCTSCHEMA - Constraint: ADORGACCTSCH_ISACTIVE_CHECK
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0009857 closed shuehner API check: build 74 fails - part2 
related to defect 0009858 closed vinothbabu API check: build 74 fails - part3 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-07-13 16:33shuehnerNew Issue
2009-07-13 16:33shuehnerAssigned To => vinothbabu
2009-07-13 16:36shuehnerNote Added: 0018168
2009-07-13 16:36shuehnerversion => pi
2009-07-13 16:37shuehnerRelationship addedrelated to 0009857
2009-07-13 16:39shuehnerRelationship addedrelated to 0009858
2009-07-14 10:20pjuvaraNote Added: 0018200
2009-07-14 10:21pjuvaraStatusnew => scheduled
2009-07-14 10:21pjuvaraNote Added: 0018201
2009-07-14 10:21pjuvaraAssigned Tovinothbabu => eduardo_Argal
2009-07-14 10:21pjuvarafix_in_branch => pi
2009-07-14 18:11hgbotCheckin
2009-07-14 18:11hgbotNote Added: 0018234
2009-07-14 18:11hgbotStatusscheduled => resolved
2009-07-14 18:11hgbotResolutionopen => fixed
2009-07-14 18:11hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/api-checks/rev/73d457c2aa3856f2b209020018472d0314b8d83d [^]
2009-07-21 11:09plujanStatusresolved => closed
2009-07-22 00:00anonymoussf_bug_id0 => 2825062

Notes
(0018168)
shuehner   
2009-07-13 16:36   
The changed added a new check constraint (allowed values 'Y', 'N') for a boolean type column which is technically a CHAR(1) so the check is useful/necessary. The column itself is older and seem to be missing this check when it was created.

This will fails with data in this column not matching the check constraint. However data other than 'Y', 'N' is not useful for a boolean type column.
(0018200)
pjuvara   
2009-07-14 10:20   
Exception accepted.

Please publish an alert. Given that this is a formal change, the risk is none.
(0018201)
pjuvara   
2009-07-14 10:21   
Eduardo: please publish the alert.
(0018234)
hgbot   
2009-07-14 18:11   
Repository: erp/devel/api-checks
Changeset: 73d457c2aa3856f2b209020018472d0314b8d83d
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Tue Jul 14 18:10:17 2009 +0200
URL: http://code.openbravo.com/erp/devel/api-checks/rev/73d457c2aa3856f2b209020018472d0314b8d83d [^]

Fixes issue 0009856. Fixes issue 0009857

---
M model/model/tables/AD_ORG_ACCTSCHEMA.xml
---