This article will cover how to manually run  the SQL scripts. The MiSP will need to through this process if Deliverator error outs.
  

1. Open File Explorer.

2. Navigate to wwwroot folder(example path: Local Disk:C-Interpub-wwwroot).

3. Select "CPHive" Folder.

4. Select "Database Installer" Folder.

5. Select "Scripts" sub folder.

 

os_srogti.k

 

6. Select the first script that caused a Deliverator error.

7. Verify script is pointed to Counterpoint Database.

8. Click "Execute".

 

Machine generated alternative text:
TestGolf 
Object Explorer 
Connect• 
dbo.SY_STC 
dbo.SY_SVC_COD 
dbo.SY_USR 
dbo.SY_WORKSTATlON 
dbo.SY_WRK 
dbo.SY_WRKGRP 
Views 
External Resources 
Synonyms 
Programmability 
liii Service Broker 
Storage 
Security 
ecurity 
erver Objects 
eplication 
olyBase 
,lways On High Availability 
anagement 
itegration Sewices Catalogs 
QL Server Agent 
Event Profiler 
Ready 
I Execute 
Execute (F5) 
. - Refresh... .TestGolf (sa (51 X 
eclare 
-- Table 
declare 
declare 
@Refreshviews table (s Type char(2), 
sName nvarchar(128) 
sOwner varchar( 128 
sSeq int) 
to hold names of Indexed views 
@IndexViews table( slndexViewName nvarchar(128 
@ViewName nVarchar(128) 
- -Use sp_msdependencies - undocumented stored procedure that gives the dependencies at all levels in the right order 
--sp_MSDependencies with Param NULL, 2 fetches the dependencies for all the views in the database. 
(S insert into @Refreshviews(sType, sName, sOwner, sSeq 
exec sp_msdependencies NULL, 2 
- -Get all the indexed or schemabound views and store the same 
insert into @IndexViews(sIndexViewName 
select name from sysobjects 
where (objectproperty(id, 
'isindexed' )=1 or objectproperty(id, 
and xtype= 'V' 
• IsSchemaBound ' )=1 
select only views (Views have s Type = 4) that are dependent on other views 
declare ViewCursor cursor for 
select sName from @Refreshviews where stype = 4 order by sSeq 
open ViewCursor 
fetch next from ViewCursor 
while = ø 
begin 
begin try 
--CR 25338 omit Indexed 
if not exists( select 1 
exec ( sp_refreshview 
end try 
begin catch 
into OiewName 
views 
from @IndexViews where slndexViewName = 
+ @ViewName) 
@ViewName) 
declare @Errmsg nvarchar(5ØØ) 
set @ErrMsg 
= 'Error in view definition: 
rai serror (@ErrMsg, 18, 1 ) 
end catch 
- Fetch next 
100% 
Connected. (1/1) 
@ViewName 
col 1 
RR-SANDBOX-OI (14.0 RTM) 
INS 
sa (51) 
TestGolf 
00:00:00 
O rows

 

9. Continue repeating the above steps till you have all the scripts that caused Deliverator errors.

10. Expand "Tables" in CP Database.

11. CPHive Installer should see three new tables in the CP database(USR_API_LOG,USE-CPHIVE_QUEUE, and USR_CPHIVE_SUBSCRIPTION).