Maximo what web-service to chose

Soap

1. Soap uses HTTP Post Methods or Operations.
2. Creating soap web service we get wsdl files which have data and operations.
3. Soap has overhead so should not be used for Mobile
4. Soap gives data in XML format.
5. We can create java files from Soap Web services.

Rest

1. Uses Get and Post, Put and delete function to perform options.
2.  Here we get URI using which we can perform Get,Post or Put functions.
3. Rest is lightweight.
4. Rest gives data in XML, JSON and Text.

Maximo Status change in Future date

Maximo allows us to change status in future date using select action change status but with a catch that you can't go to next status in between dates

For example

If you select change status and change statusdate from todays date to 10 days after today.  Maximo will not allow you to change another status before these 10 days.

Entry for this is done in wostatus table in status date for the 10 th day from today.

Eclipse Shortcuts

F2 :- To display java docs associated with a class or method

Ctrl D:- To remove a line.

Extract Method from lines

Select lines --> Rt. Click refractor -----------> Select Extract Method -------> It will create method from these lines

Checks before Maximo Installation

Following checks should be done before Mximo installation

1. Stop antivirus.
2. Check domain name is defined.
3. Check ports, System space is available.
4. Installers are extracted properly in drive.

Also please create installation document where you can maintain password and port details which will be helpful in case something messed up.

Formula to Check for Duplicates Records in Excel

Below is the formulae you can use to check value is duplicate or not


=IF(COUNTIFS(A$2:A2,A2,B$2:B2,B2,C$2:C2,C2,D$2:D2,D2,E$2:E2,E2)>1,"Duplicate Value","Not Duplicate")

Using it you highlight duplicate value with  color except first one.

Create a war file from jsp,html etc

Below is the command to create a war file

jar cfv (name of the war file) WEB-INF [*.html] [*.jsp].........

here c is create, f is file and v is verbose.

Unable to change Tool status to Obsolute, Workorder exists on this item

Hi If you are getting this  error you need to close,complete or cancel these workorders otherwise you will not be able to make this tool Obsolute.

Below are other things you can check to make tools exists so as to not get error's like that:-

1. Check Workorders exists on it or not which are not in cancelled or complete or closed status

Query

1. Workorder

select * from maximo.wpitem where itemnum='YOURTOOLNUM' and wonum in
(select wonum from maximo.wonum where status not in (SELECT MAXVALUE FROM SYNONYM domain where domainid ='WOSTATUS' AND maxvalue not in ('COMP','CLOSE','CAN'))


2. Check for invbalances

Select * from maximo.invbalances where curbal>0 and itemnum='YOURITEMNUM'

3. Check if there is any asset exist on this item

Select * from maximo.asset where  itemnum='YOURITEMNUM'

4. check for joptool

Select * from maximo.jobitem where  itemnum='YOURITEMNUM'


5. Check for MR which are not close or cancel

Select * from maximo.mrline where itemnum='YOURITEMNUM' and mrnum in
(select mrnum from maximo.mr where status not in status not in (SELECT MAXVALUE FROM MAXIMO.SYNONYM domain where domainid ='MRSTATUS' AND maxvalue not in (,'CLOSE','CAN'))

6. Check for PR

select * form maximo.prline where itemnum='YOURITEMNUM' and itemsetid='YOURITEMSITEMSETiD' and prnum in (select prnum from pr where siteid=prline.siteid and status in ( select value from MAXIMO.synonymdomain where domainid='PRSTATUS' and  maxvalue not in ('COMP', 'CAN')));

7. Check for open PO exists

select * form maximo.poline where itemnum='YOURITEMNUM' and itemsetid='YOURITEMSITEMSETID' and ponum in (select ponum from maximo.po where siteid=poline.siteid and status in ( select value from MAXIMO.synonymdomain where domainid='POSTATUS' and  maxvalue not in ('COMP', 'CAN','REVISE')));

8. Check for open Contracts

select * form maximo.ContractLine where itemnum='YOURITEMNUM' and itemsetid='YOURITEMSITEMSETID' and contractnum in (select contractnum from maximo.contract where siteid=ContractLine.siteid and status in ( select value from MAXIMO.synonymdomain where domainid='CONTRACTSTATUS' and  maxvalue not in ('COMP', 'CAN','REVISE')));

9. Check for CI exists

How to start Apache tomcat server from command prompt

Hi All below are commands to run for starting apache  tomcate server


C:\Program Files\Java\jre1.8.0_161\bin>set JAVA_HOME=C:\Program Files\Java\JDK1.
8.0_161

C:\Program Files\Java\jre1.8.0_161\bin>set CLASSPATH=C:\PROGRAM FILES\JAVA\JDK1.
8.0_161

C:\Program Files\Java\jre1.8.0_161\bin>set CATALINA_HOME=C:\Downloads
\apache-tomcat-8.5.28-windows-x64\apache-tomcat-8.5.28

C:\Program Files\Java\jre1.8.0_161\bin>C:\Downloads\apache-tomcat-8.5
.28-windows-x64\apache-tomcat-8.5.28\bin\startup.bat