Cannot Install CABI reports with MYSQL DB

Products

• DX Infrastructure Management

Issue/Introduction

After installing Bundled CABI 4.3 deployed all the supported packages but CABI reports are not appearing on the CABI library folder or Operator Console. 

Note: CABI server is running fine.

 

 

Environment

Release : 20.3

Component : UIM - CABI 4.3 Bundled

DB: MYSQL 5.7.35

Resolution

When using My SQL as CA UIM database, change the following default settings for  MySQL database so that the CA Business Intelligence dashboard/reports deployment is successful:

Set max_allowed_packet=500M 
Set innodb_log_file_size=356M 
Set table_definition_cache=2000 

 

Note: This applied to both dashboards and Reports