Transcription
Siebel Database UpgradeGuideSiebel Innovation Pack 2017, Rev. BJanuary 2018
Copyright 2005, 2018 Oracle and/or its affiliates. All rights reserved.This software and related documentation are provided under a license agreement containing restrictionson use and disclosure and are protected by intellectual property laws. Except as expressly permitted inyour license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast,modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by anymeans. Reverse engineering, disassembly, or decompilation of this software, unless required by law forinteroperability, is prohibited.The information contained herein is subject to change without notice and is not warranted to be errorfree. If you find any errors, please report them to us in writing.If this is software or related documentation that is delivered to the U.S. Government or anyone licensingit on behalf of the U.S. Government, the following notice is applicable:U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software,any programs installed on the hardware, and/or documentation, delivered to U.S. Government end usersare “commercial computer software” pursuant to the applicable Federal Acquisition Regulation andagency-specific supplemental regulations. As such, use, duplication, disclosure, modification, andadaptation of the programs, including any operating system, integrated software, any programs installedon the hardware, and/or documentation, shall be subject to license terms and license restrictionsapplicable to the programs. No other rights are granted to the U.S. Government.This software or hardware is developed for general use in a variety of information managementapplications. It is not developed or intended for use in any inherently dangerous applications, includingapplications that may create a risk of personal injury. If you use this software or hardware in dangerousapplications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, andother measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for anydamages caused by use of this software or hardware in dangerous applications.Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may betrademarks of their respective owners.Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarksare used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD,Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of AdvancedMicro Devices. UNIX is a registered trademark of The Open Group.This software or hardware and documentation may provide access to or information about content,products, and services from third parties. Oracle Corporation and its affiliates are not responsible for andexpressly disclaim all warranties of any kind with respect to third-party content, products, and servicesunless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation andits affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or useof third-party content, products, or services, except as set forth in an applicable agreement between youand Oracle.Documentation AccessibilityFor information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program websiteat http://www.oracle.com/pls/topic/lookup?ctx acc&id docacc.Access to Oracle SupportOracle customers that have purchased support have access to electronic support through My OracleSupport. For information, visit http://www.oracle.com/pls/topic/lookup?ctx acc&id info or visithttp://www.oracle.com/pls/topic/lookup?ctx acc&id trs if you are hearing impaired.
ContentsSiebel Database Upgrade Guide 1Chapter 1:What’s New in This ReleaseChapter 2:Overview of Siebel Database EnvironmentsSupported Upgrade Paths for Siebel CRM Version 17.0Terms Used in This Guide1721Naming Conventions Used in This Guide22About File Paths and Commands in Siebel Database Upgrade TopicsAbout Supported Siebel Upgrade PathsAbout Siebel Upgrade EnvironmentsChapter 3:2525Siebel Database Upgrade PlanningAbout Siebel Upgrade Planning Resources31Guidelines for Planning Your Siebel Database Upgrade34About Upgrading Your RDBMS in the Siebel EnvironmentAbout Database Sort Order in the Siebel Environment3738About the Siebel Database Configuration Wizard UtilitiesAbout the Siebel Upgrade Wizard and Driver FilesAbout Siebel Additive Schema Changes Mode48About the Siebel Database Upgrade Log Files50About the Siebel Case Insensitivity WizardAbout the Siebel Repository Merge455257About Inheriting Upgrade Behavior in a Siebel UpgradeAbout the Siebel Postmerge Utilities3953About Single-Step Repository Upgrade5961About Tuning Siebel Production Upgrade FilesChapter 4:2365Application Planning for a Siebel UpgradeUpgrade Planning for Multilingual Siebel Deployments71Siebel Database Upgrade Guide Siebel Innovation Pack 2017, Rev. B3
Contents Upgrade Planning for Language String MigrationUpgrade Planning for Siebel Unicode Support7373Upgrade Planning for Siebel RC4 or AES Encryption75Upgrade Planning for Siebel Web Template Files and Style SheetsUpgrade Planning for Siebel Access Control7577Upgrade Planning for Migrating Siebel Address DataUpgrade Planning for Siebel Workflow Designer7778Upgrade Planning for Mobile Devices in the Siebel Environment82Upgrade Planning for Resonate Central Dispatch in the Siebel EnvironmentUpgrade Planning for Siebel String TranslationUpgrade Planning for Siebel Personalization8283Upgrade Planning for Siebel Pricer and Order ManagementChapter 5:84Preparing for Siebel Database UpgradeVerifying Siebel Database Connectivity85Preparing Siebel Tables and Views for UpgradePreparing Siebel Custom Indexes for UpgradeExporting Siebel Interface Table Data858687Archiving Unneeded Siebel Repositories87Preserving Siebel Dock Objects and Visibility Rules87Securing AIX Memory Allocation Segment Space for the Siebel DatabasePreparing for a Multilingual UpgradeChapter 6:828888Preparing an IBM DB2 Database for a SiebelUpgradeVerifying the IBM DB2 Client for a Siebel UpgradeVerifying IBM DB2 Sort Order for a Siebel UpgradeSetting IBM DB2 Parameters for a Siebel UpgradeVerifying IBM DB2 Permissions for a Siebel Upgrade91919294Verifying IBM DB2 Instance Owner Permissions for a Siebel Upgrade94Creating IBM DB2 Temporary Tablespaces and Bufferpools for a Siebel UpgradeAnalyzing IBM DB2 Custom Tablespace Requirements for a Siebel Upgrade4Siebel Database Upgrade Guide Siebel Innovation Pack 2017, Rev. B9594
Contents Verifying the IBM DB2 Application Development Client for a Siebel UpgradeIdentifying IBM DB2 Long Columns for Truncation in a Siebel UpgradeChapter 7:9798Preparing an Oracle Database for a SiebelUpgradeVerifying Oracle Database Sort Order for a Siebel Upgrade101Setting Oracle Database Configuration Parameters for a Siebel Upgrade101Verifying Oracle Database Parameters for Multiple Processors in a Siebel Upgrade103Verifying the Oracle Database ODBC Definition for a Siebel UpgradeChapter 8:103Preparing a Microsoft SQL Server Database fora Siebel UpgradeVerifying Microsoft SQL Server Sort Order for a Siebel Upgrade105Setting Microsoft SQL Server Temporary Space Size for a Siebel Upgrade106Setting Microsoft SQL Server Configuration Parameters for a Siebel UpgradeRebuilding Microsoft SQL Server Clustered Indexes for a Siebel UpgradeChapter 9:106107Preparing Siebel Application Data for UpgradePreparing Siebel Workflow Processes for Upgrade109Preparing Siebel Customized Seed Data for UpgradeMigrating Siebel Household Data110111Preparing Siebel Mobile User Data for UpgradePreparing Siebel Address Data for Upgrade113114Preparing Siebel Territory Management Rules for UpgradePreparing Siebel Customizable Product Data for Upgrade115116Chapter 10: Upgrading the Siebel DatabaseExample of a Siebel Development Environment Upgrade FlowRenaming the Siebel RepositoryCopying Ancestor Repositories117124125Changing the Siebel Database Configuration Utilities LanguagePreparing to Run the Siebel Database Configuration Wizard127128Running the Siebel Database Configuration Wizard on Windows132Siebel Database Upgrade Guide Siebel Innovation Pack 2017, Rev. B5
Contents Process of Deleting Unshipped Languages from the S LST OF VAL Table on Windows134Backing Up the S LST OF VAL Table on Windows 134Deactivating Records for Unshipped or Unwanted Languages on WindowsImporting Newly Created Records from the Data File on Windows 136Running the Siebel Database Configuration Wizard on UNIX135137Process of Deleting Unshipped Languages from the S LST OF VAL Table on UNIX139Backing Up the S LST OF VAL Table on UNIX 139Deactivating Records for Unshipped or Unwanted Languages on UNIXImporting Newly Created Records from the Data File on UNIX 140Starting the Siebel Upgrade WizardMoving the Siebel Repository Files140141145Running the Siebel Case Insensitivity WizardApplying Siebel Additive Schema Changes145150Regenerating SQL Files for a Siebel Upgrade151Identifying and Dropping Obsolete Indexes for a Siebel UpgradePreparing for a Nondevelopment Environment Siebel UpgradeFixing Column Alignment for Custom Objects153Inactivating Unreferenced Repository Objects154152153Converting Siebel Web Templates with the SWT to OD Conversion Utility155Chapter 11: Reviewing the Siebel Upgrade Log FilesSummarizing Siebel Log Files Using the Logparse UtilityReviewing Siebel Upgrade Log Files for ErrorsManually Archiving Siebel Upgrade Log Files157159163Chapter 12: Performing the Siebel Repository MergePreparing for the Repository Merge165Configuring Siebel Repository Objects to Inherit Upgrade BehaviorPerforming a Siebel Repository Merge166167Reviewing the Siebel Repository Merge Log Files169Generating Siebel Enterprise Integration Manager Temporary ColumnsReviewing Siebel Repository Object Property Conflicts6172172Siebel Database Upgrade Guide Siebel Innovation Pack 2017, Rev. B
Contents Generating the Runtime Repository Data176Regenerating the Siebel Repository Definition FilesDeleting Unneeded Siebel Repository Files176179Migrating Siebel Repository Objects to the Standard User InterfaceRunning the Siebel Postmerge Utilities179184Chapter 13: Performing the Siebel Incremental RepositoryMergeProcess of Meeting the Requirements for an Incremental Upgrade to Siebel InnovationPack 2017, Using the Incremental Repository Merge 187Before You Begin 188Preparing Siebel Tools for Custom ODBC Data Source Names on Oracle Database 188Preparing Siebel Tools for Custom ODBC Data Source Names for All Databases 189Editing the Siebel Tools Configuration File 190Process of Performing an Incremental Upgrade of the Siebel Database from SiebelCRM Version 8.1.1.x (SIA Repository), 8.2.2.x, 15.x, and 16.x 190Preparing to Run the Siebel Database Configuration Wizard 191Requirements for Running the Siebel Database Configuration Wizard on Windows 196Running the Siebel Database Configuration Wizard on Windows 196Running the Siebel Database Configuration Wizard on UNIX 197Preparing to Start the Siebel Upgrade Wizard 198Starting the Siebel Upgrade Wizard 199Stopping the Siebel Upgrade Wizard on Windows 200Stopping the Siebel Upgrade Wizard on UNIX 201Preparing to Restart the Merge 201Restarting the Merge 203Executing the RUNSTATS Command on Oracle Database During the Pause Following NewRepository Creation 203Executing the RUNSTATS Command on IBM DB2 During the Pause Following NewRepository Creation 204Executing the UPDATESTATS Command on Microsoft SQL Server During the PauseFollowing New Repository Creation 205Process of Upgrading the Siebel Development Environment from Siebel CRM Version8.1.1.x (SIA Repository) 205Upgrading the Siebel Database Schema 206Executing Incremental Repository Merge on UNIX 215About Siebel Repository Merge Errors 215Reviewing the Siebel Repository Merge Log Files 217Reviewing the Hierarchical Merge Report 218Reviewing Siebel Repository Object Property Conflicts 220Siebel Database Upgrade Guide Siebel Innovation Pack 2017, Rev. B7
Contents Reviewing Log Files for All Upgrades 222Reviewing Conflicts at the Attribute Level 222Marking Conflict Resolution as Complete Using Siebel ToolsGenerating the Runtime Repository Data 223Upgrading a Custom Database SchemaVerifying the Repository After Upgrade223224229About Migrating the XML Manifest Data for Siebel Open UI from Previous Releases tothe New Manifest Data in the Database 230Default Configuration for Generic Applet Types and Configuration of Non-Applet UserInterface Constituents 233Generic Applet Types from the XML Manifest File 235Differences Between Customer Manifest Data and Oracle Manifest Data 239File Selection Rules 240Checking the Post-upgphys Verification Process 240Process of Regenerating the Siebel Repository Definition Files241Regenerating the schema.ddl File 241Regenerating the custrep.dat File 242Editing the Siebel Tools Configuration File After the Development Environment Merge243Performing a Production Test or Production Environment Migration from Siebel CRMVersion 8.1.1.x (SIA Repository) 244Chapter 14: Siebel Postmerge Development TasksReviewing Objects Deleted from the Siebel RepositoryReviewing Obsolete Objects in the Siebel RepositoryUpgrading to the Siebel Symbolic String Model245246247Dropping IBM DB2 8-KB Tablespaces and Buffers After a Siebel MergeUpdating Siebel Enterprise Application Integration (EAI)247248Chapter 15: Postupgrade Tasks for the Siebel DatabaseReapplying Schema Customizations in the Siebel DatabaseMigrating Address Data After a Direct SEA to SIA Upgrade249250Validating Dock Objects and Rule Definitions in the Siebel DatabaseVerifying an Upgraded Oracle Database After a Siebel UpgradeSetting Oracle Database Parameters After a Siebel Upgrade8251253254Siebel Database Upgrade Guide Siebel Innovation Pack 2017, Rev. B
Contents Chapter 16: Reviewing the Siebel User InterfaceTroubleshooting Postmerge Siebel User Interface ProblemsReviewing Siebel Grid-Based Applets256Reviewing Siebel User Interface Navigation258Reviewing Siebel Multi-Value Group Shuttle AppletsRevising Siebel UI Rich Text Controls259262Reviewing New Siebel UI Aggregate Categories263Revising Siebel Visibility Filters to Display Correctly263Assigning a Category and Type to Siebel Chart Views264Assigning a Category and Type to Siebel Explorer Views265Setting Up Navigation to Inaccessible Siebel Detail ViewsEliminating Obsolete Siebel UI Fields255266267Reviewing Siebel UI Objects Affected by Incorporate Custom LayoutReviewing Required Fields in the Siebel User Interface267268Chapter 17: Postupgrade Tasks for Siebel BusinessApplicationsActivating License Keys271Generating Siebel Reporting Relationships272Setting Up Siebel Global Time Zone SupportDisplaying Regions in Siebel Marketing273274Configuring Siebel Marketing Purchase Orders for DisplayUpgrading Siebel Attribute Pricing274275Verifying Aggregate Discounts in Siebel PricerUpgrading Inbound Siebel Workflows276277Chapter 18: Tuning the Siebel Upgrade FilesStarting and Stopping Siebel Upgrade Tuner279Managing Parallel Threads Using Siebel Upgrade Tuner281Managing Zero-Row SQL Commands Using Siebel Upgrade TunerTransferring UNIX Files for Use by Siebel Upgrade TunerRolling Back Siebel Upgrade Tuner Changes284287290Siebel Database Upgrade Guide Siebel Innovation Pack 2017, Rev. B9
Contents Chapter 19: Planning for a Dev to Test to Production UsingSiebel MigrationAbout Migrating with Siebel Migration293Roadmap for Planning a Migration with Siebel MigrationAbout Siebel Rules Expression Designer293296About Migration Process Orchestration During the Siebel Migration ProcessAbout the Siebel Migration Log Files296297About REST API Used for Migration Discovery and Execution298Chapter 20: Preparing Data for a Siebel MigrationProcess of Preparing Siebel Application Data for MigrationCreating Migration Rules303303Process of Transforming Data with Siebel Application Deployment ManagerCreating an ADM Data Map 305Associating a Data Map to a Project Item306Customizing Siebel Migration Execution and Resource SequencingSetting Up File Prepare and Deploy305306307Chapter 21: Migrating Data for a Dev to Test to Productionwith Siebel MigrationBefore You Begin Migrating with Siebel Migration309Process of Using Siebel Migration to Migrate Data309Creating a Connection 309Creating a Migration Plan 310Executing a Siebel Migration Plan 312Viewing Migration History and Log Files312Appendix A: Implementing Siebel High-Availability UpgradeUsing Oracle GoldenGate to Upgrade to theCurrent ReleaseOverview of Oracle GoldenGate ImplementationAbout Siebel High Availability Upgrade FilesExtracting Oracle GoldenGate Files314315315Example of Implementing a Siebel High-Availability Upgrade322Limitations When Performing a Siebel Upgrade with Oracle GoldenGate10324Siebel Database Upgrade Guide Siebel Innovation Pack 2017, Rev. B
Contents Appendix B: Overview of Performing a Siebel DatabaseUpgradeRoadmap for Siebel Database Environment Upgrade325Process of Upgrading a Siebel Development Environment332Process of Upgrading a Siebel Production Test EnvironmentProcess of Tuning Siebel Upgrade Performance339344Process of Upgrading a Siebel Production Environment348Appendix C: Siebel Incorporate Custom Layout UpgradeOptionAbout the Siebel Incorporate Custom Layout Upgrade Option355Appendix D: Siebel Case Insensitivity WizardOverview of What the Case Insensitivity Wizard Does367How CIAI Columns and Indexes Are Implemented in the Database368Chapter 22: REST API References for Migration ServicesUsing REST API with the Migration Schema Service377Exporting with the Migration Schema Service 378Getting Status with the Migration Schema Service 379Importing with the Migration Schema Service 380Verifying If a Schema Changed with the Migration Schema ServiceGetting a Watermark with the Migration Schema Service 381380Using REST API with the Migration Design Repository Data ServiceExporting with the Migration Design Repository Data Service 383Checking a Database with the Migration Design Repository Data ServiceGetting Status for a Migration Design Repository Data Service 384Importing with the Migration Design Repository Data Service 385Using REST API with the Migration Application Data Service382383386Exporting with the Migration Application Data Service 387Getting Status with the Migration Application Data Service 387Importing with the Migration Application Data Service 389Using REST API with the Migration Data Service with Transformation Service389Exporting with the Migration Application Data Service With Transformation 390Getting Status with the Migration Application Data Service With Transformation 391Importing with the Migration Application Data Service With Transformation 392Siebel Database Upgrade Guide Siebel Innovation Pack 2017, Rev. B11
Contents Using REST API with the Migration Incremental Runtime Repository Data Service393Getting a Watermark with the Migration Incremental Runtime Repository Data Service394Exporting with the Migration Incremental Runtime Repository Data Service 394Getting Status with the Migration Incremental Runtime Repository Data Service 395Importing with the Migration Incremental Runtime Repository Data Service 396Checking a Database with the Migration Incremental Runtime Repository Data Service397Activating the Workflow and Taskflow with the Migration Incremental Runtime RepositoryData Service 398Using REST API with the Migration Runtime Repository Data Service399Getting Runtime Repository Information with the Migration Runtime Repository DataService 400Getting a Watermark with the Migration Runtime Repository Data Service 401Exporting with the Migration Runtime Repository Data Service 402Getting Status with the Migration Runtime Repository Data Service 402Importing with the Migration Runtime Repository Data Service 404Checking a Database with the Migration Runtime Repository Data Service 404Using REST API with the Migration Incremental Application Workspace Data Service405Getting Status with the Migration Incremental Application Workspace Data Service 406Getting a Watermark with the Migration Incremental Application Workspace Data Service407Exporting with the Migration Incremental Application Workspace Data Service 408Importing with the Migration Incremental Application Workspace Data Service 409Invalidating Seed Caches with the Migration Incremental Application Workspace Dataservice 410Using REST API with Migration Application Workspace Data Service411Getting a Seed Copy Watermark with the Migration Application Workspace Data Service412Getting the Full Seed Watermark with the Migration Application Workspace Data Service412Getting Status with the Migration Application Workspace Data Service 413Getting a Seed Copy Export with the Migration Application Workspace Data Service 414Getting a Seed Copy Import with the Migration Application Workspace Data Service 415Getting the Full Seed Export with the Migration Application Workspace Data Service 416Getting the Full Seed Import with the Migration Application Workspace Data Service 417Invalidating the Seed Caches with the Migration Application Workspace Data Service 418Index12Siebel Database Upgrade Guide Siebel Innovation Pack 2017, Rev. B
1What’s New in This ReleaseWhat’s New in Siebel Database Upgrade Guide, Siebel Innovation Pack2017, Rev. BThis guide has been updated to correct or remove obsolete product and component terms.What’s New in Siebel Database Upgrade Guide, Siebel Innovation Pack2017, Rev. ATable 1 lists the changes described in this version of the documentation to support this release of thesoftware.NOTE: Siebel Innovation Pack 2017 is a continuation of the Siebel 8.1/8.2 release. This guide is forupgrading to Siebel Innovation Pack 2017 (version 17.0).Table 1.What’s New in Siebel Database Upgrade Guide, Siebel Innovation Pack 2017, Rev. ATopicDescription“Supported Upgrade Paths forSiebel CRM Version 17.0” onpage 17Modified topic. Added additional information about SiebelRuntime Repository.“About Siebel UpgradeEnvironments” on page 25Modified topic. Added additional information about theproduction environment.“About the Siebel RepositoryMerge” on page 53Modified topic. Added information about the Siebel RuntimeRepository tables.“Upgrade Planning for Siebel RC4or AES Encryption” on page 75Modified topic. Added information about updating the .cfg filebefore running the Key Database Manager. Added a referenceto 2104053.1 (Article ID) on My Oracle Support.“Example of a Siebel DevelopmentEnvironment Upgrade Flow” onpage 117Modified topic. Added additional information about theencryption upgrade in Table 17.“Fixing Column Alignment forCustom Objects” on page 153Modified topic. Added additional information about the FixingColumn Alignment for the Custom Objects Utility.“Inactivating UnreferencedRepository Objects” on page 154Modified topic. Added additional information about theInactivating Unreferenced Repository Objects Utility.“Converting Siebel Web Templateswith the SWT to OD ConversionUtility” on page 155Modified topic. Added additional information about the SiebelWeb Templates with the SWT to OD Conversion Utility.“Generating the RuntimeRepository Data” on page 176Modified topic. Added additional information about Full Publishin Siebel Tools.Siebel Database Upgrade Guide Siebel Innovation Pack 2017, Rev. B13
What’s New in This Release Table 1.What’s New in Siebel Database Upgrade Guide, Siebel Innovation Pack 2017, Rev. ATopicDescription“Regenerating the SiebelRepository Definition Files” onpage 176Modified topic. Added additional information about anadditional custrep dev.dat that contains the entiredevelopment repository.“Upgrading a Custom DatabaseSchema” on page 224Modified topic. Added additional information about the physicalencryption upgrade and enabling a workspace in Table 27.“Roadmap for Siebel DatabaseEnvironment Upgrade” onpage 325Modified topic. Updated Figure 9 on page 326 with additionalinformation about Full Publish in Siebel Tools.“Incorporate Custom Layout”Removed topic. For Siebel Innovation Pack 2017, theIncorporate Custom Layout merge is not applicable for anIncremental Repository Merge.“Assigning an Item Identifier toSiebel Web Template Items”Removed topic for Siebel Innovation Pack 2017.This guide has been updated to correct or remove obsolete product and component terms.What’s New in Siebel Database Upgrade Guide, Siebel Innovation Pack2017Table 2 lists the changes described in this version of the documentation to support this release of thesoftware.NOTE: Siebel Innovation Pack 2017 is a continuation of the Siebel 8.1/8.2 release. This guide is forupgrading to Siebel Innovation Pack 2017 (version 17.0).Table 2.What’s New in Siebel Database Upgrade Guide, Siebel Innovation Pack 2017TopicDescription“Copying Ancestor Repositories”on page 125Modified topic. Corrected the part number, patch ID, someversion number references, and other content to be consistentwith cases for upgrading to Siebel Innovation Pack 2017(version 17.0). Added the ancestor repository file r160.dat.“Supported Upgrade Paths forSiebel CRM Version 17.0” onpage 17New or modified topics. The current release for this guide isSiebel Innovation Pack 2017 (version 17.0). You can upgradeto Siebel CRM version 17.0 from applicable prior Siebel CRMreleases, including Siebel CRM version 8.1.1.x, version 8.2.2.x,version 15.x, or version 16.x. The upgrade tasks for thisrelease are similar to those for previous releases.Multiple topics“Supported Upgrade Paths forSiebel CRM Version 16.0”14Deleted topic. This guide documents upgrades to the currentversion, Siebel CRM version 17.0.Siebel Database Upgrade Guide Siebel Innovation Pack 2017, Rev. B
What’s New in This Release Table 2.What’s New in Siebel Database Upgrade Guide, Siebel Innovation Pack 2017TopicDescriptionMultiple topicsModified topics. Siebel Repository Files (SRF) are no longerused, as of Siebel Innovation Pack 2017. The Siebel RuntimeRepository is used instead. For more information, see UsingSiebel Tools.“Fixing Column Alignment forCustom Objects” on page 153New topic. Provides information about using the Fixing ColumnAlignment for the Custom Objects Utility.“Inactivating UnreferencedRepository Objects” on page 154New topic. Provides information about using the InactivatingUnreferenced Repository Objects Utility.“Converting Siebel Web Templateswith the SWT to OD ConversionUtility” on page 155New topic. Provides information about using the ConvertingSiebel Web Templates with the SWT to OD Conversion Utility.“Planning for a Dev to Test toProduction Using Siebel Migration”on page 293New Chapter. Provides information about planning for adatabase migration using Siebel Application Interface.“Preparing Data for a SiebelMigration” on page 303New Chapter. Provides information about preparing data for amigration using Siebel Application Interface.“Migrating Data for a Dev to Test toProduction with Siebel Migration”on page 309New Chapter. Provides information about using SiebelApplication Interface to migrate database data from a sourceenvironment to a target environment.“REST API References for MigrationServices” on page 377New Appendix. Provides examples for using REST API todiscover migration services.Siebel Database Upgrade Guide Siebel Innovation Pack 2017, Rev. B15
What’s New in This Release 16Siebel Database Upgrade Guide Siebel Innovation Pack 2017, Rev. B
2Overview of Siebel DatabaseEnvironmentsThis chapter provides an overview of the upgrade process of the three Siebel database environments(development, test, and production). It includes the following topics: Supported Upgrade Paths for Siebel CRM Version 17.0 on page 17 Terms Used in This Guide on page 21 Naming Conventions Used in This Guide on page 22 About File Paths and Commands in Siebel Database Upgrade Topics on page 23 About Supported Siebel Upgrade Paths on page 25 About Siebel Upgrade Environments on page 25NOTE: For a detailed overview of the upgrade process and related tasks, see Appendix B, “Overviewof Performing a Siebel Database Upgrade.”Supported Upgrade Paths for Siebel CRMVersion 17.0Table 3 lists supported upgrade paths. The current release for this guide is Siebel Innovation Pack2017 (Siebel CRM version 17.0). The repository for the current release is SIA in all cases. For moreinformation on terminology, see “Terms Used in This Guide” on page 21.Siebel Repository now consists of Runtime Repository as part of Siebel Innovation Pack 2017. Thisrepository contains the compiled repository definition. This Runtime Repository is available for all ofthe supported Siebel languages. Siebel clients and servers now read the compiled definition from theruntime repository stored in the database. The Runtime Repository is required for either of thefollowing upgrade tasks summarized in this topic. If you run incremental repository merge for an existing Siebel database. If you perform a full database upgrade for an existing Siebel database.You also require the Siebel Runtime Repository to run Siebel Business Applications after you installa new Siebel database for Siebel CRM version 17.0. For more information, see the Siebel InstallationGuide for the operating system you are using.NOTE: After installing the Siebel CRM software for the current release, you must reset anypasswords stored in the Siebel Gateway that were previously encrypted using RC4 encryption. In thecurrent release, such passwords are encrypted using Advanced Encryption Standard (AES) insteadof RC4. You must perform this task for any type of upgrade from versions prior to Siebel InnovationPack 2014. For more information about reencrypting passwords, see Sie
Siebel Database Upgrade Guide Siebel Innovation Pack 2017, Rev. B 5 Verifying the IBM DB2 Application Development Client for a Siebel Upgrade 97 Identifying IBM DB2 Long Columns for Truncation in a Siebel Upgrade 98 Chapter 7: Preparing an Oracle Database for a Siebel Upgrade Verifying Oracle Database Sort Order for a Siebel Upgrade 101
