dbptk-ui
dbptk-ui copied to clipboard
cannot open siard with arrays
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
Siard->metadata.xml
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.
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.