E
dit
A
ttach
P
rintable
r13 - 2015-05-27 - 17:00:48 - Main.sbagot
You are here:
TWiki
>
Deployment Web
>
DeploymentTroubleshooting
>
UpgradeTroubleshooting
>
CLMUpgradeTroubleshooting
>
UpgradeDwSchema
<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="" alt="" 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 the Datawarehouse upgrade process which is part of the Jazz Team Server upgrade script. ---++ Current data warehouse configuration The data warehouse schema was a feature initially added to CLM 3.0.1 and is used for reporting. If you were running any Jazz based products prior to 3.0.1, and upgraded to 3.0.1, you may be running the data mart if you did not migrate to the data warehouse. If this is the case, you can skip this step. <br>To validate if you are running the data mart or data warehouse, log-in to the Server Administration page and click *Reports*. Under the Configuration section click *Data Warehouse Connection* and check the *Data Warehouse Provider* attribute. If it is set to *Remote*, you are likely have a Data Warehouse schema setup. If it is set to *Local*, you are still using data mart or you did not configure a data warehouse (this configuration is only available in applications at version 3.0.1.x and higher). <br> If you are running the data mart, you can skip this step of the upgrade. <br> If you are running the data warehouse, you can continue this step of the upgrade. ---+++ Data mart vs data warehouse A data mart is a storage facility for read-only, historical and aggregated data. Through the use of an industry standard "star schema", rather than a more normalized table structure, the data mart is optimized for efficient queries and quick response times. Reports access the data that is stored in this data mart. Data mart is not a separated database from the JTS repository database, but a snapshot only. Prior to CLM 3.0.1, the Jazz Team Server provides a data mart, as well as an extensible mechanism for gathering information to store in the data mart at periodic times. Out of the box, data collection jobs are provided that aggregate and store various data about work items, source control, and builds. A data warehouse is a relational database that is designed for query and analysis rather than for transaction processing. It contains historical data derived from transaction data, but it can include data from other sources. It separates analysis workload from transaction workload and enables an organization to consolidate data from several sources. Starting from CLM 3.0.1, users can take advantage of data warehouse schema feature to separate report data from the JTS repository database. This feature provide users more control on managing the process of gathering report data and delivering to business users. ---++ Data Warehouse upgrade process During the step in the upgrade, the data warehouse database will undergo the following changes: * Upgrade the Core Schema * Grant Core Schema Read Access * Populate Date Dimension * Upgrade Calm Schema * Grant Calm Schema Read Access ---+++ Troubleshooting the Data Warehouse upgrade process For information on Troubleshooting the Data Warehouse Upgrade Process, navigate to [[https://jazz.net/wiki/bin/edit/Deployment/UpgradeDWSchemaKnownIssues][Troubleshooting the data warehouse]]. ---+++ Known Issues For information on known issues to occur during the data warehouse upgrade process, navigate to [[https://jazz.net/wiki/bin/edit/Deployment/UpgradeDWSchemaKnownIssues][Known Issues]]. ---++ Can I choose not to upgrade my data warehouse? Yes, but before DW upgrade is completed, all the reports are likely to fail or display stale data due to failing ETL jobs, meaning, no new data is gathered for reporting. ---+++ Upgrading the data warehouse manually If you choose not to upgrade the Data Warehouse when you upgrade the JTS, it can be upgraded later. Run the following JTS repotools upgradeWarehouse command: Windows: <verbatim>cd JazzInstallDir\server repotools-jts.bat -upgradeWarehouse teamserver.properties=conf\jts\teamserver.properties </verbatim> UNIX: <verbatim>cd JazzInstallDir/server ./repotools-jts.js -upgradeWarehouse teamserver.properties=conf/jts/teamserver.properties </verbatim> |*Note:* Jazz Team Server must be upgraded successfully before you can proceed with the data warehouse upgrade.| ---+++ Obtaining DDL scripts for the DW upgrade Some deployments require the DDL scripts which are run during the upgrade process so that the data warehouse can be upgraded manually. This feature will be made available from CLM 4.0.3. [[https://jazz.net/wiki/bin/view/Main/GenerateDDLScriptsForTheDataWarehouseCreationAndUpgrade][Check here for detailed instructions in CLM version 4.0.3]] ---+++++!! 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.SusanWu <sticky></div></sticky>
E
dit
|
A
ttach
|
P
rintable
|
V
iew topic
|
Backlinks:
We
b
,
A
l
l Webs
|
H
istory
: r13
<
r12
<
r11
<
r10
<
r9
|
M
ore topic actions
Deployment
Deployment web
Planning and design
Installing and upgrading
Migrating and evolving
Integrating
Administering
Monitoring
Troubleshooting
Community information and contribution guidelines
Create new topic
Topic list
Search
Advanced search
Notify
RSS
Atom
Changes
Statistics
Web preferences
NOTE: Please use the Sandbox web for testing
Status icon key:
To do
Under construction
New
Updated
Constant change
None - stable page
Smaller versions of status icons for inline text:
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
.