Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0027741Openbravo ERP09. Financial managementpublic2014-10-02 13:072018-06-26 11:38
Reportershuehner 
Assigned Toeduardo_Argal 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR15Q1Fixed in Version 
Merge Request Status
Review Assigned Topramakrishnan
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0027741: 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.
Additional Information
TagsNo tags attached.
Relationships
related to defect 00277423.0PR15Q1 closed eduardo_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 closed eduardo_Argal api break 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-10-02 13:07shuehnerNew Issue
2014-10-02 13:07shuehnerAssigned To => dmiguelez
2014-10-02 13:07shuehnerOBNetwork customer => No
2014-10-02 13:07shuehnerModules => Core
2014-10-02 13:07shuehnerTriggers an Emergency Pack => No
2014-10-02 13:14shuehnerAssigned Todmiguelez => eduardo_Argal
2014-10-02 13:31shuehnerRelationship addedrelated to 0027742
2014-11-26 17:53eduardo_ArgalStatusnew => scheduled
2014-11-26 17:53eduardo_Argalfix_in_branch => pi
2014-11-26 17:54hgbotCheckin
2014-11-26 17:54hgbotNote Added: 0072039
2014-11-26 17:54hgbotStatusscheduled => resolved
2014-11-26 17:54hgbotResolutionopen => fixed
2014-11-26 17:54hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/baa60ced5e3cc50a6301c8434e96878845e5ca8d [^]
2014-11-26 18:15shuehnerRelationship addedrelated to 0028293
2014-11-26 18:26hgbotCheckin
2014-11-26 18:26hgbotNote Added: 0072043
2014-12-11 08:37pramakrishnanReview Assigned To => pramakrishnan
2014-12-11 08:37pramakrishnanNote Added: 0072413
2014-12-11 08:37pramakrishnanStatusresolved => closed
2014-12-30 23:26hudsonbotCheckin
2014-12-30 23:26hudsonbotNote Added: 0073149
2018-06-26 11:38hgbotCheckin
2018-06-26 11:38hgbotNote Added: 0105400
2018-06-26 14:29gorka_gilNote Deleted: 0105400

Notes
(0072039)
hgbot   
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   
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   
2014-12-11 08:37   
Code review + testing - OK.
(0073149)
hudsonbot   
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