none
Error while upgrading the SQL Service Pack RRS feed

  • Question

  • Hi,

    I tried to upgrade my SQL server with the latest service pack SP4.

    My version of SQL server was

    Microsoft

    SQL Server 2005 - 9.00.3077.00 (Intel X86) Dec 17 2008 15:19:45 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

    But during the upgrade process, i got a Failure against Database Services. I am not sure why this happened as it ran without any errors on one of my other server the same time. I tried to apply the SP again, and it failed again with same error message.

    Below is the error i found in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB2463332_sqlrun_sql.msp.log file. Any comments are appericiated. Also please advice if that can have any adverse effect on my SQL server. Thanks.

    MSI (s) (CC:50) [11:47:01:375]: Product: Microsoft SQL Server 2005 - Update 'Service Pack 4 for SQL Server Database Services 2005 ENU (KB2463332)' could not be installed. Error code 1603. Additional information is available in the log file C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB2463332_sqlrun_sql.msp.log.

    MSI (s) (CC:50) [11:47:01:390]: Note: 1: 1729
    MSI (s) (CC:50) [11:47:01:390]: Transforming table Error.

    MSI (s) (CC:50) [11:47:01:390]: Note: 1: 2262 2: Error 3: -2147287038
    MSI (s) (CC:50) [11:47:01:406]: Transforming table Error.

    MSI (s) (CC:50) [11:47:01:406]: Transforming table Error.

    MSI (s) (CC:50) [11:47:01:406]: Note: 1: 2262 2: Error 3: -2147287038
    MSI (s) (CC:50) [11:47:01:406]: Transforming table Error.

    MSI (s) (CC:50) [11:47:01:406]: Note: 1: 2262 2: Error 3: -2147287038
    MSI (s) (CC:50) [11:47:01:406]: Transforming table Error.

    MSI (s) (CC:50) [11:47:01:406]: Note: 1: 2262 2: Error 3: -2147287038
    MSI (s) (CC:50) [11:47:01:406]: Transforming table Error.

    MSI (s) (CC:50) [11:47:01:406]: Note: 1: 2262 2: Error 3: -2147287038
    MSI (s) (CC:50) [11:47:01:421]: Transforming table Error.

    MSI (s) (CC:50) [11:47:01:421]: Transforming table Error.

    MSI (s) (CC:50) [11:47:01:421]: Note: 1: 2262 2: Error 3: -2147287038
    MSI (s) (CC:50) [11:47:01:421]: Transforming table Error.

    MSI (s) (CC:50) [11:47:01:421]: Note: 1: 2262 2: Error 3: -2147287038
    MSI (s) (CC:50) [11:47:01:421]: Transforming table Error.

    MSI (s) (CC:50) [11:47:01:421]: Note: 1: 2262 2: Error 3: -2147287038
    MSI (s) (CC:50) [11:47:01:421]: Product: Microsoft SQL Server 2005 -- Configuration failed.

    MSI (s) (CC:50) [11:47:01:421]: Attempting to delete file C:\WINDOWS\Installer\52eb8.msp
    MSI (s) (CC:50) [11:47:01:453]: Cleaning up uninstalled install packages, if any exist
    MSI (s) (CC:50) [11:47:01:453]: Post-install cleanup: removing installer file 'C:\WINDOWS\Installer\52eb8.msp'
    MSI (s) (CC:50) [11:47:01:453]: MainEngineThread is returning 1603
    MSI (s) (CC:10) [11:47:01:453]: Destroying RemoteAPI object.
    MSI (s) (CC:C0) [11:47:01:453]: Custom Action Manager thread ending.
    === Logging stopped: 27-12-2010  11:47:01 ===
    MSI (c) (14:14) [11:47:01:484]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied.  Counter after decrement: -1
    MSI (c) (14:14) [11:47:01:484]: MainEngineThread is returning 1603
    === Verbose logging stopped: 27-12-2010  11:47:01 ===

     

    Monday, December 27, 2010 9:06 AM

All replies

  • Can you please upload C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB2463332_sqlrun_sql.msp.log file to some share location from where we can access it.

    Refer this http://www.sqlfundas.com/post/2009/11/04/Please-help-me-in-troubleshooting-SQL-Setup-2005-issues!!!.aspx
    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    Monday, December 27, 2010 9:18 AM
    Moderator
  • Can you please suggest me such a location? I am unaware of where i can place it for you.
    Monday, December 27, 2010 9:49 AM
  • http://filefactory.com/
    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    Monday, December 27, 2010 10:02 AM
    Moderator
  • hi Balmukund. I have placed it here

    http://www.4shared.com/dir/ISdARgiQ/sharing.html

    Please have a look and advice. Thanks in advance

    Monday, December 27, 2010 10:12 AM
  • Thanks for the file. Here is the error

    <ERROR>

    <Func Name='ComponentUpgrade'>
    There was a failure during installation search up in this log file for this message:
    Service 'MSSQLSERVER' could not be started. Verify that you have sufficient privileges to start system services. The error code is (1814) The specified resource name cannot be found in the image file.

    <EndFunc Name='ComponentUpgrade' Return='1814' GetLastError='0'>


    </ERROR>

    Could you please check ERROLOG and see if there is any failure during service startup when patch was applied? Ping me at blakhani (at) koolmail (dot) in for quick help.


    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    Monday, December 27, 2010 10:28 AM
    Moderator
  • Below are few errors in Event viewer

    Event Type: Error
    Event Source: MsiInstaller
    Event Category: None
    Event ID: 1023
    Date:  27-12-2010
    Time:  11:47:01
    User:  MOG\fak011_priv
    Computer: SDOHHQDEV02
    Description:
    Product: Microsoft SQL Server 2005 - Update 'Service Pack 4 for SQL Server Database Services 2005 ENU (KB2463332)' could not be installed. Error code 1603. Additional information is available in the log file C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB2463332_sqlrun_sql.msp.log.

    ------------------

    Event Type: Information
    Event Source: MSSQLSERVER
    Event Category: (2)
    Event ID: 1814
    Date:  27-12-2010
    Time:  11:46:48
    User:  N/A
    Computer: SDOHHQDEV02
    Description:
    Could not create tempdb. You may not have enough disk space available. Free additional disk space by deleting other files on the tempdb drive and then restart SQL Server. Check for additional errors in the event log that may indicate why the tempdb files could not be initialized.

    ---------------------------

    Event Type: Error
    Event Source: MSSQLSERVER
    Event Category: (2)
    Event ID: 17204
    Date:  27-12-2010
    Time:  11:46:48
    User:  N/A
    Computer: SDOHHQDEV02
    Description:
    FCB::Open failed: Could not open file I:\SQL Databases\tempdb.mdf for file number 1.  OS error: 3(error not found).

    --------------------------------

    Event Type: Error
    Event Source: MSSQLSERVER
    Event Category: (2)
    Event ID: 17207
    Date:  27-12-2010
    Time:  11:46:48
    User:  N/A
    Computer: SDOHHQDEV02
    Description:
    FCB::Open: Operating system error 3(error not found) occurred while creating or opening file 'I:\SQL Databases\tempdb.mdf'. Diagnose and correct the operating system error, and retry the operation.

    -----------------------------

    Event Type: Error
    Event Source: MSSQLSERVER
    Event Category: (2)
    Event ID: 5123
    Date:  27-12-2010
    Time:  11:46:48
    User:  N/A
    Computer: SDOHHQDEV02
    Description:
    CREATE FILE encountered operating system error 3(error not found) while attempting to open or create the physical file 'I:\SQL Databases\tempdb.mdf'.

    -----------------------------

    Event Type: Error
    Event Source: .NET Runtime Optimization Service
    Event Category: None
    Event ID: 1101
    Date:  27-12-2010
    Time:  11:43:51
    User:  N/A
    Computer: SDOHHQDEV02
    Description:
    .NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002


    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.


    Monday, December 27, 2010 10:56 AM
  • there you go..

    CREATE FILE encountered operating system error 3(error not found) while attempting to open or create the physical file 'I:\SQL Databases\tempdb.mdf'.

    Operating system error 3 = The system cannot find the path specified.


    Is this a cluster? Is the path Valid?


    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    Monday, December 27, 2010 11:01 AM
    Moderator
  • Thanks a lot for your continuous support.

    Well the correct path is I:\SQL Database\TempDB Data\tempdb.mdf.

    Please let me know how i can resolve this.

    Monday, December 27, 2010 11:49 AM
  • USE master;
    GO
    ALTER DATABASE tempdb 
    MODIFY FILE (NAME = tempdev, FILENAME = 'I:\SQL Database\TempDB Data\tempdb.mdf');
    GO
    ALTER DATABASE tempdb 
    MODIFY FILE (NAME = templog, FILENAME = '<Put LDF File Name with Path>');
    GO
    
    

    Reference http://msdn.microsoft.com/en-us/library/ms345408(SQL.90).aspx


    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    Monday, December 27, 2010 11:54 AM
    Moderator
  • Hi BM.

    Do i need to put database offline and then back online again. what effect will the queries have on users who are connected to the system. Will they be effected / kicked out?

    Please let me know above as it is a very critical server. Thanks.

    ALTER

     

    DATABASE tempdb MODIFY FILE ( NAME = tempdev, FILENAME = 'I:\SQL Database\TempDB Data\tempdb.mdf' )

    ALTER

     

    DATABASE tempdb MODIFY FILE ( NAME = templog, FILENAME = 'L:\SQL TransLogs\templog.ldf' )

    Monday, December 27, 2010 12:11 PM
  • its for TempDB... no one would be kicked out.
    The setting would come into effect during next restart.
    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    Monday, December 27, 2010 12:23 PM
    Moderator
  • but it already has these values because below query gives me below output. So not sure how running the 2 statements will help?

    SELECT

     

    name, physical_name AS CurrentLocation, state_desc

    FROM

     

    sys.master_files

    WHERE

     

    database_id = DB_ID(N'tempdb');

    -----------

    tempdev I:\SQL Database\TempDB Data\tempdb.mdf ONLINE
    templog L:\SQL TransLogs\templog.ldf ONLINE

    Monday, December 27, 2010 12:32 PM
  • Interesitng.
    Can you try patch again??


    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    Monday, December 27, 2010 12:36 PM
    Moderator
  • Yes i had tried again after a server restart from 1st attempt. But failed the same way :(
    Monday, December 27, 2010 12:40 PM
  • If the sql server services are running fine then there is no problem with the tempdb.

    can you paste the sql server error log file(C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG & ErrorLog1) here. Also if possible provide the latest "SQL9_Hotfix_KB2463332_sqlrun_sql.msp.log " which got created after the server reboot.

     

    Monday, December 27, 2010 6:01 PM
  • For the below error, will it help to place tempdb to the compalaining path, run SQL patching SP4 and then relocate tempdb  back again?

    CREATE FILE encountered operating system error 3(error not found) while attempting to open or create the physical file 'I:\SQL Databases\tempdb.mdf'.

    Operating system error 3 = The system cannot find the path specified.

    Wednesday, December 29, 2010 9:57 AM
  • After my SP4 upgrade failed with the same issues as RubSay & following this conversation, I unchecked the compress box on the tempDB.mdf & .ldf files & reran the SP4 upgrade just for Database Services & it passed - thanks for the tips & getting me pointed in the right direction.


    badshadd
    Monday, January 10, 2011 9:10 AM
  • In my case service pack installation also failed with error code 1603. But in my installation there were incorrect permissions on \MSSQL.1\MSSQL\DATA\mssqlsystemresource1.ldf file.

    Looks like  source of failure could differ from installation to installation, but main approach should be as described at the first posts of the threads - looks around in System Logs - particularly in  Application Log, Source MSIInstaller to find out exact reason of failure.

    Monday, January 10, 2011 1:27 PM
  • Hello badshadd....thanks but i didnot understand what exactly you did to resolve the issue. Can you be a little more clear? And please confirm if you got the exact same message of tempdb file location?

    where is this option for unchecking the compress box on tempdb files?

    Monday, January 17, 2011 8:58 AM
  • Like you, I was receiving many of the error messages you listed above & 2 of the message specifically talked about access issues to the tempDB.mdf & tempDB.ldf files. I saw that both of the files were marked as compressed so when I unchecked the 'Compress contents to save disk space', I was able to successfully upgrade to SP4. Unfortunately, I don't have any logs any more with errors - they were overwritten with the successful installation logs.

    The location was different because I don't have my DB files going to the same location as you.

    To uncompress a file: Right-click the file, select Properties from the drop down menu, on the General tab click the Advanced button, uncheck 'Compress contents... space' in the Compress or Encrypt attributes section & OK & OK - that simple.


    badshadd
    • Proposed as answer by badshadd Wednesday, April 6, 2011 7:08 PM
    Tuesday, January 18, 2011 7:50 AM
  • Thanks Badshadd! that solved my issue. One thing to note: the TempDB files you mention are the default db files located usually at "x:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data"

    xxhell

    Wednesday, April 6, 2011 6:09 PM
  • Great to hear that the information I provided was helpful.  Thanks!
    badshadd
    Wednesday, April 6, 2011 7:08 PM
  • I've had this error on several of the servers I've been patching.  For some reason the service pack tries to create a tempdb database in the directory defined as your default database location.  If (post install) you moved your tempdb to a different drive the installer will (try to) create a new tempdb in the default database location.  I've seen it create compressed tempdb files and try to create a database in a location that is no longer valid on my servers.  I've had to uncompress the tempdb files on some servers, and create a valid path on the drive listed as the default database location on some servers to get this patch to apply.
    Thursday, July 28, 2011 8:56 PM
  • hey badshadd,

    your response helped me too. Thanks a ton

    Kal

    Thursday, July 12, 2012 9:31 AM
  • Just installed SQL 2005 SP4 on an old SQL server. The compress attribute on the temp database files prevented the service pack install from installing. The advice is still useful!
    Saturday, January 11, 2020 8:19 PM