When importing an export json file containing medium quanities of reports (about 15) with multiple parameters, I noticed that parameters were not importing correctly. Specifically shared parameters with List of Value reports attached to them will sometimes have the wrong or no LoV in them after the import, which can lead to unexpected report runtime errors.
This situation occurs on Postgres 12 and Microsoft Sql Server 13.0.x.x, with ART 4.12.1.
I've attached a shortened export file that I think demonstrates the issue. After import, it is supposed to have put LoVTestReport2 on LoVTestParam3, but for some reason there is no LoV report attached to that parameter when I view its edit details.
Please let me know if theres anything I can do to help further troubleshoot this issue.
I get an error when I try to import the file. java.sql.SQLException: Duplicate entry 'LoVTestReport1' for key 'art_queries_uc_name' Could you try again and see if you get this error.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Strange, I tried again and did not get this error, but I do see in the export file where it has that report multiple times for some reason... Could it just be my art version is old?
Last edit: Justin Schneider 2020-08-10
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Was there any changes to resolve the same repeated definitions but with parameters? In 4.12.1, on import sometimes we get multiple of the same parameter name as well. It doesn't error on import, but it can be confusing. I've worked around by deleting the repeated entry for now.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
When importing an export json file containing medium quanities of reports (about 15) with multiple parameters, I noticed that parameters were not importing correctly. Specifically shared parameters with List of Value reports attached to them will sometimes have the wrong or no LoV in them after the import, which can lead to unexpected report runtime errors.
This situation occurs on Postgres 12 and Microsoft Sql Server 13.0.x.x, with ART 4.12.1.
I've attached a shortened export file that I think demonstrates the issue. After import, it is supposed to have put LoVTestReport2 on LoVTestParam3, but for some reason there is no LoV report attached to that parameter when I view its edit details.
Please let me know if theres anything I can do to help further troubleshoot this issue.
Last edit: Justin Schneider 2020-08-06
I get an error when I try to import the file.
java.sql.SQLException: Duplicate entry 'LoVTestReport1' for key 'art_queries_uc_name'Could you try again and see if you get this error.Strange, I tried again and did not get this error, but I do see in the export file where it has that report multiple times for some reason... Could it just be my art version is old?
Last edit: Justin Schneider 2020-08-10
The repeated report definitions are there even in the latest version. But there have been some code changes today to hopefully fix this issue.
Was there any changes to resolve the same repeated definitions but with parameters? In 4.12.1, on import sometimes we get multiple of the same parameter name as well. It doesn't error on import, but it can be confusing. I've worked around by deleting the repeated entry for now.
The changes are in the latest code and will be available with the next release.
Ok, Thanks!
If you are able to build from the latest code you can test the fix.