When clicking on the Assigned Test Definitions tab in the Requirements section none of the Test Definitions are displayed despite the requirement having many Test Definitions assigned to it.

In the screenshot below it shows the Document View of a Requirement that has 1248 Test Definitions assigned to it.



However if you then go to the Requirements View and click on the Assigned Test Definitions tab for the requirement you will see the following:



As you can see none of the Assigned Test Definitions are displayed here. If you then go to the Administration – Reports and click on the Front-end Server Log tab you will see message like those below:



The relevant lines in this log file are:

“E;OV;2010-04-29;20:02:05;TM;http-19120-3;com.segue.tm.common.businesslayer.activities.ActivitiesServiceException: java.sql.SQLException: ORA-01795: maximum number of expressions in a list is 1000”

This issue is caused by a limitation in Oracle in which certain query types can only return a maximum of 1000 values. In this case it should return 1248 and so the error is flagged in the FrontEndServer.log file.

The workaround for this issue is to assign less than 1000 Test Definitions to a Requirement.

Alternatively there is Hotfix 08 created for SilkCentral Test Manager 2009 SP1 that uses a different query that can handle more than 1000 expressions being returned and as such it resolves the issue. To obtain this hotfix please contact Micro Focus Customer Care.