000028151 - KB-1320 - Error ORA-20126 : Review Failure

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

Article Content

Article Number000028151
Applies ToAffected Versions: 4.2.X
IssueAttempting to generate a review result produces the following error in the application server. In the UI you will see no review results and the monitoring page will show success.

ORA-20126: The creation of reviews failed.

ORA-30926: unable to get a stable set of rows in the source tables

Stored Procedure:Generate_Reviews3 execution aborted.

Stack:

ORA-06512: at "AVUSER.ENTITLEMENT_REVIEW_PKG", line 11912

ORA-06512: at "AVUSER.ENTITLEMENT_REVIEW_PKG", line 639

ORA-06512: at "AVUSER.ERROR_HANDLER_PKG", line 979

ORA-06512: at "AVUSER.ENTITLEMENT_REVIEW_PKG", line 658

ORA-06512: at "AVUSER.ENTITLEMENT_REVIEW_PKG", line 245

ORA-06512: at line 1
ResolutionSolution (two parts) :
1. The review generation may fail because the table T_AV_REV_COMPONENT_COV_NEW exists in the db. To fix the issue drop the table T_AV_REV_COMPONENT_COV_NEW from the database.
2. log into the appliance and run sqlplus as avuser with this sql statement:
select * from user_tables where table_name like 'STX_%;
if this returns any results, please dropl the STX tables listed from the query

Attachments

    Outcomes