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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0012786
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Y. DBSourceManagermajorhave not tried2010-03-24 10:252010-04-19 21:13
ReportermarvintmView Statuspublic 
Assigned Tomarvintm 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision825f121b6164
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0012786: 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.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0012961 closedmarvintm api check build 344 fails with errors and warnings - part2 

-  Notes
(0026150)
hgbot (developer)
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 (reporter)
2010-04-13 21:42

Terrific! Thanks Antonio.
(0026169)
hgbot (developer)
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 (developer)
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 (administrator)
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 (developer)
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 (developer)
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 (developer)
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 [^]

- Issue History
Date Modified Username Field Change
2010-03-24 10:25 marvintm New Issue
2010-03-24 10:25 marvintm Assigned To => marvintm
2010-03-24 10:26 jpabloae Issue Monitored: jpabloae
2010-03-29 08:21 alostale Status new => scheduled
2010-03-29 08:21 alostale fix_in_branch => pi
2010-04-13 18:58 hgbot Checkin
2010-04-13 18:58 hgbot Note Added: 0026150
2010-04-13 18:58 hgbot Status scheduled => resolved
2010-04-13 18:58 hgbot Resolution open => fixed
2010-04-13 18:58 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/825f121b6164895f9057846a5f59bfab30a8f47f [^]
2010-04-13 21:04 shuehner Relationship added related to 0012961
2010-04-13 21:42 jpabloae Note Added: 0026162
2010-04-14 11:44 hgbot Checkin
2010-04-14 11:44 hgbot Note Added: 0026169
2010-04-14 14:41 hgbot Checkin
2010-04-14 14:41 hgbot Note Added: 0026185
2010-04-15 17:06 shuehner Note Added: 0026282
2010-04-15 17:06 shuehner Status resolved => closed
2010-04-16 00:00 anonymous sf_bug_id 0 => 2987974
2010-04-19 21:13 hudsonbot Checkin
2010-04-19 21:13 hudsonbot Note Added: 0026465
2010-04-19 21:13 hudsonbot Checkin
2010-04-19 21:13 hudsonbot Note Added: 0026472
2010-04-19 21:13 hudsonbot Checkin
2010-04-19 21:13 hudsonbot Note Added: 0026476


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker