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