Rapid BIRT Configuration with IBM Maximo 7.6 - IBM Maximo

1 install jre-7-windows-x64.exe into C:\java\jre7
2 Extract eclipse-reporting-kepler-SR1-win32-x86_64 into C:\birt_431\eclipse


#classes folder copy
cp -R C:\IBM\SMP\maximo\reports\birt\scriptlibrary\classes C:\birt_431\eclipse\plugins\org.eclipse.birt.report.viewer_4.3.1.v201309171028\birt\WEB-INF\

# oraclethin.jar driver copy
cp C:\IBM\SMP\maximo\applications\maximo\lib\oraclethin.jar  C:\birt_431\eclipse\plugins\org.eclipse.birt.report.viewer_4.3.1.v201309171028\birt\WEB-INF\lib\

Import Data into Maximo using INTERFACE tables MIF – IBM Maximo

First of all, we need to have interface/intermediate tables to import something into Maximo from an external/3^rd party database. Suppose we want to import some inventory data or for instance we try to figure out with a real example. Let’s assume we need to import data from a legacy application into Maximo. That legacy application is actually an inventory issuance system already implemented somewhere, we have to integrate it with New Maximo Inventory system.

MATRECTRANS tables is actually the main table to

To import data into Maximo, few steps are required to configure step by step.

1.            Object Structure (OS)

2.            End Point (EP)

3.            Enterprise services (Inbound or to import data) (ES)

4.            Publish Channel (Outbound or export data, we will not use in this case) (PC)

5.            and Combine above all into an External System (ExS)

6.            Generate Interface tables

7.            Configure Cron task for Scheduling (CT)

8.            Done. Now insert data into Interface tables and Maximo will read as per given schedule in CT.

Object Structures (OS)

Reprocessing Interface Table Errors MEA (Maximo Enterprise Adapter for Oracle Applications) | IBM Maximo

When an error occurs in an Maximo outbound transaction, the adapter stops processing the transaction and updates the interface table status columns with information about the error. There is no user interface for correcting errors in the Maximo Asset Management interface tables, so you must update the record directly with a SQL tool.

Interface Table Status:
Every outbound interface table contains the following columns, which contain information about the status of the transaction:
OA_IFACESTATUS: The status of the transaction. It has three types:

1. DONE: The transaction was successful.
2. WARNING: The data was transferred but a problem was encountered.
3. ERROR: Due to a system or data error, the data transfer did not occur. Check OA_IFACEMESSAGE for error messages.

OA_IFACETIMESTAMP: The date and time the transaction completed or failed.

OA_IFACEMESSAGE: A general message about errors.

The triggers, which reside on the outbound interface tables, are of trigger type before insert or update. Therefore, directly updating the interface table transactions ensures that the transaction is processed.
Triggers do not exist for the inbound enterprise services. These processes are asynchronous and the integration framework retrieves the records.
The following steps describe how to update an outbound transaction with an error in the interface table, then send the transaction to the Oracle open interface tables again.

A List of JDBC Driver and URLs for Integration End Points - IBM Maximo

Oracle 
URL: jdbc:oracle:thin:@<HOST>:<PORT>:<SID>
DRIVER: oracle.jdbc.driver.OracleDriver
 
IBM DB2
URL: jdbc:db2://<HOST>:<PORT>/<DB>
DRIVER: COM.ibm.db2.jdbc.app.DB2Driver


Microsoft SQL Server
URL: jdbc:weblogic:mssqlserver4:<DB>@<HOST>:<PORT>
DRIVER: weblogic.jdbc.mssqlserver4.Driver

JDBC-ODBC Bridge
URL: jdbc:odbc:<DB>
DRIVER: sun.jdbc.odbc.JdbcOdbcDriver

MySQL (MM.MySQL Driver)
URL: jdbc:mysql://<HOST>:<PORT>/<DB>
DRIVER: org.gjt.mm.mysql.Driver

Possible Attribute Data Types in IBM Maximo

basically it depends on your database server, common datatype with descriptions are below

 

 

Data type	Data type name	Description
ALN	Alphanumeric characters, mixed case	Maximum length depends on the database: Oracle = 4000 characters SQL Server = 8000 characters DB2® = 32672 characters
AMOUNT	Decimal number, used for currency
BIGINT	Big integer
BLOB	Binary large object	Stores JPEG, movies, or PDF files in single records inside the database instead of in external files.
CLOB	Character large object

Check Budget with Oracle ERP Through Publish channel and set flag 1 or 0 on PR and PO.

Check Budget with Oracle ERP Through Publish channel and set flag 1 or 0 on PR and PO.

Create End point for publish channel that needs to be used for Publish channel with ERP.

Publish Channel Endpoinnt = MEP

Define external system and publish channel for outbound transactions and Enterprise Service for inboaund transactions

Publish channel  = BDGT_CHECKINTERFACE
Enterprise Service = BDGTCHK_POINTERFACE

once everything is done for integeration side
Send request to ERP through automataion below.

create script with action launch point.
object = 'PO' , object = 'PR' in launch points.


import sys
from psdi.util.logging import MXLoggerFactory
from psdi.mbo import MboConstants
from psdi.util.logging import MXLogger
from psdi.iface.mic import MicService
from psdi.server import MXServer
from psdi.mbo import *
from psdi.webclient.system.session import WebClientSession
from time import sleep
from psdi.security import UserInfo
from psdi.server import MXServer

How to create a READ_ONLY User in Database | Oracle

1. connect with sqlplus with dba rights

sqlplus / as sysdba

2. create a simple user and give password:

create user test identified by test;

3. Give some grants to newly created user, like create session, and select

grant CREATE SESSION to test;
grant SELECT ANY TABLE to test;

:)

Find Records Between Specific DateTime Range | SQL

This Query is written in DB2 with Maximo on Workorder table, but I believe its the same for almost all.

SELECT w.reportdate
,to_date(to_char(CURRENT timestamp-1,'YYYY-MM-DD')||' 05:00:00','YYYY-MM-DD HH24:MI:SS' ) yesterday
,to_date(to_char(CURRENT timestamp,'YYYY-MM-DD')||' 05:00:00','YYYY-MM-DD HH24:MI:SS' ) today
FROM WORKORDER W
WHERE 1=1
--FETCH FIRST 10 ROWS ONLY
AND W.reportdate BETWEEN to_date(to_char(CURRENT timestamp-1,'YYYY-MM-DD')||' 05:00:00','YYYY-MM-DD HH24:MI:SS' ) AND to_date(to_char(CURRENT timestamp,'YYYY-MM-DD')||' 05:00:00','YYYY-MM-DD HH24:MI:SS' )

for Oracle: Use Sysdate instead of Current Timestamp

How to Fix VirtualBox “UUID already exists” Errors | Virtual Box

C:\Program Files\Oracle\VirtualBox>VBoxManage internalcommands sethduuid “c:\your_vdi_file_path.vdi”

Sequence Error when Uploading Assets using MIF | IBM Maximo

for instance look at this error:

BMXAA8010E - An asset with the asset identifier 16,058 already exists. Enter a new asset identifier

Solution is very easy , just need to increment object's sequence (asset in my case)

Run these below mentioned command one by one in sqldeveloper(Oracle):

1. Increment of 10,000 in AssetIdSeq sequence:

ALTER SEQUENCE assetidseq INCREMENT BY 10000;

2. Now run this select command once to update Asset Sequence Id

SELECT assetidseq.nextval FROM DUAL;

3. in last run this command to set Asset's Sequence back to routine:

ALTER SEQUENCE assetidseq INCREMENT BY 1;

Reference: http://www-01.ibm.com/support/docview.wss?uid=swg21998810

Reset Maximo User Password using SQL | IBM Maximo

first of all, get the encrypted password string of maxadmin user, where password is 'maxadmin'

SQL> Select userid, password from maxuser where userid = 'MAXADMIN'

output :
USERID PASSWORD
--------- --------------------------------
MAXADMIN x'10FE6F4650B2ACB49A2121D7E6133E64'

Now update user's password with this string, so that the password would be same like maxadmin's password