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.
Hello all hope you can shed some light on my kpi issue. I've created a number of kpi's for one of my managers and for some reason they are not running the last run date was 2 days ago. Why would it not update automatically?
Maximo 6.2.1
SQL 2005
Thx,
mrggutz
When you say it doesn't update automatically, is he refreshing the screen, or when he logs in the KPI information doesn't change?
What browser/version is being used?
Could be a browser cache issue.
CJ Stringer
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of George
Sent: Friday, January 13, 2012 9:08 AM
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] KPI
Hello all hope you can shed some light on my kpi issue. I've created a number of kpi's for one of my managers and for some reason they are not running the last run date was 2 days ago. Why would it not update automatically?
Maximo 6.2.1
SQL 2005
Thx,
mrggutz
Check that the Cron job that updates the KPI's is still active and running.
Peter
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
George
Sent: Saturday, 14 January 2012 1:08 AM
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] KPI
Hello all hope you can shed some light on my kpi issue. I've created a
number of kpi's for one of my managers and for some reason they are not
running the last run date was 2 days ago. Why would it not update
automatically?
Maximo 6.2.1
SQL 2005
Thx,
mrggutz
You may also want to check the SQL statement again with the current data. The SQL statement may have error, such as dividing by zero, with the current data which is different from the data two days ago.
Regards,
Samson
--- In MAXIMO@yahoogroups.com, "Peter Camarsh" <peter_camarsh@...> wrote:
>
> Check that the Cron job that updates the KPI's is still active and running.
>
>
>
> Peter
>
>
>
> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
> George
> Sent: Saturday, 14 January 2012 1:08 AM
> To: MAXIMO@yahoogroups.com
> Subject: [MAXIMO List] KPI
>
>
>
>
>
> Hello all hope you can shed some light on my kpi issue. I've created a
> number of kpi's for one of my managers and for some reason they are not
> running the last run date was 2 days ago. Why would it not update
> automatically?
>
> Maximo 6.2.1
> SQL 2005
>
> Thx,
> mrggutz
>
>
>
>
>
>
>
Make sure any modifications of numeric data specifies a decimal unit. SQL Server has a bug that if you divide or multiply data by an integer, you make get SQL errors. For example, if you wanted to make sure your percentage based KPI (e.g. % overdue WO's) came out as 73.35 vs .7335, you would multiply by 100.0 not 100.
http://stackoverflow.com/questions/723215/why-does-sql-server-round-off-results-of-dividing-two-integers
--- In MAXIMO@yahoogroups.com, "shps77" <samson.siu@...> wrote:
>
> You may also want to check the SQL statement again with the current data. The SQL statement may have error, such as dividing by zero, with the current data which is different from the data two days ago.
>
> Regards,
> Samson
>
> --- In MAXIMO@yahoogroups.com, "Peter Camarsh" <peter_camarsh@> wrote:
> >
> > Check that the Cron job that updates the KPI's is still active and running.
> >
> >
> >
> > Peter
> >
> >
> >
> > From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
> > George
> > Sent: Saturday, 14 January 2012 1:08 AM
> > To: MAXIMO@yahoogroups.com
> > Subject: [MAXIMO List] KPI
> >
> >
> >
> >
> >
> > Hello all hope you can shed some light on my kpi issue. I've created a
> > number of kpi's for one of my managers and for some reason they are not
> > running the last run date was 2 days ago. Why would it not update
> > automatically?
> >
> > Maximo 6.2.1
> > SQL 2005
> >
> > Thx,
> > mrggutz
> >
> >
> >
> >
> >
> >
> >
>