Missing out of the box Domains in CA Business Intelligence JasperReport Server using MySQL DB

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

After install Cabi, not able to see any Report available in OC neither in Cabijs page.

 

May 02 15:38:07:551 [com.ca.cabi4uim.DirWatcherServicePool-1-thread-1, cabi] Import of file=uim_mcs_dashboards.zip done with status=failed, complete import state is=StateDto{id='4b203e50-7989-4d8e-a142-d51007009504', message='Import failed. Reason: null id in com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoFileResource entry (don't flush the Session after an exception occurs)', phase='failed', errorDescriptor=ErrorDescriptor{message='null', errorCode='import.failed', parameters=[null id in com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoFileResource entry (don't flush the Session after an exception occurs)], errorUid='null', exception=null}, warnings=null} [time taken=0 minute(s) 1 second(s) (1976 ms)]
May 02 15:38:07:551 [com.ca.cabi4uim.DirWatcherServicePool-1-thread-1, cabi] could not upload file=/opt/nimsoft/probes/service/cabi/content/upload/uim_mcs_dashboards.zip
May 02 15:38:07:551 [com.ca.cabi4uim.DirWatcherServicePool-1-thread-1, cabi] com.ca.cabi4uim.cabi.ImportFilesException

Environment

• Release: 20.4
• MySQL 5.7 DB on Linux

Resolution

1. Solve this by increasing max_allowed_packet value in etc/mysql/my.cnf

# The MySQL server
[mysqld]
port=3306
#socket=MySQL
basedir = c:/win32app/spectrum/mysql
tmpdir = c:/win32app/spectrum/mysql/tmp
datadir = c:/win32app/spectrum/mysql/data
#slow_query_log
#long_query_time = 10
default-storage-engine=MyISAM
#skip-innodb
character-set-server=utf8
collation-server=utf8_general_ci
max_allowed_packet=1M
secure_file_priv=  
sql-mode=

 

2. Increase to 256M:
max_allowed_packet=16M

 

3. Save the file

4. Restart the MySQL Database service

 

If you still see the same behavior, you can try increasing the max_allowed_packet setting to 256M.

Additional Information

https://community.jaspersoft.com/wiki/how-repair-corrupted-jasperreports-server-repository-database 

and 

https://community.broadcom.com/communities/community-home/digestviewer/viewthread?MID=812884