Location directory issue when the Safe Workplace Dashboard application is installed before the Workplace Space Mapping application


When the Workplace Space Mapping application is installed after the Safe Workplace Dashboard application, the sp_dependency file insertion fails due to a constrain on the Module field.

Steps to Reproduce

Install Safe Workplace Dashboard plugin of version 1.0.4 or later

Install Workplace Space Mapping plugin of the latest version 1.3.2 (March 2021 release)

Observe:  /nav_to.do?uri=sp_dependency.do?sys_id=04c763fcc311201081e86ff4c840dd19 (Name: CC leaflet js) fails during insertion due to a constraint on the Module field

Issue: The Location directory does not load the map (/ws?id=wsd_location_directory)


Workaround: The Module field has been updated to be unique in the sp_dependency record (CC leaflet js) and the XML to be imported below.

Save the below code as an .xml file and import it to your instance.

Note: Import this as an .xml file only if you are using Workplace Space Mapping version 1.3.2. The issue will be fixed in the next release of the application.


<?xml version="1.0" encoding="UTF-8"?><record_update table="sp_dependency">
  <sp_dependency action="INSERT_OR_UPDATE">
    <name>CC leaflet js</name>
    <sys_created_on>2020-12-23 07:27:32</sys_created_on>
    <sys_name>CC leaflet js</sys_name>
    <sys_package display_value="Workplace Space Mapping" source="sn_wsd_space_map">47ec013fe7561010809a268b03f6a9a1</sys_package>
    <sys_scope display_value="Workplace Space Mapping">47ec013fe7561010809a268b03f6a9a1</sys_scope>
    <sys_updated_on>2021-03-02 08:55:11</sys_updated_on>

Related Problem: PRB1478722