CoreDBUtil.exe errors when applying LDMS service pack

Version 6

    Verified Product Versions

    LANDESK Management Suite 9.5LANDESK Management Suite 9.6

    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 core configured.

     

    Solution

    Disable replication following the article below:

     

    https://community.landesk.com/support/docs/DOC-35699

     

    Remove all repl views using scripts below:

     

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

     

    open cmds
    while 1=1
    begin
    fetch cmds into @cmd
    if @@fetch_status != 0 break
    exec(@cmd)
    end
    close cmds;
    deallocate cmds
    

     

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