Edit
Attach
P
rintable
r3 - 2019-04-10 - 11:04:46 -
PaulEllis
You are here:
TWiki
>
Deployment Web
>
DeploymentTroubleshooting
>
DeploymentPatternsOnThirdPartyClouds
<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%"> ---+!! Deployment Patterns and Anti-patterns when using Third Party Cloud Environments <img src="https://jazz.net/wiki/pub/Deployment/WebPreferences/new.png" alt="new.png" width="50" height="50" align="right"> %DKGRAY% Authors: Main.PaulEllis<br> Build basis: Collaborative Lifecycle Management 6.x %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 article documents issues that we see when deploying the CLM software into the third-party Cloud environments such as Microsoft Azure; Amazon Web Services; and others. This article will not cover the issues from ClearObject. The [[https://www.ibm.com/support/docview.wss?uid=ibm10719833][Server Virtualization Policy for IBM Software]] states: <br> <br><i> "In response to the significant increase in Cloud and PureSystem technologies now available to its clients, IBM has established a set of virtualization environments for servers that we will support across our multi-platform product portfolio for servers. These virtualization environments consist of the operating system and hypervisor technology. This information is intended to help clients plan their strategic deployment environments for applications and achieve the economic benefits available through server consolidation."</i> As you can see from the [[https://jazz.net/forum/questions/225739/hosting-rational-clm-tool-suite-in-azure][jazz.net forum post]] from our Offering Manager Daniel Moul, we have stated:<br><br> <i> Yes. CLM is supported when running in Hyper-V, which is used in the Azure environment. <br> Note that if using Azure you will still need to bring perpetual licenses and provide admin services. <br>If you would rather move to SaaS and/or have someone take care of the administrative services, you could move to and IBM cloud offering. To learn more see the following: <br> https://www.ibm.com/marketplace/cloud/application-lifecycle-management<br> https://www.ibm.com/marketplace/cloud/engineering-solutions-on-cloud/" </i> <br> <br> This statement does <i>not</i> state that we support every aspect that a Cloud provider can offer. There is still a very strong expectation that the system will meet our existing IBM Engineering Support T&C, and specifically ALL OSs and middleware used within the Cloud Service meets our [[https://jazz.net/wiki/bin/view/Deployment/CLMSystemRequirements606][Systems Requirements]], for the specific version of IBM Engineering that is deployed. ---++ Windows restarts If Windows patches are set to deploy automatically, you MUST shut down the indices and CLM services, cleanly, before this is scheduled in case of the Windows patch requiring a restart. ---++ [[https://aws.amazon.com/rds/oracle/][Amazon Web Services Relational Database Service - Oracle]] ---+++ When creating Oracle tables using the commands that are prescribed in the Knowledge Center or Interactive Installation Guide, on Amazon RDS, you may encounter the following issue(s). <verbatim> "The data warehouse tables could not be created. Try the action again.ID CRJAZ1745E CRRTC8030E The creation of the data warehouse failed. com.ibm.team.repository.common.TeamRepositoryException: CREATE TABLESPACE VNF_IDX LOGGING DATAFILE '/rdsdbbin/oracle/VNF_IDX_1.ora' SIZE 200M AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO" </verbatim> and <i>java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-20900: RDS only supports Oracle Managed Files. Check ddl and remove any named identifiers ORA-06512: at "RDSADMIN.RDSADMIN", line 160 ORA-06512: at line 2 at </i> *** What is AWS RDS telling you?: The version of Oracle in use within the AWS RDS is not your typical on-premise Oracle. Therefore there maybe issues you will need to work around which will not be documented within the IBM documentation. <br> Standard tablespace create in this way (which they must have already worked around:)<br> CREATE TABLESPACE JTS<br> <b>DATAFILE 'ORACLE_BASE/oradata/CLMDB/JTS.DBF'</b><br> SIZE 1G AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE;<br> <br> What the DW is doing:<br> CREATE TABLESPACE VNF_IDX <b>LOGGING DATAFILE c:\somepath\VNF_IDX.ora'</b><br> ALTER TABLESPACE VNF_IDX ADD <b>DATAFILE c:\somepath\VNF_IDX.ora'</b><br> Specifying the paths (emboldened) is the problem here. The DBA will need to work within the Oracle command's syntax to create these and allow the Managed File System to allocate the datafies. <br > ---+++ Data Collection Component startup reports SQL Message: ORA-00942: table or view does not exist using Oracle server for Jazz Reporting Service Attempts to start the Data Collection Component (DCC) are successful, but the following message "SQL Message: ORA-00942: table or view does not exist" is reported in the dcc.log after installing IBM Jazz Reporting Service on Oracle. The DCC service reports the following in the dcc.log <verbatim> 11/07/2018 19:17:26,254 [Default Executor-thread-81] INFO sqlExceptionLogger - Syntax error or access rule violation SQL: DROP TABLE DCC_DB_USER.REPOSITORY_GTT_STRING SQL Exception #1 SQL Message: ORA-00942: table or view does not exist SQL State: 42000 Error Code: 942 java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist ........ Caused by: Error : 942, Position : 23, Sql = DROP TABLE DCC_DB_USER.REPOSITORY_GTT_STRING, OriginalSql = DROP TABLE DCC_DB_USER.REPOSITORY_GTT_STRING, Error Msg = ORA-00942: table or view does not exist at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 199 more </verbatim> <br> The table name in the error above is DCC_DB_USER.REPOSITORY_GTT_STRING but the DCC is is the user name; the table name is created based on the user name and the Global Temporary Tables Type. The table name in your log may, therefore, be different. <br> This is a known issue discussed in the following:<br> 478063: [[https://jazz.net/jazz/resource/itemName/com.ibm.team.workitem.WorkItem/478063][Silent Upgrade 606iFix006-6061RC3]] Error observed in DCC logs after upgrade<br> 478089: [[https://jazz.net/jazz/resource/itemName/com.ibm.team.workitem.WorkItem/478089][Internal API to drop a table should not throw SQLException if the table does not exist]]<br> These issues were initially suspected to be related to the Amazon Web Services RDS due to the [[https://jazz.net/wiki/bin/view/Deployment/CreateOracleDataWarehouseWithoutDBAPermissions][alternative technique required to create the Data Warehouse]]. This procedure has been confirmed to still be correct and these errors are benign and can be ignored. They relate to temporary tables which are being removed and in this instance, they do not exist anyway. ---+++++!! Related topics: [[DeploymentWebHome][Deployment web home]], [[DeploymentWebHome][Deployment web home]] ---+++++!! External links: * [[https://www.ibm.com][IBM]] ---+++++!! Additional contributors: Main.ValerieLampkin, Main.MirkoHartwig <sticky></div></sticky>
Edit
|
Attach
|
P
rintable
|
V
iew topic
|
Backlinks:
We
b
,
A
l
l Webs
|
H
istory
:
r16
|
r5
<
r4
<
r3
<
r2
|
More 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
.