MCS profiles applied to a group never unlock

Document ID : KB000094945
Last Modified Date : 07/05/2018
Show Technical Document Details
Issue:
After having deployed a profile to a Group in USM, the profile remains locked indefinitely and cannot be changed nor deleted.

When looking at the mon_config_service probe log file we see an SQL error as follows

\Nimsoft\probes\service\mon_config_service\mon_config_service.log
2018-04-29 21:37:13,314 ERROR [ProbeDeployerThread:15] org.springframework.dao.DuplicateKeyException: PreparedStatementCallback; SQL [update SSRV2Profile set template=?,status=?, retries=?, poller=?, group_id=?, cs_id=?, ancestorprofile=?, priority=?, account_id=?, foreach_fieldid=?, foreach_variable=?, foreach_val_regex=?, updated=?, ref_entity_id=? where profileId=?]; Cannot insert duplicate key row in object 'dbo.SSRV2Profile' with unique index 'IXUQ_SSRV2Profile_CsIdTemplateProfileNameParent'. The duplicate key value is (VVAgent, 80, 43, <NULL>, <NULL>, <NULL>).; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert duplicate key row in object 'dbo.SSRV2Profile' with unique index 'IXUQ_SSRV2Profile_CsIdTemplateProfileNameParent'. The duplicate key value is (VVAgent, 80, 43, <NULL>, <NULL>, <NULL>).
                at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)
                at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
                at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:660)
                at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:909)
                at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:970)
                at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:980)
                at com.nimsoft.selfservice.v2.database.ProfileDao.update(ProfileDao.java:171)
                at com.nimsoft.selfservice.v2.controller.ProfileController.createDeviceProfile(ProfileController.java:700)
                at com.nimsoft.selfservice.v2.controller.ProfileController.unlinkFromAncestor(ProfileController.java:680)
                at com.nimsoft.selfservice.v2.controller.ProfileController.handleProfileException(ProfileController.java:575)
                at com.nimsoft.selfservice.v2.controller.ProfileController.handleProfileException(ProfileController.java:527)
                at com.nimsoft.selfservice.v2.controller.ProfileController.deployProfileNow(ProfileController.java:443)
                at com.nimsoft.selfservice.v2.concurrence.ProbeDeployerThread.run(ProbeDeployerThread.java:28)
                at java.lang.Thread.run(Thread.java:745)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert duplicate key row in object 'dbo.SSRV2Profile' with unique index 'IXUQ_SSRV2Profile_CsIdTemplateProfileNameParent'. The duplicate key value is (VVAgent, 80, 43, <NULL>, <NULL>, <NULL>).
 
 
Environment:
UIM 8.51
mon_config_service 8.50 or 8.51
Resolution:
This has been resolved in a hotfix for MCS. MCS 8.5.8HF1 or later is required to resolve this error.

Hotfix mon_config_service-8.5.8-HF4 can be downloaded from
http://support.nimsoft.com/Files/Archive/00452/mon_config_service-8.5.8-HF4-8_58.zip

Please follow the included release notes in regards to applying the fixes as there are several components

mon_config_service-8.5.8-HF4.zip
mon_config_service_cli-8.5.8-HF4.zip

mon_config_service_usm_patch-8.5.8-HF4.zip (applied to UMP Wasp)

Please also make sure that mcs templates 10.4.1 or later are also applied after the fixes
mon_config_service_templates-10.4.1.zip