CRJAZ2336E while upgrading to RTC 4.0
All, we hit this error while upgrading to 4.0.
We have not found anything in the documentation on whether row versioning is supposed to be turned on with the jazz DB.
Has someone seen this error before? Will turning on row versioning in the other DB make this issue go away, or does this have larger implications for the upgrade process?
Thanks,
Vivek
CRJAZ2336E
Our admins followed the documentation on setting up an SQL Server Database and turned on row versioning. Now we're seeing the same error with the jazz DB (ccm/rtc) after changing the JTS db.The SQL Server database is configured incorrectly. The database might experience performance problems and become deadlocked. For more details, open the help system and search for CRJAZ2336E.
We have not found anything in the documentation on whether row versioning is supposed to be turned on with the jazz DB.
Has someone seen this error before? Will turning on row versioning in the other DB make this issue go away, or does this have larger implications for the upgrade process?
Thanks,
Vivek
Accepted answer
You do indeed need to turn on row versioning for the CCM database. Enabling row versioning after performing the upgrade is fine and will make the issue go away, there are no larger implications for the upgrade process.
2 other answers
If the error persists, check the database listed in Advanced Properties to ensure you are performing the command (step 4 in Setting up an SQL Server database) on the correct database.
For example:
Go to jts/admin > Server > Advanced Properties > com.ibm.team.repository.service.internal.rdb.ConnectionPoolService > JDBC Location
For example:
Go to jts/admin > Server > Advanced Properties > com.ibm.team.repository.service.internal.rdb.ConnectionPoolService > JDBC Location
Comments
Mike Shkolnik
Oct 02 '12, 11:19 a.m.The instructions I found specifically say the JTS database needs row versioning, not the CCM database. Which is correct? Or should they all have row versioning enabled? (CCM, JTS, RQ, DW) Also, is there a problem turning on row versioning in an upgraded database (from version 2 through 3 to 4)? I did not get this error after upgrading to version 3, but I am getting it in version 4.
Craig Chaney
JAZZ DEVELOPER Oct 01 '12, 9:45 p.m.The sentence in step 1 that reads:
"Use the following example, substituting jts with your database name"
is intended to mean that each of those first four commands should be executed against the databases mentioned in step 1.
1 vote
Rosa Naranjo
FORUM MODERATOR / JAZZ DEVELOPER Oct 02 '12, 11:18 a.m.Mike, Craig is correct. Each database associated with an application instance of CCM, QM, and JTS needs row versioning. The DW also needs it. All databases associated with the CLM solution need row versioning ALONG with everything else listed in the SQL setup topic.
1 vote
Mike Shkolnik
Oct 02 '12, 1:41 p.m.I see the instruction in step 1 for substituting each database name, which clearly applies to the creation instructions in steps 1 and 2. However, since steps 3 and 5 apply to specific databases, it is not clear that step 4 applies to ALL databases. Are you certain of this? From the instructions of step 3 applying to only the JTS database and step 4 following that and referring to "the database", it implies it too only applies to the JTS database. Otherwise why not put the instruction that applies to all databases before the instructions that don't?
YOGESH LOKHANDE
Nov 16 '12, 11:19 a.m.hi
Error: Unable to load /rm/rootservices?dojo.preventCache=1353068309041 status:500 at Object._28d [as resHandle] (https://tekr.com:9443/rm/web/_js/?include=A~&etag=CZAlcvMUiId_en_US&_proxyURL=%2Frm:15:83486) at func (https://tekr.com:9443/rm/web/_js/?include=A~&etag=CZAlcvMUiId_en_US&_proxyURL=%2Frm:15:82219) at _286 (https://tekr.com:9443/rm/web/_js/?include=A~&etag=CZAlcvMUiId_en_US&_proxyURL=%2Frm:15:82504)
URL: /rm/rootservices
Error 500: Internal Server Error
Invalid Configuration (Error list: Unable to retrieve "com.ibm.rdm.fronting.server.RDMWebAppDataModuleBindingRedirectUrl" application property) (More info found at entry [8558cf9a639565f3] in RRS server log)
Requirements Management/4.0
Rosa Naranjo
FORUM MODERATOR / JAZZ DEVELOPER Nov 16 '12, 11:26 a.m.Yogesh,
This looks like an entirely different issue. You seem to be failing during the RM Online migration. If you backed up your JTS db prior to starting the RRC upgrade, you should be able to reattempt the upgrade. You probably want to open a workitem against RRC and upload your rm.log, jts.log and other logs in the server directory related to the RRC offline migration.
There is one other file to include in the defect: migration-errors.log. RRC has its own upgrade results directory. This directory will be found in the <server-install>/rdm/migration/systime-tmp directory. systime is a 13 digit number based on the time the migration ran.