May 12, 2020 at 6:50 am
Hi Team,
I am getting the below error while I am executing a stored procedure from my local. But when I remote login to my VM and executing the query, it's working fine. Please advice.
Msg 50000, Level 16, State 1, Procedure EnableApplicationLogGrouping, Line 85 [Batch Start Line 1]
Unable to enable log grouping without overwriting session CONTEXT INFO.
Msg 50000, Level 16, State 1, Procedure DisableApplicationLogGrouping, Line 68 [Batch Start Line 1]
Group for session context found, but session ID differs.
Msg 50000, Level 16, State 1, Procedure XXX, Line 343 [Batch Start Line 1]
Group for session context found, but session ID differs.
Regards,
Vijay
May 12, 2020 at 9:00 am
Vijay
Those don't sound like SQL Server errors to me. Does your stored procedure use OPENROWSET or access a linked server? Are you able to post the code (CREATE PROCEDURE statements for EnableApplicationLogGrouping and DisableApplicationLogGrouping)?
John
May 12, 2020 at 9:47 am
Hi John,
I am not using any of OPENROWSET/Linked Servers. It's not a cross-server call. I am connecting to the same server from SSMS in my local then I am getting those errors if I do MSTSC and connect to the same server and execute the same procedure I am not getting the issue.
In my CREATE PROCEDURE statement, I am calling below procs for enabling and disabling the log.
EXEC dbo.EnableApplicationLogGrouping @ApplicationLogSourceName='Visualization', @Notes=@meta__ExecNote,@ProcObjectID=@@PROCID;
After a few line of code, I am calling
EXEC dbo.DisableApplicationLogGrouping @ProcObjectID=@@PROCID;
Thanks for your response.
Regards,
Vijay
May 12, 2020 at 10:46 am
it can be SQL Server - but without the code for both procs there's not much we can say
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply