Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009858Openbravo ERPZ. Otherspublic2009-07-13 16:392009-07-22 00:00
Reportershuehner 
Assigned Tovinothbabu 
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
Summary0009858: API check: build 74 fails - part3
DescriptionThis api check build fails:

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

This issue tracks the third problem out of three:

  Added mandatory column without onCreateDefault: AD_ORG_ACCTSCHEMA.ISBPNEWACCOUNT
  Added mandatory column without onCreateDefault: AD_ORG_ACCTSCHEMA.ISPRNEWACCOUNT
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0009856 closed eduardo_Argal API check: build 74 fails - part1 
related to defect 0009857 closed shuehner API check: build 74 fails - part2 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-07-13 16:39shuehnerNew Issue
2009-07-13 16:39shuehnerAssigned To => vinothbabu
2009-07-13 16:39shuehnerRelationship addedrelated to 0009856
2009-07-13 16:41shuehnerNote Added: 0018170
2009-07-13 16:43shuehnerRelationship addedrelated to 0009857
2009-07-14 10:23pjuvaraNote Added: 0018203
2009-07-14 10:24pjuvaraStatusnew => scheduled
2009-07-14 10:24pjuvaraNote Added: 0018204
2009-07-14 10:24pjuvarafix_in_branch => pi
2009-07-14 13:16hgbotCheckin
2009-07-14 13:16hgbotNote Added: 0018218
2009-07-14 13:16hgbotStatusscheduled => resolved
2009-07-14 13:16hgbotResolutionopen => fixed
2009-07-14 13:16hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/03bc6204daf7bc1e918f8065574539569a216dfe [^]
2009-07-21 11:09plujanStatusresolved => closed
2009-07-22 00:00anonymoussf_bug_id0 => 2825064

Notes
(0018170)
shuehner   
2009-07-13 16:41   
This change is about the addition of new mandatory fields which is only allowed if the new fields define a onCreateDefault value.

This value will be used on update database for all existing rows when adding the new columns.

As both column already define a normal default value its likely that the same value 'N' could be used for the onCreateDefault.
(0018203)
pjuvara   
2009-07-14 10:23   
This is indeed a violation and an onCreateDefault statement must be added, otherwise the system will fail for all existing customers.
(0018204)
pjuvara   
2009-07-14 10:24   
Vinoth: please address this as soon as possible.
Thanks,

Paolo
(0018218)
hgbot   
2009-07-14 13:16   
Repository: erp/devel/pi
Changeset: 03bc6204daf7bc1e918f8065574539569a216dfe
Author: vinothbabu <vinoth.babu <at> openbravo.com>
Date: Tue Jul 14 16:41:11 2009 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/03bc6204daf7bc1e918f8065574539569a216dfe [^]

Fixes bug 9858 OnCreateDefault statement is added.

---
M src-db/database/model/tables/AD_ORG_ACCTSCHEMA.xml
---