AnsweredAssumed Answered

db setup - what went wrong? (15.5 fresh install)

Question asked by urmas on Nov 25, 2018
Latest reply on Dec 6, 2018 by urmas

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'.

Outcomes