Do you have any data in the ARCHIVEFROMFORM column? If not then you should be
safe. Since we did not use archiving all we had to do was make sure it was
empty
We are on Linux as well and there was a few small issues going from 6.3 to
7.6.04
Here is the script we used to correct them
truncate table ALERT_USER;
commit;
-- Since no one can be logged in to the Alert tool while the upgrade is
going on it seemed a good time to clear the list
-- Backup FIELD_ENUM
Create Table FWG_FIELD_ENUM as
select * from FIELD_ENUM;
commit;
Update FIELD_ENUM set ENUMSTYLE = NULL;
COMMIT;
ALTER TABLE FIELD_ENUM MODIFY (ENUMSTYLE NUMBER(15));
COMMIT;
Update Field_ENUM f
Set ENUMSTYLE = (
Select ENUMSTYLE from FWG_FIELD_ENUM
Where SCHEMAID=f.SCHEMAID and FIELDID=f.FIELDID)
Where exists (Select ENUMSTYLE from FWG_FIELD_ENUM
Where SCHEMAID=f.SCHEMAID and FIELDID=f.FIELDID);
Commit;
-- Backup FILTER_NOTIFY
Create Table FWG_FILTER_NOTIFY as
select * from FILTER_NOTIFY;
Commit;
Update FILTER_NOTIFY set BEHAVIOR = NULL, PERMISSION=NULL;
Commit;
ALTER TABLE FILTER_NOTIFY MODIFY (BEHAVIOR NUMBER(15), PERMISSION
NUMBER(15) );
COMMIT;
Update FILTER_NOTIFY set BEHAVIOR = 0, PERMISSION=0;
Commit;
-- Backup SCHEMA_ARCHIVE
Create Table FWG_SCHEMA_ARCHIVE as
select * from SCHEMA_ARCHIVE;
Commit;
Update SCHEMA_ARCHIVE
set ARCHIVEFROMFORM=NULL;
Commit;
In order to speed up the upgrade I truncated the Flashboards historical server
statistics data
-- Flashboards 209 = FB_CUMULATIVESERVERSTATISTICS, 210 =
FB_NONCUMULATIVESERVERSTATISTI
Truncate Table T209 Drop Storage;
Truncate Table H209 Drop Storage;
Truncate Table B209 Drop Storage;
Truncate Table T210 Drop Storage;
Truncate Table H210 Drop Storage;
Truncate Table B210 Drop Storage;
These forms were converted to Vendor Forms (We didn't use Flashboards so I
could just drop them and the upgrade created the new Vendor ones)
FB:Alarm Monitor
FB:DataSourceVariables
FB:Flashboards
FB:Variable
FB:Variable Attributes
Fred
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Carina Burns
Sent: Friday, December 19, 2014 11:11 AM
To: [email protected]
Subject: Re: Help with upgrade path
I just looked and that column in our linux Ora10g Schema_archive table is a
varchar2(254) with no “not null” constraint. I don’t think I’m going to change
it to a number(15) not null column before I try the upgrade since this may be a
Solaris only issue. If the upgrade bombs then I’ll look over the install log
and see if it’s something I should address.
Thanks for the heads up though.
-----Original Message-----
From: Theo Fondse [mailto:[email protected]]
Sent: Friday, December 19, 2014 10:25 AM
To: Burns, Carina
Subject: Re: Help with upgrade path
Nope, SW00327170 is on BMC.
I see how you could have thought it was on Oracle... :-)
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
