We are curretly upgrading from 14.2 to 15.2. install.sh script fails with the below error. Its because "51762" ID is already available in CMN_CAPTIONS table and install script is trying to insert a row with the same ID. I assumed it uses CMN_CAPTIONS_S1 sequence and executed CMN_ID_SP Procedure to make sure the nextval is the max(id)+1 and re-ran the install script. Still it failed with the same error. Can someone please help?
BEGIN -- CREATE A FLAG IN THE CMN_OPTIONS TO ENABLE/DISABLE CURRENCY CONVERSION IN HIERARCHY PAGE INSERT INTO CMN_OPTIONS (ID,OPTION_CODE,IS_ACTIVE,IS_SYSTEM,CREATED_DATE,CREATED_BY,LAST_UPDATED_DATE,LAST_UPDATED_BY) VALUES (51762,'CURRENCY_CONVERSION_REQUIRED',1,1,SYSDATE,1,SYSDATE,1); INSERT INTO CMN_OPTION_VALUES (ID,OPTION_ID,COMPONENT_ID,USER_ID,VALUE,CREATED_DATE,CREATED_BY,LAST_UPDATED_DATE,LAST_UPDATED_BY) VALUES (51542,51762,NULL,NULL,'1',SYSDATE,1,SYSDATE,1); END; com.ca.clarity.jdbc.oraclebase.ddc: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00001: unique constraint (NIKU.CMN_OPTIONS_PK) violated ORA-06512: at line 3