UpdateDB fails in script V7117_31

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. If Maximo Everywhere is already installed on the 7.1.1.6 database, then 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.

Cross reference information
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:

(0 users)Average rating

Document information


More support for:

IBM Maximo Asset Management

Software version:

7.1

Operating system(s):

Platform Independent

Reference #:

1601324

Modified date:

2013-06-23

Translate my page

Machine Translation

Content navigation