AnsweredAssumed Answered

15.2 Upgrade Fails

Question asked by Augustin2537 on Jul 13, 2017
Latest reply on Jul 17, 2017 by Augustin2537
Hi  

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

 

Nika_Hadzhikidi

SumanPramanik

Outcomes