<div id="header-title" style="padding: 10px 15px; border-width:1px; border-style:solid; border-color:#FFD28C; background-image: url(<nop>https://jazz.net/wiki/pub/Deployment/WebPreferences/TLASE.jpg); background-size: cover; font-size:120%"> ---+!! <img src="https://jazz.net/wiki/pub/Deployment/WebPreferences/new.png" alt="new.png" width="50" height="50" align="right"/> Upgrading the data warehouse %DKGRAY% Authors: [[UpgradeTroubleshootingTeam][UpgradeTroubleshootingTeam]]<br> Build basis: CLM 3.x and later %ENDCOLOR%</div></sticky> <!-- Page contents top of page on right hand side in box --> <sticky><div style="float:right; border-width:1px; border-style:solid; border-color:#DFDFDF; background-color:#F6F6F6; margin:0 0 15px 15px; padding: 0 15px 0 15px;"> %TOC{title="Page contents"}% </div></sticky> <sticky><div style="margin:15px;"></sticky> This page discusses known issues and troubleshooting the Datawarehouse upgrade process. |*Note:* Jazz Team Server must be upgraded successfully before you can proceed with the data warehouse upgrade.| ---++ Troubleshooting the Data Warehouse upgrade process Since the upgrade scripts for the Data Warehouse will change the database, the most common issues that can occur during the upgrade are related to the database. If this section of the upgrade script fails, review the following log, located in the ../server folder of the CLM application installation directory, for more information. <verbatim> repotools-jts_upgradeWarehouse.log </verbatim> ---++ Known Issues ---+++ CRJAZ0265E: The database resource or the virtual storage is not available. *Version:* Upgrade to 4.x <br> *Error During Upgrade:* CRJAZ0265E: The database resource or the virtual storage is not available. SQLSTATE: 57011 <br> *Cause:* This specific message is a result of running out of space in the transaction logs. <br> *Resolution:* Run the following SQL statements to increase the log size. Note that the default size of the first is 8, and the second is 16. <verbatim>db2 update db cfg for DWDB using logprimary 20</verbatim> <verbatim>db2 update db cfg for DWDB using logsecond 30</verbatim> ---+++ Data Collection Jobs Failing *Version:* Data warehouse upgrade to 4.x <br> *Error During Upgrade:* Data collection jobs are failing, and in the log file the following error occurs: CRRRE1420E: Can not redirect to the OAuthentication identify URL <br> *Cause:* The data collection jobs need to go through a 'migration' <br> *Resolution:* Run the full data collection jobs for all once <br>When you look at the status, for example, if you run a Full data collection job for common under JTS/reports, you would see two entries, *Common Migration* and *Common* *NOTE:* The full data collection jobs may take some time to run in your deployment as they are different than the daily jobs which only gather changed data. ---+++++!! Related topics: * [[https://jazz.net/wiki/bin/view/Main/DataWarehouseSnapshotSchemas20][Data Warehouse Snapshot Schemas]] * [[https://jazz.net/wiki/bin/view/Main/DataWarehouseConcepts][Data Warehouse Concepts]] * For more troubleshooting topics, refer to [[UpgradeTroubleshooting][Upgrade Troubleshooting]]. ---+++++!! External links: * None ---+++++!! Additional contributors: Main.StephanieBagot ---+++++!! Questions and comments: %COMMENT{type="below" target="UpgradeDwSchemaComments" button="Submit"}% %INCLUDE{"UpgradeDwSchemaComments"}% <sticky></div></sticky>
This topic: Deployment
>
WebHome
>
DeploymentTroubleshooting
>
UpgradeTroubleshooting
>
CLMUpgradeTroubleshooting
>
UpgradeDwSchema
>
UpgradeDWSchemaKnownIssues
History: r1 - 2014-06-23 - 17:18:05 - Main.sbagot
Copyright © by IBM and non-IBM contributing authors. All material on this collaboration platform is the property of the contributing authors.
Contributions are governed by our
Terms of Use.
Please read the following
disclaimer
.
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
.