Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0020860Openbravo ERPA. Platformpublic2012-06-25 21:552012-06-28 08:29
Reportershuehner 
Assigned ToAugustoMauch 
PriorityimmediateSeveritycriticalReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0MP13Fixed in Version3.0MP13 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression levelAutomated tests
Regression date2012-06-25
Regression introduced in release
Regression introduced by commit http://code.openbravo.com/erp/devel/pi/rev/eae0b8fe7555d27a1b36395d2e9ce29d336fc5f6 [^]
Triggers an Emergency PackNo
Summary0020860: http://builds.openbravo.com/job/int-modules-pgsql/1752/ [^] [http://builds.openbravo.com/job/int-modules-pgsql/1752/ [^]] is failing after adding istraillowed columns.
DescriptionInstallation of any module currently fails as update.database fails with an error.


[java] 118401 INFO - Model update complete.
[java] 118769 ERROR - Error while inserting into the database: ERROR: null value in column "istrialallowed" violates not-null constraint
[java] org.postgresql.util.PSQLException: ERROR: null value in column "istrialallowed" violates not-null constraint

Error message indicates relation to the newly added istrialallowed column.


Steps To ReproduceUse current pi (see scm revision for minimum id)
Install any module
run update.database
Proposed Solutioncheck what exact sql is failing.
One possible reason might be the ad_module_install table which does not have the new column, but that might be needed.
Additional Information
TagsNo tags attached.
Relationships
related to feature request 0020855 closed AugustoMauch Include Free for Trial field in Module window 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-06-25 21:55shuehnerNew Issue
2012-06-25 21:55shuehnerAssigned To => AugustoMauch
2012-06-25 21:55shuehnerModules => Core
2012-06-25 21:56shuehnerRegression level => Automated tests
2012-06-26 12:53alostaleRegression date => 2012-06-25
2012-06-26 12:53alostaleRegression introduced by commit => http://code.openbravo.com/erp/devel/pi/rev/eae0b8fe7555d27a1b36395d2e9ce29d336fc5f6 [^]
2012-06-26 12:53alostaleRelationship addedduplicate of 0020855
2012-06-26 12:53alostaleRelationship replacedrelated to 0020855
2012-06-26 13:15hgbotCheckin
2012-06-26 13:15hgbotNote Added: 0050089
2012-06-26 13:15hgbotStatusnew => resolved
2012-06-26 13:15hgbotResolutionopen => fixed
2012-06-26 13:15hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/1627b9cffd7098b135d1cb71ae178150c6d460e3 [^]
2012-06-27 05:29hudsonbotCheckin
2012-06-27 05:29hudsonbotNote Added: 0050175
2012-06-28 08:29alostaleNote Added: 0050241
2012-06-28 08:29alostaleStatusresolved => closed
2012-06-28 08:29alostaleFixed in Version => 3.0MP13

Notes
(0050089)
hgbot   
2012-06-26 13:15   
Repository: erp/devel/pi
Changeset: 1627b9cffd7098b135d1cb71ae178150c6d460e3
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Tue Jun 26 13:15:22 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/1627b9cffd7098b135d1cb71ae178150c6d460e3 [^]

Fixes issue 20860: Column added to ad_module_install

When a mandatory column is added to ad_module, it should be added to ad_module_install too.

---
M src-db/database/model/tables/AD_MODULE_INSTALL.xml
M src-db/database/sourcedata/AD_COLUMN.xml
---
(0050175)
hudsonbot   
2012-06-27 05:29   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/cf3a7135839f [^]

Maturity status: Test
(0050241)
alostale   
2012-06-28 08:29   
Code reviewed and verified in pi@db25f47ad0a4