search

MauroDataMapper-Plugins / mdm-plugin-database-sqlserver

Apache License 2.0
2 stars 1 forks source link

Error on Enumeration guessing where NULL values are present? #5

Closed jamesrwelch closed 2 years ago

jamesrwelch commented 3 years ago

A user reports that the enumeration guessing is causing an error: "Error in Import Process"

"We put together a small dummy dataset without any NULL values, and the Mauro Data Mapper was able to load up enumeration values for that. So as far as we can tell, it is the NULLs that causing the issue" image

olliefreeman commented 3 years ago

That’s odd cos we tested this exact issue when we were developing it

aaronforshaw commented 3 years ago

@jamesrwelch Please can we have the error log?

jamesrwelch commented 3 years ago

Extract of logs:

2021-11-16 10:35:29,247 [080-exec-8] WARN  .s.p.GroupBasedUserSecurityPolicyManager : Checking for any access to secured resource class DataModel without providing an ID
2021-11-16 10:35:29,247 [080-exec-8] INFO  .s.p.GroupBasedUserSecurityPolicyManager : No id access for read rights for class uk.ac.ox.softeng.maurodatamapper.datamodel.DataModel, default response is false
2021-11-16 10:35:29,252 [080-exec-8] INFO  DatabaseDataModelImporterProviderService : Importing 1 DataModel(s)
2021-11-16 10:35:29,252 [080-exec-8] INFO  DatabaseDataModelImporterProviderService : Importing DataModel with from database Surgery with name Surgery Enumeration Test
2021-11-16 10:35:29,252 [080-exec-8] DEBUG taModelImporterProviderServiceParameters : DataSource connection using SQLServer
2021-11-16 10:35:29,309 [080-exec-8] DEBUG DatabaseDataModelImporterProviderService : Size of results from statement 107
2021-11-16 10:35:48,207 [080-exec-8] DEBUG u.a.o.s.m.datamodel.DataModelService     : Validating DataModel
2021-11-16 10:35:48,328 [080-exec-8] DEBUG u.a.o.s.m.datamodel.DataModelService     : Validated DataModel in 120 ms
2021-11-16 10:35:48,328 [080-exec-8] DEBUG u.a.o.s.m.c.controller.ModelController   : Errors found in imported models
aaronforshaw commented 3 years ago

@jamesrwelch can you confirm what plugin versions are in use? I am a bit puzzled that the screenshot does not show a 'Calculate Summary Metadata' checkbox beneath the 'Detect Enumerations' checkbox.