Jobs Submitted For Datamart Instance Remain In 'Obtainservice' Execution Status (Doc ID 819875.1)

Last updated on OCTOBER 14, 2014

Applies to:

Oracle Life Sciences Data Hub - Version: 2.1.1
This problem can occur on any platform.

Symptoms

-- Problem Statement:
On 2.1.1 in Development:
When attempting to submit a Datamart instance of type Oracle Export,
the submitted job remains in 'Pending' status with Execution Status set to 'Obtainservice'.
If trying to manually execute the oraexp.sh script, the following error occurs:

ERROR
> Setting environment variables...
> Setting up Oracle environment (lsh)
oraexp.sh: line 32: syntax error near unexpected token `('
oraexp.sh: line 32: `foreach arg ($argv) '

-- Steps To Reproduce:
The issue can be reproduced with the following steps:
1. Create a new Work Area;
2. Create a new Data Mart definition and instance using 'Oracle Export' adapter;
3. Create a Table Descriptor from an existing Table instance;
4. Install the Work Area;
5. Submit the Data Mart Instance.

-- Business Impact:
The issue has the following business impact:
Due to this issue, users cannot submit an Oracle Export Data Mart instance.

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