error since 1.4 and in 1.4.1 [Unable to get value for functionid...

[marc]

it seems like anything is working but server log show for each host...

e.g.
24004:20070630:020149 Expression [{200000000002447}=2|{200000000002446}=0] cannot be evaluated [Unable to get value for functionid [200000000002447]]

select * from functions where functionid=200000000002447;
| functionid | itemid | triggerid | lastvalue | function | parameter |
| 200000000002447 | 100000000018952 | 200000000001140 | NULL | min | 120 |

mysql> select * from items where itemid=100000000018952;
| 100000000018952 | 3 | public | | 161 | 100000000010022 | Host status | status | 60 | 30 | 365 | 0 | 0 | 1182763478 | NULL | 0 | 3 |...

mysql> select * from triggers where triggerid=200000000001140;
| triggerid | expression | description | url | status | value | priority | lastchange | dep_level | comments | error | templateid | 200000000001140 | {200000000002447}=2|{200000000002446}=0 | Server {HOSTNAME} is unreachable | | 0 | 2 | 5 | 0 | 0 | | | 200000000001136 |


trigger defined is..:
{Template_MTA:icmpping.max(120)}<1|{Template_MTA:s tatus.min(120)}=2

trigger is not active and values in latest data are correct.

items combined are as you see icmpping and status, both defined as simple checks and type Numeric (float)

iam wondering what might be wrong..

[marc]

fixed by...

update functions f, items i set f.lastvalue=0 where f.itemid=i.itemid and i.key_='status';