Openbravo Issue Tracking System - Retail Modules
View Issue Details
0021976Retail ModulesWeb POSpublic2012-10-17 17:122012-10-31 10:55
marvintm 
marvintm 
normalmajorhave not tried
closedfixed 
5
 
 
No
No
0021976: Web POS product categories are not loaded correctly in Oracle
The query which loads Product Categories currently fails in Oracle.

The cause is that in Oracle a distinct with BLOB columns cannot be done.
Try to login in the POS. Notice in the Tomcat log that the query in the file Category.java fails.
No tags attached.
Issue History
2012-10-17 17:12marvintmNew Issue
2012-10-17 17:12marvintmAssigned To => marvintm
2012-10-17 17:12marvintmOBNetwork customer => No
2012-10-17 17:23hgbotCheckin
2012-10-17 17:23hgbotNote Added: 0053431
2012-10-17 17:23hgbotStatusnew => resolved
2012-10-17 17:23hgbotResolutionopen => fixed
2012-10-17 17:23hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/10d8034d3c9caeb0bb0b6869e41ef7d256acfe63 [^]
2012-10-22 11:45hgbotCheckin
2012-10-22 11:45hgbotNote Added: 0053503
2012-10-22 11:45hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/10d8034d3c9caeb0bb0b6869e41ef7d256acfe63 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-discounts/rev/10d8034d3c9caeb0bb0b6869e41ef7d256acfe63 [^]
2012-10-22 19:19hgbotCheckin
2012-10-22 19:19hgbotNote Added: 0053555
2012-10-22 19:19hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-discounts/rev/10d8034d3c9caeb0bb0b6869e41ef7d256acfe63 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-quotations/rev/10d8034d3c9caeb0bb0b6869e41ef7d256acfe63 [^]
2012-10-24 17:28adrianromeroNote Added: 0053641
2012-10-24 17:28adrianromeroStatusresolved => closed
2012-10-31 09:37hgbotCheckin
2012-10-31 09:37hgbotNote Added: 0053884
2012-10-31 09:37hgbotStatusclosed => resolved
2012-10-31 09:37hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-quotations/rev/10d8034d3c9caeb0bb0b6869e41ef7d256acfe63 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-gal/rev/10d8034d3c9caeb0bb0b6869e41ef7d256acfe63 [^]
2012-10-31 10:55adrianromeroStatusresolved => closed

Notes
(0053431)
hgbot   
2012-10-17 17:23   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 10d8034d3c9caeb0bb0b6869e41ef7d256acfe63
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Wed Oct 17 17:22:47 2012 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/10d8034d3c9caeb0bb0b6869e41ef7d256acfe63 [^]

Fixed issue 21976. Categories will now be loaded correctly in Oracle.

---
M src/org/openbravo/retail/posterminal/master/Category.java
---
(0053503)
hgbot   
2012-10-22 11:45   
Repository: erp/pmods/org.openbravo.retail.posterminal-discounts
Changeset: 10d8034d3c9caeb0bb0b6869e41ef7d256acfe63
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Wed Oct 17 17:22:47 2012 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-discounts/rev/10d8034d3c9caeb0bb0b6869e41ef7d256acfe63 [^]

Fixed issue 21976. Categories will now be loaded correctly in Oracle.

---
M src/org/openbravo/retail/posterminal/master/Category.java
---
(0053555)
hgbot   
2012-10-22 19:19   
Repository: erp/pmods/org.openbravo.retail.posterminal-quotations
Changeset: 10d8034d3c9caeb0bb0b6869e41ef7d256acfe63
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Wed Oct 17 17:22:47 2012 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-quotations/rev/10d8034d3c9caeb0bb0b6869e41ef7d256acfe63 [^]

Fixed issue 21976. Categories will now be loaded correctly in Oracle.

---
M src/org/openbravo/retail/posterminal/master/Category.java
---
(0053641)
adrianromero   
2012-10-24 17:28   
Closed for RMP16
(0053884)
hgbot   
2012-10-31 09:37   
Repository: erp/pmods/org.openbravo.retail.posterminal-gal
Changeset: 10d8034d3c9caeb0bb0b6869e41ef7d256acfe63
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Wed Oct 17 17:22:47 2012 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-gal/rev/10d8034d3c9caeb0bb0b6869e41ef7d256acfe63 [^]

Fixed issue 21976. Categories will now be loaded correctly in Oracle.

---
M src/org/openbravo/retail/posterminal/master/Category.java
---