Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0024969Retail ModulesWeb POSpublic2013-10-17 17:512013-11-19 18:21
Reporterguilleaer 
Assigned Toguilleaer 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionRMP28Fixed in VersionRMP28 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customerNo
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0024969: Openbravo Web POS in not working in Oracle
DescriptionOpenbravo Web POS RMP27 is not working in Oracle databases
Steps To ReproduceCreate an environment of Openbravo Web POS using oracle.

- Module script gives an error during the environment set up
- Once login is done some queries are throwing errors
  + BPLocation
  + Categories
  + Products
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-10-17 17:51guilleaerNew Issue
2013-10-17 17:51guilleaerAssigned To => guilleaer
2013-10-17 17:51guilleaerOBNetwork customer => No
2013-10-17 17:51guilleaerTriggers an Emergency Pack => No
2013-10-21 09:06hgbotCheckin
2013-10-21 09:06hgbotNote Added: 0061810
2013-10-21 09:06hgbotStatusnew => resolved
2013-10-21 09:06hgbotResolutionopen => fixed
2013-10-21 09:06hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/9dcf85c769bd4428c83820b7c08d42cdbbb1845e [^]
2013-10-21 09:55hgbotCheckin
2013-10-21 09:55hgbotNote Added: 0061812
2013-10-21 11:04marvintmReview Assigned To => marvintm
2013-10-21 11:04marvintmStatusresolved => closed
2013-10-21 11:04marvintmFixed in Version => RMP28
2013-10-21 16:15hgbotCheckin
2013-10-21 16:15hgbotNote Added: 0061823
2013-10-21 17:21hgbotCheckin
2013-10-21 17:21hgbotNote Added: 0061824
2013-10-22 18:29hgbotCheckin
2013-10-22 18:29hgbotNote Added: 0061851
2013-10-22 18:29hgbotStatusclosed => resolved
2013-10-22 18:29hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/9dcf85c769bd4428c83820b7c08d42cdbbb1845e [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.cirque/rev/9dcf85c769bd4428c83820b7c08d42cdbbb1845e [^]
2013-10-22 18:29hgbotCheckin
2013-10-22 18:29hgbotNote Added: 0061852
2013-10-22 18:30hgbotCheckin
2013-10-22 18:30hgbotNote Added: 0061854
2013-10-22 18:30hgbotCheckin
2013-10-22 18:30hgbotNote Added: 0061855
2013-10-24 18:29hgbotCheckin
2013-10-24 18:29hgbotNote Added: 0061886
2013-10-29 16:35marvintmStatusresolved => closed
2013-10-30 16:03hgbotCheckin
2013-10-30 16:03hgbotNote Added: 0061971
2013-11-18 12:51hgbotCheckin
2013-11-18 12:51hgbotNote Added: 0062177
2013-11-18 12:51hgbotStatusclosed => resolved
2013-11-18 12:51hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.cirque/rev/9dcf85c769bd4428c83820b7c08d42cdbbb1845e [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-splitlines/rev/9dcf85c769bd4428c83820b7c08d42cdbbb1845e [^]
2013-11-18 12:52hgbotCheckin
2013-11-18 12:52hgbotNote Added: 0062178
2013-11-18 12:52hgbotCheckin
2013-11-18 12:52hgbotNote Added: 0062180
2013-11-18 12:52hgbotCheckin
2013-11-18 12:52hgbotNote Added: 0062181
2013-11-18 12:52hgbotCheckin
2013-11-18 12:52hgbotNote Added: 0062182
2013-11-19 18:21marvintmStatusresolved => closed

Notes
(0061810)
hgbot   
2013-10-21 09:06   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 9dcf85c769bd4428c83820b7c08d42cdbbb1845e
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Mon Oct 21 08:56:08 2013 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/9dcf85c769bd4428c83820b7c08d42cdbbb1845e [^]

fixed issue 24969: Web POS is now working using oracle

---
M src-util/modulescript/src/org/openbravo/retail/posterminal/modulescript/InsertDiscountPreference_Data.xsql
M src/org/openbravo/retail/posterminal/master/BPLocation.java
M src/org/openbravo/retail/posterminal/master/Category.java
M src/org/openbravo/retail/posterminal/master/Product.java
---
(0061812)
hgbot   
2013-10-21 09:55   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: af08487403eb9dd3c4b6320ab47d068804a2d4a2
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Mon Oct 21 09:37:44 2013 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/af08487403eb9dd3c4b6320ab47d068804a2d4a2 [^]

related to issue 24969: Include compiled file of module script

---
M build/classes/org/openbravo/retail/posterminal/modulescript/InsertDiscountPreferenceData.class
---
(0061823)
hgbot   
2013-10-21 16:15   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: bbf9b2120f7563135b72034d8ab555f2662cdee7
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Mon Oct 21 16:07:13 2013 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/bbf9b2120f7563135b72034d8ab555f2662cdee7 [^]

related to issue 24969: Include compiled file of module script using postgres

---
M build/classes/org/openbravo/retail/posterminal/modulescript/InsertDiscountPreferenceData.class
---
(0061824)
hgbot   
2013-10-21 17:21   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 4342de4a9b6dd689d7da0a973d8e22f87a7a35e9
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Mon Oct 21 17:21:35 2013 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/4342de4a9b6dd689d7da0a973d8e22f87a7a35e9 [^]

related to issue 24969: module script query now works in oracle and psotgres

---
M build/classes/org/openbravo/retail/posterminal/modulescript/InsertDiscountPreferenceData.class
M src-util/modulescript/src/org/openbravo/retail/posterminal/modulescript/InsertDiscountPreference_Data.xsql
---
(0061851)
hgbot   
2013-10-22 18:29   
Repository: erp/pmods/org.openbravo.retail.posterminal.cirque
Changeset: 9dcf85c769bd4428c83820b7c08d42cdbbb1845e
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Mon Oct 21 08:56:08 2013 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.cirque/rev/9dcf85c769bd4428c83820b7c08d42cdbbb1845e [^]

fixed issue 24969: Web POS is now working using oracle

---
M src-util/modulescript/src/org/openbravo/retail/posterminal/modulescript/InsertDiscountPreference_Data.xsql
M src/org/openbravo/retail/posterminal/master/BPLocation.java
M src/org/openbravo/retail/posterminal/master/Category.java
M src/org/openbravo/retail/posterminal/master/Product.java
---
(0061852)
hgbot   
2013-10-22 18:29   
Repository: erp/pmods/org.openbravo.retail.posterminal.cirque
Changeset: af08487403eb9dd3c4b6320ab47d068804a2d4a2
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Mon Oct 21 09:37:44 2013 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.cirque/rev/af08487403eb9dd3c4b6320ab47d068804a2d4a2 [^]

related to issue 24969: Include compiled file of module script

---
M build/classes/org/openbravo/retail/posterminal/modulescript/InsertDiscountPreferenceData.class
---
(0061854)
hgbot   
2013-10-22 18:30   
Repository: erp/pmods/org.openbravo.retail.posterminal.cirque
Changeset: bbf9b2120f7563135b72034d8ab555f2662cdee7
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Mon Oct 21 16:07:13 2013 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.cirque/rev/bbf9b2120f7563135b72034d8ab555f2662cdee7 [^]

related to issue 24969: Include compiled file of module script using postgres

---
M build/classes/org/openbravo/retail/posterminal/modulescript/InsertDiscountPreferenceData.class
---
(0061855)
hgbot   
2013-10-22 18:30   
Repository: erp/pmods/org.openbravo.retail.posterminal.cirque
Changeset: 4342de4a9b6dd689d7da0a973d8e22f87a7a35e9
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Mon Oct 21 17:21:35 2013 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.cirque/rev/4342de4a9b6dd689d7da0a973d8e22f87a7a35e9 [^]

related to issue 24969: module script query now works in oracle and psotgres

---
M build/classes/org/openbravo/retail/posterminal/modulescript/InsertDiscountPreferenceData.class
M src-util/modulescript/src/org/openbravo/retail/posterminal/modulescript/InsertDiscountPreference_Data.xsql
---
(0061886)
hgbot   
2013-10-24 18:29   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 1fdf54f309b32b8176163693f031ec3310494783
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Thu Oct 24 17:39:57 2013 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/1fdf54f309b32b8176163693f031ec3310494783 [^]

related to issue 24969: query to load generic products is now working fine with oracle and with postgresql

---
M src/org/openbravo/retail/posterminal/master/Product.java
---
(0061971)
hgbot   
2013-10-30 16:03   
Repository: erp/pmods/org.openbravo.retail.posterminal.cirque
Changeset: 1fdf54f309b32b8176163693f031ec3310494783
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Thu Oct 24 17:39:57 2013 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.cirque/rev/1fdf54f309b32b8176163693f031ec3310494783 [^]

related to issue 24969: query to load generic products is now working fine with oracle and with postgresql

---
M src/org/openbravo/retail/posterminal/master/Product.java
---
(0062177)
hgbot   
2013-11-18 12:51   
Repository: erp/pmods/org.openbravo.retail.posterminal-splitlines
Changeset: 9dcf85c769bd4428c83820b7c08d42cdbbb1845e
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Mon Oct 21 08:56:08 2013 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-splitlines/rev/9dcf85c769bd4428c83820b7c08d42cdbbb1845e [^]

fixed issue 24969: Web POS is now working using oracle

---
M src-util/modulescript/src/org/openbravo/retail/posterminal/modulescript/InsertDiscountPreference_Data.xsql
M src/org/openbravo/retail/posterminal/master/BPLocation.java
M src/org/openbravo/retail/posterminal/master/Category.java
M src/org/openbravo/retail/posterminal/master/Product.java
---
(0062178)
hgbot   
2013-11-18 12:52   
Repository: erp/pmods/org.openbravo.retail.posterminal-splitlines
Changeset: af08487403eb9dd3c4b6320ab47d068804a2d4a2
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Mon Oct 21 09:37:44 2013 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-splitlines/rev/af08487403eb9dd3c4b6320ab47d068804a2d4a2 [^]

related to issue 24969: Include compiled file of module script

---
M build/classes/org/openbravo/retail/posterminal/modulescript/InsertDiscountPreferenceData.class
---
(0062180)
hgbot   
2013-11-18 12:52   
Repository: erp/pmods/org.openbravo.retail.posterminal-splitlines
Changeset: bbf9b2120f7563135b72034d8ab555f2662cdee7
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Mon Oct 21 16:07:13 2013 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-splitlines/rev/bbf9b2120f7563135b72034d8ab555f2662cdee7 [^]

related to issue 24969: Include compiled file of module script using postgres

---
M build/classes/org/openbravo/retail/posterminal/modulescript/InsertDiscountPreferenceData.class
---
(0062181)
hgbot   
2013-11-18 12:52   
Repository: erp/pmods/org.openbravo.retail.posterminal-splitlines
Changeset: 4342de4a9b6dd689d7da0a973d8e22f87a7a35e9
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Mon Oct 21 17:21:35 2013 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-splitlines/rev/4342de4a9b6dd689d7da0a973d8e22f87a7a35e9 [^]

related to issue 24969: module script query now works in oracle and psotgres

---
M build/classes/org/openbravo/retail/posterminal/modulescript/InsertDiscountPreferenceData.class
M src-util/modulescript/src/org/openbravo/retail/posterminal/modulescript/InsertDiscountPreference_Data.xsql
---
(0062182)
hgbot   
2013-11-18 12:52   
Repository: erp/pmods/org.openbravo.retail.posterminal-splitlines
Changeset: 1fdf54f309b32b8176163693f031ec3310494783
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Thu Oct 24 17:39:57 2013 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-splitlines/rev/1fdf54f309b32b8176163693f031ec3310494783 [^]

related to issue 24969: query to load generic products is now working fine with oracle and with postgresql

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