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

Document ID : KB000006493
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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)

Database_error_lack_rights_10901.png

Environment:
CA Spectrum 10.x and CABI / BOXI 4.1 SP3
Cause:

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

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.