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

Cannot locate Zip-internal Large Object.

Open stighemmer opened this issue 3 years ago • 0 comments

When opening a SIARD file with a Large Object inside, validation fails with a message saying external large object not found.

Github doesn't like SIARD file attachments, so I have renamed it with a ZIP extention. Rename it back before using. TestDB.zip

This SIARD file was originally created using Spectral Core's Full Convert. I have done some minor edits to fix other errors. (Bugs in Full Convert are not relevant here)

Relevant parts of header/metadata.xml:

<siardArchive>
  <lobFolder>content/</lobFolder>
  ...<column>
       <lobFolder>schema0/table0/lob1/</lobFolder>
     </column>... 
</siardArchive>

Relevant part of content/schema0/table0/table0.xml

...<c1 file="seg0/rec1.txt"/>...

As far as I understand the SIARD 2.1 standard, the fact that both lobFolder elements are relative indicates that the LOB should be internal to the SIARD(ZIP) file. Nevertheless, validation looks for an external LOB.

Relevant parts of the Validation Report:

4.2 - Structure of the SIARD archive file
	P_4.2-3: [ERROR] - The individual table folders contain an XML file and an XSD file, the names of
which (folder designation and both file names) must be identical. - content\schema0\table0\lob1\seg0\rec1.txt

5.6 - Column level metadata
	A_M_5.6-1-2: [ERROR] : not found external lob 'seg0/rec1.txt' required by 'content/schema0/table0 [row: 1 column: c1]'

dbptk-validation-reporter-TestDB-20201102103955429.txt

stighemmer avatar Nov 02 '20 10:11 stighemmer