Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0022634 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] 07. Sales management | critical | always | 2012-12-19 12:20 | 2012-12-31 08:48 | |||
Reporter | gorkaion | View Status | public | |||||
Assigned To | gorkaion | |||||||
Priority | immediate | Resolution | fixed | Fixed in Version | ||||
Status | closed | Fix in branch | Fixed in SCM revision | ba7850bc2648 | ||||
Projection | none | ETA | none | Target Version | pi | |||
OS | Linux 32 bit | Database | Oracle | Java version | 1.5.0_15 | |||
OS Version | Gentoo | Database version | 11g | Ant version | 1.7.0 | |||
Product Version | pi | SCM revision | ||||||
Review Assigned To | naiaramartinez | |||||||
Web browser | ||||||||
Modules | Core | |||||||
Regression level | Automated tests | |||||||
Regression date | 2012-12-19 | |||||||
Regression introduced in release | ||||||||
Regression introduced by commit | https://code.openbravo.com/erp/devel/pi/rev/91d5e374a3a4 [^] | |||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0022634: test int-dbcons-pgsql failure due to view change | |||||||
Description | Test int-dbcons-pgsql failure due to view change Build 0003587 (Dec 19, 2012 11:13:29 AM) Output diff -r bf1cabd2bc65 src-db/database/model/views/M_PRERESERVATION_PICK_EDIT.xml --- a/src-db/database/model/views/M_PRERESERVATION_PICK_EDIT.xml Wed Dec 19 10:07:13 2012 +0100 +++ b/src-db/database/model/views/M_PRERESERVATION_PICK_EDIT.xml Wed Dec 19 10:21:15 2012 +0000 @@ -1,4 +1,4 @@ <?xml version="1.0"?> <database name="VIEW M_PRERESERVATION_PICK_EDIT"> - <view name="M_PRERESERVATION_PICK_EDIT"><![CDATA[SELECT COALESCE(res.m_reservation_stock_id, (sol.c_orderline_id || pol.c_orderline_id)) AS m_prereservation_pick_edit_id, pol.ad_client_id, pol.ad_org_id, pol.createdby, pol.created, pol.updated, pol.updatedby, to_char('Y') AS isactive, pol.c_orderline_id AS purchase_orderline_id, sol.c_orderline_id AS sales_orderline_id, so.documentno, sol.line, so.dateordered, so.datepromised, pol.qtyordered AS purchasedqty, del.qty AS receivedqty, res.quantity AS reservedqty, res.m_reservation_stock_id, CASE WHEN res.m_reservation_stock_id IS NULL THEN 'N' ELSE 'Y' END AS ob_selected, sol.qtyordered, sol.qtydelivered, solres.m_reservation_id, COALESCE(solres.qty, 0) - COALESCE(res.quantity, 0) AS otherresqty, so.c_bpartner_id FROM c_orderline pol JOIN c_order po ON pol.c_order_id = po.c_order_id AND po.issotrx = 'N' AND po.docstatus = 'CO' JOIN c_orderline sol ON pol.m_product_id = sol.m_product_id AND sol.qtyordered <> sol.qtydelivered JOIN c_order so ON sol.c_order_id = so.c_order_id AND so.issotrx = 'Y' AND so.docstatus = 'CO' JOIN (SELECT COALESCE(sum(mp.qty), 0) AS qty, ol.c_orderline_id FROM c_orderline ol JOIN c_order o ON ol.c_order_id = o.c_order_id AND o.issotrx = 'N' AND o.docstatus = 'CO' LEFT JOIN m_matchpo mp ON mp.c_orderline_id = ol.c_orderline_id AND mp.m_inoutline_id IS NOT NULL GROUP BY ol.c_orderline_id) del ON del.c_orderline_id = pol.c_orderline_id AND del.qty <> pol.qtyordered LEFT JOIN (SELECT r.c_orderline_id AS sales_orderline_id, rs.c_orderline_id AS purchase_orderline_id, rs.quantity, rs.m_reservation_stock_id FROM m_reservation r JOIN m_reservation_stock rs ON r.m_reservation_id = rs.m_reservation_id WHERE r.c_orderline_id IS NOT NULL AND rs.c_orderline_id IS NOT NULL AND rs.m_locator_id IS NULL AND (r.res_status != 'CL')) res ON res.sales_orderline_id = sol.c_orderline_id AND res.purchase_orderline_id = pol.c_orderline_id LEFT JOIN (SELECT sum(rs.quantity - COALESCE(rs.releasedqty, 0)) AS qty, r.m_reservation_id, r.c_orderline_id, r.quantity AS resqty FROM m_reservation r JOIN m_reservation_stock rs ON r.m_reservation_id = rs.m_reservation_id WHERE r.c_orderline_id IS NOT NULL GROUP BY r.m_reservation_id, r.c_orderline_id, r.quantity) solres ON solres.c_orderline_id = sol.c_orderline_id WHERE (COALESCE(solres.qty, 0) - COALESCE(res.quantity, 0)) <> (sol.qtyordered - sol.qtydelivered)]]></view> + <view name="M_PRERESERVATION_PICK_EDIT"><![CDATA[SELECT COALESCE(res.m_reservation_stock_id, (sol.c_orderline_id || pol.c_orderline_id)) AS m_prereservation_pick_edit_id, pol.ad_client_id, pol.ad_org_id, pol.createdby, pol.created, pol.updated, pol.updatedby, to_char('Y') AS isactive, pol.c_orderline_id AS purchase_orderline_id, sol.c_orderline_id AS sales_orderline_id, so.documentno, sol.line, so.dateordered, so.datepromised, pol.qtyordered AS purchasedqty, del.qty AS receivedqty, res.quantity AS reservedqty, res.m_reservation_stock_id, CASE WHEN res.m_reservation_stock_id IS NULL THEN 'N' ELSE 'Y' END AS ob_selected, sol.qtyordered, sol.qtydelivered, solres.m_reservation_id, COALESCE(solres.qty, 0) - COALESCE(res.quantity, 0) AS otherresqty, so.c_bpartner_id FROM c_orderline pol JOIN c_order po ON pol.c_order_id = po.c_order_id AND po.issotrx = 'N' AND po.docstatus = 'CO' JOIN c_orderline sol ON pol.m_product_id = sol.m_product_id AND sol.qtyordered <> sol.qtydelivered JOIN c_order so ON sol.c_order_id = so.c_order_id AND so.issotrx = 'Y' AND so.docstatus = 'CO' JOIN (SELECT COALESCE(sum(mp.qty), 0) AS qty, ol.c_orderline_id FROM c_orderline ol JOIN c_order o ON ol.c_order_id = o.c_order_id AND o.issotrx = 'N' AND o.docstatus = 'CO' LEFT JOIN m_matchpo mp ON mp.c_orderline_id = ol.c_orderline_id AND mp.m_inoutline_id IS NOT NULL GROUP BY ol.c_orderline_id) del ON del.c_orderline_id = pol.c_orderline_id AND del.qty <> pol.qtyordered LEFT JOIN (SELECT r.c_orderline_id AS sales_orderline_id, rs.c_orderline_id AS purchase_orderline_id, rs.quantity, rs.m_reservation_stock_id FROM m_reservation r JOIN m_reservation_stock rs ON r.m_reservation_id = rs.m_reservation_id WHERE r.c_orderline_id IS NOT NULL AND rs.c_orderline_id IS NOT NULL AND rs.m_locator_id IS NULL AND r.res_status <> 'CL') res ON res.sales_orderline_id = sol.c_orderline_id AND res.purchase_orderline_id = pol.c_orderline_id LEFT JOIN (SELECT sum(rs.quantity - COALESCE(rs.releasedqty, 0)) AS qty, r.m_reservation_id, r.c_orderline_id, r.quantity AS resqty FROM m_reservation r JOIN m_reservation_stock rs ON r.m_reservation_id = rs.m_reservation_id WHERE r.c_orderline_id IS NOT NULL GROUP BY r.m_reservation_id, r.c_orderline_id, r.quantity) solres ON solres.c_orderline_id = sol.c_orderline_id WHERE (COALESCE(solres.qty, 0) - COALESCE(res.quantity, 0)) <> (sol.qtyordered - sol.qtydelivered)]]></view> </database> | |||||||
Steps To Reproduce | N/A | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | |
Notes | |
(0055074) hgbot (developer) 2012-12-19 12:22 |
Repository: erp/devel/pi Changeset: ba7850bc2648aad74df97eaee78402b774a3cad1 Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com> Date: Wed Dec 19 12:22:13 2012 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/ba7850bc2648aad74df97eaee78402b774a3cad1 [^] Fixed issue 22634.Fix pg database consistency issue in view. --- M src-db/database/model/views/M_PRERESERVATION_PICK_EDIT.xml --- |
(0055097) hudsonbot (developer) 2012-12-19 20:31 |
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/a69803a2b545 [^] Maturity status: Test |
Issue History | |||
Date Modified | Username | Field | Change |
2012-12-19 12:20 | gorkaion | New Issue | |
2012-12-19 12:20 | gorkaion | Assigned To | => gorkaion |
2012-12-19 12:20 | gorkaion | Modules | => Core |
2012-12-19 12:20 | gorkaion | Triggers an Emergency Pack | => No |
2012-12-19 12:21 | gorkaion | Review Assigned To | => naiaramartinez |
2012-12-19 12:21 | gorkaion | Regression level | => Automated tests |
2012-12-19 12:21 | gorkaion | Regression date | => 2012-12-19 |
2012-12-19 12:21 | gorkaion | Regression introduced by commit | => https://code.openbravo.com/erp/devel/pi/rev/91d5e374a3a4 [^] |
2012-12-19 12:22 | hgbot | Checkin | |
2012-12-19 12:22 | hgbot | Note Added: 0055074 | |
2012-12-19 12:22 | hgbot | Status | new => resolved |
2012-12-19 12:22 | hgbot | Resolution | open => fixed |
2012-12-19 12:22 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/ba7850bc2648aad74df97eaee78402b774a3cad1 [^] |
2012-12-19 20:31 | hudsonbot | Checkin | |
2012-12-19 20:31 | hudsonbot | Note Added: 0055097 | |
2012-12-31 08:48 | naiaramartinez | Status | resolved => closed |
Copyright © 2000 - 2009 MantisBT Group |