Hi all,
I have the following problem upgrading AR System from 6.0.1 to 7.0.1
Patch 3.
During the installation process before the stage 5, the AR System server
never start.
The AR System server crash with ARERR 36.
In the ar_install.log, I can find the following :
Running DB upgrade. This may take several minutes .... Upgrade status:
255
done.
The arsql.log seems to be too small and the DB doesn't seems to be
upgraded.
/* Wed Aug 1 11:45:47 2007 */ SQL Trace Log -- ON
/* Wed Aug 1 11:45:47 2007 */ CONNECT ARAdmin
/* Wed Aug 1 11:45:48 2007 */ SELECT BANNER FROM V$VERSION
/* Wed Aug 1 11:45:48 2007 */ OK
/* Wed Aug 1 11:45:48 2007 */ ALTER SESSION SET NLS_COMP=BINARY
/* Wed Aug 1 11:45:48 2007 */ OK
/* Wed Aug 1 11:45:48 2007 */ ALTER SESSION SET NLS_SORT=BINARY
/* Wed Aug 1 11:45:48 2007 */ OK
/* Wed Aug 1 11:45:48 2007 */ SELECT dbVersion FROM control
/* Wed Aug 1 11:45:49 2007 */ OK
/* Wed Aug 1 11:45:49 2007 */ COMMIT WORK
/* Wed Aug 1 11:45:49 2007 */ INSERT INTO servgrp_op_mstr VALUES
('Reconciliation Engine', -1, 'Reconciliation-Engine-Suspended:',
'SG-Check-Config', 'Reconciliation-CHK-CONFIG;Reconciliation')
/* Wed Aug 1 11:45:50 2007 */ OK
/* Wed Aug 1 11:45:50 2007 */ INSERT INTO servgrp_op_mstr VALUES
('CMDB', -1, 'CMDB-Service-Suspended:', 'SG-Check-Config',
'CMDB-CHK-CONFIG;CMDB')
/* Wed Aug 1 11:45:51 2007 */ OK
/* Wed Aug 1 11:45:51 2007 */ DELETE FROM servgrp_op_mstr WHERE
operation = 'Full Text Index'
/* Wed Aug 1 11:45:51 2007 */ OK
/* Wed Aug 1 11:45:51 2007 */ SELECT schemaId FROM field WHERE
fieldId = 731
/* Wed Aug 1 11:45:52 2007 */ OK
/* Wed Aug 1 11:45:52 2007 */ COMMIT WORK
/* Wed Aug 1 11:45:52 2007 */ UPDATE control SET dbVersion = 21
/* Wed Aug 1 11:45:52 2007 */ OK
/* Wed Aug 1 11:45:52 2007 */ COMMIT WORK
/* Wed Aug 1 11:45:52 2007 */ ALTER TABLE support_file MODIFY (
fileContent blob )
/* Wed Aug 1 11:45:52 2007 */ OK
/* Wed Aug 1 11:45:52 2007 */ ALTER INDEX support_file_ind REBUILD
/* Wed Aug 1 11:45:52 2007 */ OK
/* Wed Aug 1 11:45:52 2007 */ ALTER TABLE field_attach ADD (
fullTextOptions number(15,0) NULL )
/* Wed Aug 1 11:45:53 2007 */ OK
/* Wed Aug 1 11:45:53 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)
/* Wed Aug 1 11:45:53 2007 */ OK
/* Wed Aug 1 11:45:53 2007 */ CREATE UNIQUE INDEX user_cache_ind6 ON
user_cacheY22 (userName)
/* Wed Aug 1 11:45:53 2007 */ OK
/* Wed Aug 1 11:45:53 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
/* Wed Aug 1 11:45:53 2007 */ ROLLBACK WORK
/* Wed Aug 1 11:45:53 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)
/* Wed Aug 1 11:45:53 2007 */ OK
/* Wed Aug 1 11:45:53 2007 */ INSERT INTO support_fileY22
(fileType,id,id2,fileId,timestamp,fileContent) SELECT
fileType,id,id2,fileId,timestamp,fileContent FROM support_file
/* Wed Aug 1 11:45:53 2007 */ OK
/* Wed Aug 1 11:45:53 2007 */ COMMIT WORK
/* Wed Aug 1 11:45:53 2007 */ DROP TABLE support_file
/* Wed Aug 1 11:45:54 2007 */ OK
/* Wed Aug 1 11:45:54 2007 */ RENAME support_fileY22 TO support_file
/* Wed Aug 1 11:45:54 2007 */ OK
/* Wed Aug 1 11:45:54 2007 */ CREATE UNIQUE INDEX support_file_ind
ON support_file (fileType, id, id2, fileId)
/* Wed Aug 1 11:45:54 2007 */ OK
/* Wed Aug 1 11:45:54 2007 */ ALTER TABLE field_attach DROP COLUMN
fullTextOptions
/* Wed Aug 1 11:45:54 2007 */ OK
/* Wed Aug 1 11:45:54 2007 */ DROP TABLE user_cacheY22
/* Wed Aug 1 11:45:55 2007 */ OK
/* Wed Aug 1 11:45:55 2007 */ COMMIT WORK RELEASE
/* Wed Aug 1 11:45:55 2007 */ SQL Trace Log - OFF
Do you have any idea about the root cause of this problem or how to find
it?
Thanks in advance.
Vincent.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
