amachanic / sp_whoisactive

sp_whoisactive
GNU General Public License v3.0
1.13k stars 281 forks source link

An error occurred while executing batch. Error message is: Name cannot begin with the '>' character, hexadecimal value 0x3E. Line 126, position 22. #100

Closed ghauan closed 10 months ago

ghauan commented 1 year ago

I get the above error if I am running EXEC dbo.sp_WhoIsActive @get_transaction_info = 1, @get_outer_command = 1, @get_plans = 1, @get_task_info = 2, @get_additional_info = 1, @find_block_leaders = 1, @get_memory_info = 1

while at the same time sp_blitzFirst is running. An example running in my environment: exec sp_blitzfirst @expertmode=1, @OutputDatabaseName = 'DBAtoolsHVI', @OutputSchemaName = 'dbo', @OutputTableName = 'BlitzFirst', @OutputTableNameFileStats = 'BlitzFirst_FileStats', @OutputTableNamePerfmonStats = 'BlitzFirst_PerfmonStats', @OutputTableNameWaitStats = 'BlitzFirst_WaitStats', @OutputTableNameBlitzCache = 'BlitzCache', @OutputTableNameBlitzWho = 'BlitzWho'

I have seen variations of the error message, I guess it has to do with where sp_blitzFirst is in its run. Another example: "An error occurred while executing batch. Error message is: Name cannot begin with the '=' character, hexadecimal value 0x3D. Line 1549, position 31."

I am running the latest version (12.0) of sp_whoisactive.

SErver: Microsoft SQL Server 2019 (RTM-CU20) (KB5024276) - 15.0.4312.2 (X64) Apr 1 2023 12:10:46 Copyright (C) 2019 Microsoft Corporation Enterprise Edition (64-bit) on Windows Server 2016 Standard 10.0 (Build 14393: ) (Hypervisor)

erikdarlingdata commented 10 months ago

I think this is a duplicate of #99