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.