How to Enable Logger or Generate Maximo Logs | IBM Maximo

Go to System Configuration > Platform Configuration > Logging. 

1. Logger = sql
2. Log Level = INFO
3. Appenders = Console,Rolling

 

Asset Meter Reading Object Structure with Only Necessary Fields - IBM Maximo

Note: first of all create/duplicate(user-defined) Object Structure(OS) from MXMeterData as below

Goto > Integration > Object Structure; Filter and select default MXMeterData OS
Click on Duplicate Object Structure from Section Action area to create new as below mentioned details

Object Structure: MyAssetMeter
Description:     My Asset Meter reading OS
Consumed by: INTEGRATION application
Support Flat File flag: Yes
Inbound processing Class: psdi.plusg.iface.app.asset.PlusGAssetMeterInterfaceProcessor

Maximo version 7.6.0.3 Entity Relationship Document (ERD) - IBM Maximo

The Maximo Entity Relationship Document (ERD) describes the Maximo business objects and the logical relationships between them. This documentation helps those writing reports or designing customization for Maximo.
To use the documentation, extract the attached file into a directory and use a web browser to open the index.html file. This file displays a list of Maximo objects that are linked to pages that list relationships from the object to other objects. The object's attributes are also listed.

This ERD is based on Maximo version 7.6.0.3, which is similar to earlier 7.6.x and 7.5 versions.

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

or Click here to direct

Automation Script Template to Log with Object Launch Point example - IBM Maximo

from psdi.server import MXServer

from psdi.mbo import MboConstants

today = MXServer.getMXServer().getDate()

v_remarks =  '\r\n' + 'Date: ' + str(today) + ': '

print  '\r\n'

print '-----------------------------------------http://maximodeploy.blogspot.com/-start--------------------------------------------'

print v_remarks + 'My description modified?: ' + str(V_DESC_modified)

print v_remarks + 'Old description was: ' + str(V_DESC_initial)

print v_remarks + 'New description is: ' + str(V_DESC)

print  '\r\n'

print '-----------------------------------------http://maximodeploy.blogspot.com/-end--------------------------------------------'

Function Defination and Call in Automation Script - IBM Maximo

Some time its helpful to define a function in automation script to avoid repitation, just recall the function, pass parameter, if function definition set to accept parameters

Suppose in our example we create a function to getMboSet

#Function definition
def getMboSet(objectName):
      return MXServer.getMXServer().getMboSet(objectName, mbo.getUserInfo())

#Function Call
wo = getMboSet("PR")

Collection of Automation Scripts - IBM Maximo

A Collection of Automation scripts by Mr. MayOn at IBM Developerworks community. IBM Official scripting guide  is here and another Developerworks community is here Maximo Automation Scripting

Automation Script Template by Chon - IBM Maximo

Another great article I found today at Chon's website; Maximo Times. A lot of matured material we read there, and once again very important, informative, tip and a complete template to import classes in jython in Maximo, this article is about to automation script.
Article or how to contains ready-made Template for Automation script shared and developed by Chan to use whenever we need instead of creating and writing again and again. 

 

Information required to Troubleshoot(logging) Maximo Integration (MIF) - IBM Maximo

Maximo.log file reproducing the problem with the following logging properties in Loggin application enabled:
Navigation: goto > System Properties > Plateform Properties > Logging

log4j.logger.maximo.integration=DEBUG
log4j.logger.maximo.sql=INFO
log4j.logger.maximo.crontask=DEBUG

If using a custom integration object, output containing the object definition information from the following queries:
select * from maxintobject where intobjectname='your custom integration object'
select * from maxintobjdetail where intobjectname='your custom integration object'
select * from maxintobjcols where intobjectname='your custom integration object' order by objectname,name

Application server log:

For WebSphere, the log is systemOut.log and is located in the server directory IBM\WebSphere\AppServer\Profiles\customprofilename\logs\servername.

Reference  IBM Technote https://www-304.ibm.com/support/docview.wss?uid=swg21393908

Extract Segments from GLCode - IBM Maximo

A requirement once occurred at integration level at one of my client, We use below mentioned select clause combination with in-built sql functions "substr" and "instr" to achieve this task.
Segments separator was used there as "."

Example GLCode is as "Asset.OC.AFE.Element.Dept.Account.GLAC"

Update DB Records without Rowstamp - IBM Maximo

To update tables records without rowstamp, we can enable a system property named

"mxd.db.updateWithoutRowstamp" to 1.

for example: Interface tables doesn't have rowstamp. then we set above mentioned system property to 1 and can update table easily without rowstamp.

Dynamic Query Variables can use in Query or Conditional Expressions – IBM Maximo

a list of variables we can use in Maximo for queries or we can use in Conditional Expressions:

:yes – true

:no – false

:&datetime& – current date/time

:&date& – current date

:&personid& – person ID of the logged in

:&user& – logged in user

:&ownername& – name of the owner business object

:&owner&.<attrname> – value of an attribute of the owner business object

:&owner&.<relationshipname>.<attrname> – value of an attribute of the related business object of the owner business object

:&appname& – application name

:&mboname& – name of the current business object

:<relationshipname>.<attrname> – value of an attribute of a related business object of the current business object

:$old_<attrname> – the initial value from the database of the attribute

Export (Import) Flat File with Enable Event Listner MIF - IBM Maximo

1. Object Structure 

New > D-Person  Demo Person AQ_PERSON_OS
Consumed by : Integration
Support Flat structure Flag : True
Source Person
Exclude all column except , personid, firstname, lastname

2. Enterprise Service

New > D-ESPerson Demo Enterprise Service Person AQ_PERSON_ES
Operation: Sync
Object Struction: D-Person AQ_PERSON_OS
Action > Enable Event Listner

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

Default System Variables, Can be used to default a value - IBM Maximo

&SYSDATE& - This will default a field with the current system date/time
&USERNAME& - This will default a field to the current USERID value
&AUTOKEY& - This is used for attributes that are set to autonumber to default to the next autonumber value.
&PERSONID& - This will default the current user's PERSONID value.

How do I set field defaults in Maximo using Database Configuration? 

Solutions:

  

1. Select the object the attribute exists in from Database Configuration Application
2. Select the attribute for which the default is to be set
3. Expand the details of the attribute
4. In the right hand side of the Details section there is a Default field, type your desired default value 

OR

you can used system defaults (above given 4 variables) that work in the Database Configuration Default field.