If you are using Rational Team Concert (RTC) 22.214.171.124 and an Oracle database, trying to load a plan with more than 1000 work items may fail.
Here are the symptoms and errors:
a. In the web client, it shows the below error:
Error - [object Object]: CRJAZ0368I A SQL query failed to execute properly on the server stmt = select1.SOURCE_ITEM_ID, t1.TARGET_ITEM_ID, t1.NAME from JAZZDBUSER.LINK_CLOSURE_RELATION t1 where (t1.SOURCE_ITEM_ID in
b. In the Eclipse client, it gives the warning that it has more than 1000 work items.
The plan contains more than 1000 work items. Please split the plan by assigning work items to other iterations or team areas
However, ignoring the warning still doesn’t help in loading the workitems on the planned items tab.
c. The complete error is as follows:
com.ibm.team.repository.common.TeamRepositoryException: CRJAZ0586I Query is too complex (10695 parameters).
Caused by: java.lang.UnsupportedOperationException: CRJAZ0586I Query is too complex (10695 parameters).
If the working environment is a combination of RTC 126.96.36.199 version and Oracle database only and this issue is encountered, one has come across a known defect.
Learn how to set up an IBM Rational Team Concert main build that performs an IBM Rational Developer for System z code review. Based on the result of the code review, the process either submits the build to compile, or stops and reports the code review errors. Apply the tested, documented sample described in this article to implement a similar solution on your own platform. The steps focus on the Rational Team Concert administrator who writes an Ant task to compile COBOL programs, depending on other previous tasks, such as quality control.
Figure 1. Technical context for the sample scenario:
About the Author: Corinne Blanchard has 20 years of experience in the application development field (Cobol, Pacbase, J2EE). In the last six years she has worked for IBM on Rational products as a client technical professional and team leader for Rational Enterprise Modernization tools. In 2010, she contributed to the IBM Redbooks IBM WebSphere RFID handbook: A solution guide and IBM WebSphere RFID handbook: A programming guide. In 2013, she wrote a workbook that explains the basics of IBM Rational Programming Patterns.
Clearcase Version Importer: Migrate to Rational Team Concert Source Control Management- A new, simpler tool for importing ClearCase version history into Rational Team Concert (RTC) was introduced in RTC 4.0.5. This is a new stand-alone tool that does not require ClearCase synchronization to be set up to use it. This presentation will first provide an overview of the difference between ClearCase and RTC SCM, then talk about the new migration tool and its enhanced capability in upcoming RTC release. You will understand how the tool can help you migrating the data successfully and it concludes with a live demo of the migration tool.
Clean Rational Team Concert build workspaces
When multiple builds run on multiple machines the process of maintaining the infrastructure can become a problem. In this article you will learn how an automated build cleaning process can improve the continuous integration environment and reduce manual maintenance.
Do yourself a favour and take a moment to read through his automated solutions and get started on that Spring cleaning a bit early, before your competitors, and get that build workspace spotless so you and your developers can work without the clutter.
One of the queries that I received, while working on IBM Rational Team Concert (RTC) is this:
I would like to change the configured Active Directory (AD) location (domain controller) of the Jazz Team Server.
Can we just change the LDAP Registry Location setting in the Advanced Properties in JTS and do we have to restart the server?
Firstly, I asked the user to confirm that by changing the configured AD location, it does not involve a change in the public URI for the Jazz team server.
(i.e. change in either the fully qualified domain name in the URI or the hostname).
He did confirm that they only want to change to another domain controller running Active Directory and containing the same user information.
No changes in the Jazz Team server location or the hostname.
==> Essentially to achieve this, you must do the following:
1. Change the LDAP location in the Jazz Server properties.
Login to JTS as admin: https: //<host_name>:9443/jts/admin
Go to server --> Advanced Properties;
Look for these two services and update with the latest parameters: -----
2. Change the LDAP host in Websphere Application Server (WAS).
3. Redo the Security role to user/group mappings in WAS because of the realm change.
For a demonstration on how to accept multiple change sets with a gap in the RTC 4.0.5 Client for Microsoft Visual Studio ID, as well as other gap related features that were not mentioned in this video, please visit the following page: http://youtu.be/ysEY95_OOwY
Please also see the following videos which show similar features in the RTC Client for Eclipse IDE:
Users using IBM Rational Team Concert (RTC) might have a concern, in that the shared queries seen within Eclipse client are not visible in the web-client for a given user.
Shared queries are set up under the Team Area under each project in RTC Eclipse client. To see them in the Web UI, one needs to add the user to that team area, so that the shared folder and queries are visible.
The web client checks that you are a Team member very strongly, as opposed to the Eclipse client. If a user is not listed as a team member, even though he is the query author and the one who shared a query, it will not show on the web.
As a work-around, in personal dashboard one can add a query widget which shows all queries from different teams. In general, the RTC Development team believed that web views should only list the 'Shared in Team' queries where the user is a member of the team.
We've run the numbers for November and have collated the top twenty technotes which were published, used, and reused to solve your Rational Team Concert PMRs last month. Here they are below to help you and others solve or even preferably avoid the same issues:
We're knee deep into fall now, and well into November already! How did that happen? I'm not sure of the time-space continuum shift that has truncated this year, but what I am sure of is that our awesome developerWorks authors have been steadily publishing their great articles regardless of how short or long the year has seemed... Here are the latest articles from the past few weeks which have gone live on Rational developerWorks:
Analyzing data in an agile world By: Scott Snyder, Senior Performance Architect, IBM
Learn to interpret test results in an adaptable way. Scott Snyder shows you the techniques and tooling that should make data analysis more interactive. Product: IBM Rational Team Concert
Develop a hybrid mobile application using Rational Application Developer By: Hamid Kalantari, Staff software engineer, IBM
Top 10 modeling hints for system engineers: #10: Forget 7 ± 2 By: Bruce Douglass, Rational Chief Evangelist, Systems Engineering, IBM
Bruce Douglass gives one hint a week to help you with modeling. This 10-week series starts with #10: Forget 7 ± 2 Products: IBM Rational Rhapsody, IBM Rational System Architect, IBM Rational Software Architect
Debugging optimized code By: Rajan Bhakta, Technical Architect, z/OS XL C/C++ compilers, IBM
Rajan Bhakta gives you ways to make the right tradeoffs to get the easiest possible debugging and fastest possible optimization. Products: IBM C/C++ Compiler
Adopting the IBM DevOps approach By: Paul Bahrs, Chief Architect, Emerging technologies, IBM
This practice-based framework will help you assess your current practices and build a roadmap to DevOps adoption.
Be smart with virtualization, Part 2 By: Mike Donati, ClearCase Performance Team Lead, IBM, Ryan Smith, Software Performance Analyst, IBM, and Grant Covell, Senior Development Manager, Rational Performance Engineering, IBM
Part 2 of this article series brings you even more best practices for using IBM Rational software in virtualized environments. Products: IBM Rational Team Concert, IBM Rational ClearCase
IBM SmartCloud Enterprise and V9 Rational IDEs simplify application development By: Jean-Yves B. Rigolet, Rational IDE Cloud Architect and Lead, IBM
The new Version 9 rational IDEs are now available on the Smart Cloud Enterprise. No more install and configuration, just continuous access to your development environment from multiple devices. Learn more from Jean-Yves Rigolet. Products: Rational Developer for System z, Rational Developer for Power, IBM Rational Software Architect, IBM Rational Application Developer, IBM Rational Team Concert
Server-side mobile application development By: Bhargav Perepa, WebSphere Architect and IT Specialist, IBM
A five-part article series that explains how to use IBM Rational Application Developer for WebSphere Software and IBM® Worklight together to develop applications for mobile devices. Bhargav Perepa walks you through the entire process. He provides application and sample configuration files to guide you through the steps. Products: IBM Rational Application Developer, IBM Worklight
One of the IBM Rational Team Concert (RTC) users, having an integration with Focal Point (FP) were planning to move the production database
to test. On refreshing the test database, as they had RTC-FP integration in production, the same links would be preserved in the artifacts in test.
They had a concern if these links will be preserved in RTC, even in the test area after refresh. Of course, they would edit the Friends connection,
to point to the Test.
Here are the steps that I suggested and one of which was successfully used by the customer to isolate production from test (step 2).
The RTC links will be preserved in the Test area after refresh.
If the plan is to have a Test environment without the RTC links (in test database) to point to the production data, there are 2 options one can choose from.
Isolate the production and the test environment at network level.
Below are the details of each of these options:
1. Server Rename
Server rename is one of the approaches to achieve this. However, this has it's drawbacks and risks, explained in the links below:
This should definitely be the last approach one can take, after raising a Problem Management Record (PMR) with IBM Rational Support.
a. Server rename and the things to be aware before proceeding:
NOTE: One needs to make sure that there are no possibilities of communication exchange between the test and production servers at all.
a. First, ensure that production and test servers are isolated at the network level so that any communication attempt is blocked.
This is to make sure the Test environment should not insert or update anything on the production environment.
b. Install CLM applications, Websphere Application Server (WAS), database on the test server following the usual methods.
c. Restore the copy of production databases in the test server.
d. Ensure the password of the database user (which is used in the CLM applications to connect to the database) is different than in
production. This can be the DB instance user, if one has used so.
Now, one needs to tell the server on how to connect to the new databases (the ones which were restored in Test environment), where the password
To get the encrypted password:
f. Run the jts/setup till Step 3 - Configure Database and
look at the jts/teamserver.properties file (which should now be in the process of getting regenerated) for the encrypted password.
Copy it in a word editor. The property name to look for the password is
g. Copy over the entire .../server/config directory from the production server to the Test server and open each of the teamserver.properties
file and update the password as noted in the above step.
i. Create an entry for production server in /etc/hosts file of test server.
Start the application in WebSphere and test.
NOTE: It is best to test this when production environment is offline or down for maintenance to avoid any unforeseen problems.
At this stage, the Test environment can only be accessed from test server and not from any clients, as the DNS is unaware of the alias in
To access the Test Environment, users can put a similar entry in their respective machines /etc/hosts file to point it to the Test environment.