Hello Vivek, >From the error it looks like it doesn't like to upgrade directly to 9 from 7.1. (Obvious reason could be there is huge change between AR 7.1 and 9)
You may 1st upgrade AR to 7604 then to 9, (With this there wont be much changes in Control table of AR Server.) Thanks Onkar On Fri, Jan 15, 2016 at 12:10 PM, Vivek <[email protected]> wrote: > Hi, > > We are getting following error while upgrading Remedy from 7.1 to 9: > > LOG EVENT {Description=[[SQLERROR] [DESCRIPTION] Failed to upgrade the > database schema],Detail=[[SQLERRORCODE]=947 [SQLMESSAGE]=ORA-00947: not > enough values [SQLSTATEMENT]=INSERT INTO controlRecordIds VALUES (1, 1, 1, > 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, > 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,1, 1, 1, 1, 1, 1, 1, 1, 1 )]} (Jan 14 > 2016 05:03:27.879 PM > > +0100),SEVERE,com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.ARServerOracleManageUpgradeDatabaseTask, > > Please let me know if anyone has seen this before or know how can we > resolve > it. > > Thanks, > Vivek > > > > -- > View this message in context: > http://ars-action-request-system.1.n7.nabble.com/Error-while-upgrading-Remedy-from-7-1-to-8-1-02-tp123609.html > Sent from the ARS (Action Request System) mailing list archive at > Nabble.com. > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > -- Regards, Onkar Shinde Mobile: +91-7709008719 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
