Fails to run the Web Intelligence / Ad-Hoc reports in CABI 4.1 SP3

book

Article ID: 6493

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction

The following error is displayed when running the Web Intelligence / Ad-Hoc reports:

 Database error: [MySQL][ODBC 5.1 Driver][mysqld-5.5.53-enterprise-commercial-advanced]View 'srmdbapi.v_fact_event' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them. (IES 10901) (WIS 10901)

<Please see attached file for image>

Database_error_lack_rights_10901.png

Cause

The WEBI_user has lack of rights on the srmdbapi and/or reporting database(s).

Environment

CA Spectrum 10.x and CABI / BOXI 4.1 SP3

Resolution

Grant the WEBI_user the capability to read all view data from teh SRMDBAPI.

  1. On the SRM server, log in to mysql as 'root'.
  2. Establish the new username and password combination in the MySQL database instance and access to both the srmdbapi and reporting schemas:
    mysql>GRANT SELECT, EXECUTE ON srmdbapi.* TO 'WEBI_user'@'%' IDENTIFIED BY '0n3cl1Ck';mysql>GRANT SELECT ON reporting.* TO 'WEBI_user'@'%';mysql>FLUSH PRIVILEGES;
  3. Logout of mysql.

 

Attachments

1558714644355000006493_sktwi1f5rjvs16tj2.png get_app