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 JANUARY 06, 2020
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.
some Data Extract batch jobs fail in INCREMENTAL mode (after upgrading from OC 4.6.x to 5.x.x)
The same Data Extract batch job succeeds in FULL mode after which INCREMENTAL mode jobs start to work.
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
Error setting role for 'STUDY_NAME'$CURRENT
ERR level 1
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
Upgraded from OC 4.6.x to OC 5.x.x
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