search

keeps / dbptk-ui

DBPTK base UI for both Desktop and Enterprise
https://database-preservation.com
GNU Lesser General Public License v3.0
23 stars 9 forks source link

error when clicking "Download" on a record #324

Closed Laurira closed 2 years ago

Laurira commented 2 years ago

Description: When database is indexed in Database Preservation Toolkit Enterprise then user sees the "Download" buttons next to each row that contains LOBs.

image

Now when clicking on such thing very often do not work and presents an error.

I discovered that when one field is related to the LOB-s where some some are in the siard and others are outside from the siard, then error is presented when record is situated outside from the siard: "RESTException: Remote exception caused by GenericException: Zip archive entry is missing" image

I made a special setup in Sakila to illustrate this issue: sakila5000bytesI.zip To reproduce this issue please upload this to dbptk Enterprise and before indexing definitely copy the lobseg folder next to the siard file before clicking "Browse" button.

I added two file paths to the last column "id-card-front-image" of the table "staff". Click on the "Download" links to see the issue.

hmiguim commented 2 years ago

The problem is related to storing the information if the LOB is inside or outside the SIARD for the whole column instead of each individual cell causing the error message.

In order to fix this bug the cell must have information about its location.