My Oracle Support Banner

Error 'Error in run sql script ssppm_pm_migrate.sql: alter table only allows columns to be added that can contain nulls' and Databae Schema Migration Fails in SQL Server When the DISCUSSION Table Contains Data (Doc ID 2963813.1)

Last updated on SEPTEMBER 05, 2023

Applies to:

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

Symptoms

When migrating a SQL Server database from PPM to EPPM or from EPPM to PPM, the migration fails in step Core PPM to PM Schema Migration with the following error:

Error in run sql script ssppm_pm_migrate.sql: alter table only allows columns to be added that can contain nulls, or have a default definition specified, or the column being added is an identity or timestamp column, or alternatively if none of the previous conditions are satisfied, the table must be empty to allow
addition of this column. Column proj_id cannot be added to non-empty table DISCUSSION because it does not satisfy these conditions.

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.