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-->postgreSQL: in case of xs:date following error occurs: RESTException: Remote exception caused by GenericExeption: caused by IlegalArgument Exception #534

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

Comments

@ibbenz
Copy link

ibbenz commented Sep 28, 2022

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

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