When running a job within Benchmark Factory that reads usernames from a file, and queries a view, reading an identifier from another file from which both use BFFileArray, this gives the error Error: Unhandled exception C0000005 occurred in one of the user thre
I can still get it to work by generating the identifier within the query, so that you do not have to use the second file:
select ....
from <view>
where appno=(select max(appno) from <view>)
Originally I was using
where appno=$BFFileArray(C:\"\B16.csv",SEQUENTIAL,3)
(different file for each user)
Replacing the attached file in the Bin directory on both the machine running any console or any BMF agent machine should resolve the issue.
Here is how to replace the BFScripts.dll file:
1. Close BMF and the agent
2. Navigate to C:\Program Files\Quest Software\Benchmark Factory for Databases\bin and make a backup copy of BFScripts.dll.
3. Copy the new BFScripts.dll into the bin directory.
4. Rerun the test.
