Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012282Openbravo ERPA. Platformpublic2010-02-16 10:192010-03-10 18:30
Reportermarvintm 
Assigned Toalostale 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version2.50MP12Fixed in Version2.50MP12 
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
Summary0012282: Sql statement in database postscript fails because isindevelopment is no longer null for all the modules
DescriptionThe statement:

update ad_reference
   set parentreference_id =( CASE VALIDATIONTYPE WHEN 'S' THEN '30' WHEN 'L' THEN '17' WHEN 'T' THEN '18' end)
   where validationtype in ('S','L','T')
   and parentreference_id is null

which is executed in the database postscript, fails when a module is affected and is not in development.
Steps To ReproduceJust update.database when a module which needs to be changed exists in the system.
Proposed SolutionThe trigger related to the table needs to be temporarily disabled for this to work.
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-02-16 10:19marvintmNew Issue
2010-02-16 10:19marvintmAssigned To => alostale
2010-02-16 10:23hgbotCheckin
2010-02-16 10:23hgbotNote Added: 0024387
2010-02-16 10:23hgbotStatusnew => resolved
2010-02-16 10:23hgbotResolutionopen => fixed
2010-02-16 10:23hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/d534e3ae812c2ef590cb435351f1f39739d604ae [^]
2010-02-17 09:57marvintmNote Added: 0024463
2010-02-17 09:57marvintmStatusresolved => closed
2010-02-17 09:57marvintmFixed in Version => 2.50MP12
2010-02-18 00:01anonymoussf_bug_id0 =>
2010-02-18 00:30hudsonbotCheckin
2010-02-18 00:30hudsonbotNote Added: 0024528
2010-03-10 18:30anonymoussf_bug_id => 2968075

Notes
(0024387)
hgbot   
2010-02-16 10:23   
Repository: erp/devel/pi
Changeset: d534e3ae812c2ef590cb435351f1f39739d604ae
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Tue Feb 16 10:23:31 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/d534e3ae812c2ef590cb435351f1f39739d604ae [^]

fixed bug 12282: Sql statement in database postscript fails because isindevelopment is no longer null for all the modules

---
M src-db/database/model/postscript-Oracle.sql
M src-db/database/model/postscript-PostgreSql.sql
---
(0024463)
marvintm   
2010-02-17 09:57   
Tested that it works (the postscript statement is executed without errors, and with the expected result)
(0024528)
hudsonbot   
2010-02-18 00:30   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/d534e3ae812c [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/7c1b489fb0a0 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.16459.obx [^]