Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SIARD-->SQL-->SIARD: Validation of SIARD fails due lacking "Z" in DATE-type values after export #536

Open
ibbenz opened this issue Sep 30, 2022 · 0 comments

Comments

@ibbenz
Copy link

ibbenz commented Sep 30, 2022

Description of error:
I execute a import-export cycle with a SIARD-file and check finally if the data remained the same.
However, DATE-type values are changed during this cycle, which results in a validation-error in the dbptk-validator.
I attached the exported file to this issue.

DATE in the imported SIARD-file (table6, column 18): 0001-01-01Z
DATE in the exported SIARD-file (table3, column 18) 0001-01-01

dbptk-validation of the exported file:
T_6.0-2: [ERROR] - Validation against XSD failed. - cvc-minInclusive-valid: Value '0001-01-01' is not facet-valid with respect to minInclusive '0001-01-01Z' for type 'dateType'. At line 1,

The bug disappears, when I manually change the 0001-01-01 to 0001-01-01Z in the SIARD file.
I attached the corrected file to this issue (see 2.4b_1-3_Northwind_simple_220913_B_b.zip)
Why is the "Z" truncated during the Export?

Steps required to reproduce the bug:

  1. Open 0_1-3_Northwind_simple_220913_B_dbptk.siard and load it into a Microsoft SQL-Database
  2. Download the uploaded DATA in a new SIARD File 2.4b_1-3_Northwind_simple_220913_B.siard
  3. Validate the downloaded SIARD-file

The imported SIARD-file:
0_1-3_Northwind_simple_220913_B_dbptk.zip

The exported SIARD-file:
2.4b_1-3_Northwind_simple_220913_B.zip

The exported SIARD-file and "Z" added in column 18 of table 3:
2.4b_1-3_Northwind_simple_220913_B_b.zip

Attach the dbptk-app.log.txt file below.
dbvtk.log

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
Status: No status
Development

No branches or pull requests

1 participant