ESX to ESXi upgrade. V6 doesn't reconnect #5180956

[ThinkGrid]

Hello there, case ID #5180956

I had an ESX 4.0 upgraded today to ESXi 4.1 update2 but Veeam6 doesn't reconnect to it

Below is error when I try to reconnect. SSH is enabled. I disconnect and reconnect but errors everytime



Please help

[ThinkGrid]

Note, this is only happening to Veeam6

Veeam5 picks up the upgrade automatically

[ThinkGrid]

This is affecting V5 now as well

Some hosts it picks up automatically and some not

Don't know the hell is going on

[ZachW]

For anyone having this issue, please create a support ticket to get this fixed up

[ThinkGrid]

Well, with V5, all I had to do is restart the BR server and then it picked them up

This didn't work with V6

[ThinkGrid]

BTW: This is the solution provided by Veeam Support in case any ones needs it. Run below query on the SQL DB, note that if you have installed Veeam with default SQL Express then you will need to download the Studio Manager to run the query:

Code: Select all

BEGIN TRANSACTION
 
UPDATE O
SET
      O."type" = N."type",
      O."reference" = N."reference"
FROM [Hosts] AS O
 
INNER JOIN [Hosts] as N
      on O."name" = N."name"
where N."name" in (
            SELECT "name"
            FROM [Hosts]
            where ("type"=6 or "type"=0)
            GROUP BY "name"
            HAVING COUNT(*)>1)
and N.reference in ( 
                  SELECT reference
                  FROM [Hosts]
                  where "name" in (
                              SELECT "name"
                              FROM [Hosts]
                              where ("type"=6 or "type"=0)
                              GROUP BY "name"
                              HAVING COUNT(*)>1)
                  and "type"=6)
and O."type" = 0
and O."type" != N."type"
 
UPDATE Hosts
set "type"=-3
where info LIKE 'VMware ESXi 4%' and "name" IN (SELECT "name"
FROM [Hosts]
where "name" in (
                        SELECT "name"
                        FROM [Hosts]
                        where ("type"=6 or "type"=0)
                        GROUP BY "name"
                        HAVING COUNT(*)>1)
and "type"=6)
 
DELETE 
FROM [Hosts]
where "type"=-3
COMMIT