Home Dashboard Directory Help
Search

The object 'sqlserver.event_sequence' does not exist by billinkc


Status: 

Closed
 as Duplicate Help for as Duplicate


10
0
Sign in
to vote
Type: Bug
ID: 705840
Opened: 11/18/2011 12:24:36 PM
Access Restriction: Public
1
Workaround(s)
view
7
User(s) can reproduce this bug

Description

Using the new extended events Session wizard results in an error being thrown. "The object 'sqlserver.event_sequence' does not exist. (Microsoft.SqlServer.Management.XEvent)"

Details
Sign in to post a comment.
Posted by rwatkins on 11/21/2012 at 5:03 AM
I just tested whether this was fixed in SQL 2012 SP1 but it appears that the bug still exists.
Posted by Microsoft on 1/3/2012 at 8:14 AM
Hi Charles,

Thanks for reporting this issue. This problem was caused when we changed the package that the event_sequence action lives in. The workaround posted by Jonathan will rectify to problem, you can also find an updated copy of the template in Jonathan's blog: http://sqlskills.com/blogs/jonathan/post/Workaround-for-Bug-in-Activity-Tracking-Event-Session-Template-in-2012-RC0.aspx.

We discovered this problem too late to fix it for the RTM release but we are hoping to address this in the first service pack.

Regards,
Mike Wachal
SQL Server
Sign in to post a workaround.
Posted by Jonathan Kehayias on 1/2/2012 at 10:58 AM
The event_sequence action is provided by package0 and not sqlserver. To work around this, you can edit the template file and replace the sqlserver package references with package0. The template is saved in the following location:

C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Templates\sql\xevent\xe_activity.xml

If you do a find for:

<action package="sqlserver" name="event_sequence" />

and replace it with:

<action package="package0" name="event_sequence" />

the template will work correctly once saved. This will at least let you play around with this while Microsoft works out the bug in the template XML.