IBM Support

Utilizing 2048+ build definitions in RTC results in SQL errors

Technote (troubleshooting)


Problem(Abstract)

Attempts to utilize 2048+ build definitions in IBM Rational Team Concert results in SQL errors.

Symptom

The following exceptions may be observed:

If a build engine is associated to more than 2048 build definitions, a IllegalArgumentException is thrown like so:
[ ccm: AsynchronousTaskRunner-1] ERROR com.ibm.rational.buildforge.buildagent              - Item Handle array cannot exceed 2048 elements.
java.lang.IllegalArgumentException: Item Handle array cannot exceed 2048 elements.


If a client is using a SQL server database and more than 2100 build definitions are created:
com.ibm.team.repository.common.InternalRepositoryException: CRJAZ0368I A SQL query failed to execute properly on the server.
  stmt = select t1.ITEM_ID, t1.STATE_ID from BUILD.BUILD_REQUEST t1 where ((t1.PROCESSED = 0) and t1.BUILD_DEFNTN_NSTNC_BLD_DFNTN_D  in(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
::SNIP::
Caused by:
com.microsoft.sqlserver.jdbc.SQLServerException: The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Too many parameters were provided in this RPC request. The maximum is 2100.


Cause

This has been identified as a product defect under APAR PM82183 and APAR PM81312, tracked via jazz.net Defect 211332 (fixed in 4.0.2) and Defect 250557 (fixed in 4.0.3).


Resolving the problem

These defects have been cumulatively resolved in Rational Team Concert 4.0.3. It is suggested you upgrade to 4.0.3 as no workaround exists in earlier versions.

Leverage the Jazz Community

The Jazz based products have an active community that can provide you with additional resources. Browse and contribute to the User forums, contribute to the Team Blog and review the Team wiki.
Refer to technote 1319600 for details and links.

Document information

More support for: Rational Team Concert
Build

Software version: 3.0, 3.0.1, 3.0.1.1, 3.0.1.2, 3.0.1.3, 3.0.1.4, 3.0.1.5, 4.0, 4.0.0.1, 4.0.0.2, 4.0.1

Operating system(s): AIX, Linux, Solaris, Windows

Reference #: 1626864

Modified date: 26 February 2014


Translate this page: