Troubleshooting
Problem
Multiline string fields truncate in data-pull BIRT or Crystal Reports for IBM Rational ClearQuest when using Change Management (CM) Server as a data source.
Symptom
When you specify a BIRT report data source of type "ClearQuest", you can specify the connection to be "My Default ClearQuest Connection" or "Change Management Server". If you use "Change Management Server", multiline string fields in the report are truncated. If you select "My Default..." as the source, no truncation occurs.
This problem can also impact a Crystal Reports data-pull reports. This problem does not impact running the query or running a data-push report. Changing the Maximum String Length value in Site Administration for ClearQuest Web does not resolve the problem.
Resolving The Problem
This defect is resolved in Rational ClearQuest versions 7.1.1.4 and 7.1.2.1. Starting in those versions, a parameter named MaxMultiLineText can be added to the connection URL for the ClearQuest Reporting Driver to override the default length for multiline string fields.
For example: A connection used to report on strings up to 5000 characters has a connection URL of the following form:
jdbc:cq:MySchema/MyDatabase@http://My.CM.Server?MaxMultiLineText=5000
Crystal Reports users must append the "?MaxMultiLineText=5000" parameter suffix directly to the ClearQuest connection URL.
BIRT users must open settings for their ClearQuest data source and append "?MaxMultiLineText=5000" to the Change Management Server setting. For example:
Change:
http://localhost:12080/TeamWeb/services/Team
... to:
For convenience during Crystal Reports creation, the CRConfig.xml can be updated to include the URL parameter. For example:
<JDBCURL>jdbc:cq:MySchema/MyDatabase@http://localhost:12080/TeamWeb/services/Team?MaxMultiLineText=5000</JDBCURL>
Note: To take advantage of these reporting driver fixes, ClearQuest Reporting drivers must be redeployed for Crystal Reports Designer and Report Launcher. You must redeploy after first upgrading Rational ClearQuest to the specified Fix Packs.
Defect APAR PM43073 is under investigation to address Information Center documentation, and for a configurable Global CMserver MBean attribute rather than the per report usage of the MaxMultiLineText CM data source URL argument as introduced by APAR PM17616.
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21450880