Oil and Gas 7.1.2 install fails on script 7110_59

Technote (troubleshooting)


Problem(Abstract)

Updatedb fails on script 7110_59 with unique constraint errors

Symptom

UPDATEDB fails with the following error when installing Oil and Gas 7.1.2

insert into wfapptoolbar (wfapptoolbarid, appname, toolbarlocation, toolbaricon, toolbarsequence, processname, objectname, description, toolbariconactive) values (230, 'PLUSGACT', 'MAIN', 'nav_icon_route.gif', 10, null, 'WORKORDER', 'Route Workflow', 'nav_icon_route_active.gif')
go
com.inet.tds.at: Msg 2601, Level 14, State 1, Line 1, Sqlstate 23000
[MAXIMO]Cannot insert duplicate key row in object 'dbo.wfapptoolbar' with unique index 'wfapptoolbar_ndx1'.

-- BEGINUPDATEDBERROR
-- Error running file: V7110_59
-- UPDATEDBFILE:V7110_59.class
-- Script: Error


Cause

This is caused by the script class file having the exact same insert as the script, inserting this twice violates the index on wfapptoolbar


Resolving the problem

This can be resolved by removing the hard coded insert in the V7110_59 sqs, ora or db2 file.

Open the file from C:\ibm\SMP\maximo\tools\maximo\en\oilandgas and remove the following line then save the script file

/************** Freeform Txn -- Inserting Workflow option on toolbar. **************/

insert into wfapptoolbar (wfapptoolbarid, appname, toolbarlocation, toolbaricon, toolbarsequence, objectname, description, toolbariconactive)
values (wfapptoolbarseq.nextval, 'PLUSGACT', 'MAIN', 'nav_icon_route.gif', 10, 'PLUSGACT', 'Route Workflow', 'nav_icon_route_active.gif')
go

You will need to restore your database to before the point of running the updatedb and run updatedb once more after remove the insert.

Cross reference information
Segment Product Component Platform Version Edition
Systems and Asset Management IBM Maximo Asset Management

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

IBM Maximo for Oil and Gas

Software version:

7.1.2

Operating system(s):

Platform Independent

Reference #:

1600846

Modified date:

2014-06-09

Translate my page

Machine Translation

Content navigation