error when i open wsus admin

When i open http://localhost/wsusadmin i see following above:

I've wsus 2.0, windows server 2003 with sp2

Microsoft.UpdateServices.Administration.WsusInvali dDataException: The
specified string is invalid.
Parameter name: Title ---> System.ArgumentException: The specified string is
invalid.
Parameter name: Title
at
Microsoft.UpdateServices.Internal.StringValidation .ValidateUpdateContainerTitleString(String paramName, String value)
at
Microsoft.UpdateServices.Internal.BaseApi.UpdateCo ntainer.set_Title(String
value)
at
Microsoft.UpdateServices.Internal.BaseApi.UpdateCo ntainer..ctor(GenericReadableRow row)
--- End of inner exception stack trace ---
at
Microsoft.UpdateServices.Internal.BaseApi.UpdateCo ntainer..ctor(GenericReadableRow row)
at
Microsoft.UpdateServices.Internal.BaseApi.UpdateCa tegory..ctor(GenericReadableRow row)
at
Microsoft.UpdateServices.Internal.BaseApi.UpdateCa tegory.BuildUpdateCategoryCollection(GenericReadab leRow[] categoryRows)
at
Microsoft.UpdateServices.Internal.BaseApi.UpdateCa tegory.GetSubcategories()
at
Administration.Manage.Subscriptions.SubscriptionPr oxy.LoadSubCategoriesValues(IUpdateCategory
seedCategory, StringCollection enabledCategoryIds, Boolean parentChecked,
StringBuilder& returnText)
at
Administration.Manage.Subscriptions.SubscriptionPr oxy.LoadSubCategoriesValues(IUpdateCategory
seedCategory, StringCollection enabledCategoryIds, Boolean parentChecked,
StringBuilder& returnText)
at
Administration.Manage.Subscriptions.SubscriptionPr oxy.LoadCategoriesValues()
at
Administration.Manage.Subscriptions.SubscriptionPr oxy.GetCategoriesList()
at Administration.Manage.Subscriptions.List.GetCatego riesListHtml()

at
Microsoft.UpdateServices.Internal.BaseApi.UpdateCo ntainer..ctor(GenericReadableRow row)
at
Microsoft.UpdateServices.Internal.BaseApi.UpdateCa tegory..ctor(GenericReadableRow row)
at
Microsoft.UpdateServices.Internal.BaseApi.UpdateCa tegory.BuildUpdateCategoryCollection(GenericReadab leRow[] categoryRows)
at
Microsoft.UpdateServices.Internal.BaseApi.UpdateCa tegory.GetSubcategories()
at
Administration.Manage.Subscriptions.SubscriptionPr oxy.LoadSubCategoriesValues(IUpdateCategory
seedCategory, StringCollection enabledCategoryIds, Boolean parentChecked,
StringBuilder& returnText)
at
Administration.Manage.Subscriptions.SubscriptionPr oxy.LoadSubCategoriesValues(IUpdateCategory
seedCategory, StringCollection enabledCategoryIds, Boolean parentChecked,
StringBuilder& returnText)
at
Administration.Manage.Subscriptions.SubscriptionPr oxy.LoadCategoriesValues()
at
Administration.Manage.Subscriptions.SubscriptionPr oxy.GetCategoriesList()
at Administration.Manage.Subscriptions.List.GetCatego riesListHtml()

Bruno,

See this thread and check the posts by jacktheexcynic and Paul:
http://www.microsoft.com/technet/com...5-db5d7d021e2d

MowGreen [MVP 2003-2008]
===============
*-343-* FDNY
Never Forgotten
===============

Bruno Leonardo wrote:

> When i open http://localhost/wsusadmin i see following above:
>
> I've wsus 2.0, windows server 2003 with sp2
>
> Microsoft.UpdateServices.Administration.WsusInvali dDataException: The
> specified string is invalid.
> Parameter name: Title ---> System.ArgumentException: The specified string is
> invalid.
> Parameter name: Title
> at
> Microsoft.UpdateServices.Internal.StringValidation .ValidateUpdateContainerTitleString(String paramName, String value)
> at
> Microsoft.UpdateServices.Internal.BaseApi.UpdateCo ntainer.set_Title(String
> value)
> at
> Microsoft.UpdateServices.Internal.BaseApi.UpdateCo ntainer..ctor(GenericReadableRow row)
> --- End of inner exception stack trace ---
> at
> Microsoft.UpdateServices.Internal.BaseApi.UpdateCo ntainer..ctor(GenericReadableRow row)
> at
> Microsoft.UpdateServices.Internal.BaseApi.UpdateCa tegory..ctor(GenericReadableRow row)
> at
> Microsoft.UpdateServices.Internal.BaseApi.UpdateCa tegory.BuildUpdateCategoryCollection(GenericReadab leRow[] categoryRows)
> at
> Microsoft.UpdateServices.Internal.BaseApi.UpdateCa tegory.GetSubcategories()
> at
> Administration.Manage.Subscriptions.SubscriptionPr oxy.LoadSubCategoriesValues(IUpdateCategory
> seedCategory, StringCollection enabledCategoryIds, Boolean parentChecked,
> StringBuilder& returnText)
> at
> Administration.Manage.Subscriptions.SubscriptionPr oxy.LoadSubCategoriesValues(IUpdateCategory
> seedCategory, StringCollection enabledCategoryIds, Boolean parentChecked,
> StringBuilder& returnText)
> at
> Administration.Manage.Subscriptions.SubscriptionPr oxy.LoadCategoriesValues()
> at
> Administration.Manage.Subscriptions.SubscriptionPr oxy.GetCategoriesList()
> at Administration.Manage.Subscriptions.List.GetCatego riesListHtml()
>
> at
> Microsoft.UpdateServices.Internal.BaseApi.UpdateCo ntainer..ctor(GenericReadableRow row)
> at
> Microsoft.UpdateServices.Internal.BaseApi.UpdateCa tegory..ctor(GenericReadableRow row)
> at
> Microsoft.UpdateServices.Internal.BaseApi.UpdateCa tegory.BuildUpdateCategoryCollection(GenericReadab leRow[] categoryRows)
> at
> Microsoft.UpdateServices.Internal.BaseApi.UpdateCa tegory.GetSubcategories()
> at
> Administration.Manage.Subscriptions.SubscriptionPr oxy.LoadSubCategoriesValues(IUpdateCategory
> seedCategory, StringCollection enabledCategoryIds, Boolean parentChecked,
> StringBuilder& returnText)
> at
> Administration.Manage.Subscriptions.SubscriptionPr oxy.LoadSubCategoriesValues(IUpdateCategory
> seedCategory, StringCollection enabledCategoryIds, Boolean parentChecked,
> StringBuilder& returnText)
> at
> Administration.Manage.Subscriptions.SubscriptionPr oxy.LoadCategoriesValues()
> at
> Administration.Manage.Subscriptions.SubscriptionPr oxy.GetCategoriesList()
> at Administration.Manage.Subscriptions.List.GetCatego riesListHtml()

Thanks for posting this.


MowGreen [MVP 2003-2008]
===============
*-343-* FDNY
Never Forgotten
===============


cejennings_cr wrote:

> Here are the exact steps that I took to resolve this problem:
>
> 1) Open CMD prompt
> 2) SET WSUS_DB=%COMPUTERNAME%\WSUS
> 3) OSQL -S %WSUS_DB% -E
> 4) 1> USE SUSDB
> 5) 2> Update tbPrecomputedCategoryLocalizedProperty
> 6) 3> Set Title = Replace(Title, '"', '')
> 7) 4> Where Title like '%"%'
> 8) 5> go
> 9) 1> Update tbPreComputedLocalizedProperty
> 10) 2> Set Title = Replace(Title, '"', '')
> 11) 3> Where Title like '%"%'
> 12) 4> go
> 13) 1> quit
>
> This resolved my problems.
>
>

I resolved it.

Tks.

Bruno


"MowGreen [MVP]" wrote:

> Thanks for posting this.
>
>
> MowGreen [MVP 2003-2008]
> ===============
> *-343-* FDNY
> Never Forgotten
> ===============
>
>
> cejennings_cr wrote:
>
> > Here are the exact steps that I took to resolve this problem:
> >
> > 1) Open CMD prompt
> > 2) SET WSUS_DB=%COMPUTERNAME%\WSUS
> > 3) OSQL -S %WSUS_DB% -E
> > 4) 1> USE SUSDB
> > 5) 2> Update tbPrecomputedCategoryLocalizedProperty
> > 6) 3> Set Title = Replace(Title, '"', '')
> > 7) 4> Where Title like '%"%'
> > 8) 5> go
> > 9) 1> Update tbPreComputedLocalizedProperty
> > 10) 2> Set Title = Replace(Title, '"', '')
> > 11) 3> Where Title like '%"%'
> > 12) 4> go
> > 13) 1> quit
> >
> > This resolved my problems.
> >
> >
>

cf.
http://blogs.technet.com/wsus/archiv...s-in-wsus.aspx

MowGreen [MVP] wrote:
> Thanks for posting this.
>
>
> MowGreen [MVP 2003-2008]
> ===============
> *-343-* FDNY
> Never Forgotten
> ===============
>
>
> cejennings_cr wrote:
>
>> Here are the exact steps that I took to resolve this problem:
>>
>> 1) Open CMD prompt
>> 2) SET WSUS_DB=%COMPUTERNAME%\WSUS
>> 3) OSQL -S %WSUS_DB% -E
>> 4) 1> USE SUSDB
>> 5) 2> Update tbPrecomputedCategoryLocalizedProperty
>> 6) 3> Set Title = Replace(Title, '"', '')
>> 7) 4> Where Title like '%"%'
>> 8) 5> go
>> 9) 1> Update tbPreComputedLocalizedProperty
>> 10) 2> Set Title = Replace(Title, '"', '')
>> 11) 3> Where Title like '%"%'
>> 12) 4> go
>> 13) 1> quit
>>
>> This resolved my problems.