Multi-Machine provisioned resource or blueprint is stuck in the MachineProvisioned state

[itsthedeal]

With this state you can't do any second day operations. Is it somehow possible to change this state of a VM without deleting the machine?

[itsthedeal]

I found a solutions by going into the SQL db and run this query.


    USE

    GO

    UPDATE .[VirtualMachine]

       SET = 'On'

    WHERE like 'MachineProvisoned' 

    GO

Don't know if it's tricky but it works like a charm. 

[itsthedeal]

Lost some characters by pasting the clipboard:


This is the query that did the trick:


    USE

    GO

    UPDATE .[VirtualMachine]

       SET = 'On'

    WHERE like 'MachineProvisoned' 

    GO

Cheers

USE

GO

UPDATE .[VirtualMachine]

  SET = 'On'

WHERE like 'MachineProvisoned' 

GO

[itsthedeal]

happy Chrome. ;-( For some reason not everything is paste into the reply and uploaded to the forum.


Another try with Firefox and leave the breackets out


USE vRa


GO


UPDATE dbo.VirtualMachine


   SET VirtualMachineState = 'On'


WHERE VirtualMachineState like 'MachineProvisioned'


GO