Hi,
I am having an issue where Aveksa fails to create a user access review result when the number of items to include is very high (example: 17000 items).
The highest number I've had so far is 11000 items.
Do any of you know what is the maximum number of items that is allowed within a user access review?
Regards
Armel Lupapi
A review definition is configured to review all the direct user access (business role and app-role) from a business division.
Aveksa Version 6.8.1
When running the review, the processing run fails.
See attached the aveksaserver.log and server.log
Regards
Armel Lupapi
Group IT | armel.lupapi@investec.co.za<mailto:armel.lupapi@investec.co.za> | Tel: +27 11 286 8063 | Cell: +27 76 920 8549
Client Support Centre: +27 11 286 9663 / 0860 110 161 | www.investec.co.za <https://www.investec.co.za/>
“The best way to get started is to quit talking and begin doing.”
Here is the relevant error
ORA-20126: The creation of reviews failed.
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
Stored Procedure:Parse_Ents_In_User_Review execution aborted.
Stack:
ORA-06512: at "AVUSER.REVIEW_DEFINITION_PARSER", line 7841
Stored Procedure:Parse_User_Review execution aborted.
Stack:
ORA-06512: at "AVUSER.ERROR_HANDLER_PKG", line 903
ORA-06512: at "AVUSER.ERROR_HANDLER_PKG", line 917
ORA-06512: at "AVUSER.REVIEW_DEFINITION_PARSER", line 7856
ORA-065
Stored Procedure:Generate_Review execution aborted.
Stack:
ORA-06512: at "AVUSER.ERROR_HANDLER_PKG", line 903
ORA-06512: at "AVUSER.ERROR_HANDLER_PKG", line 917
ORA-06512: at "AVUSER.REVIEW_DEFINITION_PARSER", line 413
ORA-06512: at "AVUSER.REVIEW_DEFINITION_PARSER", line 326
ORA-06512: at "AVUSER.ENTITLEMENT_REVIEW_PKG", line 630
ORA-06512: at "AVUSER.ENTITLEMENT_REVIEW_PKG", line 1749
ORA-06512: at "AVUSER.ERROR_HANDLER_PKG", line 903
ORA-06512: at "AVUSER.ERROR_HANDLER_PKG", line 917
ORA-06512: at "AVUSER.ENTITLEMENT_REVIEW_PKG", line 1895
ORA-06512: at "AVUSER.ENTITLEMENT_REVIEW_PKG", line 1537
ORA-06512: at "AVUSER.ENTITLEMENT_REVIEW_PKG", line 1502
ORA-06512: at line 1
Take a look at the following KB article - 000028161 - KB-1287 - ORA-01652 : unable to extend temp segment by 128 in tablespace TEMP
Thanks Boris.
I was thinking about it as well. I am in talk with the organization Database administrator to find a solution.
Regards
Armel Lupapi
Group IT | armel.lupapi@investec.co.za<mailto:armel.lupapi@investec.co.za> | Tel: +27 11 286 8063 | Cell: +27 76 920 8549
Client Support Centre: +27 11 286 9663 / 0860 110 161 | www.investec.co.za <https://www.investec.co.za/>
“The best way to get started is to quit talking and begin doing.”
As far as I know, 17000 items in a user access review is not a high number.
Can you describe the behavior in more detail?
What product version?
What is happening when you are running a review?
Any errors in the logs?