Blog Posts

Get Maximo location hierarchy

Get location hierarchy in tree format

select lpad(' ',2*(level-1)) || to_char(location) s, level
from (select * from lochierarchy where siteid = 'BEDFORD')
start with parent is null
connect by prior location = parent;

Sync node from command line

Sync Maximo nodes from command line

-------------------------------------------------------------

D:

cd D:\IBM\WebSphere\AppServer\profiles\ctgAppSrv01\bin

stopNode.bat -username wasadmin -password password

syncNode.bat localhost 8879 -userna....

Count rows in Maximo schema tables

Problem

------------------

How do I get count of all tables in Maximo with on single query?

Solution

-----------------

Just three steps, thats all .. 

--; Create function
create or replace
function      ....

Force launch Maximo 7.6 installer in english

Problem

--------------

If the local language of the client machine is other than English, IBM Installation Manager launches in that language. Need is to launch it in English.

Solution

------------

Launch installation manager from command line....

Multi-language label for custom fields in Maximo

Working in multi-language Maximo environment, it could be difficult to add custom labels in different languages. Steps below can help

--1.Navigate to application designer, add new custom label. Override the label i.e.specify a custom label.Save record
--2.Copy th....

Find and compile invalid Maximo objects

Got too many invalid objects in Maximo database. Recompile and make them valid quickly.

SELECT 
       'alter '|| object_type || ' "MAXIMO"."'|| object_name || '"  compile;'
FROM   sy....

Load Maximo 7.X classification

Loading classification data in Maximo could be quite complex, especially when it is being migrated from an earlier version of Maximo along with reference asset, location, item etc. data. Here is a techie's scratchpad for loading classification, read one line at a time :)

-....

AD Authentication in Maximo 7.6 fails

Problem

----------------

AD Authentication fails. 

Solution

--------------

Make sure login ID of maximo is excatly same as AD ID (case sensitive).

Get locked tables and release it

Find locked tables

---------------------------------------
select
oracle_username,
os_user_name,
locked_mode,
object_name,
object_type
from
v$locked_object a,dba_objects b
where
a.object_id = b.object_id;

R....

Change NLS_LENGTH_SEMANTICS to CHAR

Problem

------------------

Maximo 7.6 was installed and planned to be used for multilingual environment but later we noticed that NLS_LENGTH_SEMANTICS of the oracle database was set to BYTE. This is going to be a problem in usage and getting support from IBM. How do I change to CH....

Bulk add/remove of access rights

Problem

------------------

It is time-consuming in Maximo to individually pick and grant access to applications to a security group. One common problem is to grant all access to maxadmin in newly setup maximo environment or remove access to all applications of a module.

So....

Manual webserver creation for Maximo cluster

Create webserver manually for Maximo cluster configuration.

--------------------

Refer steps below, its raw format but it works ;)

----------------------

STEPS TO CREATE A NEW WEBSERVER DEFINITION (Report Webserver)

The followi....

Get open cursors

Get open cursors by Maximo session

------------------------------------------------------

--total cursors open, by session
select a.value, s.username, s.sid, s.serial#
from v$sesstat a, v$statname b, v$session s
where a.statistic# = b.statistic#  and s.sid=a....

Websphere 8.5 node sync fails

Problem

-----------------

Node synchronization fails for below setup of Maximo

 - WebSphere 8.5 cluster with two node

 - LDAP authentication is enabled 

 - WebSphere admin username in internal repository and federated LDAP repository are....