Hello Amanda I ran into the same issue, but the arsql.log is decieving. Not all the statements executed by the installer are written to the log. I upgraded from ARS 6.3 to 7.0.1. I was in a similar situation, I went by the DML/DDL statements one by one from the log tried it in SQL PLus it works fine but when I run the installer it fails. After much frustration found out that its not because of the SUPPORT_FILEY22 table. The installer looks at the user table for duplicates and also if user and user_cache is out of sync you will have this upgrade failure. As a first step, try identifying any duplicate login names in the user form remove those through the user form through the application(USER TOOL). When you save this it automatically saves the record will update the user_cache also. OR if you can do a MODIFY ALL action on the user form selecting all the records that will sync up the user_cache. Don't run arreload(that is what it is supposed to do), but please do it through the application and save it and then trying running the installer. Please let me know how it goes? SK
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Scott Sent: Thursday, March 15, 2007 7:34 AM To: [email protected] Subject: Re: Remedy 7.0.1 patch 001 Upgrade Problem ** Amanda, After Googling the error, here is probably your best bet: daust:oracle[o1020]> oerr ora 22835 22835, 00000, "Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: %s, maximum: %s)" // *Cause: An attempt was made to convert CLOB to CHAR or BLOB to RAW, where // the LOB size was bigger than the buffer limit for CHAR and RAW // types. // Note that widths are reported in characters if character length // semantics are in effect for the column, otherwise widths are // reported in bytes. // *Action: Do one of the following: // 1. Make the LOB smaller before performing the conversion, // for example, by using SUBSTR on CLOB // 2. Use DBMS_LOB.SUBSTR to convert CLOB to CHAR or BLOB to RAW. Bruce Scott Application Developer - Remedy SSG, PetSMART, Inc. eMail: [EMAIL PROTECTED] ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Pierce, Amanda (TBS) Sent: Thursday, March 15, 2007 7:16 AM To: [email protected] Subject: Remedy 7.0.1 patch 001 Upgrade Problem ** All, We are upgrading from Remedy 6.0.1 to Remedy 7.0.1 patch 001. We are on an Oracle 10.2.3 database. When we go to install Remedy 7.0.1 patch 001 we see the following error in our sql log: /* Tue Mar 13 16:32:26 2007 */ SQL Trace Log -- ON /* Tue Mar 13 16:32:26 2007 */ CONNECT ARAdmin /* Tue Mar 13 16:32:26 2007 */ SELECT BANNER FROM V$VERSION /* Tue Mar 13 16:32:26 2007 */ OK /* Tue Mar 13 16:32:26 2007 */ ALTER SESSION SET NLS_COMP=BINARY /* Tue Mar 13 16:32:26 2007 */ OK /* Tue Mar 13 16:32:26 2007 */ ALTER SESSION SET NLS_SORT=BINARY /* Tue Mar 13 16:32:26 2007 */ OK /* Tue Mar 13 16:32:26 2007 */ SELECT dbVersion FROM control /* Tue Mar 13 16:32:26 2007 */ OK /* Tue Mar 13 16:32:26 2007 */ COMMIT WORK /* Tue Mar 13 16:32:26 2007 */ INSERT INTO servgrp_op_mstr VALUES ('Reconciliation Engine', -1, 'Reconciliation-Engine-Suspended:', 'SG-Check-Config', 'Reconciliation-CHK-CONFIG;Reconciliation') /* Tue Mar 13 16:32:27 2007 */ OK /* Tue Mar 13 16:32:27 2007 */ INSERT INTO servgrp_op_mstr VALUES ('CMDB', -1, 'CMDB-Service-Suspended:', 'SG-Check-Config', 'CMDB-CHK-CONFIG;CMDB') /* Tue Mar 13 16:32:27 2007 */ OK /* Tue Mar 13 16:32:27 2007 */ DELETE FROM servgrp_op_mstr WHERE operation = 'Full Text Index' /* Tue Mar 13 16:32:27 2007 */ OK /* Tue Mar 13 16:32:27 2007 */ SELECT schemaId FROM field WHERE fieldId = 731 /* Tue Mar 13 16:32:27 2007 */ OK /* Tue Mar 13 16:32:27 2007 */ COMMIT WORK /* Tue Mar 13 16:32:27 2007 */ UPDATE control SET dbVersion = 21 /* Tue Mar 13 16:32:27 2007 */ OK /* Tue Mar 13 16:32:27 2007 */ COMMIT WORK /* Tue Mar 13 16:32:27 2007 */ ALTER TABLE support_file MODIFY ( fileContent blob ) /* Tue Mar 13 16:32:28 2007 */ OK /* Tue Mar 13 16:32:28 2007 */ ALTER INDEX support_file_ind REBUILD /* Tue Mar 13 16:32:28 2007 */ OK /* Tue Mar 13 16:32:28 2007 */ ALTER TABLE field_attach ADD ( fullTextOptions number(15,0) NULL ) /* Tue Mar 13 16:32:28 2007 */ OK /* Tue Mar 13 16:32:28 2007 */ CREATE TABLE user_cacheY22 (serverId number(15,0) not null,entryId varchar(15) not null,userName varchar(254) not null,password varchar(255) NULL,authUserName varchar(254) NULL,shortAuthString varchar(255) NULL,longAuthString clob NULL,licensePool varchar(30) NULL,email varchar(255) NULL,notifyMech number(15,0) NULL,licType number(15,0) NULL,licTypeFText number(15,0) NULL,licTypeReserv1 number(15,0) NULL,licTypeApp clob NULL,timestamp number(15,0) NULL,validateKey varchar(30) NULL,shortGroup varchar(255) NULL,longGroup clob NULL,shortCompGroup varchar(255) NULL,longCompGroup clob NULL,fixedLicChange clob NULL,badPwd number(15,0) NULL,badPwdTotal number(15,0) NULL,pwdChange number(15,0) NULL) /* Tue Mar 13 16:32:28 2007 */ OK /* Tue Mar 13 16:32:28 2007 */ CREATE UNIQUE INDEX user_cache_ind6 ON user_cacheY22 (userName) /* Tue Mar 13 16:32:28 2007 */ OK /* Tue Mar 13 16:32:28 2007 */ INSERT INTO user_cacheY22 (serverId, entryId, userName,password,authUserName,shortAuthString,licensePool,email, notifyMech,licType,licTypeFText,licTypeReserv1,licTypeApp,timestamp,vali dateKey,shortGroup,longGroup,shortCompGroup,longCompGroup,fixedLicChange ,badPwd,badPwdTotal,pwdChange) SELECT serverId, entryId, userName,password,authUserName,authString,licensePool,email, notifyMech,licType,licTypeFText,licTypeReserv1,licTypeApp,timestamp,vali dateKey,shortGroup,longGroup,shortCompGroup,longCompGroup,fixedLicChange ,badPwd,badPwdTotal,pwdChange FROM user_cache /* Tue Mar 13 16:32:29 2007 */ ROLLBACK WORK /* Tue Mar 13 16:32:29 2007 */ CREATE TABLE support_fileY22(fileType number(15,0) not null,id number(15,0) not null,id2 number(15,0) not null,fileId number(15,0) not null,timestamp number(15,0) not null,fileContent long raw NULL) /* Tue Mar 13 16:32:29 2007 */ OK /* Tue Mar 13 16:32:29 2007 */ INSERT INTO support_fileY22 (fileType,id,id2,fileId,timestamp,fileContent) SELECT fileType,id,id2,fileId,timestamp,fileContent FROM support_file /* Tue Mar 13 16:32:29 2007 */ *** ERROR *** ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 38400, maximum: 2000) /* Tue Mar 13 16:32:29 2007 */ ROLLBACK WORK /* Tue Mar 13 16:32:29 2007 */ DROP TABLE support_fileY22 /* Tue Mar 13 16:32:29 2007 */ OK /* Tue Mar 13 16:32:29 2007 */ ALTER TABLE field_attach DROP COLUMN fullTextOptions /* Tue Mar 13 16:32:29 2007 */ OK /* Tue Mar 13 16:32:29 2007 */ DROP TABLE user_cacheY22 /* Tue Mar 13 16:32:29 2007 */ OK /* Tue Mar 13 16:32:29 2007 */ COMMIT WORK RELEASE /* Tue Mar 13 16:32:29 2007 */ SQL Trace Log - OFF Has anyone else experienced this issue???? Is there anything we can do to bypass this? Amanda Pierce PDS Client Systems Development Technology Services Turner Broadcasting System, Inc 404-827-2959 Please use http://sos <http://sos> to submit a technology request. __20060125_______________________This posting was submitted with HTML in it___ ________________________________ The information contained in this electronic mail message, including attachments, if any, is PetSmart confidential information. It is intended only for the use of the person(s) named above. If the reader of this message is not the intended recipient, or has received this message in error, you are hereby notified that any review, dissemination, distribution or copying of this communication is strictly prohibited. If you are not the intended recipient or have received this message in error, please notify the sender via e-mail and promptly delete the original message. ________________________________ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
image001.gif
Description: image001.gif
