Our Maximo

1. Disable hyperv from turn off feature. Important  2. Enable virtualization both vtd and other virtualization from boot. Important  3. Open command prompt run as admin and disable hyper v important  4. Disable windows memory integrity from security ( Might not be required) 5. Disable virtualization based security from global policy edit gpedit msc.(imp) 6. Use virtual box 6 to support 64 bit os..

1. Every slide should not contain 10 point...do not bore audience. 2. Don't give more than 1 image in a slide. 3. Don't use too much animation 4. Do spelling grammar check... 5.Keep welcome questions page and logo of your company 6. Use same font according to org. Ur working for. 7. Collect all info. 8. Pick only imp. Facts and info which are easy to remember or eye catching. 9. Don't think too much.. 10. If ppt becomes length break it in 2 ppts divide and rule. 11. Layout are important. 12. Be concise. 

 Best Time management Tips Time is finite if you are getting so many request say no.. choose what to say yes too.. take your time in saying what to say yes too. Don't rely on your memory to remember things write it down in your system/ copy alarm.. task manager whatever...example your mother your wife your father has said 1 -2 things daily which u need to do on weekend like visit doctor , vaccine, furniture.. when weekend came u can forget it so put a system to give priority... Distraction and Lack of Focus takes 30 minutes every day of a average person so yearly it takes 18 days and 15 years it almost 1 year is gone due to these distractions so identify your distractions and remove them one by one.. and practice this thing more and more... Spend more time in planning your work.. Plan your fight inorder to win it strategy is important.. plan your day... plan your week... plan your month ..plan your year and practice.. to achieve your goal Now what will happen is we are working on s

 1. Find string is alphanumeric or not? 2. Explain Hashing ? 3. Filter in lambda with Example.. 4. Group by and having example in Sql 5. What is lazy loading. 6. Can singleton class be serialized?

 their are 2 types of profiles in websphere 1. Standalone (single JVM) can have multiple application installation... no clustering here  2. Federated one here we have dmgr and node agent and clustering etc... when u create dmgr profile a jvm is automitally created for this profile.. 3. custom profile or slave profile : it will not have JVM this is nodeagent only..  4. APplication server profile : it has 1 jvm  it is  used as a slave. 5. Cell profile 6. Admin Agent 7. Job Manager

 Basically websphere we install in 2 ways 1. Using Root user  2. Non root user (preferred for produciton too..) First we will unizip installation manager  Go to folder where installation manager exists  cd opt\OurMaximo\IM unzip imZipFile.unzip For Root user ./install For non root user  .userinst

 

 BMXAA4214E Unknow error occurred generating  XML or WSDL  Solution to this error  1. Check Directory path in Maximo global directly is correct 2. Check any objectstructure details exists where their is no corresponding objectstructure  via these queries select intobjectname, objectname from maxintobjdetail where objectname not in ( select objectname from maxobject) order by intobjectname, objectname select intobjectname, objectname, name from maxintobjcols m where not exists (select 1 from maxattribute a where a.objectname = m.objectname and a.attributename = m.name) and intobjectname not like 'REP_%' order by intobjectname, objectname, name If objectdetail exists and not object structure.. you need to take backup and remove the objectdetail...for consistency of syste....

Want to become email pro.. want your email looks like professional.. Use these tips..  1. Use Who What and When when writing email. 2. Break longer email into 2 or more marks with each part defining its own purpose.. 3. Try Order TO and CC as per designation ..  4. Rather than going for @Team Go to particular member's if you want task to be done by some one or 2, 3 people.. 5. Specify proper day date and Time when writing email.. do no confuse recipient with CST or IST.. 6. Use Attachments in your email or screenshots.. mark in screenshot where to go or where is the issue.. rather than writing in email.. 7. If you don't want recipient reply to your email Write FYI or NNTR (no need to reply) in subject itself 8. Info or Urgent should be in subject and should be first character because their may chance if you keep it last, receipt will miss it due to screen and other settings in his/her device.. 9. Spell check your email. 10. Draft repeated Emails and Save it

 Steps for troubleshooting maven issues. 1. In your project go to .m2 folder and delete repository folder. 2. Right click on project and do maven clean. 3. Right click on project again and do maven install it will pick latest files from central maven repository. 4. Whenever you change pom.xml then you should do Maven update project this should resolve your issues..

 Maximo Sigoption not working giving attribute not found or null pointer exception When we apply sigoption on application we should apply datasource also to mainrecord so sigoption conditions work for main record for example if I am apply a condition worktype='EM' and does not give the mainrecord for sigoption then Maximo does not know what's main object for this cause worktype attribute not found or null pointer exception etc.....

 Solution :- set path=C:\Program Files\Java\jdk-11.0.13\bin set JAVA_HOME=C:\Program Files\Java\jdk-11.0.13\ C:> jar Usage: jar [OPTION...] [ [--release VERSION] [-C dir] files] ... Try `jar --help' for more information. To create jar file jar -cvf C:\myJars myFolder jar -cf C:\myJars myFolder c is create f is folder v is verbose.

1. Practice Dumps atleast 1000 questions you should know the answer.... (better prepare a notebook for it also) 2. See the topics and only prepare for the topics... which are in Exam. 3. Do some courses specially free videos available in Oracle Learning website 4. Do Java magazine quizes. atlease 25 questions...... 5. Prepare Notes for study during end time.. 6. Prepare a rulebood to note down rules. 7. Go through Java docs.. 8. Solve atleast 5 practice questions given on various websites........ 9. When in exam first tick the questions you know were right and skip lengthy or tough once ...... 10. Then jump to smaller once. 11. At last to Lengthy once....... 12. If solving dumps also see the other option bcoz in exam u often gets confused..... 13. For last 3 days u should only see your rulebook and notes.. which you prepare nothing else. 14. Prepare time table Java required 120 hours of dedicated coding for experience professional with 5 yrs experience and 240 hours of preparation for

In Maximo field length of 3-30 maximo create a textbox with size 10 and if its greater than 31 it consider its size to 40 actually this is obviously disappointed for developers because customer won't like that so here is what u can do... For Combobox use Width (this one is pixel format so give value like 120 or 150 to see changes) For Textbox use Size attribute......in XML (this will be db field size)

Maximo Sending email in table format with Multiple rows... 2. ways to achieve it... 1. This can be achieved with the help of Automation script (Here we construct message at the time of sending) 2. Using Automation script at the time of saving record...( Here we construct message before sending probably when record is saved and save the mail in db in HTML format) in a custom field...this is send via escalation because constructing and sending email via each escalation run will be very time consuming for escalation ...........(Imaging u decommisioned 1000 assets and sending email for Workorder' details for each asset in a seperate mail.......) Logic of constructing this email......

 mbo is not recognized for Allow object creation script If you are creating object creation script mbo is not recognized... You need to use mboset instead of mbo  so mbo.getOwner() should become mboset.getOwner()......

Maximo Migration Collection This has been asked in various maximo interview questions and lot of developers don't know this because they don't use it much... Well we develop components in Maximo or configure applications we maintain changes did for all task in Excel and give it to admin to extract. Admin extract them with the help of Object structures and migration groups.. we offcourse remove dependency at this time.. Now in migration collection we can define list of things we are modifying or changes we are doing or even we can enable an event on application so whenever a change is done like we create a new conditional expression in maximo this will be entered automatically in Collection application. People don't use it much bcoz they don't know prior to development what all components they will modify..But as soon as developers get experience before doing the requirement or changes they know what all they will modify and start using maximo Migration collection applic

Maximo 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? 16. How to insert attributes from Backend? 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

Maximo Table  domain over Aln domain sometimes we have requirement to filter aln domain, a way of it can be to create a table domain over the aln domain and apply list where clause. Technically this design is not incorrent.... * Now their is a catch with this ... what suppose we want to further filter this with automation script...... when maximo build this list where clause  domain type :- Table domain ALN Domain :- Months List where :-  domainid='MYMONTHDOMAIN'  Automation script :- listwhere("month.startswith [J]) when we apply this to field that field might not respect your list where clause sometimes...so you might need reapply the domain in automation script on field.. so you in autoscript whereclause should be formed like wherecaluse =domainid='monthdomain' and value in (value.statrtwith (J)) because maximo ignores what's coming with list where clause....

 Maximo Setting Multiple fields to readonly using automation script

Understand existing system, check no of transactions in a day for main objects like workorders Po assets inventory .. Check no of concurrent users , No of clusters... Ram division between clusters.... Hard disk.... Indexes on main objects and custom objects... Archiving of old data... Closure of old records.... Check Maximos best practices are followed in where clauses of conditions queries and relationships... Check if db can be migrated to exadata for speed...Delete not required or unused migration package inactive wf transactions based on ibm guidelines .... Check latest fixpacks are installed on Was and db.. and Maximo.. If some custom cron taking too much time check if we can use fetch first aur create an autoscript and do same work from storedproced bco they will more faster than java code or autoscript... Run integrity checker before and after every deployment of changes to production Update maximo statistics on regular basis... Check if can create common scripts or library scri

 This error usually occurs when listernet sessions are full or the TNS listner is blocked. i.e integration system is down To resolve this activate or restart Service handler (3rd Part System)

 Unable to login to Maximo because of Cache issue:- AUTOSCRIPT CACHE ERROR AFTER DB CONFIG........... WELL IF YOU DELETE A TABLE U NEED TO DELETE ASSOCIATED AUTOMATION SCRIPT ON LAUNCH POINTS. Similarly this issue can also occur if you add some attribute or migrated some changes related to autoscript but removed a launch point ... Solution 1.  identify missing attribute lauchpoint or object launch point inactivate entry or delete it.. Solution 2. Turn on admin mode to login and identify which script is causing issue..

Their are 3 types of items in maximo *Stocked *Non Stocked * Special  Stocked items are items you reorder and maintain balance in inventory Non stock are occationally ordered itesms. You don't put it in for reordering. Special price items are items for special purpose you don't hold it in inventory as soon as work done with them you delete them...they are just one time useful...

 Why I am saying this because thier is huge cost in development which developer's are asking. companies look for developing software / maintaining it enhancing it......we require developers... Some company spend 40percent on it... Now this was done in old languages using C / Cobol/C++........... For this we require expertise.. Now in newer languages like .Net, Ruby......anyone can work because of those IDE's and simplification of Syntax so we dont need  many expertise and we can work with avg. developers.... So slowly in future software's will come where AI / ML will be so strong that we dont need developers to write code all will be done by instructions even by verbal instructions......(dont worry support will always be their..........) Also in new languages we require less no of developers due to automations.....which saves cost...

 Inorder to implement Duplicate Button in Child Table their are 2 options 1. Use duplicate event on button(No Customization required OOB) 2. Write a bean class (Custom methods need to be created custom databean class inorder +helpful in scenario's like handling Validation and Checking parent Save)

 Server not Reachable Error Step by Step 1. Ping server Like ping google.com 2. If its not working ping the ip address for finding ipaddress use netslookup commad netslookup google.com ip is 192................. ********************* then ping ip  ping 192.............................. 3. If if its still not accessible check you are connected to network.. :) 4. Check etc\hosts file  5. Check resolve Config file on your computer.

 How to Customizing Response in Maximo.... As we know default queue based services does not send response. By invocation Channel we can configure response. For enterprise service response is autogenerated, if we need to customize response we can write User exit with the help of irData we can setvalue in IRData than in our response this value will be added...

Pre upgrade steps 1. Check current configurations and  maximo upgraded configurations and note down difference and impacts.. 2. Repeat similar steps for integrations ..... 3. Check what all new features in the new versions 4. Check maximo compatibility matrix ... Below are steps to upgrade Maximo to 7.6 1. Compile all Java class to version 8. 2. Run integrity checker in report mode and resolve all issues. 3. Install 7.6 4. Point your smp to 7.6  5. Run updatedb script. 6. Run post installation fixes  7. Check all applications are opening and hv your configurations if not import oob xmls and modify it using beyond compare  8. Run all autoscripts (Many autoscripts will not work because of syntax change in libraries) 9. Create temporary records for sequence related errors. Resolve maxsequence errors 10. Reapply all statistics and indexes and check all procedures are working otherwise fix them... 11. Check system properties and end points. 12. Check doclinks 13 Check security access... Lim

 Sometimes we have an issue and after spending hours we can't identify how this has been occurred after our new deployment........ There comes to rescue Maximo Integrity Check. Maximo Integration Checker utility checks integrity of your Database as per Maximo's best practices..it should run after every deploment or upgrade or Ifix applying.. Note do not run it in Repair mode (untill IBM PMR team ask you ) run in report mode. Its logs are saved to Maximo/logs/integrityXXXX.log steps  Stop the serer. Open command prompt Go to c:\ibm\SMP\maximo\tools\maximo  Run integrityui.bat  from command prompt  Click on Check integrity tab  and click run integrity tab Click ok.

 Check Technical document for the integration...  Check Logs.. Check publish channel for Skip rule, User exit classes and Integration Scripts.. Check crontask (ifaceconsume, Sequential Consume is On)  Check Message in External system (add/modify queues) Check integration Bus Check message Tracking Check if the error is found in Ifix or something? Check classes with error....to debug... Ask Customer if you dont know these questions. When this issue occur 2. What is the issue. 3. is the issue replicable 4. time of the issue 5. is issue replicable in lower environment 6. Priority 7. No of users impacted 8. Screenshot of issue.

  Configuring Eclipse for Mobile First Development Steps 1. Go to Eclipse Ini file and change heap size from 512 to 1024 or 830 as per requiremen Steps 2. Click on Install new Software and give path for Mobile first studio.zip file. (Note you can download from Marketplace) Step 3. Import Maximoanywhere Project in Workspace using import existing project in Workspace. Step 4. Click on WindowsShow Ant View Step 5. Turn off Auto Build Step 6 Copy Ant Scripts in Ant View from Project Explorer   Step 7. Deploy OSLC Generic Adapter on Mobile First Server   Install Adroid SKD Go to android SDK--->tools-->Andoird.bat.     This allows are to Deploy apps in Mobile First. Files are deploying on Server Step 8 Run Any Mobile First Application on Developer Mobile First Server Step 9. Set Path For Android Studio using Preference-Mobile First -Location  login to worklight  Login with admin/admin credentials.   Step 11 Check Application Deployed Click on eye icon to Preview a

This blog is for people who havs seen everything in development integration funtional etc and got bored from Maximo and Java integration........ ..they can start exploring Maximo Gis   maximo schedular customization   maximo anywhere development... Explore Rest ApI...  Call and Insert data using Maximo webservice from Java. Integration Maximo with Spring jar's

Anywhere Question 1. What are new changes in 7.6.4 2. How to add a new domain value in Anywhere 3. How to enable esignation in Maximo Anywhere 4. How to enable ldap in Anywhere 6. How to Build apk (command) 7. What is RdfPuller cmd do? 8. What is a ant file? 9. What are Maximo Anywhere applications. 10. How would u test your Maximo Anywhere Application? 11. What you use Anywhere administration application For?

Maximo DBC scripts

Query to insert into maxattributecfg (Add attribute from backend) insert into maxattributecfg (OBJECTNAME,ATTRIBUTENAME,ALIAS,AUTOKEYNAME,ATTRIBUTENO,CANAUTONUM,CLASSNAME,COLUMNNAME,DEFAULTVALUE ,DOMAINID,EAUDITENABLED,ENTITYNAME,ESIGENABLED,ISLDOWNER,ISPOSITIVE,LENGTH,MAXTYPE,MUSTBE,REQUIRED,PERSISTENT,PRIMARYKEYCOLSEQ ,REMARKS,SAMEASATTRIBUTE,SAMEASOBJECT,SCALE,TITLE,USERDEFINED,CHANGED,SEARCHTYPE,MLSUPPORTED,MLINUSE,HANDLECOLUMNNAME, MAXATTRIBUTEID,RESTRICTED,LOCALIZABLE,TEXTDIRECTION,COMPLEXEXPRESSION) values ('JOBPLAN', 'TESTING', 'TESTING', null, (SELECT MAX(ATTRIBUTENO)+1 FROM MAXIMO.MAXATTRIBUTECFG WHERE OBJECTNAME='JOBPLAN'), 0, null,'TESTING', null, null, 0, 'JOBPLAN',0,0,0,20,'UPPER',0,0,1,null, 'TESTING',null,null,0,'TESTING',1,'I','NONE',0,0,null,MAXATTRIBUTECFGSEQ.NEXTVAL,0,0,null,null); update maxobjectcfg set changed = 'A' where objectname = 'JOBPLAN'; Run db c

 Download maximo files for was db2 and maximo from passport advantable  run launchpad exe Run verification Tool select db2 websphere maximo select db2 studio if you want to install db2  select path to install maximo/ http server/db2 etc...... select http port db2 password and db2 port details  complete websphere configuration Configure Database  select language  Build Ear

 CTRL+SHIFT+Q or  CTRL+SHIFT+F

 Use this PM to Trigger PM Hierarchy :- This is option you will use to generate workroder only for the parent PM and not for child pM. For parent it will be checked and for child you can unselect it so when parent is due it will generate workroder for parent only and not for child ... If pm is top level this field will be readonly...........

  check ldapusermngmt , appserversecurity   check default site present for user exists in organization  check check ssl configuration. check maxadmin or mxintadm user is blocked ? check loginblock table. Have u  deleted an attribute or object:- If yes it might impact because their is a chance that u have not deleted dependencies impacting maximo's cache.. Have u added any  attribute or object:- If yes it might impact because their is a chance that attribute already refrenced somewhere from previous migration.... Check are u able to login to admin accounts like MAXADMIN  or Maxintadm user... Hv u recently upgraded maximo or installed fixpack if yes check url of maximo is in trusted zone of browser...

  when creating site go to user and check can access inactive site

Easy way to format date time in maximo birt for a field is 

BMXAA1983E cannot approve invoice XXX. the difference in cost between line 2 of the invoice and purchase order  is 5 USD which is less than tolerance of 0 USD This issue occurs when their is a difference between Cost in PO and Cost in Receipt or their is a difference between Currency of PO and invoice.........which is greater or less than threshold. Inorder to check this use the below query to check whether limit tolerance is set or not select * from maximo.LIMITTOLERANCE where and groupname in (select groupname from groupuser where userid in (XXXX) Limit tolerance i.e tolerance % can also be set at PO level in PO line details section...... if their is a difference between cost and it is greater or less than threshold i.e limit defined in security group this error occurs.  Check if tolerance is defined and what is value of tolerance.............. Check if this invoice can be approved by another user of some different group where tolerance is defined...............

 Java Interview Concepts A Functional interface should have only 1 abstract method. All Non static methods of an interface should be abstract. When we write code we have to write too many null checks else we get Null point exception inorder to avoid it Optional class came in Java 8. Two methods 1. static <T> Optional<T> ofNullable(T value) 2. orElse(T other) Returns the value if present, otherwise returns other. Returns an Optional describing the specified value, if non-null, otherwise returns an empty Optional Enum Constructor must be private.

 Oracle Virtual box VM very slow getting hang 1. set base memory to 4 gb (50%) of your ram. 2. set video memory 32%. 3. Go to System -> Processor - set processor to 2 and execution cap to 40% and Enable PAE/NX  4. Start VM.

 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 ma

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

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

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

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

  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())

 raise ValueError(' Cust Mesg')

 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

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

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

 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     Annotatio