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 and later
Information in this document applies to any platform.


When upgrading from 8.3.2 to 16.2 the following error occurs:


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
if @default_name is not null
exec ('alter table dbo.SPIDMAP drop constraint '+@default_name)
ALTER TABLE SPIDMAP drop column audit_info_extended


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


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