UVMS allows to delete multiple times the same package via UVC

Document ID : KB000086832
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error Message :
On the derby.log the following messages may appear when trying to delete several times the same package:

######################################
WARNING: While deleting a row from a table the index row for base table row (2858,402) was not found in index with conglomerate id 2,161. This problem has automatically been corrected as part of the delete operation.
######################################

On the uvserver.log this error may appear:
######################################
|ERROR| request-worker-14756 | com.orsyp.central.aspect.DataAccessExceptionTranslator |
java.lang.NullPointerException
at com.orsyp.central.jpa.PackageDAO.deleteByNameAndProductAndType(PackageDAO.java:129)
...

|ERROR| request-worker-14756 | com.orsyp.request.AbstractRequestHandler | Failed processing request
java.lang.NullPointerException
at com.orsyp.central.jpa.PackageDAO.deleteByNameAndProductAndType(PackageDAO.java:129)
...
########################################

Patch level detected:Univiewer Management Server 6.2.00
Product Version: Dollar.Universe 6.2.0

Description :When doing some delete operations of packages in UVMS, the operation may take a while in case the package has many elements, so the operators can click several times on the Delete button, causing that the UVMS tries to remove the objects several times on the database.

As a result, the performance on UVMS might be impacted and users unable to log in.
 
Environment:
OS: All
 
Cause:
Cause type:
Defect
Root Cause: N/A
 
Resolution:
Update to the fix version listed below or a newer version if available.

Fix Status: Released

Fix Version(s):
Component: Univiewer.Management.Server
Version: Dollar.Universe 6.3.01
 
Additional Information:
Workaround :
N/A