IBM Support

Maximo 7.6.0.6 Interim Fix 001 and Maximo 7.6.0.5 Interim Fixes

Flashes (Alerts)


Abstract

When Maximo 7.6.0.6 Interim Fix (IFIX) 001 is applied to any Maximo instance that has a Maximo 7.6.0.5 Interim Fix applied, updatedb will fail with a BMXAA7968E error.

Content

Maximo Feature Pack 7.6.0.6 Interim Fix (IFIX) 001 was released December 13, 2016.

A Scheduler hot fix script in 7.6.0.6 IFIX 001 (script HF7640_01.dbc) contains a SQL insert statement that is already provided in all Interim Fixes (001-005) released for Maximo Feature Pack 7.6.0.5, in script HF7630_01.dbc. This script is executed regardless of whether the Maximo instance is entitled to IBM Maximo Asset Management Scheduler. This is the error:

-- BEGINUPDATEDBERROR
-- Product: IBM Maximo Asset Management Scheduler
-- Error running script: V7640_01
-- UPDATEDBFILE: V7640_01.dbc
-- Script: Error
ERROR: BMXAA7025E -- Script failed while running.;
BMXAA8313E -- A statement failed to execute inside a freeform statement. See the nested exception.;
BMXAA7968E -- A unique key error with index SKDPROPERTYMA_NDX1 is defined on table skdpropertymap, columns (PROPERTYNAME, OBJECTNAME, SKDOBJECTNAME).;

Maximo Feature Pack 7.6.0.6 IFIX 002 will not contain this SQL insert statement. It will be released in early January 2017.

If you are at Maximo 7.6.0.6 (with any 7.60.5 Interim Fix release applied) and need the fixes provided in Maximo 7.6.0.6 IFIX 001, you may either wait until IFIX 002 is released, or follow the steps in the Workaround section below after installing Maximo 7.6.0.6 IFIX 001 but before updating the database.

IBM Installation Manager:



The lines outlined in red mean that a Maximo 7.6.0.5 Interim Fix has been applied to this installation.

Maximo 7.6.0.5 is installed and will be updated to Maximo 7.6.0.6:



Then



Configuration Tool:



STOP! Do not apply changes to the database yet.

Workaround

After installing Maximo 7.6.0.6 IFIX 001 but before updating the database, follow these steps:

1. Make a backup of and edit the file V7640_01.dbc, located at (default)
Windows: C:\IBM\SMP\maximo\tools\maximo\en\scheduler
Linux: /opt/IBM/SMP/maximo/tools/maximo/en/scheduler

2. Replace lines 32 - 42 with:

insert into skdpropertymap (objectname, skdobjectname, skdattributename, attributename, propertyname, applinkobject, skdpropertymapid)
SELECT 'WORKORDER', 'SKDACTIVITY', 'WORKLOG', 'WORKLOG', 'WORKLOG', null, skdpropertymapseq.nextval FROM dummy_table WHERE NOT EXISTS (SELECT 1 FROM skdpropertymap WHERE objectname = 'WORKORDER' AND skdobjectname = 'SKDACTIVITY' AND skdattributename = 'WORKLOG');

insert into skdpropertymap (objectname, skdobjectname, skdattributename, attributename, propertyname, applinkobject, skdpropertymapid)
SELECT 'WOACTIVITY', 'SKDACTIVITY', 'WORKLOG', 'WORKLOG', 'WORKLOG', null, skdpropertymapseq.nextval FROM dummy_table WHERE NOT EXISTS (SELECT 1 FROM skdpropertymap WHERE objectname = 'WOACTIVITY' AND skdobjectname = 'SKDACTIVITY' AND skdattributename = 'WORKLOG');

insert into skdpropertymap (objectname, skdobjectname, skdattributename, attributename, propertyname, applinkobject, skdpropertymapid)
SELECT 'WOCHANGE', 'SKDACTIVITY', 'WORKLOG', 'WORKLOG', 'WORKLOG', null, skdpropertymapseq.nextval FROM dummy_table WHERE NOT EXISTS (SELECT 1 FROM skdpropertymap WHERE objectname = 'WOCHANGE' AND skdobjectname = 'SKDACTIVITY' AND skdattributename = 'WORKLOG');

insert into skdpropertymap (objectname, skdobjectname, skdattributename, attributename, propertyname, applinkobject, skdpropertymapid)
SELECT 'WORELEASE', 'SKDACTIVITY', 'WORKLOG', 'WORKLOG', 'WORKLOG', null, skdpropertymapseq.nextval FROM dummy_table WHERE NOT EXISTS (SELECT 1 FROM skdpropertymap WHERE objectname = 'WORELEASE' AND skdobjectname = 'SKDACTIVITY' AND skdattributename = 'WORKLOG');

3. After these changes are made, save the file.

4. Run updateDB and complete the Interim Fix installation.

If you have questions or concerns about the contents of this Flash or the workaround, please contact Maximo support.

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.6.0.5;7.6.0.6","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"System Related","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.6.0.5;7.6.0.6","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
25 September 2022

UID

swg21995846