Informix - Problem description
Problem IT36149 | Status: Closed |
SCHAPI: [AUTO UPDATE STATISTICS EVALUATION 42-2] ERROR -1265 OVERFLOW OCCURRED ON A DATETIME OR INTERVAL OPERATION. | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
With tables having data distributions info, in sysdistrib catalog table, that's older than ca. 11 years and 5 months (99999 hours), AUS would throw following error: SCHAPI: [Auto Update Statistics Evaluation 42-2] Error -1265 Overflow occurred on a datetime or interval operation. Reason seems to be an HOUR(5) limitation in an internal query populating sysadmin:aus_work_coldist transient table, aus_coldist_expired field (which is a BIGINT, so could easily hold higher numbers.) | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC7. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 or 14.10.xC7 (when * * available). * **************************************************************** | |
Local Fix: | |
determine and manually drop such old distribution info | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC7. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 or 14.10.xC7 (when * * available). * **************************************************************** | |
Comment | |
Fixed in Informix Server 12.10.xC15 and 14.10.xC7. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 09.03.2021 23.08.2021 23.08.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |