E-CLOUD - Upgrade to Cloud Manager 16 Fails on Step: Cloud Manager PeopleTools Upgrade [PTU] with ORA-00942: table or view does not exist select count(*) from PS_DUMMY_PRP_TBL (Doc ID 2968931.1)

Last updated on FEBRUARY 06, 2024

Applies to:

Symptoms

When attempting to do a Cloud Manager 15 to 16 upgrade, the following error occurs.

[psadm2@psftcm ~]$ run_cloud_manager_update -t cm_upgrade -o get_status
--------------------------------------------
CLOUD MANAGER PEOPLETOOLS UPGRADE STATUS
--------------------------------------------
ORCHESTRATION ID: CM_ORCH_PTU_20230817_053739 [Time: 2023-08-17 05:38:34:948920]
JOB SCHEDULE STATUS: SUCCESS
JOB STATUS: FAILURE

1. Validating Input Data: SUCCESS
2. Cloud Manager Pre-Update Settings: SUCCESS
3. Stopping the Cloud Manager PSFT Domains: SUCCESS
4. Cloud Manager PeopleTools Upgrade [PTU]: FAILURE
5. Cloud Manager PeopleTools Update [PTP]: PENDING
6. Un-Provisioning the Middle Tier of Cloud Manager: PENDING
7. Re-Provisioning the Middle Tier of Cloud Manager: PENDING
8. Cloud Manager Post Update Settings: PENDING

Reviewing the job.log indicates that the process fails on Step: Reviewing Table Row Counts where it shows the following error:

2023-08-17 13:33:34.117 - #embed step execution error/warn log: D:\psft\pum_output\softwareupdatePTU860{-CMPSDB}IP20230817132107\UPGCOUNT_ADHOC_out.log
PeopleTools 8.59.13 - Application Engine
Copyright (c) 1988-2023 Oracle and/or its affiliates.
All Rights Reserved
UPGCOUNT Started on 2023-08-17-06.33.31.000000 (0,0)
 Message Set Number: 0
 Message Number: 0
 Message Reason: UPGCOUNT Started on 2023-08-17-06.33.31.000000 (0,0) (0,0)
SQL error. Function: SQLExec
  Error Position: 21
  Return: 942 - ORA-00942: table or view does not exist
  Statement: select count(*) from PS_DUMMY_PRP_TBL
  Original Statement: SELECT COUNT(*) FROM PS_DUMMY_PRP_TBL
 Message Set Number: 0
 Message Number: 0
 Message Reason: SQL error. Function: SQLExec
  Error Position: 21
  Return: 942 - ORA-00942: table or view does not exist
  Statement: select count(*) from PS_DUMMY_PRP_TBL
  Original Statement: SELECT COUNT(*) FROM PS_DUMMY_PRP_TBL (0,0)

SQL error in Exec. (2,280) UPGCOUNT.MAIN.GBL.default.1900-01-01.Step01.OnExecute PCPC:1655 Statement:20
 Message Set Number: 2
 Message Number: 280
 Message Reason: SQL error in Exec. (2,280)
Process 166980 ABENDED at Step UPGCOUNT.MAIN.Step01 (PeopleCode) -- RC = 8 (108,524)
 Message Set Number: 108
 Message Number: 524
 Message Reason: Process 166980 ABENDED at Step UPGCOUNT.MAIN.Step01 (PeopleCode) -- RC = 8 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s


2023-08-17 13:33:34.127 - Step Failed at: Reviewing Table Row Counts

The issue can be reproduced at will with the following steps:
1. Login to Cloud Manager
2. Select  Cloud Manager Setting Tile >  Manage Updates
3. And select Apply button

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.