This problem is now resolved. Turns out the database had the compatibility
mode set for 9.0 instead of the default 8.0 (Windows 2000).
The course I traveled to figure this out sucked so bad I'm going to write it
down and hope it escapes my mind this way.
Original problem sent me looking for logs... First one being:
c:\program files\update services\logfiles\SoftwareDistribution.log:
2007-06-14 13:10:24.038 UTC Error w3wp.74 DBConnection.LogSqlException
DBLAYER: ExecuteReader()
CommandText: spGetRevisionIdList
SqlException:
System.Data.SqlClient.SqlException: Incorrect syntax near 'INDEX'. If this
is intended as a part of a table hint, A WITH keyword and parenthesis are
now required. See SQL Server Books Online for proper syntax.
Incorrect syntax near 'INDEX'. If this is intended as a part of a table
hint, A WITH keyword and parenthesis are now required. See SQL Server Books
Online for proper syntax.
at
Microsoft.UpdateServices.DatabaseAccess.DBConnection.DrainObsoleteConnections(SqlException
e)
at Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
This log entry mentions spGetRevisionIdList. I ran that from a query window
returning the following:
Msg 1018, Level 15, State 1, Procedure spGetRevisionIdList, Line 313
Incorrect syntax near 'INDEX'. If this is intended as a part of a table
hint, A WITH keyword and parenthesis are now required. See SQL Server Books
Online for proper syntax.
Msg 1018, Level 15, State 1, Procedure spGetRevisionIdList, Line 476
Incorrect syntax near 'INDEX'. If this is intended as a part of a table
hint, A WITH keyword and parenthesis are now required. See SQL Server Books
Online for proper syntax.
I edited the query window, and checked the BOL for the following syntax:
(line 313) SELECT
u.UpdateID, r.RevisionNumber, r.RevisionID
FROM
dbo.tbDeployment d (INDEX (nc5DeploymentRevision))
Looks valid to me.
SELECT
u.UpdateID, r.RevisionNumber, r.RevisionID
FROM
dbo.tbDeployment d (INDEX (nc5DeploymentRevision))
Looks valid to me.
Looking up the syntax in BOL ended up being a dead end.
Realizing that the default install uses mssde not 2005 express I decided 9.0
was not possible by default and switched the mode back to 8.0. Ran the
stored procedure with less syntax problems... Ran a syncronization and all
was well.
Have a nice day, I appreciate any though that someone might have dedicated
to this problem.
Luke
"Luke" <lmihalko[ at ]dollarbank.com> wrote in message
news:C0722D28-8311-4CC8-8D6F-C3248F3E98A4[ at ]microsoft.com...
[Quoted Text] > Hello,
> I have a number of WSUS servers all running Build 2.0.0.2620 syncronizing
> with one main WSUS server running Build 2.0.0.2620 where I do all my
> approvals. When the syncronization runs from a downstream WSUS server I
> get a failure and the following stack trace:
> SoapException: Fault occurred
> at
> System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> message, WebResponse response, Stream responseStream, Boolean asyncCall)
> at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters)
> at
> Microsoft.UpdateServices.ServerSyncWebServices.ServerSync.ServerSyncProxy.GetRevisionIdList(Cookie
> cookie, ServerSyncFilter filter)
> at
> Microsoft.UpdateServices.ServerSync.CatalogSyncAgentCore.InternetGetUssIdList(ServerSyncFilter
> filter)
> at
> Microsoft.UpdateServices.ServerSync.CatalogSyncAgentCore.InternalGetConfig()
> at
> Microsoft.UpdateServices.ServerSync.CatalogSyncAgentCore.CatalogSyncThreadProcessReal(Boolean
> allowRedirect)
>
> I checked the iis logs on the main server, and noticed 3 requests
> processed with the first two returning 200 http codes and a final one
> returning a 500 http code.
> 2007-06-14 00:32:22 W3SVC1089950987 10.21.11.89 POST
> /ServerSyncWebService/ServerSyncWebService.asmx - 80 - 10.24.53.59
> Microsoft+WSUS+Server 200 0 0
> 2007-06-14 00:32:23 W3SVC1089950987 10.21.11.89 POST
> /DssAuthWebService/DssAuthWebService.asmx - 80 - 10.24.53.59
> Microsoft+WSUS+Server 200 0 0
> 2007-06-14 00:32:23 W3SVC1089950987 10.21.11.89 POST
> /ServerSyncWebService/ServerSyncWebService.asmx - 80 - 10.24.53.59
> Microsoft+WSUS+Server 500 0 0
>
> I really could use the help. Thank you in advance.
> Luke
|