Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0025766Retail ModulesWeb POSpublic2014-02-19 11:542014-04-15 13:17
Reportergorkaion 
Assigned Togorkaion 
PrioritynormalSeveritycriticalReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR14Q2 
Merge Request Status
Review Assigned Tomigueldejuana
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0025766: check approval does not work using oracle database
DescriptionThe check approval process does not work using oracle database.

1274622 [http-8080-3] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-00932: inconsistent datatypes: expected - got CLOB

1274623 [http-8080-3] ERROR org.openbravo.mobile.core.process.SecuredJSONProcess - org.hibernate.exception.SQLGrammarException: could not execute query
1274623 [http-8080-3] ERROR org.openbravo.mobile.core.process.JSONRowConverter - Error in JSON process
org.codehaus.jettison.json.JSONException: class org.openbravo.retail.posterminal.utility.CheckApproval: could not execute query
Steps To ReproduceTry any process that requires approval.
Check error message.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-02-19 11:54gorkaionNew Issue
2014-02-19 11:54gorkaionAssigned To => gorkaion
2014-02-19 11:54gorkaionTriggers an Emergency Pack => No
2014-02-19 12:12gorkaionReview Assigned To => migueldejuana
2014-02-19 12:12gorkaionStatusnew => scheduled
2014-02-19 12:22hgbotCheckin
2014-02-19 12:22hgbotNote Added: 0064350
2014-02-19 12:22hgbotStatusscheduled => resolved
2014-02-19 12:22hgbotResolutionopen => fixed
2014-02-19 12:22hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.offline/rev/2e0940cc078aca9e5e800692f65d38655fd06199 [^]
2014-02-19 12:26hgbotCheckin
2014-02-19 12:26hgbotNote Added: 0064353
2014-02-19 12:26hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.offline/rev/2e0940cc078aca9e5e800692f65d38655fd06199 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.cirque/rev/2e0940cc078aca9e5e800692f65d38655fd06199 [^]
2014-02-20 11:30hgbotCheckin
2014-02-20 11:30hgbotNote Added: 0064382
2014-02-20 11:30hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.cirque/rev/2e0940cc078aca9e5e800692f65d38655fd06199 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/2e0940cc078aca9e5e800692f65d38655fd06199 [^]
2014-03-27 16:39adrianromeroNote Added: 0065531
2014-03-27 16:39adrianromeroStatusresolved => new
2014-03-27 16:39adrianromeroResolutionfixed => open
2014-03-31 17:42hgbotCheckin
2014-03-31 17:42hgbotNote Added: 0065629
2014-03-31 17:42hgbotStatusnew => resolved
2014-03-31 17:42hgbotResolutionopen => fixed
2014-03-31 17:42hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/2e0940cc078aca9e5e800692f65d38655fd06199 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/012f046901c347440d86dded11c8fa5cfebbe4c4 [^]
2014-04-01 10:03adrianromeroReview Assigned Tomigueldejuana => adrianromero
2014-04-01 10:03adrianromeroNote Added: 0065650
2014-04-01 10:03adrianromeroStatusresolved => closed
2014-04-01 10:03adrianromeroFixed in Version => RR14Q2
2014-04-03 16:45hgbotCheckin
2014-04-03 16:45hgbotNote Added: 0066151
2014-04-03 16:45hgbotStatusclosed => resolved
2014-04-03 16:45hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/012f046901c347440d86dded11c8fa5cfebbe4c4 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.cds/rev/012f046901c347440d86dded11c8fa5cfebbe4c4 [^]
2014-04-15 13:17migueldejuanaReview Assigned Toadrianromero => migueldejuana
2014-04-15 13:17migueldejuanaNote Added: 0066439
2014-04-15 13:17migueldejuanaStatusresolved => closed

Notes
(0064350)
hgbot   
2014-02-19 12:22   
Repository: erp/pmods/org.openbravo.retail.posterminal.offline
Changeset: 2e0940cc078aca9e5e800692f65d38655fd06199
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Wed Feb 19 12:17:37 2014 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.offline/rev/2e0940cc078aca9e5e800692f65d38655fd06199 [^]

Fixed issue 25766.Add to_char to where clause.

---
M src/org/openbravo/retail/posterminal/utility/CheckApproval.java
---
(0064353)
hgbot   
2014-02-19 12:26   
Repository: erp/pmods/org.openbravo.retail.posterminal.cirque
Changeset: 2e0940cc078aca9e5e800692f65d38655fd06199
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Wed Feb 19 12:17:37 2014 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.cirque/rev/2e0940cc078aca9e5e800692f65d38655fd06199 [^]

Fixed issue 25766.Add to_char to where clause.

---
M src/org/openbravo/retail/posterminal/utility/CheckApproval.java
---
(0064382)
hgbot   
2014-02-20 11:30   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 2e0940cc078aca9e5e800692f65d38655fd06199
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Wed Feb 19 12:17:37 2014 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/2e0940cc078aca9e5e800692f65d38655fd06199 [^]

Fixed issue 25766.Add to_char to where clause.

---
M src/org/openbravo/retail/posterminal/utility/CheckApproval.java
---
(0065531)
adrianromero   
2014-03-27 16:39   
Reopened. It is still failing. The problem is that the approval dialog appears but it does not show any of the configured supervisors. In postgresql it works properly.
(0065629)
hgbot   
2014-03-31 17:42   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 012f046901c347440d86dded11c8fa5cfebbe4c4
Author: Miguel A. Alsasua <miguel.alsasua <at> openbravo.com>
Date: Mon Mar 31 17:42:31 2014 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/012f046901c347440d86dded11c8fa5cfebbe4c4 [^]

fixed issue 0025766: check approval does not work using oracle database

---
M src/org/openbravo/retail/posterminal/LoginUtilsServlet.java
---
(0065650)
adrianromero   
2014-04-01 10:03   
Reviewed
(0066151)
hgbot   
2014-04-03 16:45   
Repository: erp/pmods/org.openbravo.retail.posterminal.cds
Changeset: 012f046901c347440d86dded11c8fa5cfebbe4c4
Author: Miguel A. Alsasua <miguel.alsasua <at> openbravo.com>
Date: Mon Mar 31 17:42:31 2014 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.cds/rev/012f046901c347440d86dded11c8fa5cfebbe4c4 [^]

fixed issue 0025766: check approval does not work using oracle database

---
M src/org/openbravo/retail/posterminal/LoginUtilsServlet.java
---
(0066439)
migueldejuana   
2014-04-15 13:17   
tested and reviewed in ad1d32246b78