Issue with upload data from healthleads and LAAC providers - data didn't update

[abaranowska1]

During exploration tests, I found a bug related to uploading data. I had an issue with upload healthleads files - metadata.csv file is loading and loading.

The issue exists on both browsers Google Chrome Version 80.0.3987.132 and Firefox 74.0
What is more, even if I correctly upload all files, data didn't update for healthleads and LAAC providers. I tested upload also for the rest providers and didn't meet such issue.

Steps:

1. Log in to the app as Admin
2. Go to upload data
3. Upload csv changed files for healthleads and LAAC providers
4. Check if data update

Actual result: No update for healthleads and LAAC providers
Expected result: Data should be updated after upload files.

Dev notes:

2020-03-18 09:16:01.314 ERROR 1 --- [  XNIO-1 task-1] io.undertow.request                      : UT005023: Exception handling request to /nice%20ports%2C/Tri%6Eity.txt%2ebak
org.springframework.security.web.firewall.RequestRejectedException: The request was rejected because the URL contained a potentially malicious String "%2e"
2020-03-18 10:46:09.071  INFO 1 --- [ XNIO-1 task-14] o.b.s.s.impl.DocumentUploadServiceImpl   : Data upload for LAAC has started
2020-03-18 10:46:09.491 ERROR 1 --- [ XNIO-1 task-14] o.b.s.manager.ImportManagerImpl          : org.hibernate.TransientObjectException: object references an unsaved transient instance - save the transient instance before flushing: org.benetech.servicenet.domain.GeocodingResult; nested exception is java.lang.IllegalStateException: org.hibernate.TransientObjectException: object references an unsaved transient instance - save the transient instance before flushing: org.benetech.servicenet.domain.GeocodingResult
at com.sun.proxy.$Proxy304.findOneByExternalDbIdAndProviderName(Unknown Source)
at org.benetech.servicenet.service.impl.ServiceTaxonomyServiceImpl.findForExternalDb(ServiceTaxonomyServiceImpl.java:99)
at org.benetech.servicenet.service.impl.ServiceTaxonomyServiceImpl$$FastClassBySpringCGLIB$$3eaedd92.invoke(<generated>)
at org.benetech.servicenet.service.impl.ServiceBasedImportServiceImpl$$EnhancerBySpringCGLIB$$c32e15d9.createOrUpdateServiceTaxonomy(<generated>)

[abaranowska1]

Tested with success

Verified on:

• Google Chrome Version 80.0.3987.149

Verified cases:

• Upload csv changed files for healthleads and LAAC providers
• Upload changed files for all providers
• Check if data update