We are on v13.0.1 and upgrading to v13.3. Using windows environment and Oracle DB. The internal upgrade to v13.1 and v13.2 went well but it failed on the final v13.3 upgrade part with the below error: --> ORA-01422: exact fetch returns more than requested number of rows --> SQL query is given below:
SELECT UNIQUE P.ID INTO V_SEC_OBJECT_INS_ID FROM CMN_PORTLETS P,CMN_MENU_ITEMS M, CMN_SEC_USERS S
WHERE P.ID = M.CONTAINER_ID AND M.PRINCIPAL_ID = S.ID AND M.PRINCIPAL_TYPE = 'USER'
AND P.PORTLET_TYPE_CODE = 'FAVORITE' AND S.USER_NAME = 'admin';
IF V_SEC_OBJECT_INS_ID > 0 THEN
CMN_SEC_ASSIGN_INST_RIGHT_SP('USER', 'admin', 'UserFavoriteEditor', V_SEC_OBJECT_INS_ID);
When i take the select part out of it, I get 3 to 5 rows as output from DEV and PROD clarity environments. How about you? Has anyone faced this upgrade issue?
This query was executed from
Process - post-upgrade: POSTUPGRADE_73327.xml
Any help is appreciated.