Missing SYNONYMDOMAINS after Maximo 7.5 Upgrade

For some reason, after upgrading to Maximo 7.5 some SYNONYMDOMAINS are missing such as LINETYPE, TOOLBARICONS, and ATTEMPTRESULT.  You will see an error in the SystemOut.log for these missing values on Maximo startup.  Here is the script to insert them back.

--Check to make sure they are missing values
SELECT * FROM SYNONYMDOMAIN WHERE DOMAINID IN ('LINETYPE', 'TOOLBARICONS', 'ATTEMPTRESULT')

INSERT INTO SYNONYMDOMAIN (DOMAINID, MAXVALUE, VALUE, DEFAULTS, DESCRIPTION, SYNONYMDOMAINID, VALUEID)
VALUES ('LINETYPE', 'ITEM', 'ITEM', 1, 'Item', 467, 'LINETYPE|ITEM');
INSERT INTO SYNONYMDOMAIN (DOMAINID, MAXVALUE, VALUE, DEFAULTS, DESCRIPTION, SYNONYMDOMAINID, VALUEID)
VALUES ('LINETYPE', 'MATERIAL', 'MATERIAL', 1, 'Material', 468, 'LINETYPE|MATERIAL');
INSERT INTO SYNONYMDOMAIN (DOMAINID, MAXVALUE, VALUE, DEFAULTS, DESCRIPTION, SYNONYMDOMAINID, VALUEID)
VALUES ('LINETYPE', 'SERVICE', 'SERVICE', 1, 'Service', 469, 'LINETYPE|SERVICE');
INSERT INTO SYNONYMDOMAIN (DOMAINID, MAXVALUE, VALUE, DEFAULTS, DESCRIPTION, SYNONYMDOMAINID, VALUEID)
VALUES ('LINETYPE', 'SPORDER', 'SPORDER', 1, 'Special Order', 470, 'LINETYPE|SPORDER');
INSERT INTO SYNONYMDOMAIN (DOMAINID, MAXVALUE, VALUE, DEFAULTS, DESCRIPTION, SYNONYMDOMAINID, VALUEID)
VALUES ('LINETYPE', 'STDSERVICE', 'STDSERVICE', 1, 'Standard Service', 471, 'LINETYPE|STDSERVICE');
INSERT INTO SYNONYMDOMAIN (DOMAINID, MAXVALUE, VALUE, DEFAULTS, DESCRIPTION, SYNONYMDOMAINID, VALUEID)
VALUES ('LINETYPE', 'TOOL', 'TOOL', 1, 'Tool', 472, 'LINETYPE|TOOL');

INSERT INTO SYNONYMDOMAIN (DOMAINID, MAXVALUE, VALUE, DEFAULTS, DESCRIPTION, SYNONYMDOMAINID, VALUEID)
VALUES ('TOOLBARICONS', 'nav_icon_detreport.gif', 'nav_icon_detreport.gif', 1, 'Detail Report Icon', 1093, 'TOOLBARICONS|nav_icon_detreport.gif');
INSERT INTO SYNONYMDOMAIN (DOMAINID, MAXVALUE, VALUE, DEFAULTS, DESCRIPTION, SYNONYMDOMAINID, VALUEID)
VALUES ('TOOLBARICONS', 'nav_icon_overview.gif', 'nav_icon_overview.gif', 1, 'Overview Report Icon', 1094, 'TOOLBARICONS|nav_icon_overview.gif');
INSERT INTO SYNONYMDOMAIN (DOMAINID, MAXVALUE, VALUE, DEFAULTS, DESCRIPTION, SYNONYMDOMAINID, VALUEID)
VALUES ('TOOLBARICONS', 'nav_icon_PrintToDefault.gif', 'nav_icon_PrintToDefault.gif', 1, 'Direct Printing Icon', 1095, 'TOOLBARICONS|nav_icon_PrintToDefault.gif');
INSERT INTO SYNONYMDOMAIN (DOMAINID, MAXVALUE, VALUE, DEFAULTS, DESCRIPTION, SYNONYMDOMAINID, VALUEID)
VALUES ('TOOLBARICONS', 'nav_icon_printWithAttachments.gif', 'nav_icon_printWithAttachments.gif', 1, 'DP with Print Attach Docs Icon', 1096, 'TOOLBARICONS|nav_icon_printWithAttachments.gif');
INSERT INTO SYNONYMDOMAIN (DOMAINID, MAXVALUE, VALUE, DEFAULTS, DESCRIPTION, SYNONYMDOMAINID, VALUEID)
VALUES ('TOOLBARICONS', 'NONE', 'NONE', 1, 'Not in toolbar', 1097, 'TOOLBARICONS|NONE');

INSERT INTO SYNONYMDOMAIN (DOMAINID, MAXVALUE, VALUE, DEFAULTS, DESCRIPTION, SYNONYMDOMAINID, VALUEID)
VALUES ('ATTEMPTRESULT', 'FAILED', 'FAILED', 1, 'Failed login', 1145, 'ATTEMPTRESULT|FAILED');
INSERT INTO SYNONYMDOMAIN (DOMAINID, MAXVALUE, VALUE, DEFAULTS, DESCRIPTION, SYNONYMDOMAINID, VALUEID)
VALUES ('ATTEMPTRESULT', 'LOGOUT', 'LOGOUT', 1, 'Logout', 1146, 'ATTEMPTRESULT|LOGOUT');
INSERT INTO SYNONYMDOMAIN (DOMAINID, MAXVALUE, VALUE, DEFAULTS, DESCRIPTION, SYNONYMDOMAINID, VALUEID)
VALUES ('ATTEMPTRESULT', 'SUCCESS', 'SUCCESS', 1, 'Successful esig authentication', 1147, 'ATTEMPTRESULT|SUCCESS');
INSERT INTO SYNONYMDOMAIN (DOMAINID, MAXVALUE, VALUE, DEFAULTS, DESCRIPTION, SYNONYMDOMAINID, VALUEID)
VALUES ('ATTEMPTRESULT', 'TIMEOUT', 'TIMEOUT', 1, 'Timeout', 1148, 'ATTEMPTRESULT|TIMEOUT');

Did You Know...

As Maximo Experts, we have developed several add-on products for Maximo that mobilize the work force, simplifies assignments, provides ad-hoc reporting capabilities and facilitates the seamless integration of Service Requests into Maximo.

Check out our products by clicking on the following links: EZMaxMobile, EZMaxPlanner and EZMaxRequest.

Find Out More

Leave a Reply