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.


-- 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 script, the following error occurs:

> Setting environment variables...
> Setting up Oracle environment (lsh) line 32: syntax error near unexpected token `(' 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.


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