If you import a configuration ZIP file into SAS Visual Investigator, the import might fail in the environment that is importing the file. This issue occurs when the environment already contains a map icon that is a duplicate of a map icon within the ZIP file.
An error message that is similar to the following also appears in the svi-datahub logs after the failed import:
ERROR: duplicate key value violates unique constraint "icon-file-name"
2019-12-10T12:30:40.66-0500 [APP/PROC/WEB/0] OUT Detail: Key (icon_nm)=(icon-file-name) already exists.
You can determine whether there are any map icons in the database of the target system by connecting to the schema or database for the relevant tenant and executing the following SQL query:
SELECT COUNT(*) AS number_of_map_icons FROM fdhmetadata.dh_display_icon WHERE icon_type_cd='MAP';
If there are any map icons, you can work around the import issue either by deleting the existing map icons or by changing the type of the icons to “REGULAR.”
The following syntax can delete them:
DELETE FROM fdhmetadata.dh_display_icon WHERE icon_type_cd='MAP';
The following syntax can update the type to “REGULAR”:
UPDATE fdhmetadata.dh_display_icon SET icon_type_cd='REGULAR' where icon_type_cd='MAP';
Note: When map icons remain in the svi-datahub database in SAS® Visual Investigator 10.6, they are not displayed in the user interface or exposed through the web API. Updating the type to “REGULAR” causes them to appear in both the user interface and the web API. If that is not desirable, consider deleting the icons instead.