My Oracle Support Banner

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 MARCH 06, 2019

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 'STUDY_NAME'$CURRENT
Warning: Could not connect user 'STUDY_NAME'$CURRENT, will try again after resetting password.
ERR level 1
connect_as_user
Error setting role for 'STUDY_NAME'$CURRENT
ERR level 1
maintain_account
Error when calling connect_as_user
Connect prvl user.
Connected to ORACLE as user [OPS$USER]/@SID.
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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.