SQL Server 2019 の累積的な更新プログラム適用後に発生するイベント名 feature_restriction_usage が見つからないエラーについて

Published Mar 24 2021 08:48 AM 1,121 Views
Microsoft

こんにちは SQL Server サポートチームです。

今回は SQL Server 2019 CU2 以降を適用した際に ERRORLOG に記録されるエラーについてご説明します。

  

■概要

SQL Server 2019 CU2 以降で拡張イベントの"sqlserver.feature_restriction_usage"が廃止されたことにより、

累積的な更新プログラムを適用した後の初回起動時に、下記のエラーが記録されることがあります。

このエラーは更新プログラム適用後の一時的なものであり、無視していただいて問題ありません。

 

Error: 25623, Severity: 16, State: 1.

The event name, "XXXXXXXXXXXXXXXX.sqlserver.feature_restriction_usage", is invalid, or the object could not be found

Error: 25710, Severity: 16, State: 1.

Event session "telemetry_xevents" failed to start. Refer to previous errors in the current session to identify the cause, and correct any associated problems.

Error: 25709, Severity: 16, State: 1.

One or more event sessions failed to start. Refer to previous errors in the current session to identify the cause, and correct any associated problems.

 

■発生条件

SQL Server 2019 CU1 以下のバージョンの SQL Server を使っている環境に対して、SQL Server 2019 CU2 以降の更新プログラムを適用することで発生します。

 

■影響

このエラーによるお客様のアプリケーションへの影響はありません。

 

拡張イベントの"feature_restriction_usage"は、SQL Server CEIP サービス に関連して動作する拡張イベントセッション"telemetry_xevents"で使用されています。

SQL Server CEIP サービスは、Microsoft が SQL Server の使用状態に関する情報を収集する内部機能となっており、お客様のすべてのアプリケーションの動作には影響しません。

SQL Server CEIP サービスに関する詳細は下記の公開情報をご確認ください。

 

SQL Server の使用状況および診断データの収集を構成する (CEIP)

https://docs.microsoft.com/ja-jp/sql/sql-server/usage-and-diagnostic-data-configuration-for-sql-serv...

 

■注意事項

SQL Server CEIP サービスを停止/無効化している環境や、SQL Server CEIP サービスが"telemetry_xevents"の定義を変更する前に、SQL Server サービスが再起動された場合は引き続きエラーが記録される可能性があります。

SQL Server CEIP サービスの無効化はサポートされないため、起動した状態にする必要があります。

なお、SQL Server CEIP サービスが起動した状態であれば拡張イベントセッションの定義変更は通常数分で完了し、定義変更後は基本的に自動で"telemetry_xevents"が起動するため特に操作は不要です。

%3CLINGO-SUB%20id%3D%22lingo-sub-2232716%22%20slang%3D%22ja-JP%22%3EFor%20errors%20that%20do%20not%20find%20the%20event%20name%20or%20name%20that%20occurs%20after%20applying%20the%20sql%20server%202019%20cumulative%20update%20feature_restriction_usage%20the%20event%20name%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2232716%22%20slang%3D%22ja-JP%22%3E%3CP%3EHi%2C%20I'm%20from%20the%20SQL%20Server%20support%20team.%3C%2FP%3E%0A%3CP%3EThis%20time%2C%20we%20will%20discuss%20the%20errors%20recorded%20in%20ERRORLOG%20when%20applying%20SQL%20Server%202019%20CU2%20or%20later.%3C%2FP%3E%0A%3CP%20lang%3D%22en-US%22%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%E2%96%A0Overview%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3ESql%20Server%202019%20CU2%20and%20later%20has%20deprecated%20the%20sqlserver.feature_restriction_usage%22%20of%20extended%20events.%3C%2FP%3E%0A%3CP%3EThe%20following%20errors%20may%20be%20recorded%20on%20the%20first%20boot%20after%20applying%20the%20cumulative%20update%3A%3C%2FP%3E%0A%3CP%3EThis%20error%20is%20temporary%20after%20the%20update%20has%20been%20applied%20and%20can%20be%20safely%20ignored.%3C%2FP%3E%0A%3CP%20lang%3D%22en-US%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20lang%3D%22en-US%22%3E%3CEM%3EError%3A%2025623%2C%20Severity%3A%2016%2C%20State%3A%201.%3C%2FEM%3E%3C%2FP%3E%0A%3CP%20lang%3D%22en-US%22%3E%3CEM%3EThe%20event%20name%2C%20%22XXXXXXXXXXXXXXXX.sqlserver.feature_restriction_usage%22%2C%20is%20invalid%2C%20or%20the%20object%20could%20not%20be%20found%3C%2FEM%3E%3C%2FP%3E%0A%3CP%20lang%3D%22en-US%22%3E%3CEM%3EError%3A%2025710%2C%20Severity%3A%2016%2C%20State%3A%201.%3C%2FEM%3E%3C%2FP%3E%0A%3CP%20lang%3D%22en-US%22%3E%3CEM%3EEvent%20session%20%22telemetry_xevents%22%20failed%20to%20start.%20Refer%20to%20previous%20errors%20in%20the%20current%20session%20to%20identify%20the%20cause%2C%20and%20correct%20any%20associated%20problems.%3C%2FEM%3E%3C%2FP%3E%0A%3CP%20lang%3D%22en-US%22%3E%3CEM%3EError%3A%2025709%2C%20Severity%3A%2016%2C%20State%3A%201.%3C%2FEM%3E%3C%2FP%3E%0A%3CP%20lang%3D%22en-US%22%3E%3CEM%3EOne%20or%20more%20event%20sessions%20failed%20to%20start.%20Refer%20to%20previous%20errors%20in%20the%20current%20session%20to%20identify%20the%20cause%2C%20and%20correct%20any%20associated%20problems.%3C%2FEM%3E%3C%2FP%3E%0A%3CP%20lang%3D%22en-US%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%E2%96%A0Conditions%20of%20occurrence%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3EThis%20occurs%20when%20you%20apply%20SQL%20Server%202019%20CU2%20or%20later%20updates%20to%20environments%20that%20use%20SQL%20Server%202019%20CU1%20or%20later.%3C%2FP%3E%0A%3CP%20lang%3D%22en-US%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%E2%96%A0Impact%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3EThis%20error%20does%20not%20affect%20your%20application.%3C%2FP%3E%0A%3CP%20lang%3D%22en-US%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20%22feature_restriction_usage%22%20of%20extended%20events%20is%20used%20in%20extended%20event%20sessions%20%22telemetry_xevents%20sql%20server%20CEIP%20services.%3C%2FP%3E%0A%3CP%3EThe%20SQL%20Server%20CEIP%20service%20is%20an%20internal%20feature%20that%20collects%20information%20about%20microsoft's%20usage%20status%20and%20does%20not%20affect%20the%20operation%20of%20all%20customer%20applications.%3C%2FP%3E%0A%3CP%3EFor%20more%20information%20about%20SQL%20Server%20CEIP%20services%2C%20please%20refer%20to%20the%20public%20information%20below.%3C%2FP%3E%0A%3CP%20lang%3D%22en-US%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EConfigure%20SQL%20Server%20usage%20and%20diagnostic%20data%20collection%20(CEIP)%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fdocs.microsoft.com%252Fja-jp%252Fsql%252Fsql-server%252Fusage-and-diagnostic-data-configuration-for-sql-server%253Fview%253Dsql-server-ver15%26amp%3Bdata%3D04%257C01%257CYuki.Kitazawa%2540microsoft.com%257C639112bfc3144609b06208d8eec7a6d4%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C637521888576801058%257CUnknown%257CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%253D%257C1000%26amp%3Bsdata%3D2%252BDUgATtD0575ivCeZW%252BKlfWVJoahBR%252Bj2LDjx6In0M%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fja-jp%2Fsql%2Fsql-server%2Fusage-and-diagnostic-data-configuration-for-sql-server%3Fview%3Dsql-server-ver15%3C%2FA%3E%3C%2FP%3E%0A%3CP%20lang%3D%22en-US%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%E2%96%A0Precautions%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3EErrors%20may%20still%20be%20kept%20recorded%20if%20the%20SQL%20Server%20service%20is%20restarted%20before%20the%20environment%20where%20the%20SQL%20Server%20CEIP%20service%20is%20stopped%20or%20disabled%2C%20or%20before%20the%20SQL%20Server%20CEIP%20service%20changes%20the%20definition%20of%20%22telemetry_xevents%22.%3C%2FP%3E%0A%3CP%3EDisabling%20the%20SQL%20Server%20CEIP%20service%20is%20not%20supported%20and%20should%20be%20in%20a%20booted%20state.%3C%2FP%3E%0A%3CP%3ENote%20that%20if%20the%20SQL%20Server%20CEIP%20service%20is%20started%2C%20the%20extension%20event%20session%20definition%20change%20usually%20takes%20a%20few%20minutes%2C%20and%20after%20the%20definition%20change%2C%20%22telemetry_xevents%22%20basically%20starts%20automatically%2C%20so%20no%20action%20is%20required.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2232716%22%20slang%3D%22ja-JP%22%3E%3CLINGO-LABEL%3Epatching%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESQL%202019%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Co-Authors
Version history
Last update:
‎Mar 24 2021 08:48 AM
Updated by: