Livelink ECM - Archive Server - Pre-upgrade Check â Known Problems

Prévia do material em texto

Great Minds Working Together 
Livelink® ECM – Archive Server 
Pre-upgrade Check – Known 
Problems 
 
Livelink® ECM – Archive Server 
White Paper 
23/May/2006, 13:40 
© 2005 IXOS SOFTWARE AG 
Werner-v.-Siemens-Ring 20 
85630 Grasbrunn, Germany 
Tel.: +49 (89) 4629-0 
Fax: +49 (89) 4629-1199 
eMail: 
Internet: http://www.ixos.com 
All rights reserved, including those regarding reproduction, copying or other use or communication of the contents of this document or 
parts thereof. No part of this publication may be reproduced, transmitted to third parties, processed using electronic retrieval systems, 
copied, distributed or used for public demonstration in any form without the written consent of IXOS SOFTWARE AG. We reserve the 
right to update or modify the contents. Any and all information that appears within illustrations of screenshots is provided coincidentally to 
better demonstrate the functioning of the software. IXOS SOFTWARE AG hereby declares that this information reflects no statistics of 
nor has any validity for any existing company. This product includes software developed by the OpenSSL Project for use in the OpenSSL 
Toolkit (http://www.openssl.org/) and software developed by the Apache Software Foundation (http://www.apache.org/). 
Trademarks IXOS: IXOS SOFTWARE AG. 
SAP®, R/3® and SAP ArchiveLink® are registered trademarks of SAP AG. 
Microsoft®, Microsoft Windows NT® and the names of further Microsoft products are registered trademarks of Microsoft Corporation. 
Acrobat Reader Copyright © 1987 Adobe Systems Incorporated. All rights reserved. Adobe and Acrobat are trademarks of Adobe Systems 
Incorporated which may be registered in certain jurisdictions. 
Siebel® is a registered trademark by Siebel Systems, Inc. 
Other product names are used only to identify the products and they may be registered trademarks of the relevant manufacturers. 
http://www.apache.org/
http://www.openssl.org/
http://www.ixos.com/
mailto:office@ixos.de
Contents 
Contents......................................................................................................................................... iii 
1 Known problems that may be detected by the preupgrade check, and how to 
solve them .............................................................................................................................. 4 
1.1 Missing privileges (Oracle).................................................................................................. 4 
1.2 VMIG indexes missing ........................................................................................................ 5 
1.3 Additional index VMIG_WORK_JOBID............................................................................... 6 
1.4 Sequence out of order ........................................................................................................ 6 
1.5 Additional index ds_job_flags_docidno............................................................................... 7 
Pre-upgrade Check – Known Problems 4
1 Known problems that may be detected by the preupgrade 
check, and how to solve them 
1.1 Missing privileges (Oracle) 
Symptom:
Pre-upgrade check reports errors of the kind 
FATAL: missing … privilege for user IXDS on … 
Solution:
You forgot to grant the corresponding rights to the user. Please refer to the upgrade guide for how 
to grant these rights. 
The following statements show how to grant all necessary privileges to the ixos db user: 
Sqlplus /nolog 
Connect sys/@ as sysdba 
grant connect to $DB_LOGIN ; 
grant resource to $DB_LOGIN ; 
grant CREATE SEQUENCE to $DB_LOGIN; 
grant CREATE TABLE to $DB_LOGIN; 
grant CREATE VIEW to $DB_LOGIN; 
grant CREATE SESSION TO $DB_LOGIN; 
grant ALTER SESSION TO $DB_LOGIN; 
grant select on dba_tablespaces to $DB_LOGIN; 
grant select on dba_data_files to $DB_LOGIN; 
grant select on user_free_space to $DB_LOGIN; 
grant select on dba_segments to $DB_LOGIN; 
grant select on V_$SESSION to $DB_LOGIN; 
grant select on V_$PARAMETER to $DB_LOGIN; 
grant query rewrite to $DB_LOGIN; 
exit 
Pre-upgrade Check – Known Problems 5
1.2 VMIG indexes missing 
 
Symptom:
Preupgrade check reports 
 
FATAL: missing index VMIG_WORK_IDX 
FATAL: missing index VMIG_WORK_REJECT_DUPLICATES 
…
Solution:
This may happen if the script from patch SV55-122 (or predecessors) had an error and was run 
two times. To correct this, create the indexes manually: 
 
Oracle: 
 
connect /@doc_ 
 
-- get tablespace for index to be added; default is DS_LARGE_IDX 
select tablespace_name from user_indexes where table_name='DS_DOC' and 
rownum=1; 
 
-- create indexes 
-- replace DS_LARGE_IDX with the result from the previous step 
-- only create the indexes that where reported as missing 
create unique index vmig_jobs_idx on vmig_jobs(idx) tablespace 
DS_LARGE_IDX; 
create unique index vmig_jobs_reject_duplicates on vmig_jobs(volid, 
pool, not_older, not_younger) tablespace DS_LARGE_IDX; 
create unique index vmig_work_idx on vmig_work(idx) tablespace 
DS_LARGE_IDX ; 
create unique index vmig_work_reject_duplicates on vmig_work(docidno, 
component, version) tablespace DS_LARGE_IDX; 
 
MSSQL: 
 
osql -U -P -S 
 
Determine index tablespace 
 
SELECT groupname 
FROM sysfilegroups sf, sysindexes si 
WHERE sf.groupid = si.groupid AND si.name = 'ds_doc_docidno' 
go 
 
Create index 
 
create index 
vmig_work_jobid on vmig_work(jobid) 
on 
go 
Pre-upgrade Check – Known Problems 6
1.3 Additional index VMIG_WORK_JOBID 
 
Symptom:
Preupgrade check reports 
…
WARNING: additional index VMIG_WORK_JOBID 
 
Solution:
This index was introduced with patch SV55-122 (or predecessors). The warning can be ignored. 
 
1.4 Sequence out of order 
 
Symptom:
Preupgrade check reports that one or more sequences are out of order. 
 
FATAL: 
 
Solution:
Oracle: 
Use the scripts SpDSSeq.sql and SpADMSSeq.sql from the ESC to repair the sequences: 
 
sqlplus 
connect /@doc_ 
 
-- in case you want to adjust the ds sequences 
�@DS/SpDSSeq 
�execute update_DS_Sequences(); 
-- in case you want to adjust the adms sequences 
�@ADMS/SpADMSSeq 
�execute upd_ADMS_Sequences(); 
exit 
Pre-upgrade Check – Known Problems 7
SQL-Server: 
 
Get the following scripts from a production machine: 
\pkg\DBINST\sql\DS\MSSQL_V2000\SpDSSeq.sql 
\pkg\DBINST\sql\ADMS\MSSQL_V2000\SpADMSSeq.sql 
 
install the stored procedures: 
osql -U -P -S -i SpDSSeq.sql 
osql -U -P -S -i SpADMSSeq.sql 
 
run the stored procedures: 
osql -U -P -S 
-- in case you want to adjust the ds sequences 
> update_DS_Sequences 
> go 
-- in case you want to adjust the ADMS sequences 
> update_ADMS_Sequences 
> go 
1.5 Additional index ds_job_flags_docidno 
Symptom:
The preupgrade check reports the following additional index: 
ds_job_flags_docidno 
 
Solution:
This index has been created during installation of a patch (SV55-129). The message can be 
ignored. 
 
	1 Known problems that may be detected by the preupgrade check, and how to solve them
	1.1 Missing privileges (Oracle)
	1.2 VMIG indexes missing
	1.3 Additional index VMIG_WORK_JOBID
	1.4 Sequence out of order
	1.5 Additional index ds_job_flags_docidno