Tag: maximo

Posted on

Commit database configuration changes from administrative workstation

For commiting database configuration changes please run commands from shell:

sudo su -
cd /opt/IBM/SMP/maximo/tools/maximo
./configdb.sh
#./restorefrombackup.sh
./dropbackup.sh

Running first two performs the same function as choosing the Apply Configuration Changes menu option from the Database Configuration application, but requires all maximo application servers to be stopped.

Example response :

BMXAA0342I - Views are being configured. Wed Mar 04 13:39:45 CET 2015
BMXAA0344I - The attribute metadata is being refreshed. Wed Mar 04 13:39:46 CET 2015
BMXAA0343I - Object metadata is being refreshed. Wed Mar 04 13:40:25 CET 2015
BMXAA0341I - Native indexes are being rebuilt. Wed Mar 04 13:40:29 CET 2015
BMXAA0340I - Refreshing index metadata Wed Mar 04 13:40:29 CET 2015
BMXAA0339I - Updating table storage partitions Wed Mar 04 13:40:29 CET 2015
BMXAA0337I - Make sure you have created indexes for these new tables: PLUSPAGREPRICE Wed Mar 04 13:40:35 CET 2015
BMXAA0381I - There are no backup tables to restore data from. Wed Mar 04 13:40:35 CET 2015
BMXAA6820I - ConfigDB completed without errors. Wed Mar 04 13:40:35 CET 2015
BMXAA6820I - RestoreFromBackup completed without errors. Wed Mar 04 13:40:35 CET 2015
BMXAA6818I - DropBackup started for schema MAXIMO, connected to database jdbc:db2://xxxx/maxdb75 Wed Mar 04 13:44:33 CET 2015
BMXAA0380I - There are no backup tables to drop. Wed Mar 04 13:44:33 CET 2015
BMXAA6820I - DropBackup completed without errors. Wed Mar 04 13:44:33 CET 2015

Posted on

Maximo Integration – Object Structure create/update

As written in previous post it is needed to create or extend Object Structure to have possibility to read, add or update record connected mboSets.

Example definition:

Object Parent Object Object Location Path Relationship
ASSET ASSET
ASSETUSERCUST ASSET ASSET/ASSETUSERCUST ASSETUSERCUST
ASSETSPEC ASSET ASSET/ASSETSPEC ASSETSPECCLASS

After create object structure You should “Generate Schema”.

Posted on

Add worklog to record by REST Api

Problem:

Adding comment to to record by simply create WORKLOG mbo through the rest Api is not possible.

Such action results in Error 400: comlog#ownerNull.

Solution:

Right way to do this is adding WORKLOG from parent record, using custom object structure (which has to have relation to WORKLOG enabled).

Tasks:

1. Choose  (or create) Object Structure for Integration, which will have relation to WORKLOG object.

2. Fetch record using that object structure

3. Add workload in form of attributes list:

WORKLOG.index.DESCRIPTION

(…) where index will be number of existing comments + 1

Posted on

Direct enter into Websphere Maximo application

If you using integration and passing large amount of data IHS or other proxy can by problematic as it probably could timeout your operations.

To commit this you can use strict WebSphere ports. (In default SCCD installation it will be port 9080). After knowing that port you can access directly:

http://MAXIMO_URL:9080/maximo/