000031097 - Oracle Errors found in scheduled OfflineTasks log

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000031097
Applies ToRSA Product Set: Adaptive Authentication (OnPrem)
RSA Product/Service Type: Adaptive Authentication (OnPrem)
RSA Version/Condition: 7.x
Platform: Oracle
IssueThe Adaptive Authentication On-Prem (AAOP) Offline Tasks job, is failing daily when run from the scheduler application with the following errors in the  aa_re_offline.log:
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
ORA-04021: timeout occurred while waiting to lock object
ORA-02149: Specified partition does not exist
ORA-14074: partition bound must collate higher than that of the last partition
ORA-00001: unique constraint (PMSECURE.REOT_PART_KEY_DAYS_CALC_PK) violated
You may also see an error listing at least some of the following tables:
27 Jul 2015 03:15:01,602 ERROR [com.rsa.re.offlinetasks.tasks.cleanup.CleanupTask] Cleaning up following tables did not completed successfully
    RBA_BS_CATEGORY_BUCKET_STAT
    ENTITY_AGGREGATIONS
    REOT_EVENT_EXTRA_DATA
    REOT_EVENT_DYNAMIC_BUCKETS
    REOT_EVENT_DYN_BUCKETS_KEEP
    REOT_EVENT_EXTRA_DATA_KEEP
CauseThe Offline tasks job is not able to perform it's cleanup due to database contention.
ResolutionThis problem is almost always caused by having more than one instance of the AAOP scheduler application running. Check all your application servers and make sure scheduler is only deployed on one of them.
If your the scheduler application is only deployed once, then verify no maintenance or other batch jobs are running against the AAOP Core database. If no other jobs are running and the job keeps failing, double check all your application servers. You most likely have a second instance of the Scheduler running.
 
WorkaroundWhen you are having trouble with the "Offline" tasks job running under the scheduler due to various issues, you can disable the job from the Backoffice -> Administration -> Scheduled Tasks screen and instead run it manually. Refer to chapter 3 of the AAOP Operations Guide.

Attachments

    Outcomes