Applications Systems
Transaction in an Unknown status in WPM
Transaction are not played and status is unknown
First published date
6/24/2020 4:01 AM
Last published date
2/11/2025 9:05 PM
Overview
The Transaction is in an Unknown state and does not seem to have been played.
Other symptoms include screenshots consuming excess space on the Orion database server.
The error can be found in the AgentService.log (C:\ProgramData\SolarWinds\Logs\SEUM\Player).
ERROR SolarWinds.SEUM.Agent.Common.DAL.SQLiteDatabase - Encountered exception when processing database query.
code = Error (1), message = System.Data.SQLite.SQLiteException (0x800007BF): SQL logic error
table ScheduledPlayback has 8 columns but 6 values were supplied
The internal database on the WPM Player expands and blocks playback on a remote system.
As transactions play at scheduled intervals, WPM saves screenshots and playback results to a SQLite database on the remote system. Depending on the number and complexity of assigned transactions, the database file can grow rather large in the following default location (C:\ProgramData\SolarWinds\SEUM\Data\AgentStorage.s3db)
Other symptoms include screenshots consuming excess space on the Orion database server.
The error can be found in the AgentService.log (C:\ProgramData\SolarWinds\Logs\SEUM\Player).
ERROR SolarWinds.SEUM.Agent.Common.DAL.SQLiteDatabase - Encountered exception when processing database query.
code = Error (1), message = System.Data.SQLite.SQLiteException (0x800007BF): SQL logic error
table ScheduledPlayback has 8 columns but 6 values were supplied
The internal database on the WPM Player expands and blocks playback on a remote system.
As transactions play at scheduled intervals, WPM saves screenshots and playback results to a SQLite database on the remote system. Depending on the number and complexity of assigned transactions, the database file can grow rather large in the following default location (C:\ProgramData\SolarWinds\SEUM\Data\AgentStorage.s3db)
Product section
Web Performance Monitor
Cause
The AgentStorage.s3db file size grows continually (C:\ProgramData\SolarWinds\SEUM\Data).
Resolution
Recreate SQLite database on the WPM Player server.
- On the affected WPM Player, stop the SolarWinds WPM Playback Player service.
- Go to the C:\ProgramData\SolarWinds\SEUM\Data folder
- Make a backup of AgentStorage.s3db and other similar named files.
- Remove those files.
- Start the SolarWinds WPM Playback Player service.
- Observe playback results.