AnsweredAssumed Answered

v13.3 Upgrade Error

Question asked by Georgy N Joseph on Jun 5, 2014
Latest reply on Jun 6, 2014 by Georgy N Joseph

Hi Friends,

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:

DECLARE
V_SEC_OBJECT_INS_ID NUMBER;
BEGIN
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);
END IF;
END;

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
post-upgrade: POSTUPGRADE_CLRT_70109_FAV_MENU_ASSGND_OBJ_PERM.xml

Any help is appreciated.

Georgy

Outcomes