"ORA-00959: tablespace 'STAR_DAT1' does not exist ORA-06512: at line 15" When Running ETL

(Doc ID 2308877.1)

Last updated on SEPTEMBER 27, 2017

Applies to:

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

Symptoms

When attempting to run ETL, the following error occurs:

ERROR

staretl [INFO] (Message) - Reading Properties file
staretl [INFO] (Progress) - Step 1/59 Part 1/1 - [08/24/2017 13:32:54] InitalParameterUpdate -- Update ETL parameters (UpdateEtlParameters)
staretl [INFO] (Message) - === Step 1, Part 1 ====================================================
staretl [INFO] (Message) - === Update ETL parameters (UpdateEtlParameters)
staretl [INFO] (Message) - No Set Properties
staretl [INFO] (Progress) - Step 1/59 Part 1/1 - DONE (0 hours, 0 minutes, 0 seconds, 297 milliseconds)

staretl [INFO] (Message) - Reading Properties file
staretl [INFO] (Progress) - Step 4/59 Part 1/3 - [08/24/2017 13:32:55] CreateStar -- Create the Star database (InvokeScriptRunner)
staretl [INFO] (Message) - === Step 4, Part 1 ====================================================
staretl [INFO] (Message) - === Create the Star database (InvokeScriptRunner)
staretl [INFO] (Message) - [2017-08-24 13:32:55] Setting override properties
staretl [INFO] (Message) - [2017-08-24 13:32:56] Using Override Properties
staretl [INFO] (Message) - [2017-08-24 13:32:56] Running Script: run$script.sql
staretl [ERROR] (Message) - [2017-08-24 13:32:56] ORA-00959: tablespace 'STAR_DAT1' does not exist
ORA-06512: at line 15

staretl [ERROR] (Message) - [2017-08-24 13:32:56] Database Error: error number=959
staretl [ERROR] (Message) - [2017-08-24 13:32:56] Error Message: ORA-00959: tablespace 'STAR_DAT1' does not exist
ORA-06512: at line 15

staretl [ERROR] (Message) - [2017-08-24 13:32:56] DECLARE
  user_created_already EXCEPTION;
  PRAGMA EXCEPTION_INIT(user_created_already, -1920);
BEGIN
  EXECUTE IMMEDIATE 'create user STARUSER
  identified by starSTG1
  temporary tablespace TEMP
  default tablespace STAR_DAT1
  quota unlimited on STAR_DAT1
  quota unlimited on STAR_HST1';
EXCEPTION
  WHEN user_created_already THEN
  dbms_output.put_line('user already created, skipping creation of STARUSER');
  WHEN OTHERS THEN
  RAISE;
END;
staretl [ERROR] (Message) - [2017-08-24 13:32:56] Script Failed

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