Technote (troubleshooting)
Problem(Abstract)
When applying the 7.1.1.8 fixpack to a 7.1.1.6 database, UpdateDB fails on script V7117_31.
Symptom
insert into maxdomain (internal, domainid, description, domaintype, maxtype, length, maxdomainid) values (0, 'VIEWPORT', 'Viewports', 'ALN', 'ALN', 9, 1299)
;
BMXAA7025E -- Script failed while running.;
scriptrun#UniqueKey MAXDOMAIN_NDX1 MAXDOMAIN DOMAINID;
Cannot insert duplicate key row in object 'dbo.maxdomain' with unique index 'maxdomain_ndx1'.
Cause
This script adds domain VIEWPORT as part of integrating Maximo Everywhere into 7.1.1.7 Maximo. Since Maximo Everywhere is already installed on the 7.1.1.6 database, this script is redundant and causes UpdateDB to fail.
Environment
Maximo Everywhere
Diagnosing the problem
If this SQL query returns any data, then domain VIEWPORT already exists. This causes the failure in UpdateDB script V7117_31.
Select * From maxdomain Where domainid='VIEWPORT' ;
Resolving the problem
Remove or rename script V7117_31 and re-start UpdateDB.
| Segment | Product | Component | Platform | Version | Edition |
|---|---|---|---|---|---|
| Systems and Asset Management | Tivoli Asset Management for IT | Not Applicable | |||
| Systems and Asset Management | Tivoli Change and Configuration Management Database | ||||
| Systems and Asset Management | Tivoli Service Request Manager |
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.