Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0012786 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] Y. DBSourceManager | major | have not tried | 2010-03-24 10:25 | 2010-04-19 21:13 | |||
| Reporter | marvintm | View Status | public | |||||
| Assigned To | marvintm | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | 825f121b6164 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0012786: In PostgreSQL 8.4, some views are changed when exported | |||||||
| Description | When 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 Solution | The view translation should take care of this special case. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
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 (viewer) 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 (viewer) 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 (viewer) 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 (viewer) 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 [^] |
|
Notes |
|
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:25 | marvintm | OBNetwork customer | => No |
| 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 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |