The following error is displayed in the Report Manager Administration web page because the reporting.bo_only_user table is corrupted: Operation was not successful. Possible exception occurred. Check system log. Message:null

Products

• CA Spectrum

Issue/Introduction

The following error is displayed in the Report Manager Administration web page

Operation was not successful. Possible exception occurred. Check system log. Message:null

Environment

Release:
Component: SPCRPT

Resolution

To resolve this issue, you need to recreate the bo_only_user table in the reporting database on the SRM system.

The first step is to identify the mysql command used to create the bo_only_table for your version of Spectrum. If the bo_only_table is corrupt, you will not be able to get this information from the SRM system. You will need to use a different SRM system with the save Spectrum version and patches installed and do the following:

1. Log into the SRM system as the user that owns the Spectrum installation

2. If on Windows, start a bash shell by running "bash -login"

3. cd to the $SPECROOT/mysql/bin directory and enter the following command to log into mysql:

./mysql --defaults-file=../my-spectrum.cnf -uroot -proot reporting

4. Run the following command to find the mysql command that created the bo_only_user table:

show create table bo_only_user;

The output would look something like the following (DO NOT USER THE FOLLOWING FOR YOUR ENVIRONMENT AS IT MAY NOT BE THE SAME SPECTRUM VERSION AND PATCH LEVEL)

| Table        | Create Table                                                                                                                                                                                                                                                                                          |
+--------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| bo_only_user | CREATE TABLE `bo_only_user` (
  `bo_user_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_name` varchar(255) DEFAULT NULL,
  `load_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`bo_user_id`),
  UNIQUE KEY `user_name` (`user_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |

5. Note the "CREATE TABLE...." command

Now that you have the mysql command to create the bo_only_user table, do the following on the SRM system where you are having the issue:

1. Log into the SRM system as the user that owns the Spectrum installation

2. Shutdown tomcat

3. If on Windows, start a bash shell by running "bash -login"

4. cd to the $SPECROOT/mysql/bin directory and enter the following command to log into mysql:

./mysql --defaults-file=../my-spectrum.cnf -uroot -proot reporting

5. Run the following command to drop the bo_only_user table:

mysql> drop table bo_only_user; 

6. Ensure the bo_only_user.ibd and bo_only_user.frm files were deleted from the $SPECROOT/mysql/data/reporting directory. If they still exist, manually delete them. 

7. Run the "CREATE TABLE..." command noted previous to recreate the bo_only_user table. Using the above instructions as an example, the command would be the following:

CREATE TABLE `bo_only_user` (`bo_user_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_name` varchar(255) DEFAULT NULL,   `load_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`bo_user_id`), UNIQUE KEY `user_name` (`user_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

NOTE: Do not forget to add the semi-colon character ";" at the end of the above command.

7. Start the Spectrum tomcat