Issue: CoreDBUtil.exe errors when applying LDMS service pack

Version 8

    Verified Product Versions

    Endpoint Manager 9.5Endpoint Manager 9.6Endpoint Manager 2016.xEndpoint Manager 2018.x

    Errors in ...\landesk\managementsuite\ldmain\CoreDBUtil.exe.log as below:


    System.Data.OleDb.OleDbException: Cannot drop the view 'ReplLENOVOBATTINFOV' because it is being used for replication.

      at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)

      at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()

      at LANDesk.ManagementSuite.Database.Database.ExecuteNonQueryP(String sql, Int32 timeoutSeconds, Object[] parameters)

      at LANDesk.ManagementSuite.Database.Database.ExecuteNonQuery(String sql, Int32 timeoutSeconds, ArrayList oleDbParameters)

    There should be a lot of this kind of errors, all about cannot drop a view named "repl*" because it is being used for replication


    Root cause

    There are rollup cores configured.



    Disable replication following the article below:



    Remove all repl views using scripts below:


    declare @cmd varchar(4000)
    declare cmds cursor for
    select 'drop view [' + Table_Name + ']'
    where Table_Name like 'Repl%'


    open cmds
    while 1=1
    fetch cmds into @cmd
    if @@fetch_status != 0 break
    close cmds;
    deallocate cmds


    After the upgrading is done, please manually set up the rollup configuration again.