Today, I got a error configuring my extended event session, The target, 'XXX.package0.event_file', encountered a configuration error during initialization. Object cannot be added to the event session. (Microsoft SQL Server, Error: 25602). Following, I would like to share my findings here.
When running the extended event script mentioned Lesson Learned #324: Query Recompilation in Azure SQL - Microsoft Community Hub container, the error appears. I found that the storage account that the extended event is trying to write is not random-accessible pages (classic or general purpose) and page blobs (general-purpose v2 type), for this reason, I got this error. Changing the correct one, I was able to start my extended event. Extended Events: Azure Storage Account Types Matter - Microsoft Community Hub
Storage account overview - Azure Storage | Microsoft Learn
Enjoy!
