Getting Error while migrating existing RTC databases for RAM 7521
anoop mc (748●11●200●221)
| asked Nov 18 '14, 8:01 a.m.
edited Nov 18 '14, 8:04 a.m. by Krzysztof Kaźmierczyk (7.5k●4●80●103)
Hi,
We are having issues with RAM while upgrading to version 7521 from 7511.
Below are the steps which we have performed:
1. Upgraded the DB2 EE 9.7 to 10.1 on the server.
2. Updated the existing Databases (RAMDB and RTCDB) used with RAM 7.5.1.1 to sync with DB2 10.1
3. Tested the connection to DB2 10.1 databases from the RAM 7.5.1.1 instance. (RAM could recognize the DB2 version)
4. Uninstalled the existing WAS 7.0.0.33.
5. Re-installed WAS 8.5 on the server.
6. Uninstalled existing RAM 7.5.1.1.
7. Installed RAM 7.5.2.1.
8. Running the RAM Setup hooking to the new DB
9. Encountered issue while migrating existing RTC database.
|
9 answers
You could go to the folder to see the teamserver.properties content to see if the db type, db url, db user, db passwords are all correct.
This issue is thrown by RTC repotools. Maybe some RTC guy would give you answer.. Thanks . |
Hi Ary,
We have tried manually invoking the steps for migrating the db from 2.X to 3.X as per the instruction.
Still it failed when executed the command.
repotools-ramccm.bat -migration_ccm_updateConfigurationFiles oldApplicationHome="RTC 2.X" newApplicationHome="RTC3.X"applicationContextRoot=ramccm jtsContextRoot=ramjts updateTomcatFiles=no ignoreJTSVersionCheck
Referrinfg to a technote - http://www-01.ibm.com/support/docview.wss?uid=swg21634240 also gave me the same result.
In the log file I found the below line where it throws unexpected error.
2014-11-19 14:50:12,046 The bundle com.ibm.team.reports.jfs.configuration.nl1 is UNINSTALLED.
2014-11-19 14:50:12,062 java.util.zip.ZipException: Bad file descriptor E:\PROGRA~1\IBM\WEBSPH~1\APPSER~1\profiles\AppSrv01\config\cells\USTR-E~1\RTC\server1\v3013\jazz\server\conf\ramccm\sites\nl2-rtc-commons-update-site\features\com.ibm.team.rtc.update.site.content.rtc.feature.nls2_3.0.1.v20120326_2222.jar
|
I could resolve this error by reinstalling RAM 7.5.1.1 on top of WAS 8.0 and then doing an update of RAM to 7.5.2.1.
Also by changing the RTC 2.X and 3.X path to
RTC 3.X = E:/Program Files/IBMWebSphere/AppServer/profiles/AppSrv01/config/cells/USTR-ERL-3858Node01Cell/RTC/v3013/jazz/server
RTC 2.X= E:/Program Files/IBMWebSphere/AppServer/profiles/AppSrv01/config/cells/USTR-ERL-3858Node01Cell/RTC/v2002iFix6/jazz/server
Now it gives a different error
An in the log file I could see the DB Connection was successful but there seem to be a version mismatch error.
Another thing which I noticed is the fulltextindex error which says it should point to a absolute directory. I have verified the RTC 3.X teamserver.properties file and have updated the index file location to a directory on the drive - (E:\RAM\<folder> ) still the same error.
Message from the log file go as below.
Driver Architecture
Jdbc Driver Version: 3.57.82
2014-11-21 10:35:24,277 CRJAZ8192I: Fulltext Index Location: E:\Program Files\IBMWebSphere\AppServer\profiles\AppSrv01\config\cells\USTR-ERL-3858Node01Cell\RTC\v3013\jazz\server\conf\ccm\indices\workitemindex\fulltext_index
2014-11-21 10:35:24,277 CRJAZ8190I: The fulltext index should point to an absolute directory but is currently set to 'conf/ccm/indices/workitemindex'
2014-11-21 10:35:28,884 CRJAZ1042I The component has a server version mismatch between the installed code and the database.
Package URI == com.ibm.team.build
Installed Version == 11
Database Version == 8
2014-11-21 10:35:28,884 CRJAZ1042I The component has a server version mismatch between the installed code and the database.
Package URI == com.ibm.team.workitem
Installed Version == 16
Database Version == 11
2014-11-21 10:35:28,884 CRJAZ1042I The component has a server version mismatch between the installed code and the database.
Package URI == com.ibm.team.repository
Installed Version == 24
Database Version == 15
2014-11-21 10:35:28,884 CRJAZ1042I The component has a server version mismatch between the installed code and the database.
Package URI == com.ibm.team.apt
Installed Version == 8
Database Version == 7
Comments
anoop mc
commented Nov 22 '14, 9:31 a.m.
Hint:
What we are trying to do is - DB2 database backup for (UISRAMDB and RTCDB) has been taken from DB2 V 9.5 and restored on the current QA instance - DB2 10.1. After that created a new DB by name JTSDB in 10.1.
While running the RAM 7.5.2.1 setup we pointed to these database and during Migrate option ended up with the above error.
|
Hi, You could safely ignore this error... I am familliar with this error and always ignore it. I think you are approaching success.. Thanks a lot. |
Hi Ary,
Not sure how to go about from the step above as ,via the GUI interface we cannot proceed.
Do you recommend running the steps manually ignoring the one which gave error.
If I understand the issue lies at the point where we try to run the command to import Jazz Team Server user information into the Rational Team Concert database:
d)Run the following command to import Jazz Team Server user information into the Rational Team Concert database:
repotools-ramccm.bat -migration_importUserMapping fromMappingFile=rtc-mapping.txt teamserver.properties=conf/ramccm/teamserver.properties
e)Run the following command to rebuild text indexes:
repotools-ramccm.bat -rebuildTextIndices teamserver.properties=conf/ramccm/teamserver.properties
f)Run the following command to rebuild Lucene and RDF indexes:
repotools-ramccm.bat -reindex teamserver.properties=conf/ramccm/teamserver.properties
|
I ran the below command manually and got the below error.
repotools-ramccm.bat -rebuildTextIndices teamserver.properties=conf/ramccm/teamserver.properties
Running pre-rebuild index for "Fulltext"...
CRJAZ8240W: Index Directory not found or not existing (E:\Program Files\IBMWebSphere\AppServer\profiles\AppSrv01\config\cells\USTR-ERL-3858Node01Cell\RTC\v3013\jazz\server\"E:Program FilesIBMWebSphereAppServerprofilesAppSrv01configcellsUSTR-ERL-3858Node01CellRTC"\fulltext_index)
Rebuilding "Fulltext" indices...
Here I am doubting if we have to copy some Index folder along with DB backup copied from the older RAM Server.
|
Since, using the server setup wizard I could not proceed further I have decided to run the commands manually as per the instructions present on the window.
For RTC 3.X I ran the below command and it ended with the below line in log file.
repotools-ramccm.bat -rebuildTextIndices teamserver.properties=conf/ramccm/teamserver.properties
2014-11-24 05:49:55,974 CRJAZ8240W: Index Directory not found or not existing (E:\Program Files\IBMWebSphere\AppServer\profiles\AppSrv01\config\cells\USTR-ERL-3858Node01Cell\RTC\v3013\jazz\server\"E:\Program Files\IBMWebSphere\AppServer\profiles\AppSrv01\config\cells\USTR-ERL-3858Node01Cell\RTC"\fulltext_index)
2014-11-24 05:49:55,974 Rebuilding "Fulltext" indices...
2014-11-24 05:49:55,974 Rebuilding indices for Fulltext took 0 ms.
Ignored this message then proceed with RTC 4.X
repotools-ramjts.bat -addTables teamserver.properties=conf/ramjts/teamserver.properties noPrompt - Which ran successfuly and output says
Database tables were added successfully.
Similarily for
repotools-ramccm.bat -addTables teamserver.properties=conf/ramccm/teamserver.properties noPrompt
Getting the below error message.
2014-11-24 06:21:45,532 CRJAZ2464E You cannot directly migrate to this release because your database is from an older, unsupported release. For more details, open the help and search for CRJAZ2464E.
2014-11-24 06:21:45,532 CRJAZ2464E You cannot directly migrate to this release because your database is from an older, unsupported release. For more details, open the help and search for CRJAZ2464E.
com.ibm.team.repository.common.TeamRepositoryException: CRJAZ2464E You cannot directly migrate to this release because your database is from an older, unsupported release. For more details, open the help and search for CRJAZ2464E.
Any suggestions here. Now I am not sure how to proceed further.
|
Hi, If you want to manually migrate, this is a details instructions... Please follow it as below. 1. In order to migrate RTC from 2.X to 4. We are going to need the RTC 3.X and RTC 4.X zip The default locations for the files are <Rational_Asset_Manager_install_directory>/ram/apps/was 2. These instructions assume that RTC 2002 is extracted at C:/IBM/WebSphere/AppServer/profiles/profile1/config/cells/etkCell/RTC/server1/v2002iFix6 3. If you are not using Server Setup extract RTC-Server_3013.zip to C:/IBM/WebSphere/AppServer/profiles/profile1/config/cells/etkCell/RTC/server1/v3013 otherwise verify that server setup has extracted the files there 4. If you are not using Server Setup extract RTC-Server_40RC3.zip to C:/IBM/WebSphere/AppServer/profiles/profile1/config/cells/etkCell/RTC/server1/v40RC3 otherwise verify that server setup has extracted the files there 5.RTC 3.0/4.0 needs 2 databases to run. The CCM (which will be our RTC database from RTC 2.x) and the JTS database. Since you are migrating from 2.0, you already have a RTC database. If you are not using Server Setup go ahead and create the JTS database, if not verify that a database has been created Consult CLM documentation create the JTS database for Oracle, possibly just need to add a schema like jtsschema 6. Open a command window and go to the C:/IBM/WebSphere/AppServer/profiles/profile1/config/cells/etkCell/RTC/server1/v3013/jazz/server directory. Type the following commands a)set RTC2=C:/IBM/WebSphere/AppServer/profiles/profile1/config/cells/etkCell/RTC/server1/v2002iFix6/jazz/server b)set RTC3=C:/IBM/WebSphere/AppServer/profiles/profile1/config/cells/etkCell/RTC/server1/v3013/jazz/server c)set RTC4=C:/IBM/WebSphere/AppServer/profiles/profile1/config/cells/etkCell/RTC/server1/v40RC3/jazz/server 7. Copy the ramjazz or jazz folder at %RTC2%/conf to ramccm 8.Edit the file %RTC2%/conf/ramccm/teamserver.properties a)Add/edit the following properties com.ibm.team.repository.db.vendor=ORACLE com.ibm.team.repository.db.type=JDBC com.ibm.team.repository.db.jdbc.location=thin\:rtcschema/{password}@databaseServer\:1521\:SID com.ibm.team.repository.db.jdbc.password=rtcschema where rtcschema is the schema user of your RTC database in RTC 2.x b)Enter the URL of your RTC server in RTC3/4, and RTC 3/4 does not support changing the URL once the databases have been migrated therefore great care must be taken to ensure that this is the right URL of RTC. Add the following property com.ibm.team.repository.server.webapp.url=https\://server\:port/ramccm com.ibm.team.datawarehouse.db.automatic.setup=false c)Delete the property, if it exists com.ibm.team.repository.db.j2ee.dataSource=jdbc/RTC_Con d)Save and close the file 9. Run the following commands to migrate the RTC/CCM database a)Set the environment variable JAZZ_PROVISION_PROFILES as shown below set JAZZ_PROVISION_PROFILES=%RTC3%/conf/ramccm/provision_profiles b)Run the following command to migrate your 2.0 teamserver.properties to the 3.0 directory: repotools-ramccm.bat -migration_ccm_updateConfigurationFiles oldApplicationHome="%RTC2%/conf" newApplicationHome="%RTC3%/conf" applicationContextRoot=ramccm jtsContextRoot=ramjts updateTomcatFiles=no ignoreJTSVersionCheck c)Creat a directory called 'oracle' and copy the ojdbc14.jar to %RTC3%\oracle directory, this jar is in a similar location in the RTC 20 directory, if not download it from the internet. its important that you do not rename other jars like ojdbc5.jar/ojdbc6.jar to ojdbc14.jar, they are compiled differently and may not work. mkdir oracle copy "%RTC2%/oracle/ojdbc14.jar" oracle d)Run the following command to add tables to the database: repotools-ramccm.bat -addTables teamserver.properties=conf/ramccm/teamserver.properties noPrompt e)Run the following command to export user information from the Rational Team Concert database: repotools-ramccm.bat -migration_exportJTSData toFile=jtsData.tar teamserver.properties=conf/ramccm/teamserver.properties overwrite=yes 10.Edit the file %RTC3%/conf/ramjts/teamserver.properties *Note some of these properties might already be there in the file, if present remove the duplicates a)Add/edit the following properties com.ibm.team.repository.db.type=JDBC com.ibm.team.repository.db.vendor=ORACLE com.ibm.team.repository.db.jdbc.location=thin\:jtsschema/{password}@databaseServer\:1521\:SID com.ibm.team.repository.db.jdbc.password=jtsschema where jtsschema is the schema user for the JTS database that we created earlier. b)Enter the URL of your JTS server in RTC3/4, and RTC 3/4 does not support changing the URL once the databases have been migrated therefore great care must be taken to ensure that this is the right URL of RTC. Add the following property if this does not already exist *Note some of these properties might already be there in the file, if present remove the duplicates com.ibm.team.repository.server.webapp.url=https\://server\:port/ramjts c)Save and close the file 11. a)Set the environment variable JAZZ_PROVISION_PROFILES as shown below set JAZZ_PROVISION_PROFILES=%RTC3%/conf/ramjts/provision_profiles b)Run the following command to import user information into the Jazz Team Server database: repotools-ramjts.bat -migration_importJTSData fromFile=jtsData.tar teamserver.properties=conf/ramjts/teamserver.properties createMappingFile=rtc-mapping.txt createTables overwrite=yes noPrompt c)Set the environment variable JAZZ_PROVISION_PROFILES as shown below set JAZZ_PROVISION_PROFILES=%RTC3%/conf/ramccm/provision_profiles d)Run the following command to import Jazz Team Server user information into the Rational Team Concert database: repotools-ramccm.bat -migration_importUserMapping fromMappingFile=rtc-mapping.txt teamserver.properties=conf/ramccm/teamserver.properties e)Run the following command to rebuild text indexes: repotools-ramccm.bat -rebuildTextIndices teamserver.properties=conf/ramccm/teamserver.properties f)Run the following command to rebuild Lucene and RDF indexes: repotools-ramccm.bat -reindex teamserver.properties=conf/ramccm/teamserver.properties 12. You have migrated RTC 2.0 to CLM 3.0 (RTC3.0) 13. Now we need to migrate CLM 3.0 to CLM 4.0 14. Copy your application configuration files from 3.X to 4.X, overwrite when prompted In the command window go to the %RTC4% directory. Type the following commands a)copy "%RTC3%/conf/ramjts/teamserver.properties" conf/ramjts b)copy "%RTC3%/conf/ramccm/teamserver.properties conf/ramccm In windows, copy the files through windows explorer c)Create a directory called 'oracle' and copy the ojdbc6.jar to %RTC4%\oracle directory, this jar is in a oracle install dir, if not download it from the internet. its important that you do not rename other jars like ojdbc14.jar/ojdbc5.jar to ojdbc6.jar, they are compiled differently and may not work. mkdir oracle copy oracle\ojdbc6.jar 15.Edit the file %RTC4%/conf/ramjts/teamserver.properties a)Add/edit the following properties com.ibm.team.repository.setup.completed.setup=true b)Save and close the file 16. Migrate your JTS and RTC/CCM databases from 3.0 to 4.0 by adding tables to the database. a)Set the environment variable JAZZ_PROVISION_PROFILES as shown below set JAZZ_PROVISION_PROFILES=%RTC4%/conf/ramjts/provision_profiles b)Run the following command to migrate the JTS database: repotools-ramjts.bat -addTables teamserver.properties=conf/ramjts/teamserver.properties noPrompt c)Set the environment variable JAZZ_PROVISION_PROFILES as shown below set JAZZ_PROVISION_PROFILES=%RTC4%/conf/ramccm/provision_profiles b)Run the following command to migrate the RTC/CCM database: repotools-ramccm.bat -addTables teamserver.properties=conf/ramccm/teamserver.properties noPrompt 17. You have successfully migrated your databases from 3.0 to 4.0. 18. If you are using the Server setup, click on Test Migration to verify whether the databases have been migrated. Comments
One thing I concerned is that RTC 401 does not support db2 10.1. Why RAM said 7521 support RTC 401 is because we test it on db2 10.1 with RTC 401 , it works and has no problem. But I think we missed testing migration on 10.1...
anoop mc
commented Nov 24 '14, 8:58 p.m.
Hi Ary,
If that is the case the ramjts worked fine with out any issues.
|
Hi All,
We have sorted the issue by following the below order of installation and configuration.
1. Upgraded the DB2 EE 9.7 to 10.1 on the server.
2. Updated the existing Databases (RAMDB and RTCDB) used with RAM 7.5.1.1 to sync with DB2 10.1
3. Tested the connection to DB2 10.1 databases from the RAM 7.5.1.1 instance. (RAM could recognize the DB2 version)
4. Uninstalled the existing WAS 7.0.0.33.
5. Re-installed WAS 8.5 on the server.
6. Installed RAM 7.5.1.1
7. Configured RAM 7.5.1.1 (this step was missing earlier) without configuring we upgraded directly.
8. Updated to RAM 7.5.2.1
9. Migrated RTC DB from 2.x to 3.x then to 4.x (Note: This was the road block hit during Migration )
10. Once done configured LDAP.
11. Performed a DB2 Migration which included WAS configuration.
12. Performed a Forced Synchronization of RAM Indexes.
During LifeCycle Project Configuration if you face any issue please follow the technote
Technote: http://www-01.ibm.com/support/docview.wss?uid=swg21644301
Also for the migration Error: DSRA9110E: ResultSet is closed we followed the steps on the link mentioned below:
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.
Comments
Verifying the logs in ramccm.log file I see the below information