- Failure of dashboard to publish when using MySQL Backend.
CA UIM + MySQL Backend.
- This was found to be the limitation on TEXT data type size in MySQL, which is 65536.
- UIM Support has found the following tables and stored procedures involved in dashboarddesigner function:
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
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;
As always, please contact CA Technologies support for CA UIM if you have further questions.