Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0004705Openbravo ERPZ. Otherspublic2008-08-25 16:292008-12-02 13:02
Reporterjpabloae 
Assigned Tojpabloae 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40 
Target Version2.40Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0004705: OnCreateDefault command doesn't work in PostgreSQL
DescriptionWhen the update.customized.database process is executed while trying to upgrade a customized r2.35 mp5 database to a r2.4 database, there are several errors related to the OnCreateDefault attribute of several tables.

Specifically, the problem is related to the "SELECT 'x' FROM DUAL" syntax used there. Those statements should be replaced by a simple 'x', to make them compatible both with Oracle and PostgreSQL.
Steps To ReproduceJust use the ant update.customized.database process in an MP5 database, with an originalDatabase folder containing an MP5 database, and a database folder containing the 2.40 standard xml files.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00047042.40 closed jpabloae OnCreateDefault command doesn't work in PostgreSQL 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-08-25 16:29jpabloaeNew Issue
2008-08-25 16:29jpabloaeAssigned To => jpabloae
2008-08-25 16:29jpabloaeOBNetwork customer => No
2008-08-25 16:29jpabloaeRegression testing => No
2008-08-25 16:29jpabloaeIssue generated from0004704
2008-08-25 16:29jpabloaeRelationship addedrelated to 0004704
2008-08-25 16:31svnbotCheckin
2008-08-25 16:31svnbotNote Added: 0008729
2008-08-25 16:31svnbotStatusnew => resolved
2008-08-25 16:31svnbotResolutionopen => fixed
2008-08-25 16:31svnbotsvn_revision => 6536
2008-08-25 16:32jpabloaeTarget Version2.40 => trunk
2008-09-04 16:22psarobeTarget Versiontrunk => 2.40
2008-11-25 23:20psarobeStatusresolved => closed
2008-12-02 13:02jaimetorresf_bug_id0 => 2377077

Notes
(0008729)
svnbot   
2008-08-25 16:31   
Repository: openbravo
Revision: 6536
Author: jpabloae
Date: 2008-08-25 16:31:51 +0200 (Mon, 25 Aug 2008)

Fixes issue 4705: OnCreateDefault command doesn't work in PostgreSQL

---
U trunk/src-db/database/model/tables/C_BANKACCOUNT.xml
U trunk/src-db/database/model/tables/C_BP_BANKACCOUNT.xml
U trunk/src-db/database/model/tables/C_GLITEM.xml
U trunk/src-db/database/model/tables/C_PROJECT.xml
U trunk/src-db/database/model/tables/C_PROJECTTASK.xml
U trunk/src-db/database/model/tables/C_TAX.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=6536&sc=1 [^]