validator - win10 - sakila - custom query - A_M_5.11-1-2 ERROR

[Laurira]

Created SIARD from sakila, only added a custom query "SELECT r.rental_id, r.rental_date, s.first_name FROM rental r, staff s" The "test query" button resulted successfully and siard was also nicely created.

When I validated the siard then I got an error: A_M_5.11-1-2 Check if the candidate key columns are identical to the column names in the table From the report:

Report itself: dbptk-validation-reporter-sakilaNelijärvel-20191128121121570.txt

If I look the table in the dbvtk then yes field rental_date is missing...

[Laurira]

I tried to reproduce this and got ERROR in the validation so that results file were not created at all and logs are empty or inaccessible. The button "Open Validator" do not work at all. The button "Validate Now" works but results with an error:

If I want to see JVM logs then I get an error:

The other logs are here: dbvtk.log dbvtk-2019-11-27.0.log.gz

[Laurira]

If I restarted the app and tried to validate then the same thing happens.

Then I restarted the app again and did not click "Validate" button but went straight to section "Manage".

And the ERROR has disappeared from there:

[Laurira]

Maybe it is working at background because it is affecting the other siard-s listed in there. For one database I clicked "search" but the search windows was not appearing. For some other database I got:

Please test it more on windows.

[Laurira]

I deleted .dbvtk and .dbptk folders. After this all works and little bit quicker but I now have only one database there. I think these errors will come up when the number of databases in dbvtk is more than 2-3 so please test the tool with bigger amount of databases.

[hmiguim]

Can you provide the name that you gave to the custom view?

[Laurira]

Name was "rendidJaTöötajad"