Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0004704Openbravo ERPK. Packagingpublic2008-08-25 16:272008-11-25 21:47
Reportermarvintm 
Assigned Tojpabloae 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version2.40Fixed in Version2.40 
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
Summary0004704: 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 00047052.40 closed jpabloae OnCreateDefault command doesn't work in PostgreSQL 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-08-25 16:27marvintmNew Issue
2008-08-25 16:27marvintmAssigned To => jpabloae
2008-08-25 16:27marvintmsf_bug_id0 => 2073735
2008-08-25 16:27marvintmOBNetwork customer => No
2008-08-25 16:27marvintmRegression testing => No
2008-08-25 16:29jpabloaeIssue cloned0004705
2008-08-25 16:29jpabloaeRelationship addedrelated to 0004705
2008-08-25 16:30jpabloaeTarget Version => trunk
2008-08-25 16:31svnbotCheckin
2008-08-25 16:31svnbotNote Added: 0008728
2008-08-25 16:31svnbotStatusnew => resolved
2008-08-25 16:31svnbotResolutionopen => fixed
2008-08-25 16:31svnbotsvn_revision => 6535
2008-08-25 16:32jpabloaeTarget Versiontrunk => 2.40
2008-09-04 10:54plujanStatusresolved => new
2008-09-04 10:54plujanResolutionfixed => open
2008-09-04 10:54plujanNote Added: 0008881
2008-09-04 10:54plujanProjectOpenbravo ERP => @5@
2008-09-18 15:51jpabloaeStatusnew => scheduled
2008-09-18 15:51jpabloaefix_in_branch => trunk
2008-09-18 15:51jpabloaeStatusscheduled => resolved
2008-09-18 15:51jpabloaeFixed in Version => 2.40
2008-09-18 15:51jpabloaeResolutionopen => fixed
2008-11-13 07:01jpabloaeCategoryZ. Others => Upgrader
2008-11-13 07:01jpabloaefix_in_branchtrunk =>
2008-11-13 07:03jpabloaeStatusresolved => closed
2008-11-25 21:41pjuvaraSticky IssueNo => Yes
2008-11-25 21:43pjuvaraProject@5@ => Openbravo ERP
2008-11-25 21:45pjuvaraCategoryUpgrader => K. Packaging
2008-11-25 21:47pjuvaraSticky IssueYes => No

Notes
(0008728)
svnbot   
2008-08-25 16:31   
Repository: openbravo
Revision: 6535
Author: jpabloae
Date: 2008-08-25 16:31:05 +0200 (Mon, 25 Aug 2008)

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

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

https://dev.openbravo.com/websvn/openbravo/?rev=6535&sc=1 [^]
(0008881)
plujan   
2008-09-04 10:54   
Reopened for moving to Packaging project