none
WSUS 2.0 web console問題 RRS feed

  • 問題

  •  

    今天wsus 2.0開啟web console後, 點選 "更新" "報告" "電腦" "選項" 都是正常的,但在點選 "首頁"時,

    會出現  ""WSUS遇到錯誤,所指定的字串不正確 ,參數名稱 : title "" 詳細資料如下 !

     

    而wsus server並無做任何異動,且 sysem event log裡也無error log ! 請教這該如何解決呢  THANK !

     

     

    詳細資料 :

    Microsoft.UpdateServices.Administration.WsusInvalidDataException: 所指定的字串不正確。
    參數名稱: Title ---> System.ArgumentException: 所指定的字串不正確。
    參數名稱: Title
       at Microsoft.UpdateServices.Internal.StringValidation.ValidateUpdateContainerTitleString(String paramName, String value)
       at Microsoft.UpdateServices.Internal.BaseApi.UpdateContainer.set_Title(String value)
       at Microsoft.UpdateServices.Internal.BaseApi.UpdateContainer..ctor(GenericReadableRow row)
       --- 內部例外堆疊追蹤的結尾 ---
       at Microsoft.UpdateServices.Internal.BaseApi.UpdateContainer..ctor(GenericReadableRow row)
       at Microsoft.UpdateServices.Internal.BaseApi.UpdateCategory..ctor(GenericReadableRow row)
       at Microsoft.UpdateServices.Internal.BaseApi.UpdateCategory.BuildUpdateCategoryCollection(GenericReadableRow[] categoryRows)
       at Microsoft.UpdateServices.Internal.BaseApi.UpdateCategory.GetAll(DateTime fromSyncDate, DateTime toSyncDate)
       at Microsoft.UpdateServices.Internal.BaseApi.UpdateServer.GetUpdateCategories(DateTime fromSyncDate, DateTime toSyncDate)
       at Administration.Reporting.CurrentStatus.CurrentStatusProxy.GetHomeStatus()
       at Administration.Reporting.ReportingXPost.Page_Load(Object sender, EventArgs e)

       at Microsoft.UpdateServices.Internal.BaseApi.UpdateContainer..ctor(GenericReadableRow row)
       at Microsoft.UpdateServices.Internal.BaseApi.UpdateCategory..ctor(GenericReadableRow row)
       at Microsoft.UpdateServices.Internal.BaseApi.UpdateCategory.BuildUpdateCategoryCollection(GenericReadableRow[] categoryRows)
       at Microsoft.UpdateServices.Internal.BaseApi.UpdateCategory.GetAll(DateTime fromSyncDate, DateTime toSyncDate)
       at Microsoft.UpdateServices.Internal.BaseApi.UpdateServer.GetUpdateCategories(DateTime fromSyncDate, DateTime toSyncDate)
       at Administration.Reporting.CurrentStatus.CurrentStatusProxy.GetHomeStatus()
       at Administration.Reporting.ReportingXPost.Page_Load(Object sender, EventArgs e)

    2007年11月12日 上午 08:39

解答

  •  

    The following SQL statements will make those updates, removing the
    double-quote character. It's hard to see here, but the 2nd argument to the
    Replace function is single-quote, double-quote, single-quote. The 3rd
    argument is single-quote, single-quote.

    Update tbPrecomputedCategoryLocalizedProperty
    Set Title = Replace(Title, '"', '')
    Where Title like '%"Nitrogen"%'

    Update tbPreComputedLocalizedProperty
    Set Title = Replace(Title, '"', '')
    Where Title like '%"Nitrogen"%'

    If you want to more generally eliminate all double-quotes from any title,
    instead of just the one we now know is a problem today, you could use this
    instead:

    Update tbPrecomputedCategoryLocalizedProperty
    Set Title = Replace(Title, '"', '')
    Where Title like '%"%'

    Update tbPreComputedLocalizedProperty
    Set Title = Replace(Title, '"', '')
    Where Title like '%"%'

    2007年11月13日 上午 10:08

所有回覆

  • 我的也是就樣!google了一下,好象挺多人有這個問題!等微軟件出補丁吧,只有等!

    參考以下:

    http://www.wsus.info/forums/index.php?showtopic=11125

     

    2007年11月13日 上午 08:18
  •  

    The following SQL statements will make those updates, removing the
    double-quote character. It's hard to see here, but the 2nd argument to the
    Replace function is single-quote, double-quote, single-quote. The 3rd
    argument is single-quote, single-quote.

    Update tbPrecomputedCategoryLocalizedProperty
    Set Title = Replace(Title, '"', '')
    Where Title like '%"Nitrogen"%'

    Update tbPreComputedLocalizedProperty
    Set Title = Replace(Title, '"', '')
    Where Title like '%"Nitrogen"%'

    If you want to more generally eliminate all double-quotes from any title,
    instead of just the one we now know is a problem today, you could use this
    instead:

    Update tbPrecomputedCategoryLocalizedProperty
    Set Title = Replace(Title, '"', '')
    Where Title like '%"%'

    Update tbPreComputedLocalizedProperty
    Set Title = Replace(Title, '"', '')
    Where Title like '%"%'

    2007年11月13日 上午 10:08
  •  

    ya...it's work !!!! But anyone know why it happened !!!
    2007年11月14日 上午 01:48