0034967: the delete client process is not finishing

Openbravo Issue Tracking System - Retail Modules

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0034967

Retail Modules

StoreServer

public

2017-01-16 14:09

2017-01-16 16:20

Reporter

malsasua

Assigned To

platform

Priority

normal

Severity

major

Reproducibility

always

Status

closed

Resolution

duplicate

Platform

OS Version

Product Version

Target Version

Fixed in Version

RR17Q1

Merge Request Status

Review Assigned To

caristu

OBNetwork customer

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0034967: the delete client process is not finishing

Description

In a instance with mobile core module, and the property mobile_server_key no defined, the delete client process is blocked and it is not finishing.

The problem is in this line
https://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/file/0341cbbaf0aa/src/org/openbravo/mobile/core/listener/SetCurrentMobileServerListener.java#l46 [^]
is executing one update, but if the varialbe "serverkey" is null, the connection is not closed, and the table OBMOBC_SERVER_DEFINITION is locked:
https://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/file/0341cbbaf0aa/src/org/openbravo/mobile/core/listener/SetCurrentMobileServerListener.java#l49 [^]

Steps To Reproduce

. install retail modules
. as system administrator:
  . initial client setup:
   . create a new client

  . delete client process:
   . delete the previous client created

the delete process never finish, it is locked in this database command:
ALTER TABLE OBMOBC_SERVER_DEFINITION DROP CONSTRAINT OBMOBC_SERV_DEF_ALLORG_CHK

Proposed Solution

Add OBDal.getInstance().commitAndClose(); in this line
https://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/file/0341cbbaf0aa/src/org/openbravo/mobile/core/listener/SetCurrentMobileServerListener.java#l71 [^]

Additional Information