Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0010157Openbravo ERPZ. Otherspublic2009-08-03 09:462009-08-19 00:00
shuehner 
dalsasua 
immediatemajorhave not tried
closedfixed 
5
pi 
pi 
Core
No
0010157: API check build 99 fails
This api check fails:

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

+++++++++++++++++++++++++++++++++++++++++++++++++++
  Errors in API data validation
+++++++++++++++++++++++++++++++++++++++++++++++++++
  Changed column value AD_COLUMN.ISMANDATORY -ID:6493 from [N] to [Y]


No tags attached.
related to defect 0051073 closed shuehner Delete obsolete code from prescript-* from before 2.50MP4 
Issue History
2009-08-03 09:46shuehnerNew Issue
2009-08-03 09:46shuehnerAssigned To => dalsasua
2009-08-03 09:46shuehnerNote Added: 0018788
2009-08-04 14:15dalsasuaNote Added: 0018824
2009-08-07 16:30dalsasuaStatusnew => scheduled
2009-08-07 16:30dalsasuafix_in_branch => pi
2009-08-07 16:31hgbotCheckin
2009-08-07 16:31hgbotNote Added: 0018881
2009-08-07 16:31hgbotStatusscheduled => resolved
2009-08-07 16:31hgbotResolutionopen => fixed
2009-08-07 16:31hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/f6ee3b157d7b23dd7f24849f227c590b7427b593 [^]
2009-08-10 11:23hgbotCheckin
2009-08-10 11:23hgbotNote Added: 0018887
2009-08-10 11:23hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/f6ee3b157d7b23dd7f24849f227c590b7427b593 [^] => http://code.openbravo.com/erp/devel/pi/rev/1ae7761ffcf7614b771f6917131cd49f452e8ab7 [^]
2009-08-10 12:28hgbotCheckin
2009-08-10 12:28hgbotNote Added: 0018890
2009-08-10 12:28hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/1ae7761ffcf7614b771f6917131cd49f452e8ab7 [^] => http://code.openbravo.com/erp/devel/api-checks/rev/8756d57a1567f08731635fb7629344191824668e [^]
2009-08-18 14:56sureshbabuStatusresolved => closed
2009-08-18 14:56sureshbabuNote Added: 0019006
2009-08-18 14:56sureshbabuFixed in Version => pi
2009-08-19 00:00anonymoussf_bug_id0 => 2839896
2022-12-05 17:22shuehnerRelationship addedrelated to 0051073

Notes
(0018788)
shuehner   
2009-08-03 09:46   
changeset: 4465:3998e7028d13
user: David Alsasua <david.alsasua@openbravo.com>
date: Fri Jul 31 18:39:58 2009 +0200
files: src-db/database/sourcedata/AD_COLUMN.xml
description:
Field Not Mandatory, corresponding to a non-nullable column
(0018824)
dalsasua   
2009-08-04 14:15   
This column was non-nullable in 2.40, and somehow turned to nullable during 2.50 development. Now needs to be non-nullable again.

This was noticed due to https://issues.openbravo.com/view.php?id=10073 [^]

The only solution is to make this column not nullable again, and the corresondant field mandatory. Problem is approach for updates that include this change.

After discussing possible solutions we have agreed that:

1- A SQL-snippet will be provided to check if there is an update needed. If no update is needed, there is no problem.
2- A OnCreateDefault value will provided for this field, establishing the same account for cash, that the one existing for bank (that has always been mandatory). This way, there will be no problem to perform the update.
3- User must be aware of this, because a default account will have been established with no action from his side. I think that a comment in the release notes is not enough, so we have to decide how will be this communicated to the user.

Kindly Regards.
(0018881)
hgbot   
2009-08-07 16:31   
Repository: erp/devel/pi
Changeset: f6ee3b157d7b23dd7f24849f227c590b7427b593
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Fri Aug 07 16:31:04 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/f6ee3b157d7b23dd7f24849f227c590b7427b593 [^]

Fixes issue 10157: API check build 99 fails

---
M src-db/database/model/prescript-Oracle.sql
M src-db/database/model/prescript-PostgreSql.sql
---
(0018887)
hgbot   
2009-08-10 11:23   
Repository: erp/devel/pi
Changeset: 1ae7761ffcf7614b771f6917131cd49f452e8ab7
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Mon Aug 10 11:22:53 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/1ae7761ffcf7614b771f6917131cd49f452e8ab7 [^]

Fixes issue 10157: API check build 99 fails

---
M src-db/database/model/prescript-Oracle.sql
M src-db/database/model/prescript-PostgreSql.sql
---
(0018890)
hgbot   
2009-08-10 12:28   
Repository: erp/devel/api-checks
Changeset: 8756d57a1567f08731635fb7629344191824668e
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Mon Aug 10 12:28:31 2009 +0200
URL: http://code.openbravo.com/erp/devel/api-checks/rev/8756d57a1567f08731635fb7629344191824668e [^]

Fixes issue 10157: API check build 99 fails

---
M model/model/tables/C_ACCTSCHEMA_DEFAULT.xml
M model/sourcedata/AD_COLUMN.xml
---
(0019006)
sureshbabu   
2009-08-18 14:56   
Not able to reproduce the check