Upgrading to 7.5.0.2, UpdateDB V7500_46.class fails

Technote (troubleshooting)


This document applies only to the following language version(s):

English

Problem(Abstract)

Upgrading to Maximo 7.5.0.2 with SmartCloud Control Desk fails on CCI_PMP class V7500_46.

Symptom

From the UpdateDB log (found in maximo\tools\maximo\log):

-- Calling the class : psdi.cci_pmp.en.V7500_46
-- -------------------------------------------------------------------
com.ibm.db2.jcc.am.SqlIntegrityConstraintViolationException: One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by "1" constrains table "MAXIMO.RECONRULECLAUSE" from having duplicate values for the index key.. SQLCODE=-803, SQLSTATE=23505, DRIVER=4.11.69


Cause

This has been identified as a product defect under APAR IV25660

Environment

DB2 only

Diagnosing the problem

Run these queries:
1) Select MAX(reconruleclauseid) From maximo.reconruleclause;

2) Select NEXTVAL for maximo.RECONRULECLAUSEUSEQ From sysibm.sysdummy1

If command 2 returns a value equal to or lower than command 1, problem can be resolved.

Resolving the problem

Run these queries:
1) Select MAX(reconruleclauseid) From maximo.reconruleclause;

2) Select NEXTVAL for maximo.RECONRULECLAUSEUSEQ From sysibm.sysdummy1

If command 2 returns a value equal to or lower than command 1, repeat command 2 as many times as required to make sure the output is higher than the value returned from command 1. Each time command 2 is run, NEXTVAL will increment by one.

Run these queries:
3) Select MAX(reconruleid) From maximo.reconrule;

4) Select NEXTVAL For maximo.RECONRULEUSEQ From sysibm.sysdummy1

If command 4 returns a value equal to or lower than command 3, repeat command 4 as many times as required to make sure the output is higher than the value returned from command 3. Each time command 4 is run, NEXTVAL will increment by one.

5) Commit the updates

6) 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
Systems and Asset Management IBM SmartCloud Control Desk

Rate this page:

(0 users)Average rating

Document information


More support for:

IBM Maximo Asset Management
Upgrade Programs

Software version:

7.5

Operating system(s):

Windows

Reference #:

1609017

Modified date:

2013-07-19

Translate my page

Machine Translation

Content navigation