Error while adding profile via Monitoring Tab

Document ID : KB000106975
Last Modified Date : 18/07/2018
Show Technical Document Details
Issue:
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
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.