RQM 2.0.1 iFix05 repotools export hanging
Hello RQM experts
I have RQM 2.0.1 iFix005 installed on Windows Server 2003. I need to run repotools export -toFile command to export the data to a tar file.
JTS is configured to run as Windows service. Before running the command I stopped Jazz Team Service from Start, Programs, RQM 2.0.1. I didn't stop the Windows service. I ran repotools export and it was hanging at the step below. Is it possible JTS is still running if it is not stopped from Windows Service and stopped from Start,Programs, RQM 2.0.1 ? Any help is greatly appreciated.
E:\Program Files\IBM\RQM201\server>repotools.bat -export toFile=E:\export.tar
Repo Tools
Rational Quality Manager, Version 2.0.1 iFix 5 (I20101011_1426)
Jazz Foundation - Jazz Team Server, Version 1.0.0.2 iFix 4 (I20100903-0816)
Rational Jazz Team Server (RQM) - Enterprise
CRJAZ1363I Loading configuration from "file:conf/jazz/teamserver.properties".
CRJAZ1365I Attempting Initial Database Connection Using
Db Name/Location: thin:xxxxxxxx/xxxxxxxx@//orcldb-prod-p01.<DB>:1521/
pbft
CRJAZ1364I Initial database connection successful
Db Product Name: Oracle
Db Product Version: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0
- 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
Db URL: jdbc:oracle:thin:jazzDBuser/NewYork90@//orcldb-prod-p01.<server>:
1521/pbft
Jdbc Driver Name: Oracle JDBC driver
Jdbc Driver Version: 10.2.0.4.0
CRJAZ8192I: Fulltext Index Location: E:\workitemindex\fulltext_index
The user "ADMIN" has logged in to the database "thin:xxxxxxxx/xxxxxxxx@//orcldb-
prod-p01.<server>:1521/pbft".
Exporting the data from the database "thin:xxxxxxxx/xxxxxxxx@//orcldb-prod-p01.<server>:1521/pbft" to the file "E:\export.tar".
Using encoding "windows-1252"
I have RQM 2.0.1 iFix005 installed on Windows Server 2003. I need to run repotools export -toFile command to export the data to a tar file.
JTS is configured to run as Windows service. Before running the command I stopped Jazz Team Service from Start, Programs, RQM 2.0.1. I didn't stop the Windows service. I ran repotools export and it was hanging at the step below. Is it possible JTS is still running if it is not stopped from Windows Service and stopped from Start,Programs, RQM 2.0.1 ? Any help is greatly appreciated.
E:\Program Files\IBM\RQM201\server>repotools.bat -export toFile=E:\export.tar
Repo Tools
Rational Quality Manager, Version 2.0.1 iFix 5 (I20101011_1426)
Jazz Foundation - Jazz Team Server, Version 1.0.0.2 iFix 4 (I20100903-0816)
Rational Jazz Team Server (RQM) - Enterprise
CRJAZ1363I Loading configuration from "file:conf/jazz/teamserver.properties".
CRJAZ1365I Attempting Initial Database Connection Using
Db Name/Location: thin:xxxxxxxx/xxxxxxxx@//orcldb-prod-p01.<DB>:1521/
pbft
CRJAZ1364I Initial database connection successful
Db Product Name: Oracle
Db Product Version: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0
- 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
Db URL: jdbc:oracle:thin:jazzDBuser/NewYork90@//orcldb-prod-p01.<server>:
1521/pbft
Jdbc Driver Name: Oracle JDBC driver
Jdbc Driver Version: 10.2.0.4.0
CRJAZ8192I: Fulltext Index Location: E:\workitemindex\fulltext_index
The user "ADMIN" has logged in to the database "thin:xxxxxxxx/xxxxxxxx@//orcldb-
prod-p01.<server>:1521/pbft".
Exporting the data from the database "thin:xxxxxxxx/xxxxxxxx@//orcldb-prod-p01.<server>:1521/pbft" to the file "E:\export.tar".
Using encoding "windows-1252"
2 answers
Hi,
I am not sure the post shows all the data you put in.
I have seen instances where servers did not shut down properly. With WAS I have seen that the WAS service is sometimes shut down, but java processes are still running (you can identify then, because they run the WAS java JRE which is visible in the properties.). Was would not start again, if that would be the case either. In those cases, kill the mentioned process trees.
I am not sure the post shows all the data you put in.
I have seen instances where servers did not shut down properly. With WAS I have seen that the WAS service is sometimes shut down, but java processes are still running (you can identify then, because they run the WAS java JRE which is visible in the properties.). Was would not start again, if that would be the case either. In those cases, kill the mentioned process trees.
Hi RQM exprts
The problem with repotools export from RQM 2.0.1 Oracle DB in my environment is still an issue. I have a PMR open with Rational tech support. The DBA here ran AWR report on Oracle DB and sent to tech support. I generated a trace during export and sent it to tech support. We were told by tech support our Oracle database for RQM 2.0.1 is missing around 1691 indexes. The DBA here found it is missing 7 tables as well. It appears the tool in RQM 2.0.1 that created the tables has a bug which caused the problem with missing indexes and tables. We are surprised how RQM 2.0.1 even worked on Oracle 10G.
If the problem is due to bug in the tool there must be other users of RQM 2.0.1 on Oracle 10 G who have problem with repotools export.
I'll run another repotools export once the missing indexes and tables in the database are re-created.
Thanks
NP
The problem with repotools export from RQM 2.0.1 Oracle DB in my environment is still an issue. I have a PMR open with Rational tech support. The DBA here ran AWR report on Oracle DB and sent to tech support. I generated a trace during export and sent it to tech support. We were told by tech support our Oracle database for RQM 2.0.1 is missing around 1691 indexes. The DBA here found it is missing 7 tables as well. It appears the tool in RQM 2.0.1 that created the tables has a bug which caused the problem with missing indexes and tables. We are surprised how RQM 2.0.1 even worked on Oracle 10G.
If the problem is due to bug in the tool there must be other users of RQM 2.0.1 on Oracle 10 G who have problem with repotools export.
I'll run another repotools export once the missing indexes and tables in the database are re-created.
Thanks
NP
Hi,
I am not sure the post shows all the data you put in.
I have seen instances where servers did not shut down properly. With WAS I have seen that the WAS service is sometimes shut down, but java processes are still running (you can identify then, because they run the WAS java JRE which is visible in the properties.). Was would not start again, if that would be the case either. In those cases, kill the mentioned process trees.