Collected Datasets File source fails to consume file

johannes-darms commented 6 months ago

This issue is unique

[X] I have used the search tool and did not find an issue describing my bug.

Version information

5.2.3

Expected behavior

Collected Datasets can be read and imported from file source

Actual behavior

A valid file is uploaded (Via Collected Datasets>Files>Upload) and can be downloaded. The path is copied via the "copy file path to clipboard" button. The copied path is pasted into the Data Source> File source> Path field. Yet indexing/publication fails with "Verify the datasource is available. org.obiba.magma.support.DatasourceParsingException: Errors while parsing tables of datasource: /collected-dataset/1247/FILENAME.xlsx"

Reproduction steps

See action behavior

Operating System (OS)

Linux

Browser

FireFox

Contact info

No response

johannes-darms commented 6 months ago

The only log messages I get are those two lines:

2024-01-09 10:51:36.297  INFO 61 --- [48043131-284279] o.o.m.d.s.CollectedDatasetService$Helper : clearing dataset variables cache dataset-1247
2024-01-09 10:51:36.302  INFO 61 --- [48043131-284279] .o.m.c.s.StudyTableSourceServiceRegistry : Reading study table from file: /collected-dataset/1247/FILENAME.xlsx

ymarcon commented 6 months ago

Could you share this excel file? either attach it to the issue or send it to me, thx

obiba / mica2