Dashboard Publish Failure with MySQL Backend Database

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

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