Getting error "Agent Error" when using custom load scenario when using a variable in the select S (4320180)

When running select SQL scripts as part of a customer load scenario in Benchmark Factory for Databases, I am getting the error "Agent Error".

To use the setting of variables in the first query you will need to be running all the queries inside a user scenario so that you can guarantee that the statement with all the setting of variables are executed first. A user scenario tells BMF to run all of it's statements in the order as shown. So your test would look like:

Custom Load Scenario
User Scenario
Query 1
Query 2
.
.
Query n

If you run the queries inside a mix test without being inside a user scenario, the test will randomly pick for all virtual users what statements to run next. So Query 1 may not be the first statement that a particular virtual user will execute and thus you will get an error running Query 2. Now you will get errors until the virtual user executes Query 1 and from then on Query 2 will execute without error.