Reports Integration Guide › Troubleshooting › Data Warehouse: Fails to Become Enabled

Data Warehouse: Fails to Become Enabled

Symptom:

You cannot enable the data warehouse. The CA DataMinder server installation wizard returns an error if you select the 'Enable data warehousing for this CMS' check box.

• On Oracle CMSs, the error message is:

  ORA-01031: insufficient privileges
  

• On SQL Server CMSs, the error message is:

  Login is not a user in msdb that is a member of the SQLAgentUserRole. (See MSSQL DB pre-requisites.)
  

Note: This problem only affects CMSs that have been upgraded from version 6.0 of CA DataMinder.

Reason:

Your primary database account does not the required privilege or role.

Solution:

Verify that your primary database account has the required privilege or role before you enable the data warehosue.

Oracle CMSs

Your primary user needs the CREATE JOB privilege. To verify that your primary user has this privilege, run this command:

SELECT * FROM DBA_SYS_PRIVS WHERE PRIVILEGE ='CREATE JOB';

If you primary user does not have this privilege, run this command line as an Oracle SYS user:

GRANT CREATE JOB TO WGNUSER; COMMIT;

Note: The CREATE JOB privilege is granted automatically when you install a version 12.0 or later CMS.

SQL Server CMSs

Verify that your primary login (such as WGNUSER) has been added as a user in the msdb system database. Verify that that this user has been granted the msdb database role SQLAgentUserRole.

Note: The SQLAgentUserRole role is granted automatically when you install a version 12.0 or later CMS.