Go To menu does not work in Maximo.

Purpose: The purpose of this document is to explain one of the reason 'Go To' menu does not work.

Applicable: To all versions of Maximo.

Issue: I have created an image (to prepare QA server) from Production Server in which Maximo was working well. I changed the Host name in all relevant files and was able to successfully login into Maximo. However, I am unable to select 'Go To' menu including all menu options. Even Start Center page was hanging.

Solution: Frankly speaking, I struggled to fix this issue for 2 days. I thought it might be some javascript issue or some other class issue. I compare all IE settings with production sever and all were the same. So, I couldn't figure out what was the issue.  So, finally I thought of enabling Active X in IE settings even though it wasn't enabled in Production.

I enabled all settings relating to Active X & Scripting in Tools -> Internet Options -> Security -> Internet -> Custom Level.

Migration Manager Fails when Required=1 and Default Value is blank

Purpose: The purpose of this post is to explain one of the reason for which MM package deployment fails.

Issue: I experienced myself when I was migrating database configuration attributes through MM package. MM package failed during deployment and we were getting an error "Required Fields are Blank". Initially, I couldn't find out the root cause but after some struggle, I found out that few fields in Database configuration are "Required=1" and "Default Value" is blank. 

Work Around: Entered some dummy values in "Default Value" and again created the package and was able to successfully deploy the package in Target sever. After successful deployment removed the dummy default values. 

The above procedure will be helpful, if you have few custom fields but this will not help if you have many custom fields.

Hence, I recommended it is very important to plan the migration procedure during planning phase. 

Delete Workflow History for Inactive Records

Purpose: As years pass by, the database size increases and you would like to delete unwanted records especially workflow history. This document explains you how to delete workflow history.

To delete the workflow history, execute the below scripts:

delete
from wftransaction
where wfid not in
(
  select wfid
  from wfinstance
  where active = 1
)
  and transdate <= (current timestamp - 1 month)
  and memo is null;
commit;

delete
from wfcallstack
where wfid in
(
  select wt.wfid
  from wftransaction wt
    ,wfinstance wi
  where wt.wfid = wi.wfid
    and wi.active = 0
    and transdate <= (current timestamp - 1 month)
    and memo is null
);
commit;

delete
from wfassignment
where wfid in
(
  select wt.wfid
  from wftransaction wt
    ,wfinstance wi
  where wt.wfid = wi.wfid
    and wi.active = 0
    and transdate <= (current timestamp - 1 month)
    and memo is null
);
commit;

delete
from wfinstance
where wfid in
(
  select wfid
  from wftransaction
  where memo is null
    and transdate <= (current timestamp - 1 month)
)
  and active = 0;
commit;

delete
from logintracking
where attemptdate <= (current timestamp - 3 month);
commit;