locked
Cannot force the computer to unmanaged management mode in MOM admin console RRS feed

  • Question

  • I Get the following message on several clients, which I want to delete while forcing client to unmanaged mode.

     

     

    0x00040ed2: Unknown error code 265938.

    Error = 0x80040e2f, The statement has been terminated.. SQL: 3621, 01000

    Error = 0x80040e2f, The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Attribute_Instance". The conflict occurred in database "OnePoint", table "dbo.Instance", column 'InstanceID'.. SQL: 547, 23000

     


    • Edited by FCS rookie Thursday, October 13, 2011 4:48 PM
    Thursday, October 13, 2011 4:47 PM

Answers

  • Hi,

    Thank you for your post.

    It's Database relationship conflict, please run sql queries below to fix this issue:

    BEGIN TRAN

    GO


    declare @idinst uniqueidentifier

    declare @idclass uniqueidentifier

    declare @domain nvarchar(20)

    declare @keyval nvarchar(400)

    declare @sname nvarchar(20)


    -- replace these parameters

    -- the target we have to replace

    set @sname = 'SYSNAME';

    -- the customer domain

    set @domain = 'CUSTDOMAIN';

    -- gets the key for the computer

    select @idinst = idComputer from computer

    where name = @sname;


    -- gets the key for the computer class

    select @idclass = ClassID from ClassDefinition

    where name = 'Computer';


    -- build the domain key

    set @keyval = @domain + '/' + @sname


    INSERT INTO Instance

    VALUES ( @idinst, @idclass, @keyval, null, getdate(), getdate(),

    'dbo', null, null);

    GO


    COMMIT TRAN

    GO


    Regards,
    Rick Tan
    • Marked as answer by Rick Tan Monday, October 24, 2011 5:49 AM
    Thursday, October 20, 2011 2:56 AM