Running the Data Allocation

Search Knowledge Base by Keyword

< Back

To test or run the allocation directly from Test Modeller, rather than as part of an automation framework you can filter the allocated tests. Click on the filter button and choose the tests you want:

Running Data Allocation 1

Then, execute this test, choosing the server that connects to your system under test databases and applications.
Pick the job Data Allocate and click execute. This will submit a job to try and run the allocated tests you have defined for the filters you have chosen and is a good way to test that your criteria have been defined correctly.

Running Data Allocation 2

Once the test has run, the run results will show:

Running Data Allocation 3

Click to download this log and open it in an editor. Look through this log in detail, especially the first time you are running the allocate for a test type. An example log is shown below:

Running Data Allocation 4

An example SQL:

SQL=select top 500 CAST(id as VARCHAR(100)) from dbo.OPPORTUNITIES where ( (Opportunity_Type = ‘Existing business’ OR ‘Existing business’ = ”) and (Sales_Stage = ‘Needs analysis’ OR ‘Needs analysis’ = ”) and (Lead_Source = ‘Existing customer’ OR ‘Existing customer’ = ”)) and (CAST(id as VARCHAR(100))) not in (‘2EFCE793-2207-4798-ADB9-004B558D4B9A’)

2019-10-23 16:48:10-varSQlResults.count = 81 varI=3

If there is a problem with the SQL it will show up in here. You can then adjust the definition of the Test Type and retry running the allocation.

Next, return to the allocation pool and check the results are correct:

Running Data Allocation 5

If you click on the results button, it will show you the found values:

Running Data Allocation 6

If you click on the allocated test you will get further details:

Running Data Allocation 7

You have successfully run an allocated test.