IBM Support

UpdateDB fails in script V7117_31

Technote (troubleshooting)


When applying the fixpack to a database, UpdateDB fails on script V7117_31.


insert into maxdomain (internal, domainid, description, domaintype, maxtype, length, maxdomainid) values (0, 'VIEWPORT', 'Viewports', 'ALN', 'ALN', 9, 1299)

BMXAA7025E -- Script failed while running.;
Cannot insert duplicate key row in object 'dbo.maxdomain' with unique index 'maxdomain_ndx1'.


This script adds domain VIEWPORT as part of integrating Maximo Everywhere into Maximo. If Maximo Everywhere is already installed on the database, then this script is redundant and causes UpdateDB to fail.


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

Document information

More support for: Maximo Asset Management

Software version: 7.1

Operating system(s): Platform Independent

Reference #: 1601324

Modified date: 23 June 2013

Translate this page: