keeps / dbptk-ui

DBPTK base UI for both Desktop and Enterprise
https://database-preservation.com
GNU Lesser General Public License v3.0
23 stars 9 forks source link

Error during validation of SIARD file #337

Open gillianh1 opened 1 year ago

gillianh1 commented 1 year ago

Description: 50,122,865+ errors and 2G error log produced when validating SIARD file produced byt DBPTK desktop. In one table a column of type "NUMBER" contains decimal values and believe this is the cause of this error? Can you advise how to resolve? Is there is any config within DBPTK that we could change to allow validation to complete?

Context: DBPTK Desktop: Windows version 2.7

Steps required to reproduce the bug:

  1. Extracted 7 tables from oracle database (one of which has column with type NUMBER and contains decimal point values)
  2. Ran validation on file. Failed with 50,122,865 errors like "Data type invalid - 48.22 is not in conformity with 'NUMERIC(38)' type"
  3. Validation completed but failed.

Attach any related screenshots below. image

image

Logs too large - here is extract

"T_6.0 - Requirements for table data T_6.0-1: [OK] A_T_6.0-1-1: [OK] A_T_6.0-1-2: [ERROR] - Data type invalid - 48.22 is not in conformity with 'NUMERIC(38)' type in content/schema1/table1/table1.xml A_T_6.0-1-2: [ERROR] - Data type invalid - 581.44 is not in conformity with 'NUMERIC(38)' type in content/schema1/table1/table1.xml" ... "A_T_6.0-1-2: [ERROR] - Data type invalid - 58.6 is not in conformity with 'NUMERIC(38)' type in content/schema1/table1/table1.xml A_T_6.0-1-2: [ERROR] Requirements for table data [FAILED]"

Find DBPTK Desktop logs at Help -> Logs menu. Find DBPTK Enterprise logs with docker logs command.