[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 
Error 25602 storing file of XEvent on Azure Storage

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
SQL Server 2017
SQL Server 2019
Tips
Troubleshooting
Tuning

Error 25602 storing file of XEvent on Azure Storage.


Applies to: Azure SQL Database.
 

Problem Description.
 

Consider that you have created a extended event session for an Azure SQL Database where you store the resulting file in Azure Blob Storage, but when you start the extended event session you receive Error 25602:

Microsoft SQL Server Management Studio
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)

Additional information:
The target, "xxxxx.package0.event_file", encountered a configuration error during initialization. Object cannot be added to the event session. The operating system returned error 13: 'The data is invalid.
'while creating the file
'https://myazurestorage10.blob.core.windows.net/extendedevent/FileName_0_131786915402130000.xel'. (Microsoft SQL Server, Error: 25602)





We created a shared access signature for container storage and also created a database scoped credential on the SQL Azure database. The extended event is using the credential created.




Cause.


This error is related to the type of storage account created. The extended event cannot write on a Blob Storage account.





Solution.


Use instead a General Purpose type of storage account instead.


 

Please do not use a general purpose v1 storage account, use instead a general purpose v2 account type (based on ARM). 




 

 

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.