WSUS 30 SP2 Install Failure - Error 0x80070643: Fatal error during installation

Problem:

I was trying to install WSUS 30 SP2, in preparation of SUP install for  my SCCM 2012 SP1 environment.  As you some of you admins especially SCCM folks aware of that SUP relies on WSUS for SCCM based patching. Install kept failing, whatever method I chose to install, either thru Server Manager Add roles / features or downloaded setup executable WSUS30-KB972455-SP2-x64.exe. Install gets kicked of and accepts all of your selections and throws above error which we don’t like much, as it doesn’t reveal needed info to solve the problem.

How to find the root cause of problem:

Now, the hunt began for more info, precisely the location of log files to find more details of failure. Install logs location may vary based on how you install WSUS

                C:\windows\logs\servermanager.log in case if you use “Add Roles” feature using server manger
                %TEMP% which usually resolves to C:\Users\userid\AppData\Local\Temp in case if you used downloaded executable to kick of install

In my case I used downloaded executable and found 3 related logs, each of which are passing information to other.

WSUSSetup.log: This log is kind oversees and passes same info as what GUI throws and very basic
2013-01-18 15:43:39 Error MWUSSetup InstallWsus: MWUS Installation Failed (Error 0x80070643: Fatal error during installation.)
2013-01-18 15:43:39 Error MWUSSetup CInstallDriver::PerformSetup: WSUS installation failed (Error 0x80070643: Fatal error during installation.)
2013-01-18 15:43:39 Error MWUSSetup CSetupDriver::LaunchSetup: Setup failed (Error 0x80070643: Fatal error during installation.)
2013-01-18 15:43:53 Error MWUSSetup DoInstall: Wsus setup failed (Error 0x80070643: Fatal error during installation.)

WSUSSetupmsi_130118_1541.log: This log possess little more details but couldn’t give all, rather pointed to below log for actual details on failure
Error 1722. There is a problem with this Windows Installer package. A program run as part of the setup did not finish as expected. Contact your support personnel or package vendor. Action ExConfigureDb…..C:\Users\UserID\AppData\Local\Temp\2\WSUSCa_130118_1541.log"

WSUSCa_130118_1541.log: This is the log which has given suffice and needed info to resolve the issue
Cannot create file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\SUSDB.mdf' because it already exists. Change the file path or the file name, and retry the operation.Msg 1802, Level 16, State 4, Server ServerName, Line 2
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.

How to Resolve:

WSUSCa_****.log has indicated clearly that setup fails to create a file as a file with same name already exists in SQL DB Files folder. I guess file might have created during my earlier attempt of WSUS either standalone or part of SUP install or sorts and MDF/LDF files got created during. Post deleting the same file, which I did as I know it was less risky in my case and reran the install which went smoothly

· Delete any MDF or LDF files that denote SUS Databases from SQL DB files location (Don’t delete these files if they are used for any other purposes)

· Rerun the setup successfully

Also, this error code might not always results similar root cause, so you will need to act on the problem based on the error clues got from above mentioned log files

--- Thanks, Vasu Miriyala

 

BGB, What is this new component/log in SCCM 2012 SP1

Post install SP1 of SCCM 2012, as usual typical admin task was to check all components logs to find how was site doing. To my surprise there are few logs that weren’t observed in any of previous version of SMS or SCCM. Going through these logs dint reveal much info on what they are all about, but could see it is a new role installed thru and by SCCM only (rolesetup.exe /install /siteserver:MYSERVER SMSBGB 0) .

C:\Program Files\Microsoft Configuration Manager\Logs>dir *bgb*

16-01-2013  18:14           325,900 bgbisapiMSI.log
16-01-2013  17:13           310,868 bgbisapiMSI.log.LastError
16-01-2013  21:38           955,927 bgbmgr.log
16-01-2013  12:12              2,621,583 bgbmgr.lo_
16-01-2013  21:34            55,694 BgbServer.log
16-01-2013  18:14           318,539 BgbSetup.log

I could see from snippet of logs mentioning install of BGB components hence I did try to install it those msi ("C:\Program Files\Microsoft Configuration Manager\bin\x64\bgbisapi.msi) myself, hoping I will get clue on these app/program, but it started a program with “BGB http Proxy” which I have never heard, guess so is Google. I quit that program as safety measure, please don’t tell anyone J

Ok, I took longer breaths to calm down and to simplify my search with log snippets, msi names etc and finally cracked it……and would like to share with you that this is the new game changing component introduced for the first time in SMS/SCCM versions with SCCM 2012 SP1, that allow us to push notifications (policies as we know them) to SCCM Client with objective of assigning them immediate actions to perform , instead of waiting till its policy interval usually, such push may help fasten tasks like OOB patch etc. This new feature called “Client Notification” is interesting compared to Pull mechanism that SMS/SCCM clients use traditionally and comprises of Notification Server, Notification Manager (on Server) and Notification agent (on Client) components to function. More info and credits to Randy XU’s blog below. Also write up on Client Notification by Randy is one the best articles that I have seen for its quality despite being quantitative. BTW, I still need to explore this feature and will share more from the floor when I do so

http://blogs.technet.com/b/configmgrteam/archive/2012/10/11/3522960.aspx

 

--- Thanks, Vasu Miriyala

System Center Configuration Manager (SCCM) 2012 SP1 & PowerShell

Post installing or upgrading to System Center Configuration Manager (SCCM) 2012 SP1, PowerShell is one of the features you will be excited to try. Though needless to introduce you to the benefits of PowerShell in general, but in short introduction of PowerShell cmdlets (~470) in SCCM 2012 SP1 release, helps to automate otherwise repetitive administrative tasks in SP1 environment. Also it helps to systematic passion to execute of tasks thru such automation, as ruling out manual efforts may eliminate errors.

Though Integrating PowerShell module (importing.. precisely) in SCCM is easier there are few points that helps you to know in advance to save your time, as it sounded little confusing especially when you have Windows Server 64 bit, as PowerShell module that will be loaded is 32 bit.

Prerequisites:

SCCM 2012 SP1, which has prerequisite for its successful install/upgrade i.e. Windows Management Framework 3.0 which in turn brings in PowerShell 3.0. SP1 install or upgrade copies necessary PowerShell Models for SCCM 2012 SP1 sites administration, this file is located under C:\Program Files (x86)\Microsoft Configuration Manager\AdminConsole\bin\ ConfigurationManager.psd1. Either this modules needs to imported manually or it will be loaded automatically based on how you connect to PowerShell for SCCM 2012 SP1 administration. So in a way all if you install SP1 successfully PowerShell cmdlets are almost there on your SCCM server but just needs to be imported to use in your PowerShell session  

 How to connect to PowerShell:  

1)  You can use SCCM console to connect to PowerShell, which will import automatically ready to use cmdlets of SCCM 2012 SP1 administration. Connecting to PowerShell this way, takes you to PowerShell context that is ready to use cmdlets of Configuration Manager  

                                                                Or

2)  If you are on 64bit OS, Launch x86 flavor of PowerShell and import SCCM 2012 SP1 module into that session

a.       Start > Run > “%SystemRoot%\syswow64\WindowsPowerShell\v1.0\powershell.exe”

Or Start > PowerShell > Select PowerShell (X86)

b.       Import module below way and you will be connected

                                                               i.      cd ‘.\Program Files (x86)\Microsoft Configuration Manager\AdminConsole\bin’

                                                              ii.      Import-Module .\ConfigurationManager.psd1

                                                            iii.      Set-Location <3 letter sitecode>:    (Example: Set-location CEN if you site code is CEN)

 

How to get started:  

Once you are successfully connected to PowerShell module of ConfigurationManager, context of PowerShell displayes 3 letter site code of your SCCM site. Configuration Manager cmdlets are available for execution in this context only. If you change context to C: drive or so cmdlets of SCCM won’t be available

            PS JAN:\> Get-Command -Module ConfigurationManager   (This gives list of cmdlets available for configuration manager administration)

         
How to get help:
Default cmdlets of help to an extent like get-help, get-help –examples etc but “get-help –online” doesn’t seem to provide much help as online links aren’t going to specific cmdlets but opens up SC tech resources page. Hope MS will fix it shortly

What to try:

Like newbee to SQL or Scripting, it is wise to try all cmdlets that retrieve information from site but not make any changes. They are start with Get, like Get-cmmanagementpoint, for example provides info on MP of that site. Once you are more comfortable then rest of the categories like set, add, remove J etc

You may find below sources help you take your learning’s to next to level get stronger grip on this module. Microsoft has taken great amount efforts to make the job easier as approximately 470 cmdlets should be more than suffice and ideally allow us to automate literally any action on You onfiguration manager administration. I am sure you will enjoy these features as they allows us to focus more on even better and value added tasks for organization… Enjoy !!!

 http://technet.microsoft.com/en-us/library/jj821927.aspx

http://cm12sdk.net/?page_id=1623

 

 

Hyderabad Metro Rail Contest - For Ambassadors

Dead Hyderabadis,

Amazing opportunity strikes you, to show your passion to Hyderabad, especially the new prestigious transport project ever in new era of Hyderabad, L&T Hyderabad Metro Rail. LTHMR invites registration from interested to become its Ambassadors, who will become face of all publicity and campaigns representing. I like its emblem, which is recenlty released, which is truly bibrant and showcases the this elegant project

Why to become brand ambassador:Though pride factor alone to represent L&T HMR alone is life time opportunity, but other benefits as shown below
a) Awarded the prestigious title of the “Official Brand Ambassador for XYZ Category”
b) Be the face of Hyderabad Metro Rail
c) Customized Ambassador’s grooming & personality development workshop
d) Part of promotional campaigns for Hyderabad Metro Rail
e) Opportunity to be a part of the inauguration ceremonies of metro rail, stations and others
f) Amongst first batch of commuters at launch of Metro Rail
g) Opportunity to represent Hyderabad Metro Rail in various genres of society
h) Interviews in Print/Electronic media
i)  && some goodies etc

Category to register:
Students, Executives, Senior Citizens, Housewives and Others

Register and to get more info here

Hurry up and Good luck to those aspiring regisrants !!!

--- Vasu Miriyala
 

Find and delete files on drives - SCCM Script

SCCM is often considered a delivery mechanism using which IT Teams can deliver their intelligence thru software, script etc to clients around, based on what is required by business. Recently our project demanded us to come up with a script that will be deployed thru SCCM to find and delete certain older versions of our LOB apps on each of the local drives on clients. Though I am not an expert at scripting, but do have passion for scripting /automation as they benefit in increased productivity. Ok, this passion drives me to find and build script (from net, sometimes) and, would like to share below what I used for above said requirement just in case if you will find it useful

 I do practice to log suffice info that helps us to troubleshoot in case of any issues, without needing to repro the issue,  including start and end times of script launch, computer name etc. In this case I have saved a copy on network share all actions, so I know in detail what happened on client, as SCCM execution status (mere success or failure)  doesn’t fully provide such info. Also I added few lines to script to force software scan on SCCM clients so that we get latest info on exe files

@ECHO OFF

Echo Starts now on %computername% >> c:\windows\temp\%computername%.log

date /t && time /t >> c:\windows\temp\%computername%.log
wmic path win32_logicaldisk where drivetype=3 get caption | findstr : > c:\windows\temp\drvs.txt
for /f %%v in (c:\windows\temp\drvs.txt) do call :DelFunction %%v
:DelFunction
%1
cd\ >> c:\windows\temp\%computername%.log
Echo Starts now on %computername% and %1 drive >> c:\windows\temp\%computername%.log
date /t && time /t >> c:\windows\temp\%computername%.log
del LOBApps1.exe /s /Q /f >> c:\windows\temp\%computername%.log
del LOBDepend.exe /s /Q /f >> c:\windows\temp\%computername%.log
Echo Ends now on %computername% and %1 drive >> c:\windows\temp\%computername%.log
date /t && time /t >> c:\windows\temp\%computername%.log
copy c:\windows\temp\%computername%.log \\SCCMDP\FilesDelete$ /Y
WMIC /namespace:\\root\ccm path sms_client CALL TriggerSchedule "{00000000-0000-0000-0000-000000000002}" /NOINTERACTIVE

PS: Innovate as much as possible, leveraging SCCM Capabilities to transform your IT environments and you  will rock !!!

 

Cheers, Vasu Miriyala

Step by Step Install - System Center Orchestrator SP1 Install

Hi,

Eagerly awaiting and excited to try System Center Orchestrator SP1 , since its recent latest service pack release SP1. I think beyond SCCM in System Center suite, this is one product that is really interesting to folks who likes to automate processes around IT Operations, I am no exception to join that category. Please find below install (not an upgrade) experience with its screenshots and some useful tips on log files' locations to make your install seamless and troubleshoot well in case of failures

New features of System Center Orchestrator SP1 can be found here

Though it’s pretty straight forward to install but prerequisites seems slightly less compared SCCM folks like me who had prepare a lot before such install. Have SQL 2008 R2 or higher, basic config of IIS, guess it’s done mostly, but detailed can found from online documentation based on roles you install etc.

You will find this install similar to any other System center (or Microsoft) product, but would like to few key points that will be of your interest and help when you do try it yourself

• For me, watching install process in detail though rolling logs is a must (SCCM has made me so), but couldn’t find it easily as Microsoft SCO Help mentioned C:\Users\SCXSVC\AppData\Local\SCO\LOGS but they are not found there.... could figure it out self that they are actually located
  C:\Users\VasuMiriyala\AppData\Local\Microsoft System Center 2012\Orchestrator\LOGS.  Install logs may vary based on components selection but these are found setupwizard.log, webcomponentmsi.log, runbookdesignermsi.log, runbookservermsi.log, managementservicemsi.log, SCOprereqcheck.log and setupuporchestrator.log
• Same is the case with operational logs location when using the product , they are located here in
  C:\ProgramData\Microsoft System Center 2012\Orchestrator\ManagementService.exe\Logs, instead of
  C:\ProgramData\Microsoft System Center Orchestrator\OrchestratorManagementService where Microsoft SCO Help mentions. I assume these two location are changed since SP1 and Microsoft will change online/relevant documentation shortly
• This is the major change I observed, End of the wizard before hitting install button System Center Orchestrator SP1 Install allows you change your selection directly from same window as shown below, instead of going all way back to former screens, saves you few clicks of course

 

If you are a newbee and wants to try SCO, there are tons of articles but you may find Greg's aticle on Technet Magazine (2012 Dec copy) interesting here. to begin with

 

Happy Reading and I will share few simple to medium runbook executions shortly that will help us to automate some known/repetetive stuff

 

Cheers, Vasu Miriyala

Debut Blogging... Vasu Miriyala

Hi,

Today I open my blog, with the intention of sharing my thoughts, views from my experience to make them useful to readers. May be because of my career span and exposure to Microsoft products mainly, since beginning (guess it was 1999 and with Windows 95 ), I may blog on Microsoft products mostly but due credits to others wherever I find. Since last few years my focus has been System Center, especially SCCM, VMM and Orchestrator recently.

I would like to share my thoughts on non-technical and other aspect as well wherever I find it helpful to others, mainly on making Earth more livable and peaceful place for all us

Hope you enjoy my blogs and I find it interesting !!!

Cheers, Vasu Miriyala

PS: I chose black colored template for my blog, as you all aware it consumes less power on your monitors/screens, my tiny contribution to our mother earth to make it more greener