Control-M: 33_EUP - Event: JOB NOT OK App: BARN-IS-BI-PROD-BPB Job: ORACLE-DBSTATS Folder: 9EUPR33_SUS-DATABASE-BW
Incident Description 
The scheduled BRCONNECT statistics collection job completed with a return code RC=1, causing the job to be flagged as FAILED by the scheduler, despite the majority of statistics being successfully collected. 
 
Key Findings 
 
BRCONNECT executed successfully and completed with warnings, not a fatal error. 
Out of 361 database objects selected for statistics collection: 
 
360 objects were updated successfully. 
1 object failed to collect statistics, triggering a warning (BR1308W). 
 
 
Total tables checked: 32,922 
BRCONNECT explicitly reported: 
"BRCONNECT completed successfully with warnings" 
No database outage, corruption, or backup issue was detected. 
 
 
Root Cause 
 
A single table or index failed during statistics collection (non?critical). 
BRCONNECT returns RC=1 when warnings are present. 
The job scheduler/wrapper treats any non?zero return code as failure, leading to a false?negative incident. 
 
Resolution Actions 
 
Job reviewed and confirmed as functionally successful. 
Identified that RC=1 = success with warnings for BRCONNECT. 
Incident closed as non?functional failure / monitoring misinterpretation.