000034773 - Offline Tasks Failing in RSA Adaptive Authentication (OnPrem) 7.2 - Cannot delete old partitions for the table RBA_BS_CATEGORY_BUCKET_STAT

Document created by RSA Customer Support Employee on Feb 20, 2017
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000034773
Applies ToRSA Product Set: Adaptive Authentication (OnPrem)
RSA Product/Service Type: Adaptive Authentication (OnPrem)
RSA Version/Condition: 7.2
 
IssueAn Adaptive Authentication (On Premise) customer noticed the following error in their aa_re_offline.log:
 
31 Jan 2017 01:00:10,949 INFO  [com.rsa.re.offlinetasks.tasks.cleanup.ClassicTableCleaner] --- Delete old partitions for table RBA_BS_CATEGORY_BUCKET_STAT.
31 Jan 2017 01:00:12,688 WARN  [com.rsa.re.offlinetasks.tasks.cleanup.ClassicTableCleaner] !!! Could not complete cleanup of table RBA_BS_CATEGORY_BUCKET_STAT, attempt to clean the table will be executed next time the task will be executed
java.lang.RuntimeException: --- Cannot delete old partitions for the table RBA_BS_CATEGORY_BUCKET_STAT
    at com.rsa.re.offlinetasks.tasks.cleanup.ClassicTableCleaner.executeStmt(ClassicTableCleaner.java:278)
    at com.rsa.re.offlinetasks.tasks.cleanup.ClassicTableCleaner.partitionCleanup(ClassicTableCleaner.java:254)
    at com.rsa.re.offlinetasks.tasks.cleanup.ClassicTableCleaner.cleanupTable(ClassicTableCleaner.java:127)
    at com.rsa.re.offlinetasks.tasks.cleanup.ClassicTableCleaner.clean(ClassicTableCleaner.java:88)
    at com.rsa.re.offlinetasks.tasks.cleanup.CleanupTask.execute(CleanupTask.java:167)
    at com.rsa.re.offlinetasks.OfflineTasksMgr.runOfflineTasks(OfflineTasksMgr.java:240)
    at com.rsa.re.offlinetasks.OfflineTasksMgr.runOfflineTasks(OfflineTasksMgr.java:117)
    at com.rsa.csd.wrapper.REOfflineTasksWrapper.process(REOfflineTasksWrapper.java:103)
    at com.rsa.csd.wrapper.REOfflineTasksWrapper.process(REOfflineTasksWrapper.java:112)
    at com.rsa.csd.scheduler.BatchJobWrapper.process(BatchJobWrapper.java:94)
    at com.rsa.csd.scheduler.BatchJobWrapper.executeInternal(BatchJobWrapper.java:78)
    at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:86)
    at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
    at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The specified partition range value could not be found.
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
    at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:332)
    at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
    at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
    at com.rsa.db.direct.CPreparedStatementWrapper.execute(CPreparedStatementWrapper.java:170)
    at com.rsa.re.offlinetasks.tasks.cleanup.ClassicTableCleaner.executeStmt(ClassicTableCleaner.java:267)
    ... 13 more
31 Jan 2017 01:00:12,689 INFO  [com.rsa.re.offlinetasks.tasks.cleanup.ClassicTableCleaner] --- Starting cleanup REOT_BUCKET_AGGR_STATUS table before the date 20161023


 
TasksA change was needed in RE_CREATE_PARTITIONS procedure in order to handle the gap introduced when the scheduler is not running for a day or more.
ResolutionThis issue has been fixed and is available in V7.2 Hot Fix 30.

Attachments

    Outcomes