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.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
image001.gif
Description: image001.gif
