dbptk-ui icon indicating copy to clipboard operation
dbptk-ui copied to clipboard

cannot open siard with arrays

Open Laurira opened this issue 3 years ago • 2 comments

Postgresql database had ARRAY-s in it but the siard was created with no errors.

But it cannot be opened with Desktop or Enterprise, it gives error image

Siard->metadata.xml image

Laurira avatar Nov 03 '21 10:11 Laurira

This is from DBPTK-Desktop log: 2021-11-03 12:11:59,486 [http-nio-auto-1-exec-4] INFO c.d.m.siard.update.SIARDEditModule - Importing SIARD version 2.1 2021-11-03 12:12:04,364 [http-nio-auto-1-exec-1] ERROR c.d.c.c.c.utils.AsyncCallbackUtils - [127.0.0.1] AsyncCallback error - RESTException: Remote exception caused by GenericException: Arrays are not yet supported. caused by ViewerException: Arrays are not yet supported.

Laurira avatar Nov 03 '21 10:11 Laurira

Our suggestion is that in this case the application should not tell the user "it can not be done". Instead it should just convert those array fields to varchar and continue with warning that "as arrays are not supported then these fields were converted into varchar".

At the moment we edited our siard file and made that change by hand. After this modification the siard file was exported nicely into the dbptk enterprise and is browsable as well.

Laurira avatar Nov 16 '21 08:11 Laurira