IT Core Blog

Never stop questioning. Curiosity has its own reason for existing…

Archive for the ‘Troubleshooting’ Category

Recent MS Updates that you should consider for installation

with one comment

Important (recommended updates) fixes that were Recently released by Microsoft that you should consider for installation in Windows 2008 R2 and Windows 7 Systems.

KB979782: An update rollup package for the Validate a Configuration Wizard of the Failover Clustering feature is available for Windows Server 2008 R2

KB981314: The “Win32_Service” WMI class leaks memory in Windows Server 2008 R2 and in Windows 7

KB981577: The “Invoke-WmiMethod” cmdlet dispatches incorrect results on a computer that is running Windows 7 or Windows Server 2008 R2

KB982293: The Svchost.exe process that has the WMI service crashes in Windows Server 2008 R2 or in Windows 7

KB982383: You encounter a decrease in I/O performance under a heavy disk I/O load on a Windows Server 2008 R2-based or Windows 7-based computer

KB983289: The “ZwAllocateVirtualMemory” function fails together with a STATUS_INSUFFICIENT_RESOURCES error randomly when you have sufficient memory in Windows 7 or in Windows Server 2008 R2

KB983551: Windows 7 or Windows Server 2008 R2 stops responding at the “Please wait” screen before you are requested to press Ctrl+ALT+DEL

Written by IT Core

June 11, 2010 at 2:55 PM

SCVMM Error: The server encountered an error while creating “Name of the VM”

leave a comment »

Robert Vierthaler that works at Microsoft as an Escalation Engineer posted about an interesting error that you might run into.
The Details:

On a Hyper-V Server, existing VMs where running just fine, however, we could not create new VMs. The error at the final stage of the Wizard was:
The server encountered an error while creating “Name of the VM”
The operation failed
Failed to create external configuration store at
: A required privilege is not held by the client. (Virtual machine ID 0×80070522)

As it turned out, the Virtual Machine Management Server was not able to create a symbolic link for the machine at “%systemdrive%\programdata\Microsoft\Windows\Hyper-V\Virtual Machines”

By default the local User Right “Create Symbolic links” is assigned to the Adminstrators group. Once you install Hyper-V a extension is installed on this machine that allows Service SIDs to be used and the Service SID “Virtual Machines” is allowed to “Create Symbolic links”

Now, you might have the requirement to configure the User Right “Create Symbolic links” with a Domain GPO. Once configured it replaces the local assignment, and for Hyper-V Hosts you’d need to add the “Virtual Machines” Service SID. The Domain Controller is most likely not a Hyper-V Host, and does not have the necessary Hyper-V extension. Also the GPO Admin tools will not allow you to browse the Service SID namespace. Simply adding the string “Virtual Machines” does not help either as it needs to have the Hyper-V Service SID Prefix “NT VIRTUAL MACHINES”.

To get the necessary Service SID added, you need to edit the GptTmpl.inf that is associated with the GPO on the Sysvol directly. [You need to locate the correct GptTmp.inf by the GPO's Unique ID]

Example with Administrators and added “Virtual Machines”
….
[Privilege Rights]
SeCreateSymbolicLinkPrivilege = *S-1-5-32-544, NT Virtual Machine\Virtual Machines

Written by IT Core

June 8, 2010 at 10:07 PM

System Center Virtual Machine Manager 2008 R2 hotfix rollup package for Server and Administrator’s Console

leave a comment »

KB982522 - Description of the System Center Virtual Machine Manager 2008 R2 hotfix rollup package: June 8, 2010
KB982523 - Description of the System Center Virtual Machine Manager 2008 R2 Admin Console hotfix rollup package: June 8, 2010
From System Center Virtual Machine Manager Team Blog

 

 

List of issues that are resolved:SCVMM Server Rollup
Issue 1: A high availability virtual machine with a GPT pass-thru disk is reported is reported as “Unsupported Cluster Configuration.”
Issue 2: When you manage VMware Virtual Center that has distributed switches, the Virtual Machine Manager service (Vmmservice.exe) crashes.
Additionally, the following events are logged in the VM Manager log:
Log Name: VM Manager
Source: Virtual Machine Manager
Event ID: 19999
Level: Error
Description: Virtual Machine Manager (vmmservice:4676) has encountered an error and needed to exit the process. Windows generated an error report that has the following parameters:
Event:VMM20
P1(appName):vmmservice
P2(appVersion):2.0.4271.0
P3(assemblyName):VMWareImplementation
P4(assemblyVer):2.0.4273.0
P5(methodName):M.C.V.VmwVMNetworkAdapter.get_ConnectedPort
P6(exceptionType):System.InvalidCastException
P7(callstackHash):f20b

Log Name: VM Manager
Source: Virtual Machine Manager
Event ID: 1
Level: Error
Description: System.InvalidCastException: Unable to cast object of type ‘Microsoft.VirtualManager.VMWareService.VirtualDeviceBackingInfo’ to type ‘Microsoft.VirtualManager.VMWareService.VirtualDeviceDeviceBackingInfo’.

Issue 3: After Quick Storage Migration is completed, the Failover Cluster Management MMC snap-in reports that the VM still uses the old CSV volume.
Issue 4: If a VM is configured with 3 virtual processors, the SCVMM Admin Console crashes.
Issue 5: The settings for the virtual network are incorrect after a Refresh-VMHost cmdlet job is completed.

How to obtain this SCVMM 2008 R2 hotfix rollup package
This hotfix rollup package is available on Microsoft Update.
To obtain this update from Microsoft Update, follow these steps on the Virtual Machine Manager server:
1-Click Start, and then select Control Panel.
2-In Control Panel, double-click Windows Update.
3-In the Windows Update window, click Check Online for updates from Microsoft Update.
4-Click important updates are available.
5-Select Update for System Center Virtual Machine Manager 2008 R2 (KB982522), and then click OK.
6-Click Install updates
.
Note If the Virtual Machine Manager or Virtual Machine Manager Agent service is running when the hotfix rollup package is installed on the Virtual Machine Manager server, you have to restart the computer.

To manually download the hotfix rollup package from the Microsoft Update Catalog, visit the following Microsoft Web site

SCVMM Administrator’s Console Rollup
List of issues that are resolved:
- If a VM is configured to have 3 virtual processors, the SCVMM Admin Console crashes.
Note To resolve this issue, install the hotfix rollup package 982522 that is a hotfix rollup package for System Center Virtual Machine Manager 2008 R2 and then this hotfix rollup package.
This hotfix rollup package also resolves the issues that are documented in the following SCVMM 2008 R2 Admin Console update:
976246 When you remove a virtual hard disk from a virtual machine in System Center Virtual Machine Manager 2008 R2, the .vhd file on the Hyper-V server is deleted without warning

How to obtain the SCVMM 2008 R2 Admin Console hotfix rollup package
This hotfix rollup package is available on Microsoft Update.
To obtain this update from Microsoft Update, follow these steps on computers that have the SCVMM Admin Console installed:

1-Click Start, and then select Control Panel.
2-In Control Panel, double-click Windows Update.
3-In the Windows Update window, click Check Online for updates from Microsoft Update.
4-Click important updates are available.
5-Select Update for System Center Virtual Machine Manager 2008 R2
(KB982523), and then click OK.
6-Click Install updates.

To manually download the hotfix rollup package from the Microsoft Update Catalog, visit the following Microsoft website

:)

Written by IT Core

June 8, 2010 at 9:58 PM

KB2010168: The system Center Operations Manager 2007 web console fails to open with “Error: Could not load file or assembly ‘Microsoft.ReportViewer.WebForms, Version=9.0.0.0″

leave a comment »

From KB2010168

When installing the System Center Operations Manager 2007 R2 Web Console on a server running Windows Server 2008, the setup process completes successfully but the following errors occur when attempting to open the web console:

Server Error in ‘/’ Application.
——————————————————————————–
Runtime Error
Description
: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed.

If remote errors are enabled in the web.config file, the following error should also appear in the browser:

Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message: Could not load file or assembly ‘Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a’ or one of its dependencies. The system cannot find the file specified. (C:\Program Files\System Center Operations Manager 2007\Web Console\web.config line 83) (C:\Program Files\System Center Operations Manager 2007\Web Console\web.config line 50)
Source Error:

Line 48:     <httpModules>
Line 49:       <add name=”ScriptModule” type=”System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35″ />
Line 50:       <add name=”RequestManager” type=”Microsoft.EnterpriseManagement.OperationsManager.WebConsole.RequestManager” />
Line 51:     </httpModules>
Line 52:     <!– 

Source File: C:\Program Files\System Center Operations Manager 2007\Web Console\web.config    Line: 50

In the Application event log on the server hosting the web console, you may also see the following event:

Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1310
User:  N/A
Description:
Event code: 3008
Event message: A configuration error has occurred.
Event time: <Time>
Event time (UTC): <UTC Time>
Event ID: dadadf80bdae40aba74497495d549348
Event sequence: 2
Event occurrence: 1
Event detail code: 0
 
Application information:
    Application domain: /LM/W3SVC/2/ROOT-1-129050434759652361
    Trust level: Full
    Application Virtual Path: /
    Application Path: C:\Program Files\System Center Operations Manager 2007\Web Console\
    Machine name: <Computer Name>
 
Process information:
    Process ID: 3988
    Process name: w3wp.exe
    Account name: NT AUTHORITY\NETWORK SERVICE
 
Exception information:
    Exception type: ConfigurationErrorsException
    Exception message: Could not load file or assembly ‘Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a’ or one of its dependencies. The system cannot find the file specified. (C:\Program Files\System Center Operations Manager 2007\Web Console\web.config line 83) (C:\Program Files\System Center Operations Manager 2007\Web Console\web.config line 50) (C:\Program Files\System Center Operations Manager 2007\Web Console\web.config line 50)
 
Request information:
    Request URL: http://localhost:51908/default.aspx
    Request path: /default.aspx
    User host address: 127.0.0.1
    User: 
    Is authenticated: False
    Authentication Type: 
    Thread account name: NT AUTHORITY\NETWORK SERVICE
 
Thread information:
    Thread ID: 1
    Thread account name: NT AUTHORITY\NETWORK SERVICE
    Is impersonating: False
    Stack trace:    at System.Web.Configuration.HttpModuleAction.get_Entry()
   at System.Web.Configuration.HttpModulesSection.CreateModules()
   at System.Web.HttpApplication.InitInternal(HttpContext context, HttpApplicationState state, MethodInfo[] handlers)
   at System.Web.HttpApplicationFactory.GetNormalApplicationInstance(HttpContext context)
   at System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext context)
   at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)

Cause:
This can occur if some of the files that the web console requires to render the web forms are missing from the server.

Solution:
To resolve this issue, install the Microsoft Report Viewer Redistributable 2008.

Written by IT Core

June 5, 2010 at 7:51 PM

Integration Components Setup Error: An error has occurred: Internal Error

leave a comment »

Here’s an interesting one :)
You try to install the Hyper-V Integration Services (Drivers) in a VM with Windows 2003 and you get the following error:
An error has occurred: Internal Error

Hum… :(
No errors in the event log we decided to start by installing the latest updates for that VM. Unfortunately not all updates were able to install properly, in fact most of the updates were failing to install as well…
 Ok, Back to the Integration Components setup, it was time to check the log. Under %Windir% directory we check the installation log “vmguest.log”:

Hyper-V Integration Services Installer version 6.1.7600.16385
MUI file loaded
Parsing command line…
Command line parsing complete
Application Directory = D:\support\x86
ServicingMode = 0
##### START: VERIFY SYSTEM ENVIRONMENT
OS Version      = 5.2
OS SP Level     = 2
OS Platform ID  = 2
OS Product Type = 3
Edition ID      = 0×0
Processor Arch  = 0
Processor Count = 2
System Language = en-us (ENU)
Windows Dir     = C:\WINDOWS
System Dir      = C:\WINDOWS\system32
Drivers Dir     = C:\WINDOWS\system32\drivers
System MUI Dir  = C:\WINDOWS\system32\en-us
Drivers MUI Dir = C:\WINDOWS\system32\drivers\en-us
##### END: VERIFY SYSTEM ENVIRONMENT – Exit code = 0×0
Starting the restart dialog killer thread
RestartDialogCaption = System Settings Change
Restart dialog handler ready
Creating progress dialog
Dialog created
ProgressMessage = 49305
Creating worker thread
Worker thread created
Waiting for worker thread
##### START: UPDATE HAL
HAL found at C:\WINDOWS\inf\hal.inf
##### END: UPDATE HAL – Error code = 0×0
##### START: INSTALL KMDF
About to load DLL D:\support\x86\WdfCoInstaller01007.dll
About to call preinstall
Preinstall failed with error 0000F00D
##### END: INSTALL KMDF – Error code = 0xF00D
Detected worker thread exit
Worker thread error code = 0000F00D
Exit code = 0xEA60

After identifying which component fail, we proceed to the respective log “Wdf01007Inst.log” under the same directory “%WinDir%”. Inside this log, between other errors, we found this one:
Failed to copy spupdsvc.exe

So we decided to analyze the “%Windir%\System32\ spupdsvc.exe“. After checking the ” spupdsvc.exe” we discover that “spupdsvc.exe” did not appear to be a original Microsoft exe file, we were able to confirm this checking the “spupdsvc.exe” properties and its digital signature which didn’t exist at all.

Solution:
The Solution was to delete the “spupdsvc.exe”, run a Malware remover tool in the system (this may be need as the antivirus may not be able to detect the malware or remove it), then copy the “spupdsvc.exe” from a healthy system to the problematic one.
After this the Integration components were successfully installed and the updates that were also ALL installed successfully.

:)

Written by IT Core

May 28, 2010 at 1:47 AM

TechNet Wiki – AV Exclusion List

leave a comment »

Wouldn’t it be handy to have one place on the web where you could find an updated list of ALL the AV exclusions you might want to configure? This wiki stub topic is meant to be that list. Feel free to add to the list, it is the wiki way!  

  

Windows:
KB822158 Virus scanning recommendations for Enterprise computers that are running currently supported versions of Windows

Windows / Active Directory: 
http://support.microsoft.com/kb/822158
http://support.microsoft.com/kb/837932
http://support.microsoft.com/kb/943556

Cluster:
http://support.microsoft.com/kb/250355

Forefront: Considerations when using antivirus software on FF Edge
Products

http://support.microsoft.com/kb/943620
http://technet.microsoft.com/en-us/library/cc707727.aspx

FRS:
http://support.microsoft.com/kb/815263

SQL:
http://support.microsoft.com/kb/309422

IIS:
http://support.microsoft.com/kb/821749
http://support.microsoft.com/kb/817442

DHCP:
http://support.microsoft.com/kb/927059

SCOM / MOM:
http://support.microsoft.com/kb/975931

Hyper-V:
http://support.microsoft.com/default.aspx/kb/961804

Exchange:
Exchange 2010: http://technet.microsoft.com/en-us/library/bb332342.aspx
Exchange 2007: http://technet.microsoft.com/en-us/library/bb332342(EXCHG.80).aspx
http://support.microsoft.com/kb/328841
http://support.microsoft.com/kb/823166
http://support.microsoft.com/kb/245822
http://technet.microsoft.com/en-us/library/bb332342(EXCHG.80).aspx
http://technet.microsoft.com/en-us/library/bb332342.aspx

SharePoint:
http://support.microsoft.com/kb/952167
http://support.microsoft.com/kb/320111
http://support.microsoft.com/kb/322941

SMS:
http://support.microsoft.com/kb/327453

ISA:
http://support.microsoft.com/kb/887311

WSUS:
http://support.microsoft.com/kb/900638

SBS:
http://support.microsoft.com/kb/885685

 Med-V
Recommended Anti-Virus exclusions for MED-V client and workspace installations

System Center:
Recommendations for antivirus exclusions in MOM 2005 and Operations Manager 2007

KB983253-SCVMM 2008 Administrator Console cannot connect to a Windows Server 2008 Hyper-V-hosted VM in Windows 7 or in Windows Server 2008 R2

leave a comment »

Error:
Virtual Machine Manager failed to connect to the virtual machine because of a socket connection error. Check the firewall and network settings, and then try to connect again.

Cause:
This issue may occur because the SCVMM 2008 Administrator Console tries to establish a Remote Desktop connection by not using a VMConnect connection to the Hyper-V host on the 2179 TCP port. Instead, the SCVMM 2008 Administrator Console tries to establish a Remote Desktop connection directly with the operating system of the VM on the 3389 TCP port.

Note: The SCVMM 2008 Administrator Console works as expected on a computer that is running a supported version of Windows XP, of Windows Vista, or of Windows Server 2008.

Resolution:
To resolve this issue on a computer that is running Windows 7 or Windows Server 2008 R2, you must use Microsoft System Center Virtual Machine Manager (SCVMM) 2008 R2. Additionally, you must use SCVMM 2008 R2 to manage Windows Server 2008 R2 Hyper-V hosts.

Taken from:
KB983253-SCVMM 2008 Administrator Console cannot connect to a Windows Server 2008 Hyper-V-hosted VM in Windows 7 or in Windows Server 2008 R2

Written by IT Core

May 19, 2010 at 10:31 PM

KB2027535- Management Server unable to get configuration in System Center Operations Manager 2007

leave a comment »

A Management Server that has been added to a Systems Center Operations Manager 2007 management group is able to download configuration information from the Root Management Server, but generates an error when attempting to process the configuration. The Operations Manager event log on the new management server will show the following two events every few minutes:

Source: HealthService
Event ID: 7022

Task Category: Health Service
Level: Error
Description:
The Health Service has downloaded secure configuration for management group , and processing the configuration failed with error code 0x80FF003F(0x80FF003F).

Source: HealthService
Event ID: 1220
Task Category: Health Service
Level: Error
Description:
Received configuration cannot be processed. Management group . The error is 0x80FF003F(0x80FF003F).

Check KB2027535 - New Management Server unable to get configuration in System Center Operations Manager 2007

Written by IT Core

May 18, 2010 at 6:59 PM

CRITICAL UPDATE for Exchange 2010 Address List Segregation and Current Support Stances

leave a comment »

CRITICAL UPDATE for Exchange 2010 Address List Segregation and Current Support Stances, read the Full article From Dgoldman’s WebLog

Written by IT Core

May 11, 2010 at 8:59 PM

Posted in MS Hotfixes, Troubleshooting

Tagged with

Hyper-V Fixes for Network Connectivity related issues

with 2 comments

Important Hyper-V Network issues related (Recommended Updates):
KB974909 - The network connection of a running Hyper-V virtual machine is lost under heavy outgoing network traffic on a Windows Server 2008 R2-based computer
KB981836 - Network connectivity for a Windows Server 2003-based Hyper-V virtual machine is lost temporarily in Windows Server 2008 R2.
KB978309 - IPv6 transition technologies, such as ISATAP, 6to4 and Teredo do not work on a computer that is running Windows Server 2008 R2 Server core.

When this issue occurs, one or both of the following events are logged in the System log on the VM:
Event Type: Warning
Event Source: netvsc
Event Category: None
Event ID: 5
Date: <date>
Time: <time>
User: N/A
Computer: <computer name>
Description: The miniport ‘<network adapter name>’ hung.

Event Type: Warning
Event Source: netvsc
Event Category: None
Event ID: 4
Date: <date>
Time: <time>
User: N/A
Computer: <computer name>
Description: The miniport ‘<network adapter name>’ reset.

Notes:
KB979409 is to be installed in the Hyper-V servers.
KB981836 is to be installed on the Hyper-V server which will create a new set of Integration Components and then the new Integration Components will need to be updated in the Windows 2003 VMs.

KB978309 - Check Related Issues in the following posts:
IP Helper Service – IpHlpSvc Consume more than expected %CPU
Unable to add additional node to Hyper-V Cluster
Windows 2008 R2 problems with HP Drivers
Windows 2008 R2 problems with HP Drivers Again…

Additional Updates At:
Hyper-V Update List for Windows Server 2008 R2
Hyper-V Update List for Windows Server 2008

Written by IT Core

May 11, 2010 at 4:07 PM

Removing missing VMs from SCVMM DB

leave a comment »

Do you have missing Virtual machines in your SCVMM console? Learn how to remove them using Michael’s scripts:

“it has come to our attention that there are some customer complaints with regards to missing virtual machines in the administrator console after a cluster failover. Since it is not easy to remove those VMs from the VMM administrator console, Gokcen from our team wrote a script that will allow you to clean those VMs up. Here are the steps to follow.”

1.First close the VMM Administrator Console
2.Then, stop the VMMService windows service on the VMM server computer
3.Take a FULL database backup of the VMM database [Just in case; this is a safety net in case something goes wrong]
4.Now you are ready to clean up any missing VMs. it is important to notice that all missing Virtual Machines in this VMM environment will be deleted from the VMM database. we are not deleting any virtual machines from any virtualization host computer. basically we are not touching anything on Hyper-V, Virtual Server, or VMware ESX computers
5.Install Microsoft SQL Server Management Studio Express on the same computer where the VMM database exists. This is a free download from microsoft and you can search for it on Bing.
6.Open SQL Management Studio, select the VMM database and run the SQL script below. That should delete all VMs that are in the missing state in the VMM database.
7.Once the sql script is completed, restart the VMMService and open the Administrator Console. All your missing VMs should now be “eliminated” :)

<<

BEGIN TRANSACTION T1

DECLARE custom_cursor CURSOR FOR
SELECT ObjectId from
dbo.tbl_WLC_VObject WHERE [ObjectState] = 220

DECLARE @ObjectId uniqueidentifier

OPEN custom_cursor
FETCH NEXT FROM custom_cursor INTO @ObjectId

WHILE(@@fetch_status = 0)
 BEGIN

 DECLARE vdrive_cursor CURSOR FOR
 SELECT VDriveId, VHDId, ISOId from
 dbo.tbl_WLC_VDrive WHERE ParentId = @ObjectId

 DECLARE @VDriveId uniqueidentifier
 DECLARE @VHDId uniqueidentifier
 DECLARE @ISOId uniqueidentifier

 OPEN vdrive_cursor
 FETCH NEXT FROM vdrive_cursor INTO @VDriveId, @VHDId, @ISOId
 WHILE(@@fetch_status = 0)
 BEGIN
  DELETE FROM dbo.tbl_WLC_VDrive
         WHERE VDriveId = @VDriveId
  if(@VHDId is NOT NULL)
  BEGIN
       
   DELETE FROM dbo.tbl_WLC_VHD
   WHERE VHDId = @VHDId
   DELETE FROM dbo.tbl_WLC_PhysicalObject
   WHERE PhysicalObjectId = @VHDId
  END
  if(@ISOId is NOT NULL)
  BEGIN
  
   DELETE FROM dbo.tbl_WLC_ISO
          WHERE ISOId = @ISOId
   DELETE FROM dbo.tbl_WLC_PhysicalObject
   WHERE PhysicalObjectId = @ISOId
  END
 
     FETCH NEXT FROM vdrive_cursor INTO @VDriveId, @VHDId, @ISOId
   END
 CLOSE vdrive_cursor
 DEALLOCATE vdrive_cursor

—————–
 DECLARE floppy_cursor CURSOR FOR
 SELECT VFDId, vFloppyId from
 dbo.tbl_WLC_VFloppy WHERE HWProfileId = @ObjectId

 DECLARE @vFloppyId uniqueidentifier
 DECLARE @vfdId uniqueidentifier

 OPEN floppy_cursor
 FETCH NEXT FROM floppy_cursor INTO @vfdId, @vFloppyId
 WHILE(@@fetch_status = 0)
 BEGIN
      DELETE FROM dbo.tbl_WLC_VFloppy 
  WHERE VFloppyId = @vFloppyId
  
  if(@vfdid is NOT NULL)
  BEGIN
   DELETE FROM dbo.tbl_WLC_VFD
   WHERE VFDId = @vfdId
   DELETE FROM dbo.tbl_WLC_PhysicalObject
   WHERE PhysicalObjectId = @vfdId
  
  END
 
     FETCH NEXT FROM floppy_cursor INTO @vfdId, @vFloppyId
   END
 CLOSE floppy_cursor
 DEALLOCATE floppy_cursor

—————-
 DECLARE checkpoint_cursor CURSOR FOR
 SELECT VMCheckpointId from
 dbo.tbl_WLC_VMCheckpoint WHERE VMId = @ObjectId

 DECLARE @vmCheckpointId uniqueidentifier

 OPEN checkpoint_cursor
 FETCH NEXT FROM checkpoint_cursor INTO @vmCheckpointId
 WHILE(@@fetch_status = 0)
 BEGIN
      DELETE FROM dbo.tbl_WLC_VMCheckpointRelation 
  WHERE VMCheckpointId = @vmCheckpointId
  
 
     FETCH NEXT FROM checkpoint_cursor INTO @vmCheckpointId
   END
 CLOSE checkpoint_cursor
 DEALLOCATE checkpoint_cursor

————————-
———Clean checkpoint

 DELETE FROM dbo.tbl_WLC_VMCheckpoint
 WHERE VMId = @ObjectID

        exec [dbo].[prc_VMMigration_Delete_VMInfoAndLUNMappings] @ObjectId

        DECLARE @RefreshId uniqueidentifier
        exec [dbo].[prc_RR_Refresher_Delete] @ObjectId, @RefreshId

        DELETE FROM dbo.tbl_WLC_VAdapter
 WHERE HWProfileId = @ObjectId

        DELETE FROM dbo.tbl_WLC_VNetworkAdapter
 WHERE HWProfileId = @ObjectId

               
        DELETE FROM dbo.tbl_WLC_VCOMPort
 WHERE HWProfileId = @ObjectId

        DELETE FROM dbo.tbl_WLC_HWProfile
        WHERE HWProfileId = @ObjectId

        DELETE FROM dbo.tbl_WLC_VMInstance
        WHERE VMInstanceId = @ObjectId

 DELETE FROM dbo.tbl_WLC_VObject
 WHERE ObjectId = @ObjectId

    FETCH NEXT FROM custom_cursor INTO @ObjectId
  END
CLOSE custom_cursor
DEALLOCATE custom_cursor

COMMIT TRANSACTION T1

>>

Written by IT Core

April 17, 2010 at 8:08 PM

SCVMM Administrator Console does NOT show up properly “Windows 2000″

leave a comment »

Another great article from Michael. This time he explains how to fix a problem that we also had in our SCVMM…

if you are managing a Windows 2000 Server Virtual Machine with Hyper-V, you might notice that VMM does not recognize this operating system in the Administrator Console. Even if you manually change the OS name in the Virtual Machine properties, VMM will make it empty on the next refresh of the VM.

To get around this issue and get the proper name to display follow these steps

1.First close the VMM Administrator Console
2.Then, stop the VMMService windows service on the VMM server computer
3.Take a FULL database backup of the VMM database [Just in case; this is a safety net in case something goes wrong]
4.Now you are ready to edit the database and insert the columns that will allow VMM to recognize the OS name for Win2k.
5.Install Microsoft SQL Server Management Studio Express on the same computer where the VMM database exists. This is a free download from microsoft and you can search for it on Bing.
6.Open SQL Management Studio, select the VMM database and run the two SQL insertion statements/scripts below. That should change the VMM knowledge of supported guest operating systems and also add Win2k to the list (for both Server and Advanced Server).
7.Once the sql script complete, restart the VMMService and open the Administrator Console. Wait for approximately 30 minutes to 1 hour and your VMs will display the proper Win2k operating system in the Administrator Console. Make sure your Virtual Machines are running during this time, otherwise the guest operating system version will not be discovered
8.Good luck

INSERT INTO tbl_IL_OS
(OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestId)
VALUES (’08f954f9-6475-4e07-9e32-4d2ddefc4c54′, ‘Windows 2000 Advanced Server’, ‘Windows 2000 Advanced Server’, 1, 3, ’5.0′, ‘x86′, 0x3f, ‘win2000AdvServGuest’)

INSERT INTO tbl_IL_OS
(OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestId)
VALUES (‘e85f1375-c69e-4cbd-8249-0e32caa04abb’, ‘Windows 2000 Server’, ‘Windows 2000 Server’, 0, 3, ’5.0′, ‘x86′ , 0x3f, ‘win2000ServGuest’)

:)

Written by IT Core

April 17, 2010 at 8:02 PM

How to use Problem Steps Recorder

leave a comment »

From App-V Team Blog.

“On Windows 7 and Windows Server 2008 R2, there is a great troubleshooting tool called the Problem Steps Recorder (PSR). The PSR allows screenshots and details of actions to be automatically recorded and saved in a .MHT file that is automatically zipped. A user can send this file to Microsoft Support to provide an accurate account of steps to reproduce and issue. There is a short video on TechNet that gives a demonstration of the Problem steps recorder.

We can appropriate this tool and turn it into a Sequencing Steps Recorder to document “recipes” for sequencing applications. Other App-V blog articles have demonstrated how to use video to document sequencing. The Problem Steps Recorder just provides another alternative, especially for those users that like to read from a printout.

The PSR can be easily be found on Windows 7 or Server 2008 just by clicking on the Windows Logo and typing “steps” ,“record”, or “PSR.exe” in the search bar”

Read more at: “Document Sequencing on Windows 7 with the Problem Steps Recorder

Opsmgr Hotfix: System Center Operations Manager 2007 R2 does not display new properties in some views after you import a management pack

leave a comment »

You import a new management pack that contains new properties for certain views on a computer that is running System Center Operations Manager 2007 R2. After you do this, you may receive the following error message:
An object of type Variable with ID Number was not found
Additionally, you find that the new properties are missing from a specific view.

KB981740 – System Center Operations Manager 2007 R2 does not display new properties in some views after you import a management pack

Written by IT Core

April 12, 2010 at 8:32 PM

SCVMM Admin Console to Slow to start…

leave a comment »

Recently I ran into an issue where the SCVMM consoles were slow at initial load, after some debugging and web search I found a perfect match for my scenario:
FROM Michael’s Blog:
VMM Administrator Console taking too much time to load (because of PRO)
If you have enabled the PRO integration with operations manager in your VMM environment, then this blog post might be for you. If your VMM Administrator Console is taking too long to load and the memory footprint of the vmmadmin.exe is too large (i.e. the vmmadmin.exe is taking up too much RAM), then it is possible that you have a lot of PRO tips in the VMM Database and they need to be purged. During the initial load of the Administrator Console, we also load all PRO tips in the UI, both active and completed ones, causing this side effect.
Even though our Jobs view has a built-in grooming cycle, the PRO tips table does not. if you would like to purge some of the completed PRO tips, you can do that using the SQL script in this blog post.
You can modify the NumberOfDays variable to choose how many days of PRO tips to leave back in the database. Currently the script is configured to purge any PRO tip older than 30 days.
Once you successfully execute the script, you can restart the Administrator Console and see the improved performance
<<
/*
Query deletes all ProTips which
- are closed (@ProTipStateClosed = 7)
- are created @NumberOfDays before today
- don’t have a entry in jobs table
*/
DECLARE @NumberOfDays INT, @ProTipStateClosed INT
SET @NumberOfDays = 30;
SET @ProTipStateClosed = 7;
DELETE FROM tbl_PRO_PROTip WHERE
CreationTime <= GETDATE() – @NumberOfDays AND ObjectState = @ProTipStateClosed AND ObjectId NOT IN ( — ProTips that have a job trail. SELECT Tasks.PROTipID FROM tbl_TR_TaskTrail AS Tasks INNER JOIN tbl_PRO_PROTip AS Protips ON Tasks.PROTipID = Protips.ObjectId )

>>

Written by IT Core

April 11, 2010 at 4:11 PM

Follow

Get every new post delivered to your Inbox.

Join 36 other followers