Data Extract batch jobs fail in INCREMENTAL mode (after upgrading from OC 4.6.x to 5.x.x) (Doc ID 2029953.1)

Last updated on AUGUST 03, 2015

Applies to:

Oracle Clinical - Version 5.0.0 to 5.1.0 [Release 5.0.0 to 5.1]
Information in this document applies to any platform.

Symptoms

i.
some Data Extract batch jobs fail in INCREMENTAL mode (after upgrading from OC 4.6.x to 5.x.x)


ii.
The same Data Extract batch job succeeds in FULL mode after which INCREMENTAL mode jobs start to work.


iii.
The following error appears in the Data Extract 'out' file when debug is enabled :

Executing: Connect SSB_FLEX$CURRENT
Warning: Could not connect user SSB_FLEX$CURRENT, will try again after resetting password.
ERR level 1
connect_as_user
Error setting role for SSB_FLEX$CURRENT
ERR level 1
maintain_account
Error when calling connect_as_user
Connect prvl user.
Connected to ORACLE as user [OPS$SBAINS]/@oc501lnx.
Connected to ORACLE as user RXC_MAA.
rxcvbcmn_pc_stmt_01 executed successfully.
RXCDXBVB EXIT WITH FAILURE

Changes

 Upgraded from OC 4.6.x to OC 5.x.x

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