"Error 6 initializing SQL*Plus ... SP2-0667: Message file sp1.msb not found" and Primavera Data Warehouse Schema Upgrade Fails

(Doc ID 2162640.1)

Last updated on APRIL 18, 2018

Applies to:

Primavera Analytics - Version 15.2.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to upgrade the Data Warehouse schema from 3.4 to 15.2 using the upgradeschema34.sh/.bat script, it fails with the following error:

schemaUpgrade [INFO] (Progress) - Step 4/13 Part 1/2 - [07/11/2016 08:53:42] DropStagingAndViews -- Drop existing staging tables and views (upgrade/drop_staging_tables.sql)
schemaUpgrade [INFO] (Message) - === Step 4, Part 1 ====================================================
schemaUpgrade [INFO] (Message) - === Drop existing staging tables and views (upgrade/drop_staging_tables.sql)
schemaUpgrade [WARN] (Message) - Error 6 initializing SQL*Plus
schemaUpgrade [WARN] (Message) - SP2-0667: Message file sp1.msb not found
schemaUpgrade [WARN] (Message) - SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

The issue can be reproduced at will with the following steps:

  1. Run upgradeschema34.sh/.bat
  2. View log file

Changes

 

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