**
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,validateKey,shortGroup,longGroup,shortCompGroup,longCompGroup,fixedLicChange,badPwd,badPwdTotal,pwdChange)
SELECT serverId, entryId,
userName,password,authUserName,authString,licensePool,email,
notifyMech,licType,licTypeFText,licTypeReserv1,licTypeApp,timestamp,validateKey,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.***
* *
[image: tts_logo]
__20060125_______________________This posting was submitted with HTML in
it___
