How to create a demo database by Scripts

بسم الله الرحمن الرحيم

In Sometimes , you need to ckeek the default functionality Of maximo or new product based on maximo, you can do this by the demo data which provided By IBM 

In this post I'm going to show you how to install this demo data by scripts 

 from your maximo's workstation run maxinst.bat in windows CMD

1- open windows CMD then change directory to <SMP Directory>\maximo\tools\maximo

2- then run maxinst.bat , this patch will need a two parameters as modatery 

 a -t <tablespace name>

 b -s<tablespace name>

and optionall you can create an epmty Database from demo data by this pramter  -imaximo 

3- make sure that maximo.properties in SMP have a correct database's URL and the MXServer Stoped.

 

 

   4- press enter then wait unitle the process is copmlete.

NOTE : you maybay find error like following :

 simply copy the content of C:\IBM\SMP\maximo\tools\maximo\en\maxdemo.db2 to C:\IBM\SMP\maximo\tools\maximo\en

then run againe

Create a primal Preventive maintenance in maximo .

بسم الله الرحمن الرحيم

In some cases maximo needs a licence to enable Preventive maintenance model , and maybe to enable it will exceed your budget.
in this post I will illustrate how to Create a primal Preventive maintenance functionality.
I suppose the requirement is to  generate  a WOs on Asset or location with  job plan based on a frequency of days.


this solution implemented on  SCCD 7.5.1 and DB2

• Solution summary (the solution based on create a  WO from another one)

1. Create new 4 attributes(PM_nextduedate,PM_previousduedate,frequncey and pmflg)By A database configuration application
2.  Duplicate Workorder tracking Application By Application designer
3.  Ceate an escalation to generate a WO and calculate the next due date 

• Solution Details  

1. 1 Create new needs attributes from Database Configuration application 

1. 2  open GOTO--> System Configuration --> platform configuration-->Database Configuration

1. 3 filter on workorder object and add the following attributes 

the new attributes Table

Attribute	Type	description
PM_nextduedate	DATE	Hold the next due date
PM_previousduedate	DATE	Hold the last time WO GEN
frequncey	integare	The frequency for WO generation(my unit is in day)
pmflg	YORN	To flag the PMs records in Workorder table

1. 4 run admin mod and apply the configuration.

 2.0 Duplicate WOTRACK APP

 2.1 - From GOTO--> System Configuration --> platform configuration  --> Application Designer

 2.2 - filter on WOTRACK Application  then open it

 2.3 - from select Action -->  Duplicate Application then enter name like CUST_PM and in description Preventive maintenance

 2.4 remove all tabs except  list, work order and Related Records

 2.5 in work order tab remove all objects except (wonum, location,asset,site,class,worktype,jobplan and status)
 2.6 add a default value object and set  pmflg=1

 2.7 add the add attributes in 1.3 to be like following

 3.1 create a  new Escalation as following table

The Escalation Table Caption

Table Header	Table Header
Escalation	WOAUTOGEN
Description	TAMIT - WO Auto generation
Applies To	WORKORDER
Conditionc	pmflag = 1 and date(pm_nextduedate)  =  date (current date) and status ='APPR'
Schedule	set it to every day
Create Successful Execution Entry?	CHECK

 3.2 add a new escalation point and check repeat checkbox.

 3.3 we will add  3 action in action section  as following

The actions Table Caption

Action	desc	Object	Type	value	Paramter/attribute
1100	set pervois date = current date	WORKORDER	Set Value	:&DATE&	pm_perviousduedate
Table Cell	set the next due date	WORKORDER	Set Value	:&DATE& + :pm_frequency	pm_nextduedate
Table Cell	generate a WO	WORKORDER	Application Action	CREATEWO

 3.4 after that Activate the escalation

 4.1 finally you will need to add the jpnum in WO2WO DOMAIN to be able to copy the job plan to the generated WO
GOTO--> System Configuration --> platform configuration  -->domains
 
4.2

filter on  WO2WO

 4.3 add jpnum in both source and destination

  For now the solution is ready for work , may be need for more enhancement, Let us discover it together .

in Birt Designer the Enter Parameter Window is blank

بسم الله الرحمن الرحيم

I run Birt designer V4.3.1 on windows 8.1, and when I run any report viewer I get a window with title enter parameters but nothing shows up in the window(BLANK).

Diagnosing the problem(IBM)

If you are using a computer with IE11 as the default browser you will likely have this issue.

The Solution try one of the following :

1.1  - in eclipse open the preferences  from  windows -->preferences 

1.2  - in left pan select WeB Browser under General
1.3  - select Use external web browser and check Firefox 

 Second solution 

2.1 - put the following lines in exclipse.ini

 -Dorg.eclipse.swt.browser.DefaultType=ie,mozilla
 -Dorg.eclipse.swt.browser.IEVersion=7000

2.2 - restart Eclipse

2.3 - Test -just wait  a minute -

 D: bye
 

Maximo 7.6.0.1 Fix Pack installation guide with snapshoots.

On June 19, 2015, IBM Software released the 7.6.0.1 fix pack for Maximo Asset Management (here) .  

the new Fix Pack work for Products

· IBM Maximo Asset Manager Scheduler 7.5.3.0

· IBM Maximo Mobile 7.5.1.0

· IBM Industry Solutions > Asset Configuration Manager 7.5.1.1

· IBM Industry Solutions > Nuclear 7.5.1.0

· IBM Industry Solutions > Oil and Gas 7.5.1.0

· IBM Industry Solutions > Service Provider 7.6

· IBM Industry Solutions > Transportation 7.5.1.0

· IBM Industry Solutions > Utilities 7.5.0.1

· IBM Industry Solutions > Spatial 7.5.0.1

· IBM Industry Solutions > Health, Safety and Environment Manager 7.5.1.0 

the size of this Fix Pack 330 mig and that sound is good where IBM used to release fixes with size nearly to 1.5 GB, and this fix has new installation  wizards and methodology and the aim of this post to illustrate this installation steps with snapshots.

 

Before you begin

1- Ensure that no database configuration changes are pending.
SELECT count(*) FROM maxobjectcfg WHERE changed!='N';

2- Shutdown all Maximo applications and back up the database.
3- Copy the Maximo directory and save it to another location.

This fix pack is provided as an Installation Manager (IM) compressed file. When the fix pack is installed by using the Installation Manager program, the existing Maximo directory structure is overwritten. The fix pack also contains database scripts that modify the existing database.

If you want to reverse the changes, you must restore the earlier version of the Maximo directory and database that you saved to another location.

 

 Procedure

1- Download the 7.6.0.1-TIV-MAMMT-FP0001 compressed file and copy it to the Administrative Workstation machine.

2- Run the Installation Manager from the following directory:

• Windows: Start > All Programs > IBM Installation Manager > IBM Installation Manager
• UNIX: In the /opt/IBM/InstallationManager/eclipse directory, run the IBMIM command. 
 

3- from file -->select Preferences 

4- Click the Add Repository button, find the downloaded coprossed file ,then select it .

 

5- in the preferences dialog box, click OK.

 

1. 
   6 - Click the Update icon
   
   

   

   
   7 - In the Update Packages dialog box, select the IBM Tivoli's process automation suite package group, and click the Next button.
   
   

   

   
   

   

   
   8-  Click next .
   
   

   

   
   9- Select Accept the terms , then click next .
   
   

   

   
   10- Keep defaults, click Next.
   
   

   

   
   11 - Select IBM Maximo Asset Managment 7.6.0.1 , then click update.
   
   

   
   

   

   
   12- waite untill the update completed
   

   
   

   
   

   

   
   

   

   
   13- Click Finish
   
   

    

   
   

   You can automatically configure the fix pack by using the UI configuration tool, which removes the need for manual tasks.

   Procedure

   1. Start the configuration program
      • For Windows 7 and above, navigate to C:\IBM\SMP\ConfigTool\ConfigUI.exe or <InstallLocation>\ConfigTool\ConfigUI.exe.
      • For UNIX, navigate to the <installLocation>/ConfigTool directory and run ConfigUI. For example, /opt/IBM/SMP/ConfigTool/ConfigUI.
      
      
      
      
      
       
       
      
      
   2. In the Deployment Operations pane, select the Update Database, Build and Deploy Application EAR Files option.

    
   
   
   

   3- To complete the configuration, Click Next .
   
   
   
   4- Click finsh.
   

   

    5 - validating deployd system

   

    6- Running Validattion and configuration.

    

    

    7 - After Complete .click OK.

   

    
   

   Importing report design files into IBM Maximo Asset Management Multitenancy

   This fix pack contains new and updated report design files. If you previously customized delivered BIRT reports, the customizations might be overwritten with this fix pack. You can also review any reports that you created to ensure that they display correctly. After you install the fix pack, use the report import utility to import any necessary design file updates to your existing reports. For more details, access the Maximo 76 Report Development Guide.

   Procedure

   1- On the administrative workstation, browse to <install_home>\maximo\reports\birt\tools.
    
    
   

   2- Open the reporttools.properties file. This file indicates the location to where the reports are imported.
   

   3- Edit the reporttools.properties file to meet your system requirements.
   

   4- Run the importreports.cmd to import your report design files.
   

   
   

   
   

   Finally Open Maximo and review Sys Information.

   
   

   

   
   

 

Install Maximo Asset Management 7.5.0 (Incomplete)

بسم الله الرحمن الرحيم

How DO you  Install Maximo Asset Management 7.5 (Incomplete) last update 6/12/2015
My Lab Environment :
OS : windows 2008
Database :Oracle
AppServer : WebSphere