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

Error during validation of SIARD file

Open gillianh1 opened this issue 2 years ago • 3 comments

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.

gillianh1 avatar Nov 01 '22 14:11 gillianh1