Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0009856 | Openbravo ERP | Z. Others | public | 2009-07-13 16:33 | 2009-07-22 00:00 |
|
| Reporter | shuehner | |
| Assigned To | eduardo_Argal | |
| Priority | immediate | Severity | major | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | pi | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | No |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0009856: API check: build 74 fails - part1 |
| Description | This 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 | |
| Tags | No 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 Modified | Username | Field | Change |
| 2009-07-13 16:33 | shuehner | New Issue | |
| 2009-07-13 16:33 | shuehner | Assigned To | => vinothbabu |
| 2009-07-13 16:33 | shuehner | OBNetwork customer | => No |
| 2009-07-13 16:36 | shuehner | Note Added: 0018168 | |
| 2009-07-13 16:36 | shuehner | version | => pi |
| 2009-07-13 16:37 | shuehner | Relationship added | related to 0009857 |
| 2009-07-13 16:39 | shuehner | Relationship added | related to 0009858 |
| 2009-07-14 10:20 | pjuvara | Note Added: 0018200 | |
| 2009-07-14 10:21 | pjuvara | Status | new => scheduled |
| 2009-07-14 10:21 | pjuvara | Note Added: 0018201 | |
| 2009-07-14 10:21 | pjuvara | Assigned To | vinothbabu => eduardo_Argal |
| 2009-07-14 10:21 | pjuvara | fix_in_branch | => pi |
| 2009-07-14 18:11 | hgbot | Checkin | |
| 2009-07-14 18:11 | hgbot | Note Added: 0018234 | |
| 2009-07-14 18:11 | hgbot | Status | scheduled => resolved |
| 2009-07-14 18:11 | hgbot | Resolution | open => fixed |
| 2009-07-14 18:11 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/api-checks/rev/73d457c2aa3856f2b209020018472d0314b8d83d [^] |
| 2009-07-21 11:09 | plujan | Status | resolved => closed |
| 2009-07-22 00:00 | anonymous | sf_bug_id | 0 => 2825062 |
|
Notes |
|
|
|
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. |
|
|
|
|
Exception accepted.
Please publish an alert. Given that this is a formal change, the risk is none. |
|
|
|
|
|
Eduardo: please publish the alert. |
|
|
|
(0018234)
|
|
hgbot
|
|
2009-07-14 18:11
|
|
|