Maximo List Archive - PM's Overdue escalation

This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.

PM's Overdue escalation

From: shirleyfanmail (2013-06-03 19:23)

I have set an escalation to run everyday and sent a notification when there are overdue pm workorders.
Condition - status not in ('COMP', 'CLOSE', 'CAN') and worktype='pm' and (targcompdate < getdate () and actfinish is null) and istask = 0
Escalation point - 1
Elapsed time attribute - TARGCOMPDATE
Escalation point condition - ACTFINISH is null
Still, I get nothing...

From: foundationboarder187 (2013-06-03 19:27)

Shirley,
Try a few things:
1. Capitalize PM in the where clause
2. Depending on your DB you can use "sysdate" instead of getdate()
Best of Luck,
Todd
--- In MAXIMO@yahoogroups.com, "shirleyfanmail" <shirleyvelez.pmtech@...> wrote:
>
> I have set an escalation to run everyday and sent a notification when there are overdue pm workorders.
>
> Condition - status not in ('COMP', 'CLOSE', 'CAN') and worktype='pm' and (targcompdate < getdate () and actfinish is null) and istask = 0
>
> Escalation point - 1
> Elapsed time attribute - TARGCOMPDATE
> Escalation point condition - ACTFINISH is null
>
> Still, I get nothing...
>

From: shirleyfanmail (2013-06-03 19:49)

Hi, my DB is SQL and when I run through a where clause in the application it runs just fine, thank you anyway.
--- In MAXIMO@yahoogroups.com, "foundationboarder187" <todd.bellamy@...> wrote:
>
> Shirley,
>
> Try a few things:
>
> 1. Capitalize PM in the where clause
> 2. Depending on your DB you can use "sysdate" instead of getdate()
>
>
> Best of Luck,
>
> Todd
> --- In MAXIMO@yahoogroups.com, "shirleyfanmail" <shirleyvelez.pmtech@> wrote:
> >
> > I have set an escalation to run everyday and sent a notification when there are overdue pm workorders.
> >
> > Condition - status not in ('COMP', 'CLOSE', 'CAN') and worktype='pm' and (targcompdate < getdate () and actfinish is null) and istask = 0
> >
> > Escalation point - 1
> > Elapsed time attribute - TARGCOMPDATE
> > Escalation point condition - ACTFINISH is null
> >
> > Still, I get nothing...
> >
>

From: shannon sutton (2013-06-03 12:55)

Have you set maximo for logging so you can see what is happening when the escalation is running? I assume that your cron is active? Have you viewed the systemout file to see if it tells you anything?

Shannon Dale SuttonMobile: 318-334-8002
________________________________
From: shirleyfanmail <shirleyvelez.pmtech@gmail.com>
To: MAXIMO@yahoogroups.com
Sent: Monday, June 3, 2013 3:49 PM
Subject: [MAXIMO List] Re: PM's Overdue escalation

Hi, my DB is SQL and when I run through a where clause in the application it runs just fine, thank you anyway.
--- In MAXIMO@yahoogroups.com, "foundationboarder187" <todd.bellamy@...> wrote:
>
> Shirley,
>
> Try a few things:
>
> 1. Capitalize PM in the where clause
> 2. Depending on your DB you can use "sysdate" instead of getdate()
>
>
> Best of Luck,
>
> Todd
> --- In MAXIMO@yahoogroups.com, "shirleyfanmail" <shirleyvelez.pmtech@> wrote:
> >
> > I have set an escalation to run everyday and sent a notification when there are overdue pm workorders.
> >
> > Condition - status not in ('COMP', 'CLOSE', 'CAN') and worktype='pm' and (targcompdate < getdate () and actfinish is null) and istask = 0
> >
> > Escalation point - 1
> > Elapsed time attribute - TARGCOMPDATE
> > Escalation point condition - ACTFINISH is null
> >
> > Still, I get nothing...
> >
>

From: Travis Herron (2013-06-04 18:26)

Did you check the "repeat" box on the Escalation Point? (You need to.)
Travis Herron
--- In MAXIMO@yahoogroups.com, "shirleyfanmail" <shirleyvelez.pmtech@...> wrote:
>
> Hi, my DB is SQL and when I run through a where clause in the application it runs just fine, thank you anyway.
>
> --- In MAXIMO@yahoogroups.com, "foundationboarder187" <todd.bellamy@> wrote:
> >
> > Shirley,
> >
> > Try a few things:
> >
> > 1. Capitalize PM in the where clause
> > 2. Depending on your DB you can use "sysdate" instead of getdate()
> >
> >
> > Best of Luck,
> >
> > Todd
> > --- In MAXIMO@yahoogroups.com, "shirleyfanmail" <shirleyvelez.pmtech@> wrote:
> > >
> > > I have set an escalation to run everyday and sent a notification when there are overdue pm workorders.
> > >
> > > Condition - status not in ('COMP', 'CLOSE', 'CAN') and worktype='pm' and (targcompdate < getdate () and actfinish is null) and istask = 0
> > >
> > > Escalation point - 1
> > > Elapsed time attribute - TARGCOMPDATE
> > > Escalation point condition - ACTFINISH is null
> > >
> > > Still, I get nothing...
> > >
> >
>