none
SQL Server error 11009 RRS feed

  • 一般討論

  • 我在DB Cluster 活動節點安裝Service Pack3, 遇到以下錯誤SQL Error 110099.  各位大大可否幫幫忙該如何修復下面錯誤訊息.以便安裝Service Pack3 成功. thanks

    Process Name           Feature                      TYPE                      USER NAME
    MSSQLSERVER          Database Service       服務 (Service)            5468
    resrcmin.exe            Database Service       應用程式 (Application)    Cluster-DB\ib_cluster 4176 
    srmagent.exe           Database Service       應用程式 (application)    AUTHORITY\SYSTEM 3140
    SQL SERVERAGENT   Database Service       服務 (Service)            4524
    SQLBrowser             Database Service       服務 (Service)            3068
    MSSQLServerOLAPService Analysis Service       服務 (Service)            5548


    Product                             :Dtabase Services (MSSQLSERVER)     
    Product Version (Previous) :3233
    Product Version (Final)       :
    atus                                  :失敗
    Log File                             :1009
    Error Description                :有Passive 節點己成功修補

     

    Product                             :Analysis Services (MSSQLSERVER)     
    Product Version (Previous) :3233
    Product Version (Final)       :
    Satus                               :失敗       
    Log File                            :1009
    Error Description               :有Passive 節點己成功修補

    SUMMARY
           沒有Passive 節點己成功修補
           Exit Code Returned:11009


    grace
    • 已變更類型 Alex ChuoModerator 2010年1月11日 上午 07:30 提問者未有後續回應
    2009年12月14日 下午 04:13

所有回覆

  • 請問您是否先看過這個論壇上方的公告:「SQL Server Management 討論區發言規範」,裡面提到:
    請在提出問題時,附上詳細的作業環境,問題陳述,錯誤訊息(包含來自事件檢視器,SQL Server logs),SQL Server 軟體版本(SQL Server 2000, SQL Server 2005, Express/Workgroup/Standard/Enterprise/Developer),以及其他可供判斷的足夠資訊,以利板上高手與專家們的判斷,愈充分的資料愈容易得到正確的判斷 .

    看來大家得先通過您的「猜看看」考驗才會知道這位大少爺/大小姐您所用的 SQL Server 是那個版本的。
    那就讓我先起個頭吧,我猜是 SQL Server 2005,如果猜對的話,您就得自己去看  C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix 裡面相關的安裝更新記錄檔,它會告訴您發生什麼事情了。
    ☞ 這裡是「免費的討論區」付費支援服務請造訪 此處享受尊榮服務
    如果回覆對您有幫助,請記得按下標示為解答」
    在本討論區使用正體中文(即繁體中文),是對參與的朋友的一種尊重,因此請用本討論區的語言:正體中文。
    2009年12月15日 下午 01:06
    版主
  • Dear Alex,
                   抱歉.忘了描述系統詳細資訊.下次我會注意小心.  我要尋問的問題是SQL Server 2005 Enterprise 且是DB Cluster 系統.之前有安裝過Service Pack2.   這次安裝Service Pack3. Database 和Analysis Service 確安裝不成功.   讀過安裝SP3文件之後我發現安裝的過程不對.  應該先從Active node 安裝.但我先從passive node 安裝.導致Database 和Analysis Service 確安裝不成功.  之後我試著從Active node 安裝Database 和Analysis Service SP3 確是失敗.  因我第一次接觸DB Cluster. 比較陌生.可否指導我該如何看此HotFix 的錯誤訊息及找出問題點該如何將 Database 和Analysis Service SP3 安裝成功. 謝謝


    安裝Database 和Analysis Service 在Active node   部分HOTFIX Log

    12/07/2009 02:43:04.214
    12/07/2009 02:43:58.153 Product Enumeration Results:
    12/07/2009 02:43:58.184   INF File Name: e:\c65f1f6d879f372816def0b750e72e\HotFixSQLServer2005_BC_x64.inf
    12/07/2009 02:43:58.200   baselinebuild = 1399
    12/07/2009 02:43:58.216   build = 2312
    12/07/2009 02:43:58.231   description = 回溯相容性
    12/07/2009 02:43:58.247   details = 回溯相容性元件的 Service Pack,包括 Data Transformation Services 執行階段和 SQL-DMO。
    12/07/2009 02:43:58.247   installerlogpath = <PROGRAMFILESDIR>\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix
    12/07/2009 02:43:58.262   kbarticle = KB955706
    12/07/2009 02:43:58.278   kbarticlehyperlink = http://support.microsoft.com/?kbid=955706
    12/07/2009 02:43:58.294   lcid = 1028
    12/07/2009 02:43:58.309   legalproductname = Microsoft SQL Server 2005 回溯相容性 (64 位元)
    12/07/2009 02:43:58.325   machinetype = x64
    12/07/2009 02:43:58.325   package = HotFixSQLServer2005_BC_x64
    12/07/2009 02:43:58.341   packagetype = Hotfix
    12/07/2009 02:43:58.356   productname = Redist9
    12/07/2009 02:43:58.372   recommendinstall = 1
    12/07/2009 02:43:58.387   relatedlinks = <LCIDSUPPORTDIR>\FinalSQL2005Information.rtf
    12/07/2009 02:43:58.403   servicepackname = Microsoft SQL Server 2005 Service Pack 3 安裝程式
    12/07/2009 02:43:58.419   splevel = 3
    12/07/2009 02:43:58.434   supportdir = e:\c65f1f6d879f372816def0b750e72e
    12/07/2009 02:43:58.450   upgradecode = {7B6BF434-3C72-4DB3-8049-FEF31AEAFF9A}
    12/07/2009 02:43:58.466   version = 9
    12/07/2009 02:43:58.481
    12/07/2009 02:43:58.481   File Group Details: MSI
    12/07/2009 02:43:58.497     cachedmsipath = <PROGRAMFILESDIR>\Microsoft SQL Server\90\Setup Bootstrap\Cache
    12/07/2009 02:43:58.512     sourcepath = <SUPPORTDIR>\<PACKAGE>\Files
    12/07/2009 02:43:58.528     File Details: SQLServer2005_BC_x64.msi
    12/07/2009 02:43:58.544
    12/07/2009 02:43:58.544 Product Enumeration Results:
    12/07/2009 02:43:58.559   INF File Name: e:\c65f1f6d879f372816def0b750e72e\HotFixSqlWriter.inf
    12/07/2009 02:43:58.575   baselinebuild = 1399
    12/07/2009 02:43:58.591   build = 4035
    12/07/2009 02:43:58.606   description = Microsoft SQL Server VSS Writer
    12/07/2009 02:43:58.606   details = Microsoft SQL Server VSS Writer Service Pack。
    12/07/2009 02:43:58.622   installerlogpath = <PROGRAMFILESDIR>\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix
    12/07/2009 02:43:58.637   kbarticle = KB955706
    12/07/2009 02:43:58.653   kbarticlehyperlink = http://support.microsoft.com/?kbid=955706
    12/07/2009 02:43:58.669   lcid = 1028
    12/07/2009 02:43:58.684   legalproductname = Microsoft SQL Server VSS Writer
    12/07/2009 02:43:58.684   machinetype = x86
    12/07/2009 02:43:58.700   package = HotFixSqlWriter
    12/07/2009 02:43:58.716   packagetype = Hotfix
    12/07/2009 02:43:58.731   productcode = {789C8C69-0A24-469C-B9F9-73359447CA34}
    12/07/2009 02:43:58.747   productname = Redist9
    12/07/2009 02:43:58.747   recommendinstall = 1
    12/07/2009 02:43:58.762   relatedlinks = <LCIDSUPPORTDIR>\FinalSQL2005Information.rtf
    12/07/2009 02:43:58.778   servicepackname = Microsoft SQL Server 2005 Service Pack 3 安裝程式
    12/07/2009 02:43:58.794   splevel = 3
    12/07/2009 02:43:58.809   sqladminprovisioningtool = <PROGRAMFILESDIR_WOW>\Microsoft SQL Server\90\Shared\sqlprov.exe
    12/07/2009 02:43:58.825   supportdir = e:\c65f1f6d879f372816def0b750e72e
    12/07/2009 02:43:58.825   upgradecode = {65D8E1DF-6201-4B53-A0F9-E654F8E80F97}
    12/07/2009 02:43:58.841   version = 9
    12/07/2009 02:43:58.856
    12/07/2009 02:43:58.872   File Group Details: MSI
    12/07/2009 02:43:58.887     cachedmsipath = <PROGRAMFILESDIR>\Microsoft SQL Server\90\Setup Bootstrap\Cache
    12/07/2009 02:43:58.887     sourcepath = <SUPPORTDIR>\<PACKAGE>\Files
    12/07/2009 02:43:58.903     File Details: SqlWriter.msi
    12/07/2009 02:43:58.919
    12/07/2009 02:43:58.934   Instance Details: Microsoft SQL Server VSS Writer
    12/07/2009 02:43:58.950     fullversion = 9.00.4035.00
    12/07/2009 02:43:58.950     lcid = 1028
    12/07/2009 02:43:58.966     productcode = {789C8C69-0A24-469C-B9F9-73359447CA34}
    12/07/2009 02:43:58.981     qfelevel = 4035
    12/07/2009 02:43:58.997     sp = -1
    12/07/2009 02:43:59.012
    12/07/2009 02:43:59.028 Product Enumeration Results:
    12/07/2009 02:43:59.028   INF File Name: e:\c65f1f6d879f372816def0b750e72e\HotFixSqlWriter_x64.inf
    12/07/2009 02:43:59.044   baselinebuild = 1399
    12/07/2009 02:43:59.059   build = 4035
    12/07/2009 02:43:59.075   description = Microsoft SQL Server VSS Writer
    12/07/2009 02:43:59.075   details = Microsoft SQL Server VSS Writer Service Pack。
    12/07/2009 02:43:59.091   installerlogpath = <PROGRAMFILESDIR>\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix
    12/07/2009 02:43:59.106   kbarticle = KB955706
    12/07/2009 02:43:59.122   kbarticlehyperlink = http://support.microsoft.com/?kbid=955706
    12/07/2009 02:43:59.137   lcid = 1028
    12/07/2009 02:43:59.153   legalproductname = Microsoft SQL Server VSS Writer (64 位元)
    12/07/2009 02:43:59.153   machinetype = x64
    12/07/2009 02:43:59.169   package = HotFixSqlWriter_x64
    12/07/2009 02:43:59.184   packagetype = Hotfix
    12/07/2009 02:43:59.200   productname = Redist9
    12/07/2009 02:43:59.216   recommendinstall = 1
    12/07/2009 02:43:59.216   relatedlinks = <LCIDSUPPORTDIR>\FinalSQL2005Information.rtf
    12/07/2009 02:43:59.231   servicepackname = Microsoft SQL Server 2005 Service Pack 3 安裝程式
    12/07/2009 02:43:59.247   splevel = 3
    12/07/2009 02:43:59.262   supportdir = e:\c65f1f6d879f372816def0b750e72e
    12/07/2009 02:43:59.278   upgradecode = {E9031696-DD39-4C25-BAEB-425FF28279EA}
    12/07/2009 02:43:59.278   version = 9
    12/07/2009 02:43:59.294
    12/07/2009 02:43:59.309   File Group Details: MSI
    12/07/2009 02:43:59.325     cachedmsipath = <PROGRAMFILESDIR>\Microsoft SQL Server\90\Setup Bootstrap\Cache
    12/07/2009 02:43:59.341     sourcepath = <SUPPORTDIR>\<PACKAGE>\Files
    12/07/2009 02:43:59.356     File Details: SqlWriter_x64.msi
    12/07/2009 02:43:59.356
    12/07/2009 02:44:44.592 Registry: Opened registry key "System\CurrentControlSet\Control\Session Manager"
    12/07/2009 02:44:44.607 Registry: Cannot read registry key value "PendingFileRenameOperations", error 0
    12/07/2009 02:44:47.607 Authenticating user using Windows Authentication
    12/07/2009 02:44:48.404 Authenticating user using Windows Authentication
    12/07/2009 02:44:48.420 Validating database connections using Windows Authentication
    12/07/2009 02:44:48.795 Pre-script database connection check was successful - proceeding with script execution
    12/07/2009 02:44:49.217 Received sysadmin status for instance: MSSQLSERVER
    12/07/2009 02:44:49.233 Validating database connections using Windows Authentication
    12/07/2009 02:44:49.623 Pre-script database connection check was successful - proceeding with script execution
    12/07/2009 02:44:49.639 User authentication was successful
    12/07/2009 02:45:05.202 Authenticating user using Windows Authentication
    12/07/2009 02:45:05.592 Authenticating user using Windows Authentication
    12/07/2009 02:45:05.608 Validating database connections using Windows Authentication
    12/07/2009 02:45:05.999 Pre-script database connection check was successful - proceeding with script execution
    12/07/2009 02:45:06.452 Received sysadmin status for instance: MSSQLSERVER
    12/07/2009 02:45:06.467 Validating database connections using Windows Authentication
    12/07/2009 02:45:07.030 Pre-script database connection check was successful - proceeding with script execution
    12/07/2009 02:45:07.045 User authentication was successful
    12/07/2009 02:47:02.861 Registry: Read registry key value "EnableErrorReporting", DWORD value = 1
    12/07/2009 02:47:02.877 Registry: Read registry key value "EnableErrorReporting", DWORD value = 0
    12/07/2009 02:47:02.892 Registry: Read registry key value "EnableErrorReporting", DWORD value = 0
    12/07/2009 02:47:02.908 Registry: Read registry key value "CustomerFeedBack", DWORD value = 1
    12/07/2009 02:47:02.923 Registry: Read registry key value "CustomerFeedBack", DWORD value = 0
    12/07/2009 02:47:02.939 Registry: Read registry key value "CustomerFeedBack", DWORD value = 0
    12/07/2009 02:47:14.002 Locked file: Checking for locked files
    12/07/2009 02:47:17.486 Locked file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\binn\resources\1033\sqlevn70.rll (MSSQLSERVER [sqlservr.exe] - 5468)
    12/07/2009 02:47:17.564 Locked file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\binn\resources\1028\sqlevn70.rll (MSSQLSERVER [sqlservr.exe] - 5468)
    12/07/2009 02:47:17.611 Locked file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\binn\resources\1028\xpstar90.rll (MSSQLSERVER [sqlservr.exe] - 5468)
    12/07/2009 02:47:17.877 Locked file: C:\WINDOWS\system32\sqsrvres.dll (resrcmon.exe - 4176)
    12/07/2009 02:47:17.955 Locked file: C:\WINDOWS\system32\sqlctr90.dll (srmagent.exe - 3140)
    12/07/2009 02:47:18.080 Locked file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\binn\sqlsvc90.dll (SQLSERVERAGENT [SQLAGENT90.EXE] - 4524)
    12/07/2009 02:47:18.111 Locked file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\binn\xpstar90.dll (MSSQLSERVER [sqlservr.exe] - 5468)
    12/07/2009 02:47:18.143 Locked file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\binn\sqlos.dll (MSSQLSERVER [sqlservr.exe] - 5468)
    12/07/2009 02:47:18.174 Locked file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\binn\xpsqlbot.dll (MSSQLSERVER [sqlservr.exe] - 5468)
    12/07/2009 02:47:18.189 Locked file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\binn\xplog70.dll (MSSQLSERVER [sqlservr.exe] - 5468)
    12/07/2009 02:47:18.252 Locked file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\binn\sqlservr.exe (MSSQLSERVER [sqlservr.exe] - 5468)
    12/07/2009 02:47:18.330 Locked file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\binn\batchparser90.dll (MSSQLSERVER [sqlservr.exe] - 5468)
    12/07/2009 02:47:18.346 Locked file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\binn\batchparser90.dll (SQLSERVERAGENT [SQLAGENT90.EXE] - 4524)
    12/07/2009 02:47:18.393 Locked file: C:\WINDOWS\system32\sqlagentctr90.dll (srmagent.exe - 3140)
    12/07/2009 02:47:18.502 Locked file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\binn\resources\1028\sqlagent90.rll (SQLSERVERAGENT [SQLAGENT90.EXE] - 4524)
    12/07/2009 02:47:18.580 Locked file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\binn\sqldtsss90.dll (SQLSERVERAGENT [SQLAGENT90.EXE] - 4524)
    12/07/2009 02:47:18.611 Locked file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\binn\sqlrepss90.dll (SQLSERVERAGENT [SQLAGENT90.EXE] - 4524)
    12/07/2009 02:47:18.627 Locked file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\binn\sqlolapss90.dll (SQLSERVERAGENT [SQLAGENT90.EXE] - 4524)
    12/07/2009 02:47:18.658 Locked file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\binn\sqlagent90.exe (SQLSERVERAGENT [SQLAGENT90.EXE] - 4524)
    12/07/2009 02:47:18.830 Locked file: C:\Program Files\microsoft sql server\90\shared\resources\1028\msmdsrv.rll (SQLBrowser [sqlbrowser.exe] - 3068)
    12/07/2009 02:47:18.908 Locked file: C:\Program Files\microsoft sql server\90\shared\msmdredir.dll (SQLBrowser [sqlbrowser.exe] - 3068)
    12/07/2009 02:47:19.221 Locked file: C:\Program Files\microsoft sql server\90\shared\sqlbrowser.exe (SQLBrowser [sqlbrowser.exe] - 3068)
    12/07/2009 02:47:24.862 Locked file: C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin\msmdctr90.dll (srmagent.exe - 3140)
    12/07/2009 02:47:25.362 Locked file: C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin\resources\1028\msmdsrv.rll (MSSQLServerOLAPService [msmdsrv.exe] - 5548)
    12/07/2009 02:47:25.565 Locked file: C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin\sqlboot.dll (MSSQLServerOLAPService [msmdsrv.exe] - 5548)
    12/07/2009 02:47:25.596 Locked file: C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin\msmgdsrv.dll (MSSQLServerOLAPService [msmdsrv.exe] - 5548)
    12/07/2009 02:47:25.690 Locked file: C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin\msmdsrv.exe (MSSQLServerOLAPService [msmdsrv.exe] - 5548)
    12/07/2009 02:47:25.877 Locked file: C:\Program Files\microsoft sql server\90\shared\resources\1028\msmdsrv.rll (SQLBrowser [sqlbrowser.exe] - 3068)
    12/07/2009 02:47:25.893 Locked file: C:\Program Files\microsoft sql server\90\shared\msmdredir.dll (SQLBrowser [sqlbrowser.exe] - 3068)
    12/07/2009 02:47:25.924 Locked file: C:\Program Files\microsoft sql server\90\shared\sqlbrowser.exe (SQLBrowser [sqlbrowser.exe] - 3068)
    12/07/2009 02:47:39.018 Attempting to pause the 32 bit ngen queue
    12/07/2009 02:47:39.878 Installing product: SQL9
    12/07/2009 02:47:39.893 Installing instance: MSSQLSERVER
    12/07/2009 02:47:39.909 Enumerating passive cluster nodes
    12/07/2009 02:47:39.940 Patching available passive node: TWASPRTW010015
    12/07/2009 02:47:39.940 Patching passive node: TWASPRTW010015
    12/07/2009 02:47:39.956 Waiting for first completed passive node
    12/07/2009 02:47:40.159 Task Scheduler: Created remote folder for product instance target \\TWASPRTW010015
    12/07/2009 02:48:41.723 Task Scheduler: Transferred payload to remote product instance target \\TWASPRTW010015
    12/07/2009 02:48:41.738 Task Scheduler: Transferred payload to remote product instance target \\TWASPRTW010015
    12/07/2009 02:48:41.801 Task Scheduler: Created new scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 02:48:41.817 Task Scheduler: SaveTaskToDisk(): Got task interface
    12/07/2009 02:48:41.848 Task Scheduler: SaveTaskToDisk(): Error -2147216624
    12/07/2009 02:48:42.879 Task Scheduler: Saved new scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 02:48:42.895 Task Scheduler: Created scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 02:48:42.926 Task Scheduler: Started scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 02:48:42.942 Task Scheduler: Started scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 02:48:45.973 Task Scheduler: Scheduled task for product instance target has completed
    12/07/2009 02:48:45.989 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 02:48:51.020 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 02:48:56.051 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 02:49:01.083 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 02:49:06.145 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 02:49:11.175 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 02:49:16.205 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 02:49:21.251 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 02:49:26.282 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 02:49:31.313 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 02:49:36.329 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 02:49:41.360 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\\TWASPRTW010015
    \\TWASPRTW010015
    12/07/2009 02:52:07.301 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 02:52:12.332 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 02:52:17.364 Task Scheduler: Waiting for exit code from scheduled task for product instance target 12/07/2009 02:52:47.583 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 02:52:52.615 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 02:52:57.646 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 02:53:02.740 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    ce target \\TWASPRTW010015
    12/07/2009 02:53:53.085 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 02:53:58.132 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 02:54:03.163 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 02:54:08.195 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 02:54:13.226 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 02:54:18.258 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 02:54:23.289 Task Scheduler: Waiting for exit code from scheduled task for product instance target 12/07/2009 02:55:03.556 Task Scheduler: Waiting for exit code from scheduled task for product instance target 12/07/2009 02:58:04.841 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 02:58:09.904 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 02:58:14.920 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 02:58:19.967 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 02:58:24.983 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 02:58:30.014 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 02:58:35.061 Task Scheduler: Waiting for exit code from scheduled task for product instance target 12/07/2009 02:59:15.296 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 02:59:20.328 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 02:59:25.390 Task Scheduler: Waiting for exit code from scheduled task for product instance target t \\TWASPRTW010015
    12/07/2009 03:03:42.209 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:03:47.256 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:03:52.304 Task Scheduler: Error, timed out waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:03:52.319 Task Scheduler: Error, result code for scheduled task for product instance target was not received
    12/07/2009 03:03:52.366 Task Scheduler: Removed scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:03:53.085 Task Scheduler: Removed remote folder for product instance target \\TWASPRTW010015
    12/07/2009 03:03:53.100 Error, remote process failed for product instance target
    12/07/2009 03:03:53.116 Exit code for passive node: TWASPRTW010015 = 1603
    12/07/2009 03:03:55.007 The following exception occurred: 沒有 Passive 節點已成功修補  Date: 12/07/2009 03:03:54.991  File: \depot\sqlvault\stable\setupmainl1\setup\sqlse\sqlsedll\instance.cpp  Line: 3510
    12/07/2009 03:03:59.507 Watson: Param1 = Unknown
    12/07/2009 03:03:59.538 Watson: Param2 = 0x2b01
    12/07/2009 03:03:59.554 Watson: Param3 = Unknown
    12/07/2009 03:03:59.569 Watson: Param4 = 0x0
    12/07/2009 03:03:59.585 Watson: Param5 = instance.cpp@3510
    12/07/2009 03:03:59.616 Watson: Param6 = Unknown
    12/07/2009 03:03:59.632 Watson: Param7 = SQL9
    12/07/2009 03:03:59.647 Watson: Param8 = Hotfix@
    12/07/2009 03:03:59.663 Watson: Param9 = x86
    12/07/2009 03:03:59.679 Watson: Param10 = 4035
    12/07/2009 03:03:59.694 Installed product: SQL9
    12/07/2009 03:03:59.710 Installing product: OLAP9
    12/07/2009 03:03:59.726 Installing instance: MSSQLSERVER
    12/07/2009 03:03:59.757 Enumerating passive cluster nodes
    12/07/2009 03:03:59.772 Patching available passive node: TWASPRTW010015
    12/07/2009 03:03:59.788 Patching passive node: TWASPRTW010015
    12/07/2009 03:03:59.804 Waiting for first completed passive node
    12/07/2009 03:03:59.944 Task Scheduler: Created remote folder for product instance target \\TWASPRTW010015
    12/07/2009 03:05:05.212 Task Scheduler: Transferred payload to remote product instance target \\TWASPRTW010015
    12/07/2009 03:05:05.212 Task Scheduler: Transferred payload to remote product instance target \\TWASPRTW010015
    12/07/2009 03:05:05.258 Task Scheduler: Created new scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:05:05.274 Task Scheduler: SaveTaskToDisk(): Got task interface
    12/07/2009 03:05:05.305 Task Scheduler: SaveTaskToDisk(): Error -2147216624
    12/07/2009 03:05:06.337 Task Scheduler: Saved new scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:05:06.352 Task Scheduler: Created scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:05:06.415 Task Scheduler: Started scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:05:06.430 Task Scheduler: Started scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:05:09.462 Task Scheduler: Scheduled task for product instance target has completed
    12/07/2009 03:05:09.477 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:05:14.509 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:05:19.571 Task Scheduler: Waiting for exit code from scheduled task for product instance target \12/07/2009 03:05:59.822 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:06:04.854 Task Scheduler: Waiting for exit code from scheduled task for product instance target \12/07/2009 03:06:45.105 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:06:50.121 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:06:55.152 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:07:00.183 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:07:05.230 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:07:10.246 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:07:15.293 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:07:20.340 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:07:25.387 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:07:30.450 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:07:35.497 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:07:40.528 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:07:45.606 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:07:50.638 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:07:55.685 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:08:00.763 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:08:05.794 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:08:10.841 Task Scheduler: Waiting for exit code from scheduled task for product instance target \12/07/2009 03:09:16.374 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:09:21.406 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:09:26.453 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:09:31.484 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:09:36.500 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:09:41.594 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:09:46.625 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:09:51.656 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:09:56.735 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:10:01.766 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:10:06.797 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:10:11.829 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:10:16.860 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:10:21.892 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:10:26.954 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:10:32.001 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:14:43.789 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:14:48.820 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:14:53.852 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:14:58.883 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:15:03.914 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:15:08.946 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:15:13.962 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:15:18.993 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:15:24.024 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:15:29.056 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:15:34.087 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:17:24.965 Task Scheduler: Waiting for exit code from scheduled task for product instance target 12/07/2009 03:18:20.419 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:18:25.451 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:18:30.482 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:18:35.560 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:18:40.592 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:19:46.015 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:19:51.047 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:19:56.094 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:20:01.125 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:20:06.157 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:20:11.204 Task Scheduler: Waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:20:16.376 Task Scheduler: Error, timed out waiting for exit code from scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:20:16.391 Task Scheduler: Error, result code for scheduled task for product instance target was not received
    12/07/2009 03:20:16.407 Task Scheduler: Removed scheduled task for product instance target \\TWASPRTW010015
    12/07/2009 03:20:17.719 Task Scheduler: Removed remote folder for product instance target \\TWASPRTW010015
    12/07/2009 03:20:17.813 Error, remote process failed for product instance target
    12/07/2009 03:20:17.938 Exit code for passive node: TWASPRTW010015 = 1603
    12/07/2009 03:20:19.844 The following exception occurred: 沒有 Passive 節點已成功修補  Date: 12/07/2009 03:20:19.844  File: \depot\sqlvault\stable\setupmainl1\setup\sqlse\sqlsedll\instance.cpp  Line: 3510
    12/07/2009 03:20:24.688 Watson: Param1 = Unknown
    12/07/2009 03:20:24.720 Watson: Param2 = 0x2b01
    12/07/2009 03:20:24.720 Watson: Param3 = Unknown
    12/07/2009 03:20:24.735 Watson: Param4 = 0x0
    12/07/2009 03:20:24.751 Watson: Param5 = instance.cpp@3510
    12/07/2009 03:20:24.766 Watson: Param6 = Unknown
    12/07/2009 03:20:24.782 Watson: Param7 = OLAP9
    12/07/2009 03:20:24.798 Watson: Param8 = Hotfix@
    12/07/2009 03:20:24.798 Watson: Param9 = x86
    12/07/2009 03:20:24.813 Watson: Param10 = 4035
    12/07/2009 03:20:24.829 Installed product: OLAP9
    12/07/2009 03:20:24.860 Hotfix package completed
    12/07/2009 03:20:24.876 Attempting to continue the 32 bit ngen queue

                   
    grace
    2009年12月17日 上午 07:25
    1. 關閉防毒與防間諜這類的軟體
    2. 嘗試轉移(Failover) passive node,接著在 passive node 安裝 Service Pack

    ☞ 這裡是「免費的討論區」付費支援服務請造訪 此處享受尊榮服務
    如果回覆對您有幫助,請記得按下標示為解答」
    在本討論區使用正體中文(即繁體中文),是對參與的朋友的一種尊重,因此請用本討論區的語言:正體中文。
    2009年12月17日 上午 09:44
    版主
  • Dear Alex,
                    謝謝你的資訊.不好意思關於第二點我不是很清楚. 你的意思是指將原本passive node(twasprtw010015) 轉成 active node. 原本的acitve node  (twasprtw010016)變成到passive node (twasprtw010016).  然後在twasprtw010015 (新轉換成active node) 安裝sp3嗎?     還是直接到passive node (twasprtw010015) 安裝SP3. 若是此種情形我有個疑問.  因我第一次安裝Service Pack3 時己在twasprtw010015 和twasprtw010016 安裝過, 只有Database 和analysis service 無法勾選安裝. 其它service 都安裝成功.   當時安裝二台都處在passive node. 不好意思因我對DB Cluster 不是很熟悉. 可否請你在詳細解釋.  謝謝
    grace
    2009年12月19日 下午 03:05
  • Restart task scheduler service on all nodes then try again.
    2009年12月19日 下午 04:47
  • Dear Rmiao,
                      thanks.  I will try it.
    grace
    2009年12月22日 上午 09:50
  • 最近安裝win2008+sql2005 enterprice 64bit 更新SP3時 我也遇到一樣的問題 .

    不知有解決方法嗎 ??

    2010年7月22日 上午 03:13
  • Did you follow above suggestions?
    2010年7月22日 上午 03:21
  • 上面所建議的方法都試過 , 安裝依然出現失敗.

     

    2010年7月22日 上午 03:34
  • Is it on cluster? Have details?
    2010年7月22日 上午 03:40