Data Extract batch jobs fail in INCREMENTAL mode (after upgrading from OC 4.6.x to 5.x.x)
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.
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 SSB_FLEX$CURRENT
Warning: Could not connect user SSB_FLEX$CURRENT, will try again after resetting password.
ERR level 1
Error setting role for SSB_FLEX$CURRENT
ERR level 1
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
Upgraded from OC 4.6.x to OC 5.x.x
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