Learn Maximo with Chetan Arer

Usually you get lexer error after updating new schema for maximo ORA-20000: Oracle Text error: DRG-10700: preference does not exist: global_lexer ORA-06512: at "CTXSYS.DRUE", line 160 ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 364         at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java :112) To fix this issue which is mainly for missing global lexer or due to missing of indexes Step1:Running following queries for missing global lexer Note: Prior to running check proper access to database user  call ctx_ddl.drop_preference('global_lexer'); call ctx_ddl.drop_preference('default_lexer'); call ctx_ddl.drop_preference('english_lexer'); call ctx_ddl.drop_preference('chinese_lexer'); call ctx_ddl.drop_preference('japanese_lexer'); call ctx_ddl.drop_preference('korean_lexer'); call ctx_ddl.drop_preference('german_lexer'); call ctx_ddl.drop_preference('dutch_lexer...

In Maximo we can get current date time of different time zone using Java Customization/Automation scripts. Lets see automation script approach to get time of  different time zone. Step1:Get Calendar instance by specifying the required timezone. Step2:From the calendar instance fetch the time value Source Code: Result: Another approach to get convert date time is -->Get date time of your current timezone in milliseconds then subtract the raw offset of your current timezone and then you will get GMT/UTC time.To GMT/UTC time add the offset of the required timezone. The timezone conversion is necessary when Maximo server will be there in one timezone and your External system/Middle ware will be there in another time zone and you want update the date according to timezone of external system.

Recently i came a scenario where i wanted to traverse multiple object.And i got to know a trick to use "Dot relationship" to traverse multiple object only if there is  1:1 relationship This can be used in conditions,actions,java/automation script in maximo Consider that you want to traverse from Workorder to asset and then to location OOB relationship from WO -> Asset=ASSET OOB relationship from Asset -> Location=LOCATION In Condition to check location is operating  :ASSET.LOCATION.STATUS='OPERATING' In Action to set location description to 'Paris Storeroom' with setvalue action type Parameter will be  :ASSET.LOCATION.DESCRIPTION Value will  "Paris Storeroom" In Java/Automation script to get value of status through dot relationship mbo.getString("ASSET.LOCATION.STATUS") This way we can traverse n number of relationship  Through this we can avoid creating new relationship and use existing relationship to fetch/up...

IBM Maximo 7.6 Preview site IBM Maximo 7.5 Preview site Note:Maximo user password will be keep on updated by IBM