A JDBC Data Set with an incorrect SQL statement causes the Virtual Service to fail with the following error:
Exception executing Step: Error doing random data sets
Trapped Exception: Database query problem
Is there a way to avoid the Test or the Virtual Service stopping.
Release : 10.4, 10.5, 10.6
Component : CA Service Virtualization
Options for preventing the Virtual Service failing are:
1) Test all SQL commands before putting the VS in production.
2) The JDBC step can identify that there is a problem with the SQL command without this step failing.
Configure the following field in the step to handle an invalid statement: If SQL error
An additional JDBC step can be added just before the JDBC data set. If there is a problem with the SQL command, then the JDBC data set can be bypassed.
3) Alternatively, replace the JDBC data set with the JDBC step. Looping through the results from the step may require some recoding.
The most common reason for getting the error 'Error doing random data sets' is running out of rows.