WorkloadTools: Capture the workload Error
I am feeling like a common visitor at this point.
We have this error: Before pasting it:
1. We checked that no instance of workload is running 2. We have all permissions (tried few accounts with different permissions) 3. Directory is in exceptions 4. Both files are good, they ran before, this is the first time that we got this error
2023-05-01 01:20:06.7604 - Info - SqlWorkload.Program : Reading configuration from ‘d:\WorkloadTools\Workload-Prod.json’
2023-05-01 01:20:06.8852 - Info - WorkloadTools.Listener.ExtendedEvents.ExtendedEventsWorkloadListener : Reading Extended Events session definition from C:\Program Files\WorkloadTools\Listener\ExtendedEvents\sqlworkload.sql
2023-05-01 01:20:06.9009 - Error - WorkloadTools.WorkloadController : Uncaught Exception
2023-05-01 01:20:06.9009 - Error - WorkloadTools.WorkloadController : The event, “sqlserver.attention”, can not be added to an event session that specifies no event loss.
Cannot alter the event session ‘sqlworkload’, because it does not exist or you do not have permission.
2023-05-01 01:20:06.9477 - Error - WorkloadTools.WorkloadController : at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at WorkloadTools.Listener.ExtendedEvents.ExtendedEventsWorkloadListener.Initialize() in C:\github\WorkloadTools\WorkloadTools\Listener\ExtendedEvents\ExtendedEventsWorkloadListener.cs:line 135
at WorkloadTools.WorkloadController.Run() in C:\github\WorkloadTools\WorkloadTools\WorkloadController.cs:line 42
2023-05-01 01:20:06.9477 - Info - SqlWorkload.Program : Controller stopped.
2023-05-01 01:20:07.0884 - Info - WorkloadTools.Consumer.WorkloadFile.WorkloadFileWriterConsumer : Closing the connection to the output file
2023-05-01 01:20:07.0884 - Info - WorkloadTools.Listener.ExtendedEvents.ExtendedEventsWorkloadListener : Disposing ExtendedEventsWorkloadListener.
2023-05-01 01:20:07.0884 - Warn - WorkloadTools.Listener.ExtendedEvents.ExtendedEventsWorkloadListener : Error disposing ExtendedEventWorkloadListener: Object reference not set to an instance of an object.
2023-05-01 01:20:07.0884 - Info - WorkloadTools.Listener.ExtendedEvents.ExtendedEventsWorkloadListener : Extended Events session [sqlworkload] stopped successfully.
2023-05-01 01:20:07.0884 - Info - SqlWorkload.Program : Controller disposed.
2023-05-01 01:21:11.6626 - Info - SqlWorkload.Program : Reading configuration from ‘d:\WorkloadTools\Workload-Prod.json’
2023-05-01 01:21:11.7564 - Info - WorkloadTools.Listener.ExtendedEvents.ExtendedEventsWorkloadListener : Reading Extended Events session definition from C:\Program Files\WorkloadTools\Listener\ExtendedEvents\sqlworkload.sql
2023-05-01 01:21:11.7564 - Error - WorkloadTools.WorkloadController : Uncaught Exception
2023-05-01 01:21:11.7564 - Error - WorkloadTools.WorkloadController : The event, “sqlserver.attention”, can not be added to an event session that specifies no event loss.
Cannot alter the event session ‘sqlworkload’, because it does not exist or you do not have permission.
2023-05-01 01:21:11.7720 - Error - WorkloadTools.WorkloadController : at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at WorkloadTools.Listener.ExtendedEvents.ExtendedEventsWorkloadListener.Initialize() in C:\github\WorkloadTools\WorkloadTools\Listener\ExtendedEvents\ExtendedEventsWorkloadListener.cs:line 135
at WorkloadTools.WorkloadController.Run() in C:\github\WorkloadTools\WorkloadTools\WorkloadController.cs:line 42
2023-05-01 01:21:11.7720 - Info - SqlWorkload.Program : Controller stopped.
2023-05-01 01:21:11.7720 - Info - WorkloadTools.Consumer.WorkloadFile.WorkloadFileWriterConsumer : Closing the connection to the output file
2023-05-01 01:21:11.7720 - Info - WorkloadTools.Listener.ExtendedEvents.ExtendedEventsWorkloadListener : Disposing ExtendedEventsWorkloadListener.
2023-05-01 01:21:11.7720 - Warn - WorkloadTools.Listener.ExtendedEvents.ExtendedEventsWorkloadListener : Error disposing ExtendedEventWorkloadListener: Object reference not set to an instance of an object.
2023-05-01 01:21:11.7720 - Info - WorkloadTools.Listener.ExtendedEvents.ExtendedEventsWorkloadListener : Extended Events session [sqlworkload] stopped successfully.
2023-05-01 01:21:11.7720 - Info - SqlWorkload.Program : Controller disposed.

Capture JSON:
{ “Controller”: {
"Listener":
{
"__type": "ExtendedEventsWorkloadListener",
"ConnectionInfo":
{
"ServerName": "ServerName",
"UserName": "",
"Password": ""
},
"TimeoutMinutes": 480,
"DatabaseFilter": "DB"
},
"Consumers":
[
{
"__type": "WorkloadFileWriterConsumer",
"OutputFile": "D:\\WorkloadTools\\File_Trace1.sqlite"
}
]
}
}
CMD File:
“%programfiles%\WorkloadTools\sqlworkload.exe” --File “Workload-Prod.json”
Have no idea what to do with it. Restarting server did not help, reinstall did not help, shutting down antivirus did not help. I have checked all files but i do not see any problem, as said, this is first encounter with this error. I would like to ask for some guidance. The last time we ran this was it went as expected (start of April). Now it does not work, so maybe some Microsoft patches of server could interfere with this.
About this issue
- Original URL
- State: open
- Created a year ago
- Comments: 16 (5 by maintainers)
Commits related to this issue
- fix for #134 #131 — committed to spaghettidba/WorkloadTools by spaghettidba 8 months ago
- fix for #134 #131 — committed to a-teece/WorkloadTools by spaghettidba 8 months ago
Navigate to your installation folder of WorkloadTools (C:/ProgramFiles/WorkloadTools) and i think it is in one of the subfolders, there you will find .sql file and almost down there is EVENT_RETENTION_MODE, change the value to ALLOW_SINGLE_EVENT_LOSS (more on this here: https://learn.microsoft.com/en-us/sql/t-sql/statements/create-event-session-transact-sql?view=sql-server-ver16)