How do I fix DOORS NG database issue
I have been running DNG locally on my workstation for some time and recently I have been unable to access the database contents. I can go to the Jazz Server Administration pages and use those, but I am not able to use any other applications. The diagnostics I get are:
I have reviewed related issues (https://jazz.net/forum/questions/116734/how-to-get-jts-out-of-read-only-mode, https://jazz.net/forum/questions/108221/crrrw7284e-why-do-i-get-rrc-bad-behaviour) and followed recommendations, but to no avail.
Any clues?
I have reviewed related issues (https://jazz.net/forum/questions/116734/how-to-get-jts-out-of-read-only-mode, https://jazz.net/forum/questions/108221/crrrw7284e-why-do-i-get-rrc-bad-behaviour) and followed recommendations, but to no avail.
Any clues?
Accepted answer
Hi Keith,
I am not used to forums, but PMRs and it is certainly easier to follow PMRs!
OK, it is hard to know where your data is being read from, even if the logs are writing to the old JTS location. I think it would make sense to simply re-run the JTS/setup command and re-point to the database from the 4.0.4 installation (JTS_1). If you're using Derby, then this is potentially even simpler as you can just replace one set of files with another...or you could formerly go through the backup procedures described in the info center:
http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m4/topic/com.ibm.jazz.repository.web.admin.doc/topics/t_backup_derby.html
Of course, what it sounds like, to me, is that your log4j.properties file is pointing to the old location for logging, but that can easily be checked/changed, as per:
http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m4/topic/com.ibm.rational.clm.doc/topics/c_logfiles_loc.html
Of course, you need to correct your shortcuts too. Simply remove the 4.0.3 references.
If you are using Derby and you're sure you know where the data is installed, you could just re-install 4.0.4 if you're certain the upgrade was successful. There should be upgrade logs to indicate that, as a separate issue.
Let me know if you need any further info. It would help to know your DB, but either way it should be easy to correct any teamserver.properties links to your databases to get just one installation correctly working.
I am not used to forums, but PMRs and it is certainly easier to follow PMRs!
OK, it is hard to know where your data is being read from, even if the logs are writing to the old JTS location. I think it would make sense to simply re-run the JTS/setup command and re-point to the database from the 4.0.4 installation (JTS_1). If you're using Derby, then this is potentially even simpler as you can just replace one set of files with another...or you could formerly go through the backup procedures described in the info center:
http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m4/topic/com.ibm.jazz.repository.web.admin.doc/topics/t_backup_derby.html
Of course, what it sounds like, to me, is that your log4j.properties file is pointing to the old location for logging, but that can easily be checked/changed, as per:
http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m4/topic/com.ibm.rational.clm.doc/topics/c_logfiles_loc.html
Of course, you need to correct your shortcuts too. Simply remove the 4.0.3 references.
If you are using Derby and you're sure you know where the data is installed, you could just re-install 4.0.4 if you're certain the upgrade was successful. There should be upgrade logs to indicate that, as a separate issue.
Let me know if you need any further info. It would help to know your DB, but either way it should be easy to correct any teamserver.properties links to your databases to get just one installation correctly working.
Comments
Paul Ellis
JAZZ DEVELOPER Aug 23 '13, 4:36 a.m.Hi Keith,
The message is stating that your database clock could be out of sync with your application. Is your database on the same workstation as your CLM apps? The two previous posts you list mention all the re-index commands to be run, but if your database time is the same as the workstation time, then maybe the re-index is not working.
Every instance of this message I can find from previous situations was resolved using the indices directory clean-up and repotools-jts re-index -all command. However, this command may be failing. Can you check the log and see if there are any issues completing this command?
It might even be worth changing the location of the indices and re-run it just in case you're hitting a disk corruption, although that would seem less likely.
Please append/edit any errors in the jts.log and/or reindex log here and we'll go again.
Keith Collyer
JAZZ DEVELOPER Aug 23 '13, 6:06 a.m.Hi Paul, I usually leave grubby tool details to experts, but here, I am trying to become the expert ;)
The server and applications are on the same workstation.
When I hunted for jts.log, I found I had two copies, one in:
C:\Program Files\IBM\JazzTeamServer\server\logs\jts.log
and the other in:
C:\Program Files\IBM\JazzTeamServer_1\server\logs\jts.log
That's not in itself surprising as I had done an upgrade installation from 4.0.3 to 4.0.4 and thought I had caught everything in the instructions. However, the entry in JazzTeamServer is dated yesterday, the one in JazzTeamServer_1 is dated 30 July, just before I went on two week holiday and before I noticed any issues. So, definitely something odd here. I had installed new versions of the applications and database into JTS_1, and was (I believed) running in that. However, the "Start Jazz server" shorcut points to:
C:\Windows\System32\cmd.exe /c cd /d "C:\Program Files\IBM\JazzTeamServer\server" & "C:\Program Files\IBM\JazzTeamServer_1\server\server.startup.bat"
<more follows>
Keith Collyer
JAZZ DEVELOPER Aug 23 '13, 6:02 a.m.<the rest>
so that is weird. Somehow, I have been running the JTS_1 startup in the JTS directory. Not surprisingly, things have got confused. It's a wonder it ever worked!
So, the question is, how do I get out of this? I don't have much data, just the built in samples and restored archives, so if the answer is "blow it all away and start again", that's irritating, but might be best. If so, what is the best way of going about this? Uninstall everything and install 4.0.4 afresh?