Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0004643Openbravo ERPA. Platformpublic2008-08-19 13:102008-11-25 23:35
Reportershuehner 
Assigned Tocromero 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 8.04
Product Version 
Target Version2.50Fixed 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
Summary0004643: ant create.database fails with postgresql-8.3 after merge of uuid-branch to r2.5x
DescriptionThe create.database command fails because some trigger cannot be created because some VARCHAR2-types are not translated to varchar for postgres

i.e. trigger MA_PRODUCTIONRUN_STANDARD
line starting 'DECLARE Cur_Stock CURSOR (v_Product_old VARCHAR2, v_UOM_old VARCHAR2, v_Product_UOM_old VARCHAR2,' is trying to use VARCHAR2 type.

i.e. trigger A_ASSET_TRG reports
ERROR: syntax error at or near "Cur_Defaults"

trigger C_ORDERLINE_TRG reports
ERROR: syntax error at or near "v_IsSOTrx"

trigger M_TRANSACTION_TRG reports
ERROR: syntax error at or near "v_ATTRIBUTESET_ID"
Steps To Reproducetry ant create.database on postgresql-8.3 with r2.5x
Proposed Solution
Additional Information
TagsUUID project
Relationships
depends on defect 0004757 closed marvintm Create database fails on PostgreSQL due to some varchar2 dataypes 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-08-19 13:10shuehnerNew Issue
2008-08-19 13:10shuehnerAssigned To => cromero
2008-08-19 13:10shuehnersf_bug_id0 => 2059488
2008-08-19 13:10shuehnerOBNetwork customer => No
2008-08-19 13:10shuehnerRegression testing => No
2008-08-20 11:53psarobeTarget Version => 2.50
2008-08-21 12:16shuehnerTag Attached: UUID project
2008-08-21 12:16shuehnerversiontrunk =>
2008-08-29 11:55iperdomoRelationship addedrelated to 0004757
2008-08-29 11:55iperdomoRelationship deletedrelated to 0004757
2008-08-29 11:55iperdomoRelationship addeddepends on 0004757
2008-08-31 21:25shuehnerNote Added: 0008793
2008-09-01 15:37svnbotCheckin
2008-09-01 15:37svnbotNote Added: 0008827
2008-09-01 15:37svnbotStatusnew => resolved
2008-09-01 15:37svnbotResolutionopen => fixed
2008-09-01 15:37svnbotsvn_revision => 6703
2008-11-25 23:35psarobeStatusresolved => closed

Notes
(0008793)
shuehner   
2008-08-31 21:25   
in current r2.5x only the error regarding MA_PRODUCTIONRUN_STANDARD remains. The other errors are already fixed and not relevant to this issue anymore.
(0008827)
svnbot   
2008-09-01 15:37   
Repository: openbravo
Revision: 6703
Author: marvintm
Date: 2008-09-01 15:37:01 +0200 (Mon, 01 Sep 2008)

Fixed bug 4643. Now create.database should work in PostgreSQL.

---
U branches/r2.5x/src-db/database/model/functions/MA_PRODUCTIONRUN_STANDARD.xml
---

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