Dashboard Publish Failure with MySQL Backend Database

Article Id: 34934

Status: Published

Updated On: 14-02-2018 06:40

Legacy Id: TEC000003257

Products:

CA Unified Infrastructure Management On-Premise (Nimsoft / UIM) , NIMSOFT PROBES

Issue/Introduction:

Symptoms:

- Failure of dashboard to publish when using MySQL Backend.

Environment:

CA UIM + MySQL Backend.

Cause:

- This was found to be the limitation on TEXT data type size in MySQL, which is 65536.

Resolution:

- UIM Support has found the following tables and stored procedures involved in dashboarddesigner function:

Tables:

tbnLocalDashboard (xml)
tbnDashboard (content)
tbn_t_dashboards (content)

Store Procedures:

spn_dd_SaveLocalDashboard (pXml)
spn_dd_savebackupdashboards (pContent)
spn_dd_InsertDashboard (pContent)

Change data type from TEXT to MEDIUMTEXT (16,777,216) then you will be able to save and publish dashboards which exceeded 65,536 characters in dashboard.xml file.

Change Stored Procedures:

You can use \$NIMROOT\UMP\MySQL\nis-5-procs-designer.sql file (attached) to get the create SQL for the above stored procedures, copy to a new file, change the mentioned fields' data type from TEXT to MEDIUMTEXT and run the script:

# mysql -H <MySQL DB> -u <NMS DB user> -p<password> -D <Nimsoft SLM database> < nis-5-procs-designer-modified

Change Tables:

mysql> alter table tbnlocaldashboard change xml xml mediumtext;

mysql> alter table tbndashboard change content content mediumtext;
mysql> alter table tbn_t_dashboard change content content mediumtext;

Additional Information:

As always, please contact CA Technologies support for CA UIM if you have further questions.

Environment:

Release:
Component: CAUIM