Default Schema/Database For Primavera Shows Changed Objects In The Schema Validation Utility (Validate.[bat/sh]) (Doc ID 1620963.1)

Last updated on JUNE 29, 2016

Applies to:

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

Symptoms

Schema Validation output shows changed objects for a new default database and/or an upgraded database.

 

SQL Server Database

Changed Objects:

Object TypeObject NameTable NameMessageSourceTarget
FIELD doc_data DOC_VERSION Changed column DOC_VERSION.doc_dat blob blob_sf
FIELD pc_process_stat_id PC_PROCESS_STAT Changed column PC_PROCESS_STAT.pc_process_stat_id double identity
FIELD start_ts PC_PROCESS_STAT Changed column PC_PROCESS_STAT.start_ts UNKNOWN ortimestamp
FIELD end_ts PC_PROCESS_STAT Changed column PC_PROCESS_STAT.end_ts UNKNOWN ortimestamp

 

Oracle Database

Changed Objects:

Object TypeObject NameTable NameMessageSourceTarget
FIELD doc_data DOC_VERSION Changed column DOC_VERSION.doc_dat blob blob_sf
FIELD pc_process_stat_id PC_PROCESS_STAT Changed column PC_PROCESS_STAT.pc_process_stat_id double identity
FIELD start_ts PC_PROCESS_STAT Changed column PC_PROCESS_STAT.start_ts UNKNOWN ortimestamp
FIELD end_ts PC_PROCESS_STAT Changed column PC_PROCESS_STAT.end_ts UNKNOWN ortimestamp

 

Extra Objects:

Object TypeObject NameTable NameMessage
INDEX docver_docdata_qsi doc_version Extra Index DOC_VERSION.docver_docdata.qsi

 

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