I did a fresh install of 15.5.
Everything seemed to be OK and the PMO add-in with sample data installed without hick ups.
However, after setting up the Datamart the Datamart Extraction failed
bg-ca.log has lines like
ERROR 2018-11-25 01:21:25,559 [Dispatch 1Datamart Extraction : bg@WIN-Q361UV7IEAP (tenant=clarity)] niku.njs (clarity:kinnunenad:5127055__3C2247C6-784E-433B-A7C1-9D8DDB087F72:1Datamart Extraction) Error executing job: 5021006
com.niku.union.persistence.PersistenceException:
SQL error code: 229
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]The SELECT permission was denied on the object 'sysjobs_view', database 'msdb', schema 'dbo'.
SQL error code: 50000
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]-20999_CMN_DB_JOB_ADD_SP Checking for existing job - error 229 return code 0
I set up the db like this
In MS SQL Server Management Studio
Select Databases
Right click and Select Restore Database
Device and Add
Locate the mssql_base.db (all file types)
Select that and restore (the database name is niku and ppm_dwh)
Login as sa
USE niku
GO
sp_addlogin @loginame = 'niku'
, @passwd = 'Clarity15'
, @defdb = 'niku'
use niku
sp_addlogin @loginame = 'niku'
, @passwd = 'Clarity15'
, @defdb = 'niku'
USE niku
ALTER USER niku WITH LOGIN=niku
USE master
GRANT VIEW SERVER STATE to niku
ALTER DATABASE niku
SET ARITHABORT ON
ALTER DATABASE niku
SET ANSI_NULLS ON
ALTER DATABASE niku
SET QUOTED_IDENTIFIER ON
EXEC SP_DBCMPTLEVEL niku, 130
ALTER DATABASE niku
SET READ_COMMITTED_SNAPSHOT ON
sp_configure 'remote query timeout',0
reconfigure with override
What did I miss or do wrong when the datamart extraction is looking for
database 'msdb', schema 'dbo'.