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

Document ID : KB000051148
Last Modified Date : 14/02/2018
Show Technical Document Details

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.