Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0027741
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajorhave not tried2014-10-02 13:072018-06-26 11:38
ReportershuehnerView Statuspublic 
Assigned Toeduardo_Argal 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revisionbaa60ced5e3c
ProjectionnoneETAnoneTarget Version3.0PR15Q1
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Topramakrishnan
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0027741: The database view APRM_REC_DETAIL_V has syntax inconsistency on PostgreSQL 9.3 (and 9.4beta)

DescriptionWhen running a dbconsistency test using PostgreSQL 9.3 version that view exports with a different syntax compare to version before 9.3

Additionally when trying to commit those syntax changes they are again reverted on <9.2

When testing by AMO we could not find a common syntax of this view which exports identically on 9.1 and 9.3

Steps To ReproduceRun dbconsistency test on PostgreSQL 9.3
i.e. by using try param to push pi to try using 9.3
Proposed Solution1.) Rewrite or remove the view and adapt all users (Only known user is QueryListWidget: Reconciliation Detail)

2.) Adapt dbsourcemanager to support the view syntax transparently.

Note: 2.) seems to be very hard to strong recommendation to try 1.) first.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 00277423.0PR15Q1 closededuardo_Argal The database view C_ORDER_LINETAX_VT is not used at all and has syntax concistency problem with pgsql 9.3 
related to defect 00282933.0PR15Q1 closededuardo_Argal api break 

-  Notes
(0072039)
hgbot (developer)
2014-11-26 17:54

Repository: erp/devel/pi
Changeset: baa60ced5e3cc50a6301c8434e96878845e5ca8d
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Wed Nov 26 17:53:50 2014 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/baa60ced5e3cc50a6301c8434e96878845e5ca8d [^]

Fixes issue 27741: The database view APRM_REC_DETAIL_V has syntax inconsistency

---
M modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_COLUMN.xml
M modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_ELEMENT.xml
M modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml
M modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELDGROUP.xml
M modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_REFERENCE.xml
M modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_TABLE.xml
M modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBUIAPP_PARAMETER.xml
M modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/utility/FIN_BankStatementImport.java
M referencedata/sampledata/F_B_International_Group/FIN_RECONCILIATION.xml
M referencedata/sampledata/F_B_International_Group/OBKMO_WIDGET_CLASS_ACCESS.xml
M referencedata/sampledata/QA_Testing/FIN_RECONCILIATION.xml
M referencedata/sampledata/QA_Testing/OBKMO_WIDGET_CLASS_ACCESS.xml
M src-db/database/model/tables/FIN_RECONCILIATION.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src/org/openbravo/financial/ResetAccounting.java
R modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_REC_DETAIL_V.xml
R modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBCQL_QUERY_COLUMN.xml
R modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml
R modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBKMO_WIDGET_CLASS.xml
R modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBKMO_WIDGET_REFERENCE.xml
---
(0072043)
hgbot (developer)
2014-11-26 18:26

Repository: erp/pmods/org.openbravo.retail.sampledata
Changeset: 85d03ee2cdfffb620cf69636910280b646055d87
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Wed Nov 26 18:26:15 2014 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.sampledata/rev/85d03ee2cdfffb620cf69636910280b646055d87 [^]

Related to issue 27741: Fixes related sampledata

---
M referencedata/sampledata/The_White_Valley_Group/FIN_RECONCILIATION.xml
M referencedata/sampledata/The_White_Valley_Group/OBKMO_WIDGET_CLASS_ACCESS.xml
---
(0072413)
pramakrishnan (developer)
2014-12-11 08:37

Code review + testing - OK.
(0073149)
hudsonbot (developer)
2014-12-30 23:26

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/6525fe229e06 [^]
Maturity status: Test

- Issue History
Date Modified Username Field Change
2014-10-02 13:07 shuehner New Issue
2014-10-02 13:07 shuehner Assigned To => dmiguelez
2014-10-02 13:07 shuehner Modules => Core
2014-10-02 13:07 shuehner Triggers an Emergency Pack => No
2014-10-02 13:14 shuehner Assigned To dmiguelez => eduardo_Argal
2014-10-02 13:31 shuehner Relationship added related to 0027742
2014-11-26 17:53 eduardo_Argal Status new => scheduled
2014-11-26 17:53 eduardo_Argal fix_in_branch => pi
2014-11-26 17:54 hgbot Checkin
2014-11-26 17:54 hgbot Note Added: 0072039
2014-11-26 17:54 hgbot Status scheduled => resolved
2014-11-26 17:54 hgbot Resolution open => fixed
2014-11-26 17:54 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/baa60ced5e3cc50a6301c8434e96878845e5ca8d [^]
2014-11-26 18:15 shuehner Relationship added related to 0028293
2014-11-26 18:26 hgbot Checkin
2014-11-26 18:26 hgbot Note Added: 0072043
2014-12-11 08:37 pramakrishnan Review Assigned To => pramakrishnan
2014-12-11 08:37 pramakrishnan Note Added: 0072413
2014-12-11 08:37 pramakrishnan Status resolved => closed
2014-12-30 23:26 hudsonbot Checkin
2014-12-30 23:26 hudsonbot Note Added: 0073149
2018-06-26 11:38 hgbot Checkin
2018-06-26 11:38 hgbot Note Added: 0105400
2018-06-26 14:29 gorka_gil Note Deleted: 0105400


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker