Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012786Openbravo ERPY. DBSourceManagerpublic2010-03-24 10:252010-04-19 21:13
Reportermarvintm 
Assigned Tomarvintm 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0012786: In PostgreSQL 8.4, some views are changed when exported
DescriptionWhen doing an export.database in PostgreSQL 8.4, everything stays the same except some views, which are exported slightly differently.
Steps To Reproduce- Set Core in development.
- Do ant export.database
- Do hg diff. Notice that some views have changed.
Proposed SolutionThe view translation should take care of this special case.
Additional Information
TagsNo tags attached.
Relationships
related to defect 0012961 closed marvintm api check build 344 fails with errors and warnings - part2 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-03-24 10:25marvintmNew Issue
2010-03-24 10:25marvintmAssigned To => marvintm
2010-03-24 10:26jpabloaeIssue Monitored: jpabloae
2010-03-29 08:21alostaleStatusnew => scheduled
2010-03-29 08:21alostalefix_in_branch => pi
2010-04-13 18:58hgbotCheckin
2010-04-13 18:58hgbotNote Added: 0026150
2010-04-13 18:58hgbotStatusscheduled => resolved
2010-04-13 18:58hgbotResolutionopen => fixed
2010-04-13 18:58hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/825f121b6164895f9057846a5f59bfab30a8f47f [^]
2010-04-13 21:04shuehnerRelationship addedrelated to 0012961
2010-04-13 21:42jpabloaeNote Added: 0026162
2010-04-14 11:44hgbotCheckin
2010-04-14 11:44hgbotNote Added: 0026169
2010-04-14 14:41hgbotCheckin
2010-04-14 14:41hgbotNote Added: 0026185
2010-04-15 17:06shuehnerNote Added: 0026282
2010-04-15 17:06shuehnerStatusresolved => closed
2010-04-16 00:00anonymoussf_bug_id0 => 2987974
2010-04-19 21:13hudsonbotCheckin
2010-04-19 21:13hudsonbotNote Added: 0026465
2010-04-19 21:13hudsonbotCheckin
2010-04-19 21:13hudsonbotNote Added: 0026472
2010-04-19 21:13hudsonbotCheckin
2010-04-19 21:13hudsonbotNote Added: 0026476

Notes
(0026150)
hgbot   
2010-04-13 18:58   
Repository: erp/devel/pi
Changeset: 825f121b6164895f9057846a5f59bfab30a8f47f
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Tue Apr 13 19:11:31 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/825f121b6164895f9057846a5f59bfab30a8f47f [^]

Fixed issue 12786. Views will no longer be changed when exported from PostgreSQL 8.4

---
M src-db/database/lib/dbsourcemanager.jar
M src-db/database/model/views/AD_AUDIT_TRAIL_V.xml
M src-db/database/model/views/AD_FIELD_V.xml
M src-db/database/model/views/AD_FIELD_VT.xml
M src-db/database/model/views/AD_PROCESS_EXECUTION_V.xml
M src-db/database/model/views/AD_REF_LIST_V.xml
M src-db/database/model/views/AD_TABLE_POST_V.xml
M src-db/database/model/views/AD_TAB_V.xml
M src-db/database/model/views/AD_TAB_VT.xml
M src-db/database/model/views/AD_USER_ROLES_V.xml
M src-db/database/model/views/AD_WINDOW_VT.xml
M src-db/database/model/views/A_ASSET_AMORTIZATION.xml
M src-db/database/model/views/C_BPARTNER_V.xml
M src-db/database/model/views/C_CASH_DETAIL.xml
M src-db/database/model/views/C_DEBT_PAYMENT_CANCEL.xml
M src-db/database/model/views/C_DEBT_PAYMENT_GENERATE.xml
M src-db/database/model/views/C_DEBT_PAYMENT_V.xml
M src-db/database/model/views/C_INVOICELINE_V.xml
M src-db/database/model/views/C_INVOICELINE_V2.xml
M src-db/database/model/views/C_INVOICE_CANDIDATE_V.xml
M src-db/database/model/views/C_INVOICE_CUSTOMERPRODQTR.xml
M src-db/database/model/views/C_INVOICE_CUSTOMERVENDQTR.xml
M src-db/database/model/views/C_INVOICE_DAY.xml
M src-db/database/model/views/C_INVOICE_HEADER_V.xml
M src-db/database/model/views/C_INVOICE_HEADER_VT.xml
M src-db/database/model/views/C_INVOICE_LINETAX_V.xml
M src-db/database/model/views/C_INVOICE_LINETAX_VT.xml
M src-db/database/model/views/C_INVOICE_MONTH.xml
M src-db/database/model/views/C_INVOICE_PRODMONTH.xml
M src-db/database/model/views/C_INVOICE_PRODWEEK.xml
M src-db/database/model/views/C_INVOICE_V.xml
M src-db/database/model/views/C_INVOICE_V2.xml
M src-db/database/model/views/C_INVOICE_VENDORMONTH.xml
M src-db/database/model/views/C_INVOICE_WEEK.xml
M src-db/database/model/views/C_ORDER_HEADER_V.xml
M src-db/database/model/views/C_ORDER_HEADER_VT.xml
M src-db/database/model/views/C_ORDER_LINETAX_V.xml
M src-db/database/model/views/C_ORDER_LINETAX_VT.xml
M src-db/database/model/views/C_ORDER_OPEN.xml
M src-db/database/model/views/C_PERIODCONTROL_V.xml
M src-db/database/model/views/C_PROJECTPROPOSAL_V.xml
M src-db/database/model/views/C_PROJECT_DETAILS_V.xml
M src-db/database/model/views/C_PROJECT_DETAILS_VT.xml
M src-db/database/model/views/C_PROJECT_HEADER_V.xml
M src-db/database/model/views/C_PROJECT_HEADER_VT.xml
M src-db/database/model/views/FIN_PAYMENT_DETAIL_V.xml
M src-db/database/model/views/FIN_PAYMENT_PROP_DETAIL_V.xml
M src-db/database/model/views/FIN_PAYMENT_SCHED_INV_V.xml
M src-db/database/model/views/FIN_PAYMENT_SCHED_ORD_V.xml
M src-db/database/model/views/FIN_RECONCILIATIONLINE_V.xml
M src-db/database/model/views/GL_JOURNALLINE_ACCT_V.xml
M src-db/database/model/views/MA_PROCESSPLAN_TOTALIZED.xml
M src-db/database/model/views/MA_SEQUENCE_EMPLOYEE_COST.xml
M src-db/database/model/views/MA_SEQUENCE_INDIRECT_COST_COST.xml
M src-db/database/model/views/MA_SEQUENCE_MACHINE_COST.xml
M src-db/database/model/views/M_INOUT_CANDIDATE_V.xml
M src-db/database/model/views/M_INOUT_HEADER_V.xml
M src-db/database/model/views/M_INOUT_HEADER_VT.xml
M src-db/database/model/views/M_INOUT_LINE_V.xml
M src-db/database/model/views/M_INOUT_LINE_VT.xml
M src-db/database/model/views/M_TRANSACTION_SUM.xml
M src-db/database/model/views/M_TRANSACTION_V.xml
M src-db/database/model/views/R_REQUEST_V.xml
M src-db/database/model/views/S_TIMEEXPENSELINE_V.xml
---
(0026162)
jpabloae   
2010-04-13 21:42   
Terrific! Thanks Antonio.
(0026169)
hgbot   
2010-04-14 11:44   
Repository: erp/devel/pi
Changeset: 2aac4501bbd527315dcd2427ac7d6cd77d5c6510
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Wed Apr 14 11:56:39 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/2aac4501bbd527315dcd2427ac7d6cd77d5c6510 [^]

Related to issue 12786. Slightly modified views so that they don't change in Oracle too.

---
M src-db/database/model/views/AD_AUDIT_TRAIL_V.xml
M src-db/database/model/views/AD_FIELD_V.xml
M src-db/database/model/views/AD_FIELD_VT.xml
M src-db/database/model/views/AD_PROCESS_EXECUTION_V.xml
M src-db/database/model/views/AD_REF_LIST_V.xml
M src-db/database/model/views/AD_TABLE_POST_V.xml
M src-db/database/model/views/AD_TAB_V.xml
M src-db/database/model/views/AD_TAB_VT.xml
M src-db/database/model/views/AD_USER_ROLES_V.xml
M src-db/database/model/views/AD_WINDOW_VT.xml
M src-db/database/model/views/A_ASSET_AMORTIZATION.xml
M src-db/database/model/views/C_BPARTNER_V.xml
M src-db/database/model/views/C_CASH_DETAIL.xml
M src-db/database/model/views/C_DEBT_PAYMENT_CANCEL.xml
M src-db/database/model/views/C_DEBT_PAYMENT_GENERATE.xml
M src-db/database/model/views/C_DEBT_PAYMENT_V.xml
M src-db/database/model/views/C_INVOICELINE_V.xml
M src-db/database/model/views/C_INVOICELINE_V2.xml
M src-db/database/model/views/C_INVOICE_CANDIDATE_V.xml
M src-db/database/model/views/C_INVOICE_CUSTOMERPRODQTR.xml
M src-db/database/model/views/C_INVOICE_CUSTOMERVENDQTR.xml
M src-db/database/model/views/C_INVOICE_DAY.xml
M src-db/database/model/views/C_INVOICE_HEADER_V.xml
M src-db/database/model/views/C_INVOICE_HEADER_VT.xml
M src-db/database/model/views/C_INVOICE_LINETAX_V.xml
M src-db/database/model/views/C_INVOICE_LINETAX_VT.xml
M src-db/database/model/views/C_INVOICE_MONTH.xml
M src-db/database/model/views/C_INVOICE_PRODMONTH.xml
M src-db/database/model/views/C_INVOICE_PRODWEEK.xml
M src-db/database/model/views/C_INVOICE_V.xml
M src-db/database/model/views/C_INVOICE_V2.xml
M src-db/database/model/views/C_INVOICE_VENDORMONTH.xml
M src-db/database/model/views/C_INVOICE_WEEK.xml
M src-db/database/model/views/C_ORDER_HEADER_V.xml
M src-db/database/model/views/C_ORDER_HEADER_VT.xml
M src-db/database/model/views/C_ORDER_LINETAX_V.xml
M src-db/database/model/views/C_ORDER_LINETAX_VT.xml
M src-db/database/model/views/C_ORDER_OPEN.xml
M src-db/database/model/views/C_PERIODCONTROL_V.xml
M src-db/database/model/views/C_PROJECTPROPOSAL_V.xml
M src-db/database/model/views/C_PROJECT_DETAILS_V.xml
M src-db/database/model/views/C_PROJECT_DETAILS_VT.xml
M src-db/database/model/views/C_PROJECT_HEADER_V.xml
M src-db/database/model/views/C_PROJECT_HEADER_VT.xml
M src-db/database/model/views/FIN_PAYMENT_DETAIL_V.xml
M src-db/database/model/views/FIN_PAYMENT_PROP_DETAIL_V.xml
M src-db/database/model/views/FIN_PAYMENT_SCHED_INV_V.xml
M src-db/database/model/views/FIN_PAYMENT_SCHED_ORD_V.xml
M src-db/database/model/views/FIN_RECONCILIATIONLINE_V.xml
M src-db/database/model/views/GL_JOURNALLINE_ACCT_V.xml
M src-db/database/model/views/MA_PROCESSPLAN_TOTALIZED.xml
M src-db/database/model/views/MA_SEQUENCE_EMPLOYEE_COST.xml
M src-db/database/model/views/MA_SEQUENCE_INDIRECT_COST_COST.xml
M src-db/database/model/views/MA_SEQUENCE_MACHINE_COST.xml
M src-db/database/model/views/M_INOUT_CANDIDATE_V.xml
M src-db/database/model/views/M_INOUT_HEADER_V.xml
M src-db/database/model/views/M_INOUT_HEADER_VT.xml
M src-db/database/model/views/M_INOUT_LINE_V.xml
M src-db/database/model/views/M_INOUT_LINE_VT.xml
M src-db/database/model/views/M_TRANSACTION_SUM.xml
M src-db/database/model/views/M_TRANSACTION_V.xml
M src-db/database/model/views/R_REQUEST_V.xml
M src-db/database/model/views/S_TIMEEXPENSELINE_V.xml
---
(0026185)
hgbot   
2010-04-14 14:41   
Repository: erp/devel/pi
Changeset: 0c04f0b3817366c6715c91b16152cddbf259782b
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Wed Apr 14 14:54:44 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/0c04f0b3817366c6715c91b16152cddbf259782b [^]

Related to issue 12786. In PostgreSQL, an additional line will not be added sometimes.

---
M src-db/database/lib/dbsourcemanager.jar
---
(0026282)
shuehner   
2010-04-15 17:06   
Tested working fine -> Closing

Testcases done:
update.database+export.database+check consistency on pg8.4, pg8.3, ora11g (for core without modules)

update.database+export.database+check consistency on pg8.4, pg8.3, ora11g (for 2 modules shipping views (which are not changed/affected by this issue: org.openbravo.obbo, org.openbravo.acctTab)

update.database+export.database+check consistency on pg8.4, pg8.3 (for 1 module shipping view which is affected by this change: org.dwnet.loyaltymgt
- The view is changes once as epxected, after this change no new inconsistency happens.
- This test was skipped on oracle as the view shipped in this module does not work on oracle (even without this issue (Tested on mp14)). As the issue only changes the postgresql translation codepath skipping this test is ok.
(0026465)
hudsonbot   
2010-04-19 21:13   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/825f121b6164 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/91d98bda46c1 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17088.obx [^]
(0026472)
hudsonbot   
2010-04-19 21:13   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/2aac4501bbd5 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/91d98bda46c1 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17088.obx [^]
(0026476)
hudsonbot   
2010-04-19 21:13   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/0c04f0b38173 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/91d98bda46c1 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17088.obx [^]