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

SIARD-->postgreSQL: in case of xs:date following error occurs: RESTException: Remote exception caused by GenericExeption: caused by IlegalArgument Exception

Open ibbenz opened this issue 1 year ago • 0 comments

Description:

RESTException: Remote exception caused by GenericExeption: caused by IlegalArgument Exception The error is caused by a column containing DATE-datatype values (Table 6 (Employees) in the attached SIARD-file). No such error occurs, when I convert SIARD-->Microsoft SQL, for example.

Steps required to reproduce the bug:

  1. Open the 0_1-3_Northwind_simple_220913_B_dbptk2b.siard into dbptk (see attached zip)
  2. "Send To Live DBMS" and choose postgresql.
  3. Check "Disable Encription". The "test connection" is successful
  4. Click the "Export" Button. The error message occurs.
  5. Check the Tables in the postgresql-db, The values of the Tables which were processed before the "Employees"-table exist. The values of the "Employees" table and the other tables do not exist.

Table 6 (Employees) contains the xs: date in Table 6 the last column is the DATE-datatype column

SIARD-file, where the DATE-datatype column in Table 6 is deleted: 0_1-3_Northwind_simple_220913_B_dbptk2a.zip

SIARD with the DATE-column, where the bug occurs. 0_1-3_Northwind_simple_220913_B_dbptk2b.zip

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

ibbenz avatar Sep 28 '22 10:09 ibbenz