Alter Table Drop Column Failed Because Column 'Audit_info_extended' Does Not Exist in Table 'Spidmap' When Upgrading From 8.3.2 to 16.2 (Doc ID 2222029.1)

Last updated on MARCH 09, 2017

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 16.2.0.0 and later
Information in this document applies to any platform.

Symptoms

When upgrading from 8.3.2 to 16.2 the following error occurs:

ERROR


ALTER TABLE DROP COLUMN failed because column 'audit_info_extended' does not exist in table 'SPIDMAP'.SQL Query:
declare @default_name varchar(255)
declare @col_name varchar(255)
select @default_name =name from sys.default_constraints where
parent_object_id=object_id('SPIDMAP') and
col_name(parent_object_id,parent_column_id)='audit_info_extended'
if @default_name is not null
exec ('alter table dbo.SPIDMAP drop constraint '+@default_name)
ALTER TABLE SPIDMAP drop column audit_info_extended

STEPS TO REPRODUCE:

1. Run dbsetup.
2. Enter connection info.
3. Click Yes to upgrade.
4. Notice the above issue.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms