Monday, March 23, 2009

Tab name in Workflow

To determine a tab identifier, complete the followings steps:
1 Navigate to the following directory:
\resources\presentations
2 Using a text editor, open the XML file for the application.
3 Search for the following phrase "tab id=" until you locate the appropriate
tab identifier, for example:

Path to Check Java Classes in Maximo

IBM/SMP/MAXIMO/Applications/maximo/BusinessObjects/classes/psdi/app

Sunday, March 22, 2009

Inserting Hyperlinks in Maximo

You can insert a hyperlink to a Maximo record within the body of your
communication template message that includes the application name and
record ID.
To insert a hyperlink in a Workflow communication template, insert the
following link into the body of your message:
http://:HOSTNAME/maximo/ui/
maximo.jsp?event=loadapp&value=:APP&uniqueid=:OWNERID
where HOSTNAME is the name or IP address of the MXServer.
When Maximo generates a notification, the application name and record ID
appear in the message as a hyperlink that leads directly to the record.
NOTE In order to be able to view the record, the e-mail recipient must be a Maximo
user with security permission to the specified application.

Sample Escalation Log Messages

Sample Escalation Log Messages
NOTE You must first enable logging.
Escalation Start and Finish
These messages indicate the escalation’s start and finish, including its name
and time of execution.
21 Jul 2004 13:47:23:839 [DEBUG] Started Escalation task:
ESCALATION for instance: ESC INCID
21 Jul 2004 13:47:23:849 [DEBUG] Finished Escalation task:
ESCALATION for instance: ESC INCID
These statements appear in the log file if you place this statement in the
properties file:
log4j.logger.Maximo.crontask.ESCALATION=DEBUG, A2

Enabling Logging for Escalations

Time drives escalations, and log files let you check whether escalation actions
run according to schedule.
To enable logging on the escalation cron task, notification messages, and
action messages, you must modify the logging.properties file. Default location:
applications\Maximo\properties
where is the folder where you installed Maximo.
1 Append these examples to your local file:
# Enable crontask for ESCALATION
log4j.logger.Maximo.crontask.ESCALATION=DEBUG, A2
# Enable the following for Notification messages on logger
log4j.logger.Maximo.service.SYSTEM.COMMTEMPLATE=INFO, A2
# Enable the following for Action messages on logger
log4j.logger.Maximo.service.SYSTEM.ACTION=INFO, A2
2 Save the modifications.
Enabling Logging for Escalations
Escalations 12-13
3 Rebuild the EAR file and restart the application server.

DB config Restore Backup

Question: Error when running ConfigDB: "Tables exist that have not had their backup data restored. You must run restorefrombackup before you configure the database" But there are no backup tables to be restored. ???

Answer: This can happen if a table is manually restored via SQL rather than using restorefrombackup. A flag is left in the database that indicates restorefrombackup needs to run to restore the data from the xxtable_name to table_name.

To correct this you need to remove these flags from the database. To verify if these are incorrect run the following query.

select restoredata from maxtable where tablename='table_name'

select restoredata from maxtablecfg where tablename='table_name'

If either of these return a value of 1 they must be changed to 0 to allow ConfigDB to run.

Saturday, March 21, 2009

Escalation : Notification when purchase contract renewal date is 30, 60, 90 days away


on
Escalation : Notification when purchase contract renewal date is 30, 60, 90 days away

Applies To : Purchview

Condition: STATUS=(select value from synonymdomain where domainid = 'CONTRACTSTATUS' and maxvalue = 'APPR')

Escalation points :

Escalation point : 1
Elapsed Time Attribute: ENDDATE Elapsed Time Interval : -90 days

Escalation point : 2
Elapsed Time Attribute: ENDDATE Elapsed Time Interval : -60 days

Escalation point : 3
Elapsed Time Attribute: ENDDATE Elapsed Time Interval : -30 days

Create a Notification for each Escalation point.

Notificatication Commtemplate is :

Applies To : PURCHVIEW

ACCESSIBLE FROM : ESCALATION

Commlog Entry: check mark Yes.(right mark).

Subject : Expiration notice: Contract :contractnum

Message: Purchase contract :contractnum is expiring on :enddate .