Manage Files Problem after Update to 1.10 docker

[HBI]

We have an old xnat database moved from 1.6 to 1.7.6 with all metadata of our studies without dicom images. Via manage files we attached some pdf files to the subjects.

The old 1.7.6 installation is a VM and we want to move to 1.10 docker version.

Based on the age the pdf files are at /home/xnat/data/archive on the 1.7.6 installation.

In the 1.10 docker version we moved the data to /data/xnat/archive.

We dumped the sql database and replaced all /home/xnat/data with /data/xnat/, same with the old /tmp/ to /data/xnat/build.

The import of the modified dump seemed to work. All projects, subjects and metadata are available. But...

I can not access the pdf via manage files using the gui.

I see the folder structure and can create a new folder with the gui. The new folder is created at the right place (/data/xnat/archive...)

I can not see any file. Expanding the folder yields to a 504 server error after waiting a long time.

Using the Rest API:

GET /data/subjects/xnat_S00001/resources

gives me xnat_abstractresource_id label...

GET /data/subjects/xnat_S00001/resources/myLabel/files

gives me the file list and the uri with xnat_abstractresource_id in it.

Clicking on the uri with the ID -> 504

Replacing the ID by label is working.

GET /data/subjects/xnat_S00001/resources/myLabel/files/MyFile.pdf is fine

GET /data/subjects/xnat_S00001/resources/001/files/MyFile.pdf, time out 504 error

On a fresh installed 1.10 the manage files is working as expected. The error must be in my sql database. I can access the files by myLabel, so it is not a file system permission error.

I had some chatgpt debugging sessions, checking for duplicate entries... the link xnat_abstractrecource to label... but I still do not find the error.

Jörg