Additional Step Required when Upgrading to SCM r12.0 to FP2 or r12.1 in an Oracle Database

book

Article ID: 51148

calendar_today

Updated On:

Products

CA Harvest Software Change Manager - OpenMake Meister

Issue/Introduction

Description:

Create HARCHILDRENTEMP table when upgrading from SCM r12.0 GA and FP1 to SCM r12.0 FP2 or r12.1.

Solution:

To avoid 'table or view does not exist' errors during usage, you must manually create a temporary table as part of the upgrade process in the following situations:

If you are an Oracle user who is...
Upgrading from SCM r12.0 GA to SCM r12.0 FP2
Upgrading from SCM r12.0 GA to SCM r12.1
Upgrading from SCM r12.0 FP1 to SCM r12.0 FP2
Upgrading from SCM r12.0 FP1 to SCM r12.1

you need to create the temporary table 'HARCHILDRENTEMP' in your SCM Oracle database schema.

This step is not necessary if you are upgrading from Harvest 7.x to SCM r12.0, if you are creating a new SCM schema in r12.0 FP2, or if you are using SQL Server.

While connected as the database schema owner, execute the following commands to create the HARCHILDRENTEMP temporary table.

CREATE GLOBAL TEMPORARY TABLE HARCHILDRENTEMP
(CHILDVERSIONOBJID NUMBER) ON
COMMIT DELETE ROWS;
COMMIT;

This information was originally documented in the SCM r12.0 FP2 ReadMe, but also applies to SCM r12.1.

The original ReadMe may be viewed here:

https://support.ca.com/irj/portal/phpdocs?techDocAccess=N&filePath=7/255/SCMr12FP2_ReadMe.html.

Environment

Release:
Component: CCCHV