Error while adding profile via Monitoring Tab

Products

• DX Infrastructure Management
• NIMSOFT PROBES

Issue/Introduction

We have an issue with our UIM. When we select a host, open the Monitoring Tab and then click on one of the plus buttons to add a profile to this host, an error appears. The portal.log file shows the following error:

Caused by: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select c.id, c.caption, c.height, c.width, c.layout, c.position, c.path, c.helptext, c.name, c.template, c.url, c.align, p.name as property_name, p.value as property_value from SSRV2Container c left join SSRV2ContainerProperty p on c.id = p.container_id where c.template = ? order by c.position]; nested exception is java.sql.SQLSyntaxErrorException: Table 'sys_nimslm.ssrv2containerproperty' doesn't exist

....

Caused by: java.sql.SQLSyntaxErrorException: Table 'sys_nimslm.ssrv2containerproperty' doesn't exist

Environment

Release:
Component: UIMMSV

Resolution

Disable MCS and then run the below query.
CREATE TABLE SSRV2ContainerProperty ( container_id int NOT NULL, name varchar(128) NOT NULL, value varchar(256), CONSTRAINT PK_SSRV2ContainerProperty PRIMARY KEY (container_id, name) ); ALTER TABLE SSRV2ContainerProperty ADD CONSTRAINT FK_SSRV2ContainerProperty_Container FOREIGN KEY (container_id) REFERENCES SSRV2Container (id) ON DELETE Cascade;
Once done, turn on MCS.