error on OAT using informix 12.10 FC8

Hi, I encountered an error when trying to access the alerts link in OAT web with error below... [Informix][Informix ODBC Driver][Informix]Unspecified System Error = -9272. sqlerrm(bigint) (SQLPrepare[-9272] at ..\\\\pecl\\\\pdo_informix\\\\informix_driver.c:131) Query: select FIRST 25 trim(lower(alert_color)) as alert_color, alert_type, alert_id, alert_message, alert_time, trim(alert_state) as alert_state, alert_action,trim(alert_object_type) as alert_object_type, alert_object_info, trim(task_name) as task_name FROM ph_alerts WHERE UPPER(alert_color) IN ( 'RED', 'YELLOW', 'GREEN' ) AND UPPER(alert_type) IN ( 'ERROR', 'WARNING','INFO' ) AND UPPER(alert_state) IN ( 'NEW', ' ', ' ', ' ' ) ORDER BY alert_time DESC Isn't 12.10 supported by the Open Admin Tool or is there a new version of OAT that I need to install? Thanks,

Hello. This should not be a problem, unless your sysadmin:ph_alerts alerts is plenty of records. It seems an overload of a smallint on php. Could you count how big is your ph_alerts table? Check if your AlertCleanup task is being executed (is your dbscheduller active?) HTH Regards