Migrate Tool Does Not Create Privuser Views and Set Pubuser.Private_db_passwd (Doc ID 2087409.1)

Last updated on JULY 12, 2017

Applies to:

Primavera P6 Professional Project Management - Version 15.1.0.0 to 15.2.2.1 [Release 15.1 to 15.2]
Primavera P6 Enterprise Project Portfolio Management - Version 15.1.0.0 to 15.2.2.0 [Release 15.1 to 15.2]
Information in this document applies to any platform.

Symptoms

DESCRIPTION OF PROBLEM:
-------------------------
When migrating a database from SQL Server to SQL Server or from Oracle to SQL Server, the following issues occur with the schema in the new database:

  1. The views for privuser are not created.
  2. The pubuser table in the target database is not updated with the data from the source database.

STEPS TO REPRODUCE:
-------------------------

  1. Migrate a SQL Server database to SQL Server
  2. In the target database, note that the privuser views are missing (using the SQL Management Studio)

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