Our Maximo

 Technical Questions How do you rate your self in :- 1. PL/SQL 2. Java 3. Automation Script 4. Mbo Customization 5. Admininstration Jobs 6. Funtional Concepts 7. Maximo Configuration Do not rate anything less than 7 unless you don't want interview to skip the topic Deployment / Administration  1. Explain LDAP integration? 2. Explain SSO and LTPA token? 3. What is global security? 4. How session is managed in Websphere or Maximo? 5. How request is passed in Maximo? 6. How to do horizontal and vertical clustering? 7. Explain how you confire websphere for maximo manually? 8. What are Websphere MQ? 9. What is JMS, Connection Factory and Queues? 10. What is difference between vmm and ldap sync integration ? 11. What is Standalone and federated repository? 12. How to install a new language in Maximo? 13. What are the steps to apply a Fix pack in Maximo, Websphere or DB2? 14. Have you worked on any performance checking tools? 15. Have you worked on Junit? 16. What is devops in terms ...

 1. Apple 2. Microsoft 3. Google 4. Accenture 5. IBM 6. WIPRO 7. TCS 8. Infosys 9. L&T 10. Siemens 11. Cognizant 12. FIS Global 13. Thomson Reuters 14. PWC 15 E&Y 16. KPMG

 Skip : This processing Rule will skip the entire transaction. this can be applied on main object or child object. Message will be deleted from queue Skip : This processing rule will skip the particular record and child records  Example If you want to skip transaction when workorder goes to Waiting for material you can use Skip rul e on main record If you want to skip labor which belong to Organization A but still want to send workorder along with other labors use Skip record action.........

Below are option after we select Integration :-  We create publish channel Scripts for publish channel (data going out) We create enterprise service Scrips for Enterprise Service (data coming in) We create Invocation Channel Script for Invocation Channel

 Json Mapping in Maximo  When we send data to Maximo, response we receive in XML format. What if we want to receive responce in JSON format with 7.6 version this is possible with JSON API in Maximo. We creating mapping for json for a particular enterprise service and also cofigure response. For this we us JSON Mapping application. We can configure properties for mapping source and target values. Json mapping can be used in caseof inbound transactions as well as outbound transactions....

 How to transform inbound message in maximo format We often have requirement to transform inbound message to maximo format :- 2 ways it can be achieved  1. XSL transformation 2. User Exit In case of XSL transformation we create a XSL file based on inbound xml.

 1. Check processing rules (Skip Start) 2. Check loggers exception and integration. 3. Check admin mode. 4. Check crontask JMS sequential consumer 5. check end point accesible.

 This error can occur during cron run in logs or during process selected message in Maximo. In logs you can enbale logs for crontask, Exception, Integration to reproduce this error in logs. Solution : define pretyprint property  with value 0 or 1 in end point for you xml end point.

 Creating JMS Consumer queue error :- Attribute Memo does not exists  This is cron cron instance class for JMS when u create a new queue to resolve this apply fix pack 7.6.0.8.

 1. Create inbound webservice. 2. Publish data using webservice on event listener 3. Publish data using cron task on particular schedule or on Escalation.  4. Integrate using Interface Table (Use both Publish and Sync). 5. Create a Java simple web applicaiton and integration with maximo using webservice 6. Read Data using java File handler from Maximo automation script. 7. Write code to insert data in maximo using RMI binding. 8. Open another application like Flipkart or Amazon from maximo from a place where u select items...... 9. Connect Maximo with any filenet server or any file based server. 10. Use Flat file consumer to consume flat files using cron. 11.  Use Soap UI or HTTP or JSON Api to send data to Maximo 12. Change Workorder number and prefix it with EXTSYSTEM+WONUM when workorder getting created in maximo from external system.

 BMXAA1581E No object with the name {0} is set up in the JNDI tree. Check the JMS/JNDI setup in the server administration console This error might come after you setup queue after you create destination then queue in websphere and add same in external system Add/Modify queue and same thing in main table of external system..... When u click on publish maximo can give this error......... reason is JNDI name you specifiy in maximo when adding queue from select action does not match with jndi name you specify in websphere...... Go to Websphere ->resources->JMS->queues ->and open your queue and check jndi name now check same name in maximo add/modify queue select your queue and check the jndi name........ Check the connection facility class in add/modify queues compare it with other queue whether it is requried / cusotmized or something delete data of your new queue(if it is not required else take backup or ask integration team to resend in case you have backup).. and now tr...

 If you are modifying a single workflow subprocess points are  1. It is not require to activate it else it will be shown as option for default workflow .... 2. After migration only enable it and syncronize with workflow so that new records will pick up your latest workflow........ 3. Migrate dependency like email/escalation etc on this wf first then migrate workflow.

 1. Check donotrun property in particular JVM in system properties application....... 2. Check crontask is working for escalation with instance name as your escalation name... 3. Check your adminemail/global directory is setup 4. check admin mode is on or not?

 1. Create script named CRONAUTOSCRIPT without launchpoint ....... 2. Create a crontask with class name com.ibm.tivoli.maximo.script.ScriptCrontask 3. Give runasUser and create new instance. 4. Give the scriptname as CRONAUTOSCRIPT and give arguments if you need any... 5. Activate crontask. You can do all work which you will do with crontaskcall like  Getting mbset from server looping, performing opration in bulk..............

 BMXAA4211E - Database error number 1 has occurred when operating on WFINSTANCE This solution you can use for any table generic solution in oracle db only  this is duplicate id issue.. (if you cannot remove duplicate just increase nextval like i did since in my case too i can't find duplicate and max value is greater than nextval. select max(WFID) from maximo.wfinstance *select maximo.WFINSTANCESEQ.NEXTVAL from dual; increase you value with some 1000's from o/p of query 1... example *alter sequence maximo.WFINSTANCESEQ restart start with 17572034; Similary if it comes for wfcallstack   BMXAA4211E – Database error number 1 has occurred when operating on WFCALLSTACK:   Report the error to the owner of the deployment.     check maxvalue    select max(wfcallstackid) from maximo.WFCALLSTACK     check next value    select maximo.WFCALLSTACKSEQ.NEXTVAL from dual; increase value by some 10000 etc...... alter sequence max...

How to stop bulk workflow like all PO workflow's etc........ UPDATE MAXIMO.WFINSTANCE SET ACTIVE = 0 WHERE OWNERTABLE = 'PO' and active=1 UPDATE MAXIMO.WFASSIGNMENT SET ASSIGNSTATUS = 'INACTIVE' WHERE OWNERTABLE = 'PO'  and ASSIGNSTATUS = 'INACTIVE'   UPDATE MAXIMO.WFCALLSTACK SET ACTIVE = 0 WHERE ACTIVE=1 AND WFID IN (SELECT WFID FROM  MAXIMO.WFINSTANCE WHERE ACTIVE = 1 AND OWNERTABLE = 'PO') AND PROCESSNAME LIKE '%PO%' another way is escalation using oob action class (recommended way) check IBM notes...

 2causes if u are setting null value and you have check option allow null......remove it from db config bcoz it's trying to set null from parent... 1.  Where clause return multiy values use rownum less than 2 or  2. Use Max or min to return firdt record...

 If we assig. Delegate in person and date from and too workflow will automatically route to delegate for these dates. But if we have to create 2assignments then select option preserve original assignment when delegating.....