Control-M: 33_EUP - Event: JOB NOT OK App: BARN-IS-BI-PROD-BPB Job: ORACLE-DBSTATS Folder: 9EUPR33_SUS-DATABASE-BW
1 . Detailed description of the Issue: Failure of ORACLE-DBSTATS job in BARN-IS-BI-PROD-BPB in  Control-M 
2 . GXP impact : No 
3. Actions taken: Checked the error Logs. 
4. Root cause: SAP BW dynamically creates and drops table partitions during data load, compression, and housekeeping activities. When ORACLE-DBSTATS runs concurrently, it may attempt to collect statistics on partitions that were valid at job start but no longer exist at execution time, resulting in an ORA?20000 error. 
5. Workaround: Yes, Statistics collection completes successfully on the next scheduled run once BW partition changes are finished. No manual correction is required. 
6. Solution: NA 
7. customer feedback : NA 
8. Change reference: NA