Maximo technical Interview questions

 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 of maximo deployment.

17. What is Silent installation?

18. How u resolve port conflicting issues?

19. What are commonly seen issues during installation or maximo upgrade?

20. Why should you never start anything using root user?

21. How do you identify java memory leak and if found what would be your approach to resolve it?

22. What is the log4j vulnerability?

23. How to configure SSL?

Customization Question

1. Why do we write remote classes?
2. What is the most complex customization you have ever done?
3. How you configure eclipse for customization
4. What is status handler class why we write it ?
5. Explain how can you make an application Stateful?
6. What is the use of event handler class?
7. How can you redirect user's to another JSP page when they are accessing your login page?
8. How to modify product.xml when u are customizing a class?
9. How can we change skin's in Maximo?
10. How do we create a new domain ?
11. How do we create a new synonym domain?
12. How can you make a workflow display a non persistent field or a field which does not exists in current object?
13. What is the use of AppValidate Method?
14. What is JAX-RS?
15. You have a workflow and javacode which is called by action of workflow? if their is an error in code or exception is thrown how it should be handled in class ? Is their any mechanism to handle such event in workflow using conditions?

16. What is new workflow features in current version of Maximo.

17. How u decide which integration is best...

Automation Script

1. Is there a way you can achieve Custom status implementation through Automation Script
2. How can you handle dialog's using automation script?
3. What are types of Automation script you have created or you create.
4. Can automation script replace an event handler class?
5. How to retrieve list in Automation script for an attribute in Maximo 7.6
6. how can I have an automation script to export data at certain time of the day and then send the exported file to other server.
7. What best practices you should follow while writing automation scripts?

8. How to use sqlformatter in automation script?

9. If you need to implement or extend failure list with another level what all configuring/customization should be done (basically user is checking your logic)

Configuration Question

1.  What is the difference between table domain and synonym domain?
2.  How many types of objects we can create in Maximo?
3. Why do we create non persistent attributes or object?
4. What happens when I run Db Config and Turning on/off admin mode?
5. What would you do if Db Config failed?
6. Can you insert a textbox in a work order application ?
7. How can you replace work order Number with Job Order Number in every application in Maximo?
8. What are the different types of controls ?
9. What are ways to hide a field in Maximo?

10. How to make a kpi?

11. How to add non persistent field in resultset?

12. What is Edit go button in workflow?

13. Can you create 2 alndomain with same name via dataloading if yes then how system will behave?

14. How u will implement multiselect in lookup?

15. How do you change lookup name dinamically?

16. I want to present user with 4 status options for Workorder to user WMT, Approved, Cancelled, Close from WAPPR how to achieve this requirement

without automation script and customization.?(Hint WF Manual input :) )

Start Centers/Result sets/KPI

1. How can you refresh start centers every 1 minutes for particular users?
2. How to create WorkCentre?
3. How to give access to WorkCentre in Maximo?

Birt Report  Question
1. How you configure Birt designer from Maximo?
2. How to create Cross tab report?
3. How to create Linked dataset?
4. How to migrate user from one report to another?
5. How can you update database table using report?
6. What is the functionality of ABC Report
7. How to change report title dynamically?
8. What are different functions in report you have used ?
9. What is order of report functions?
10. What is the difference you found in Birt and Other reporting tools?

11. You were investigating some issue and saw 1=0 condition in maximo or in workflow 1=1 what can be a reason to create such conditions in wf or other places?? Think for both conditions.

12. Can I hv 2 wf on same object both active how will system behave can their be 2 options....



Cognos Reporting Question
1. How to configure Maximo with Congnos?

Anywhere Question

Workflow Question

Migration Manager Question
1. What are different process you use for migration.



MIF Questions

1. What are different integration you have done?

2. What is XSL Map ? Why json mapping preferred over XSL mapping?
2. What is rest api?
3. Differenciate between soap and rest?
4. How many types of web service we can create in Maximo?
5. Explain Maximo Integration Framework and this modules applications use?
6. Apart from Maximo MIF, Rest Api etc what integration you saw ?
7. How you can consume a webservice using Soap?
8. How can you consume a websphere using Rest?
9. Why Rest API I need to send 1 Workorder with 5 tools what code should I write for this  shall I do it why for loop with multiple post or create a json object or is there any other way?

10. Give a scenario of o/b integration and i/b integration what all configuration /customization ?

11. When will you chose Continuous queues/When you will go with Sequencial queues / When you will go with Webservice integration/ When u will go with JMS Queue based integration of or Publish channel based XML interface?
12. Difference between skip and skip record?

13. Methods to loop through tree for ERDatat and IrData 

14. How can u loop through a big xml using Maximo integration methods name few methods and their use?

15. How can u remove duplicates if it comes from inbound integration?

13. if event listner enabled on a field and processing rule is not configured how u write a code so that u modify a field and it will not cause interation to trigger in this only case for a particular record.........without  processing rule?

14. How ifate tables maintain primary column , do we need to specifically define idex for them...

15. How maximo handles parent child relationship in case of iface tables?

16. What is view based integration?...

17. How will you trigger an integration on Creation of Asset in Maximo?

Companies to work for in java technology

 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

Maximo Naming Convention

Difference between Skip and Skip Record

 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.........

Integration flow in case of Publish Channel Service

Integration Automation Script Basics

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

Integration flow in case of Enterprise Service

json Mapping in Maximo

 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

 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.

Integration error debugging

 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.

Sequencial Consumer cron task failed with error specified value is not valid yes or no value enter Y or N

 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

 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.

Maximo Integration Scenarios for Practice

 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

 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 try....

export message again and check in queue (bus->destination-> your queue - > queue points ->Runtime -> messages ->u will get data flowing...:)

Migrating subprocess in Maximo

 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.

escalation not starting

 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?

Running automation script from cron task

 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 mbo...

 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 maximo.WFCALLSTACKSEQ restart start with 36946999;

how to stop all instances of a workflow in bulk

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...

BMXAA4082 WHERE CLAUSE IS EITHER EMPTY ..

 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...

Maximo workflow delegate

 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.....