LSH: ORA-00959 Error While Installing Work Area Following Smoke Test Step 2.34 (Doc ID 2061747.1)

Last updated on OCTOBER 06, 2016

Applies to:

Oracle Life Sciences Data Hub - Version 2.2.0.5 and later
Information in this document applies to any platform.

Symptoms

LSH Version 2.4, you are following the LSH Smoke Test Document. You are on step 2.34 of Smoke Test Document, and encounter the following error message when installing a Work Area: 


Set install status to $INSTSTATUSES$DROPPED
Set install status to $INSTSTATUSES$CREATEACTIVE
Calling Create deployment
Deploying CDR_W1C86_3997D_$CREATE_1
Unit Name=CDR_W1C86_3997D_$CREATE_1
ORA-00959: tablespace ' LSH_OBJECTS16K' does not exist

Unit Name=CDR_W1C86_3997D_$CREATE_1
ORA-00942: table or view does not exist

Unit Name=CDR_W1C86_3997D_$CREATE_1
ORA-00942: table or view does not exist

Deploying AUX_CDR_W1C86_3997D_0_$CREATE_2
Unit Name=AUX_CDR_W1C86_3997D_0_$CREATE_2
ORA-00942: table or view does not exist

Unit Name=AUX_CDR_W1C86_3997D_0_$CREATE_2
ORA-00942: table or view does not exist

fail to complete create deployment
Set install status to $INSTSTATUSES$CREATEACTIVE
set work area status to install failed
OWB deployment ID=14310

...
1. Error during Workarea Install : There are errors during OWB deployment. See install log for details.

------------------------------------
Failed to install WorkArea
Revoking privileges from the primary schema


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

1.  Domain
2.  Application Area
3.  Work Area
4.  In the LOV, select Table (in order to create a new table)
5.  Create new table definition and instance and call it TAB1, and add one column called COL1 Varchar2(25)
6.  Navigate to the Work Area, and press the Installation Button, Omit None, keep the radio button as Upgrade, select Apply and Install
7.  Results in the aforementioned error message.


NOTE:  Users also get this error message following the Smoke Test Steps.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot Install Work Areas on this new environment.

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