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.
| Segment | Product | Component | Platform | Version | Edition |
|---|---|---|---|---|---|
| Systems and Asset Management | IBM Maximo Asset Management |
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.