Saw something similar, but it was 7.0.1, no patch: http://arswiki.org/wiki/ARS_7.x_Topics#Issues_with_Oracle_Unicode_Upgrade
Axton Grams On Dec 28, 2007 9:10 PM, Pedro Cardoso <[EMAIL PROTECTED]> wrote: > ** Hi all, do you know this error is related to DB backup-restore process? > How I can know it? > I run installer with upgrade option and it finish fine stage until 5, when > trying to restart the server I got > > 390600 : This version of the Action Request System(R) is ready for use or > evalu For unlimited capabilities, contact your sales representative. > (ARNOTE 27) 390600 : The database is not the expected version (may need to > run upgrade prog > 390600 : AR System server terminated -- fatal error encountered (ARNOTE > 21) > ARNOTE 0) Unable to receive indication that server is up. > > In arsql.log I find this..*** ERROR *** ORA-01406: fetched column value > was truncated > and the script dont finish to upgrade the DB. > > and ar_install finish with this message. > > /* Fri Dec 28 18:22:26 2007 */ Start of Stage 1 of 21 > /* Fri Dec 28 18:22:26 2007 */ Upgrade old field-lengths codeset=0 > 'windows-1252' errorCode=0 > Failure during SQL operation to the database (ARERR 552) > Repair of 6.3 Unicode database failed. > > Thanks for any Help > > Linux RedHat 4 > Oracle 10g > Remedy CSS 5.6 > ARS 6.3 to upgrade to 7.01 patch 5 > > > Peter > > > /* Fri Dec 28 18:27:17 2007 */ SELECT > name,escalationId,timestamp,version,smObjProp,safeGuard,objPro > p,queryShort,queryLong FROM escalation ORDER BY 2 ASC > /* Fri Dec 28 18:27:17 2007 */ OK > /* Fri Dec 28 18:27:17 2007 */ UPDATE escalation SET > queryShort='1\2\4\1\1\300597200\2\0\4\1\1\30059 > 7200\2\4\19\Llamada Telefónica\4\6\1\300081200\2\4\8\Resuelto\' WHERE > escalationId=2970 > /* Fri Dec 28 18:27:17 2007 */ OK > /* Fri Dec 28 18:27:17 2007 */ UPDATE escalation SET > queryShort='1\2\4\1\1\300597200\2\0\4\1\1\30059 > 7200\2\4\19\Llamada Telefónica\4\6\1\300081200\2\4\8\Resuelto\' WHERE > escalationId=3307 > /* Fri Dec 28 18:27:17 2007 */ OK > /* Fri Dec 28 18:27:17 2007 */ SELECT > schemaId,fieldId,vuiId,propShort,propLong FROM field_dispprop > ORDER BY 1 ASC,2 ASC,3 ASC > /* Fri Dec 28 18:27:17 2007 */ OK > /* Fri Dec 28 18:34:14 2007 */ *** ERROR *** ORA-01406: fetched column > value was truncated > /* Fri Dec 28 18:34:14 2007 */ ROLLBACK WORK > /* Fri Dec 28 18:34:14 2007 */ COMMIT WORK RELEASE > /* Fri Dec 28 18:34:14 2007 */ SQL Trace Log -- OFF > __20060125_______________________This posting was submitted with HTML in > it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
