sp_BlitzLock fails on Azure SQL DB and Managed Instances

[BrentOzar]

What is the current behavior?
sp_BlitzLock produces:

Msg 40538, Level 16, State 3, Procedure sp_BlitzLock, Line 170 [Batch Start Line 0]
A valid URL beginning with 'https://' is required as value for any filepath specified.

Will dig into why.

[BlitzErik]

It's going to be for this section of code:

        WITH xml
        AS ( SELECT CONVERT(XML, event_data) AS deadlock_xml
             FROM   sys.fn_xe_file_target_read_file(@EventSessionPath, NULL, NULL, NULL) )
        SELECT TOP ( @Top ) xml.deadlock_xml
        INTO   #deadlock_data
        FROM   xml
        WHERE  xml.deadlock_xml.value('(/event/@name)[1]', 'VARCHAR(256)') = 'xml_deadlock_report'
               AND xml.deadlock_xml.value('(/event/@timestamp)[1]', 'datetime') >= @StartDate
               AND xml.deadlock_xml.value('(/event/@timestamp)[1]', 'datetime') < @EndDate
			   ORDER BY xml.deadlock_xml.value('(/event/@timestamp)[1]', 'datetime')
			   OPTION ( RECOMPILE );

We can get to the system health file normally just by doing this:

@EventSessionPath VARCHAR(256) = 'system_health*.xel',

[BlitzErik]

Closed via #1860

[KoiMundi]

Hi,

Just curious, I see this was closed, but I am still getting the same error when running SP_BlitzLock on SQL Managed Instance?

[LukaszSwiatekMeniga]

Hi,
I have a similar issue on SQL Managed Instance.

[BrentOzar]

@LukaszSwiatekMeniga feel free to open a new issue with your details. Make sure to include everything that's asked in the new issue, like the exact version of the scripts you're using, the exact error you're getting, etc.