IBM Support

All Rational Change users have lost queries and reports after upgrade

Technote (troubleshooting)


After upgrading IBM Rational Change, all queries and reports have been lost.


This issue is seen because all saved queries and reports, as well as shared reports and queries are stored in the LDAP (Rational Directory Server) profile as database specific. 
For example: If the database path changes, the LDAP needs to be updated.

Resolving the problem

In order to see your personal queries and reports after changing the database path, the following perl script must be run. The script requires you set two environment variables.



    c:\>set PERL5LIB=

    Note: Clear PERL5LIB on Windows as Perl can figure this out on its own.


    $ setenv PERL5LIB CHANGE_APP_HOME/WEB-INF/perl/lib/perl5/5.8.6:CHANGE_APP_HOME/WEB-INF/perl/lib/perl5/site_perl/5.8.6



    $ setenv LD_LIBRARY_PATH CHANGE_APP_HOME/WEB-INF/perl:CHANGE_APP_HOME/WEB-INF/perl/lib/perl5/5.8.6/aix-multi/CORE


    $ setenv LD_LIBRARY_PATH CHANGE_APP_HOME/WEB-INF/perl:CHANGE_APP_HOME/WEB-INF/perl/lib/perl5/5.8.6/i686-linux-multi/CORE


    $ setenv LD_LIBRARY_PATH CHANGE_APP_HOME/WEB-INF/perl:CHANGE_APP_HOME/WEB-INF/perl/lib/perl5/5.8.6/sun4-solaris-multi/CORE



All source code and/or binaries attached to this document are referred to here as "the Program". IBM is not providing program services of any kind for the Program. IBM is providing the Program on an "AS IS" basis without warranty of any kind. IBM WILL NOT BE LIABLE FOR ANY ACTUAL, DIRECT, SPECIAL, INCIDENTAL, OR INDIRECT DAMAGES OR FOR ANY ECONOMIC CONSEQUENTIAL DAMAGES (INCLUDING LOST PROFITS OR SAVINGS), EVEN IF IBM, OR ITS RESELLER, HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.

Change the values of hostname, port number, username, password and database path as explained below:  

    use ChangeSynergy::csapi;

    my $csapi = new ChangeSynergy::csapi();



      $csapi->setUpConnection("http", "hostname", 8600);

      my $aUser = $csapi->Login("user name", "password", "Admin", "database path");

      $tmpData = $csapi->PreferenceNameSubstitutionForAllUsers($aUser, "old database path", "new database path");

        print $tmpData->getResponseData();


      if ($@)


      print $@;




    • "hostname" is the hostname of the server where you would be running this script.
    • 8600 is the port where Rational Change is installed.
    • "user name" is the User with admin privilege
    • "password" is the password of the user mentioned above
    • "Admin" is the Role.  This should be left as Admin.
    • "database path" is the db path used for this installation.   
      Where Rational Synergy is installed on UNIX, this is the normal path, such as /data/ccmdb/tutorial.
      On Windows, each \ must be escaped with another \, for example " \\host\ccmdb\cm_database" becomes "\\\\host\\ccmdb\\cm_database"
    • "new database path" is same as the db path mentioned above
    • "old database path" is the old database path

Note: This solution is applicable regardless of which version of Rational Directory Server is used.

Document information

More support for: Rational Change
Directory Server

Software version: 5.2,,,,,,,,,,,,,,, 5.3.1,

Operating system(s): Linux, Solaris, Windows

Reference #: 1417084

Modified date: 07 January 2010