Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0038655Openbravo ERPA. Platformpublic2018-05-30 10:262018-06-12 09:32
Reporteralostale 
Assigned Toalostale 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR18Q3 
Merge Request Status
Review Assigned Tocaristu
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0038655: incorrect query in UserLock
DescriptionThe HQL query used to determine last success login for a given user has incorrect bracket balance.

Hibernate 3.6 allows it whereas it is not allowed in newer versions.
Steps To Reproduce1. Using Hibernate 5.3 activate user locking
2. Try to login with any user
  -> ERROR:It is not possible to log in
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0038651 closed alostale problems in user locking implementation 
related to defect 0037112 closed alostale incorrect HQL to retrieve preferences 
blocks feature request 0037064 closed caristu upgrade hibernate to 5.3.2 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-05-30 10:26alostaleNew Issue
2018-05-30 10:26alostaleAssigned To => alostale
2018-05-30 10:26alostaleOBNetwork customer => No
2018-05-30 10:26alostaleModules => Core
2018-05-30 10:26alostaleTriggers an Emergency Pack => No
2018-05-30 10:26alostaleReview Assigned To => caristu
2018-05-30 10:27alostaleRelationship addedrelated to 0038651
2018-05-30 10:28alostaleRelationship addedrelated to 0037112
2018-05-30 10:28alostaleRelationship addedblocks 0037064
2018-05-30 11:06hgbotCheckin
2018-05-30 11:06hgbotNote Added: 0104803
2018-05-30 11:06hgbotStatusnew => resolved
2018-05-30 11:06hgbotResolutionopen => fixed
2018-05-30 11:06hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/bff50e6e772b9e25cd58b6d44c06a7acc8d3e0a8 [^]
2018-05-30 17:11hudsonbotCheckin
2018-05-30 17:11hudsonbotNote Added: 0104814
2018-06-01 15:34caristuNote Added: 0104885
2018-06-01 15:34caristuStatusresolved => closed
2018-06-01 15:34caristuFixed in Version => 3.0PR18Q3
2018-06-12 09:32caristuIssue cloned0038735

Notes
(0104803)
hgbot   
2018-05-30 11:06   
Repository: erp/devel/pi
Changeset: bff50e6e772b9e25cd58b6d44c06a7acc8d3e0a8
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Wed May 30 11:06:06 2018 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/bff50e6e772b9e25cd58b6d44c06a7acc8d3e0a8 [^]

fixed bug 38655: incorrect query in UserLock

  The query had unbalanced parenthesis

---
M src/org/openbravo/base/secureApp/UserLock.java
---
(0104814)
hudsonbot   
2018-05-30 17:11   
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/10bad01a186a [^]
Maturity status: Test
(0104885)
caristu   
2018-06-01 15:34   
Code reviewed + tested OK.