Dynamic MboSet a beutiful concept of Maximo

We can create dynamic mboset using relationship 

For this we can use &Owner&.assetnum this is an example for where clause to get the current owner value.

else we have do get Mboset("ourcustomMBOset")

then apply setWhere and reset using sql format.

If Else clause or decode or Case in Where clause

 If Else clause or decode or case in Where clause

We are not going to check here if else or decode or case but i am going to tell u an alternate.........

Suppose we need workorder's with status =APPR  else I need WAPPR but i have to give preference to APPR solution

select * from maximo.workorder where status in (APPR,WAPPR) order by status desc

Now suppose we have 2 records one is appr and one is wappr

Then modify this query like 

Select * from maximo.workorder where workorderid in (

select workorderid  from maximo.wokrorder where workorderid in (select workorderid from maximo.workorder where status in (APPR,WAPPR) order by status desc

)  where rownum<2)

So we are using here rownum to display approve before wappr ............

If we have only wappr records then our subquery will return wappr records only and with  rownum<2 

we will get only one record....................

This you can use in relationship of maximo where u have to find 1 record only as fetch 1st alternate.......

how to use sqlformat in automation script

  status=mbo.getString("status")

 siteid=mbo.getString("siteid") 

  assetSet=mbo.getMboSet("ASSET")

  sqlFormat = SqlFormat(assetSet.getUserInfo(), "siteid = :2 and status=:1 ")

  sqlFormat.setObject(1, "ASSET", "STATUS", status)

  sqlFormat.setObject(2, "ASSET", "SITEID", siteid)

  assetSet.setWhere(sqlFormat.format())

throw error in one line

 raise ValueError(' Cust Mesg')

Books and Blogs on Maximo

 1. Maximo Functional Consultant :- get it from Amazon/Google Bookstore..

2. IBM Redbooks (User Guide, Certification Guide, Performance Guide, Workflow Guide , Multisite Implementation, Application designer Guide)

3. Bruno's blog

4. Maximoconcepts blog

5. MaximoTimes blog

6. Ourmaximoblotspot

High Level Overview of Maximo Architecture (clustered environment with Ldap)

cannot find symbol DateTimeFormatter

 java 11 cannot find symbol DateTimeFormatter

This error occur due to import statements are missing..

import java.time.*;

import java.text.DateFormat;

import java.text.SimpleDateFormat;

import java.time.LocalDate;

import java.time.LocalDateTime;

import java.time.LocalTime;

import java.time.Month;

import java.time.format.DateTimeFormatter;

import java.util.Date;

public class DateTimeAPI 

{

public static void main(String[] args)

{

 LocalDate date2 = LocalDate.of(2020, Month.NOVEMBER, 10);

        LocalTime time2 = LocalTime.of(19, 23);

        LocalDateTime dt2 = LocalDateTime.of(date2, time2);

System.out.println(date2.format(DateTimeFormatter.ISO_LOCAL_DATE));

        System.out.println(time2.format(DateTimeFormatter.ISO_LOCAL_TIME));

        System.out.println(dt2.format(DateTimeFormatter.ISO_LOCAL_DATE_TIME));

var formatter2 = DateTimeFormatter.ofPattern("MM/dd/yyyy hh:mm:ss");

        System.out.println(dt2.format(formatter2));

System.out.println(LocalDate.now());

System.out.println(LocalTime.now());

System.out.println("Local date time "  +LocalDateTime.now());

System.out.println("Zoned Date time" +ZonedDateTime.now());

LocalDate date1=LocalDate.of(2020,Month.NOVEMBER,10);

System.out.println("local date  "+date1.now());

LocalTime time1=LocalTime.of(10,55);

LocalDateTime ldt2=LocalDateTime.of(2020,Month.NOVEMBER,10,10,55,55);

System.out.println("localdatetime "+ldt2);

System.out.println("day of Year "+ldt2.getDayOfYear());

System.out.println("Get Month Of Year"+ldt2.getDayOfMonth());

//custom format

var dt=LocalDateTime.of(date1,time1);

var formatter1 = DateTimeFormatter.ofPattern("MM/dd/yyyy hh:mm:ss");

System.out.println(dt.format(formatter1));

}

}

Java Secure coding guidlines

 Java Secure coding guidelines

1. Use Security Api's.

2. Always Close open resources use Try with Resources.

3. Use Class Loaders and Policy's for fine grain access

4. Always validate input format and input data .

5. Never grant unnecessary permission to third party code.

6. Never ignore exceptions  

7. Avoid duplications.

8. Document Security Information 

9. Encapsulate your changes.

10. Write Clear Code.

11. Do not log config information of your app.

12. Do not serialize security Codes.

13. Always do negative Testing against your code.

14. Use known and tested libraries

15. Always use prepared statements to handle SQL parameters.

16. Don't reveal implementation via complete error messages example userid failed or password failed.

17. Keep security releases up to date.

18. Look for dependency vulnerabilities.

19  Monitor and log user activity for brute force attack and denial of service.

Need to load millions\lacks of records in Maximo

Need to load millions\lacks of records in Maximo 
 

Their might be chance you need to load millions of records in existing maximo records but since ur system might have already so many records uploading using dataloader or any csv will be difficult another option you can use  iface tables in another schema that in Maximo and then configure baches in Maximo.
You can monitor these batches.

Steps for clearing Cloud practitioner certification

 1. Do Stephen Course on udemy (better u do aws developer so u don't need to purchase 2 course)

2. Do stephen practice test course

3. On youtube search for dumps of cloud practitioned u will get 90% questions from them.

4. Solve AWS practice dumps on aws certification site...

No need to study whitepapers, etc 

How to clear Java developer 11 Certification 819

 How to clear Java developer 11 Certification 819 (6 Months for fresher... 2-4 Months for Experience developer assuming avg. 3years experience)

1. Study Durgasoft Core java lectures and videos

2. Study Durgasoft Java 9 Features 

3. Study Durgasoft Java 11 Features

4. Study OCP by Jeanne Boyarsky or kt siera..

5. Enroll  couple of for practice test of udemy's /ethuware/wh...labs..

6. Work on Dumps of Youtube

7. Write code on notepad only and pay attention to command prompts.

8. Do lot of code, code ... code and code... 

9. Oracle.com docs...

Solve mock test every 2 weeks (3 Months === 10 Mock Tests Minimum likewise )

If you fail with low score than again study resources... 

Divide your time to complete.. Speed up your study if required.

Partition your study in these category like I did and mark it checked :- 

Topics	Theory	Videos	Practice Programs Made	Dumps
JPMS
Annotations
Diamond Operator
Secure Coding in Java SE Application.......

BMXAA4473E : The assignments created for task in workflow process do not include an owner for the task.

 That means assignment is going to Role but the role is not found example suppose u want wf to be assigned to supervisor of person but if supervisor field blank then this error will come.