ReplayConsumer not updating database about workloadtools HOT 2 OPEN

Hi Simon,
Your process looks ok, so I'm not really sure what could be the problem there.
Does the sqlite database contain the commands you expect to run? Maybe they were not captured. Just a guess.
Can you please check?

from workloadtools.

Yes it does, the 55000 events are queries associated with the required databases, think there were double that when I included other databases.

When I run this query on the sqlite database I get 10888 records, so it has recorded the details.
SELECT COUNT(*) FROM EVents WHERE sql_text like '%INSERT%' AND database_name = 'TMS'

Question, this is recorded about the ReplayConsumer

WorkloadTools.Consumer.Replay.ReplayConsumer : All future delays will be calculated from this point + 1s, triggered by event {"Text":"use [PROD DATABASE NAME]\n", "SPID":346, "ApplicationName":".Net SqlClient Data Provider", "DatabaseName":"[PROD DATABASE NAME]", "LoginName":"[PROD SQL Login Name]", "HostName":"[PROD APPS SERVER NAME]", "Reads":0, "Writes":0, "CPU":0, "Duration":123, "EventSequence":1, "ReplayOffset":0, "StartTime":"2023-12-17T10:49:49.6990329Z", "Type":"RPCStarting"}

What does this mean, as it is listing production details, which do not exist in the Target, e.g. the production user does not exist on the target server.

Grasping at straws here.

from workloadtools.