|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
recent SQL 2005 hotfix creates problem
Here are the errors in event log. The installation packeage keeps trying
every 3 hours. How shouyld I fix it. Microsoft SQL Server 2005 Tools Express Edition -- Install started. Product: Microsoft SQL Server 2005 Tools Express Edition -- Error 2711. The installer has encountered an unexpected error. The error code is 2711. The specified Feature name ('SQL_Documentation') not found in Feature table. Product: Microsoft SQL Server 2005 Tools Express Edition - Update 'GDR 1406 for SQL Server Tools and Workstation Components 2005 ENU (KB932557)' could not be installed. Error code 1603. Additional information is available in the log file C:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQLTools9_Hotfix_KB932557_sqlrun_tools.msp.log. Hi
Show quoteHide quote "fj" wrote: What does this log say? > Here are the errors in event log. The installation packeage keeps trying > every 3 hours. How shouyld I fix it. > > > Microsoft SQL Server 2005 Tools Express Edition -- Install started. > > Product: Microsoft SQL Server 2005 Tools Express Edition -- Error 2711. The > installer has encountered an unexpected error. The error code is 2711. The > specified Feature name ('SQL_Documentation') not found in Feature table. > > Product: Microsoft SQL Server 2005 Tools Express Edition - Update 'GDR 1406 > for SQL Server Tools and Workstation Components 2005 ENU (KB932557)' could > not be installed. Error code 1603. Additional information is available in the > log file C:\Program Files (x86)\Microsoft SQL Server\90\Setup > Bootstrap\LOG\Hotfix\SQLTools9_Hotfix_KB932557_sqlrun_tools.msp.log. It may be similar to http://support.microsoft.com/kb/916760/en-us or http://support.microsoft.com/kb/834484/en-us i.e. the permissions or folders expected may not exist or have the wrong permissions or the account doing the install may not have enough permissions. John Here is the part I found that might cause the problem. The specified Feature
name ('SQL_Documentation') not found in Feature table. ..... MSI (s) (80:34) [09:51:03:575]: Dir (target): Key: payload_ul.97F81AF1_0E47_DC99_FF1F_C8B3B9A1E18E , Object: C:\WINDOWS\winsxs\x86_microsoft.vc80.atl_1fc8b3b9a1e18e3b_8.0.50727.42_none_dc990e4797f81af1\ MSI (s) (80:34) [09:51:03:575]: Dir (target): Key: VSRetarget , Object: C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Binn\ MSI (s) (80:34) [09:51:03:575]: Note: 1: 2711 2: SQL_Documentation MSI (s) (80:34) [09:51:03:887]: Product: Microsoft SQL Server 2005 Tools Express Edition -- Error 2711. The installer has encountered an unexpected error. The error code is 2711. The specified Feature name ('SQL_Documentation') not found in Feature table. Error 2711. The installer has encountered an unexpected error. The error code is 2711. The specified Feature name ('SQL_Documentation') not found in Feature table. Action ended 9:51:03: CostFinalize. Return value 3. Action ended 9:51:03: INSTALL. Return value 3. Property(S): ProductCode = {2750B389-A2D2-4953-99CA-27C1F2A8E6FD} Property(S): ProductLanguage = 1033 Property(S): Manufacturer = Microsoft Corporation Property(S): ProductVersion = 9.00.1399.06 Property(S): MEDIAPACKAGEPATH = \Setup\ ..... Hi
Show quoteHide quote "fj" wrote: SQL Express is not one of the products that have been listed as affected by > Here is the part I found that might cause the problem. The specified Feature > name ('SQL_Documentation') not found in Feature table. > > > > .... > MSI (s) (80:34) [09:51:03:575]: Dir (target): Key: > payload_ul.97F81AF1_0E47_DC99_FF1F_C8B3B9A1E18E , Object: > C:\WINDOWS\winsxs\x86_microsoft.vc80.atl_1fc8b3b9a1e18e3b_8.0.50727.42_none_dc990e4797f81af1\ > MSI (s) (80:34) [09:51:03:575]: Dir (target): Key: VSRetarget , Object: > C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Binn\ > MSI (s) (80:34) [09:51:03:575]: Note: 1: 2711 2: SQL_Documentation > MSI (s) (80:34) [09:51:03:887]: Product: Microsoft SQL Server 2005 Tools > Express Edition -- Error 2711. The installer has encountered an unexpected > error. The error code is 2711. The specified Feature name > ('SQL_Documentation') not found in Feature table. > > Error 2711. The installer has encountered an unexpected error. The error > code is 2711. The specified Feature name ('SQL_Documentation') not found in > Feature table. > Action ended 9:51:03: CostFinalize. Return value 3. > Action ended 9:51:03: INSTALL. Return value 3. > Property(S): ProductCode = {2750B389-A2D2-4953-99CA-27C1F2A8E6FD} > Property(S): ProductLanguage = 1033 > Property(S): Manufacturer = Microsoft Corporation > Property(S): ProductVersion = 9.00.1399.06 > Property(S): MEDIAPACKAGEPATH = \Setup\ > .... the hotfix! http://support.microsoft.com/kb/932557/en-us John
Show quote
Hide quote
"John Bell" wrote: Yeh, the VS 2005 is installed on the box but SQL Express is not. This fix is > Hi > > "fj" wrote: > > > Here is the part I found that might cause the problem. The specified Feature > > name ('SQL_Documentation') not found in Feature table. > > > > > > > > .... > > MSI (s) (80:34) [09:51:03:575]: Dir (target): Key: > > payload_ul.97F81AF1_0E47_DC99_FF1F_C8B3B9A1E18E , Object: > > C:\WINDOWS\winsxs\x86_microsoft.vc80.atl_1fc8b3b9a1e18e3b_8.0.50727.42_none_dc990e4797f81af1\ > > MSI (s) (80:34) [09:51:03:575]: Dir (target): Key: VSRetarget , Object: > > C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Binn\ > > MSI (s) (80:34) [09:51:03:575]: Note: 1: 2711 2: SQL_Documentation > > MSI (s) (80:34) [09:51:03:887]: Product: Microsoft SQL Server 2005 Tools > > Express Edition -- Error 2711. The installer has encountered an unexpected > > error. The error code is 2711. The specified Feature name > > ('SQL_Documentation') not found in Feature table. > > > > Error 2711. The installer has encountered an unexpected error. The error > > code is 2711. The specified Feature name ('SQL_Documentation') not found in > > Feature table. > > Action ended 9:51:03: CostFinalize. Return value 3. > > Action ended 9:51:03: INSTALL. Return value 3. > > Property(S): ProductCode = {2750B389-A2D2-4953-99CA-27C1F2A8E6FD} > > Property(S): ProductLanguage = 1033 > > Property(S): Manufacturer = Microsoft Corporation > > Property(S): ProductVersion = 9.00.1399.06 > > Property(S): MEDIAPACKAGEPATH = \Setup\ > > .... > > SQL Express is not one of the products that have been listed as affected by > the hotfix! > http://support.microsoft.com/kb/932557/en-us > > John installed by auto-update. Now it seems like there is a scheduled job at somewhere, how I can stop or remove it? Is the hotfix referred by your link a fix to the problem? Thanks -FJ Hi
Show quoteHide quote "fj" wrote: It looks like you may have something left over then, if you have removed it.> > > "John Bell" wrote: > > > Hi > > > > "fj" wrote: > > > > > Here is the part I found that might cause the problem. The specified Feature > > > name ('SQL_Documentation') not found in Feature table. > > > > > > > > > > > > .... > > > MSI (s) (80:34) [09:51:03:575]: Dir (target): Key: > > > payload_ul.97F81AF1_0E47_DC99_FF1F_C8B3B9A1E18E , Object: > > > C:\WINDOWS\winsxs\x86_microsoft.vc80.atl_1fc8b3b9a1e18e3b_8.0.50727.42_none_dc990e4797f81af1\ > > > MSI (s) (80:34) [09:51:03:575]: Dir (target): Key: VSRetarget , Object: > > > C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Binn\ > > > MSI (s) (80:34) [09:51:03:575]: Note: 1: 2711 2: SQL_Documentation > > > MSI (s) (80:34) [09:51:03:887]: Product: Microsoft SQL Server 2005 Tools > > > Express Edition -- Error 2711. The installer has encountered an unexpected > > > error. The error code is 2711. The specified Feature name > > > ('SQL_Documentation') not found in Feature table. > > > > > > Error 2711. The installer has encountered an unexpected error. The error > > > code is 2711. The specified Feature name ('SQL_Documentation') not found in > > > Feature table. > > > Action ended 9:51:03: CostFinalize. Return value 3. > > > Action ended 9:51:03: INSTALL. Return value 3. > > > Property(S): ProductCode = {2750B389-A2D2-4953-99CA-27C1F2A8E6FD} > > > Property(S): ProductLanguage = 1033 > > > Property(S): Manufacturer = Microsoft Corporation > > > Property(S): ProductVersion = 9.00.1399.06 > > > Property(S): MEDIAPACKAGEPATH = \Setup\ > > > .... > > > > SQL Express is not one of the products that have been listed as affected by > > the hotfix! > > http://support.microsoft.com/kb/932557/en-us > > > > John > > Yeh, the VS 2005 is installed on the box but SQL Express is not. This fix is > installed by auto-update. > > Now it seems like there is a scheduled job at somewhere, how I can stop or > remove it? > > Is the hotfix referred by your link a fix to the problem? > > Thanks > -FJ You may want to check out: http://msdn2.microsoft.com/en-us/vstudio/aa718704.aspx or http://support.microsoft.com/kb/909967 John Thanks John,
Actually I found the problem is because I didn't install the client tool and documents from the original 2005 SQL Server(64bit). BUT, the auto-update downloaded the hotfix for the SQL server 2005 without checking if I need this fix. This hotfix (MSDN article number 932557) has "hardwired" update for those tools and docs whch I don't have so the update failed. Since the update is scheduled to launch every 3 hours, I am keep getting this annoying errors. Now my question still remains, how I can terminate the remaining update manually? Is there a way to intercept MicroSoft's auto-update? I don't think I need to re-install or remove VS2005 or SQL 2005. There is a bug in this hotfix and Microsoft needs to know that. Thanks -FJ Hi
Show quoteHide quote "fj" wrote: Why not install the tools, allow the update or manually install the update > Thanks John, > Actually I found the problem is because I didn't install the client tool and > documents from the original 2005 SQL Server(64bit). BUT, the auto-update > downloaded the hotfix for the SQL server 2005 without checking if I need this > fix. This hotfix (MSDN article number 932557) has "hardwired" update for > those tools and docs whch I don't have so the update failed. > > Since the update is scheduled to launch every 3 hours, I am keep getting > this annoying errors. > > Now my question still remains, how I can terminate the remaining update > manually? Is there a way to intercept MicroSoft's auto-update? > > I don't think I need to re-install or remove VS2005 or SQL 2005. There is a > bug in this hotfix and Microsoft needs to know that. > > Thanks > -FJ and then remove the tools? Automatic updates are not something you would want on a production system so you may want to turn them off, but the problem could still occur if you turned them on at some point. John
Other interesting topics
Hyperthreaded CPU's
SATA for SQL Server data SQL Server Agent Not Restarting Automatically MS OLE DB provider for Oracle SSIS Connection Error Cannot create a Stored Procedure set transaction isolation level read uncommitted A couple LDF questions. Help with moving DB from 2000 to 2005 folders Linked server error in SSMS |
|||||||||||||||||||||||