Informix - Problem description
Problem IT35527 | Status: Closed |
WHEN TRYING TO COMPRESS BLOBS IN A TABLE, IF THE COMPRESSION WOULD FAIL BECAUSE < 2000 BLOBS, A 161 ERROR IS ALSO GENERATED | |
product: | |
INFORMIX SERVER / 5725A3900 / E10 - | |
Problem description: | |
When trying to either do a compression estimate or actually compressing the blobs in a partition, if the commands would fail because there's no enough blobs to continue the command, a misleading 161 error is also generated. The MSGPATH output would look like this: 11:11:28 SCHAPI Estimate Compression for db1:"informix".t1 started 11:11:28 SCHAPI Estimate succeeded for table 'db1:"informix".t1' partnum 1001e0. 11:11:28 Partition 1001e0, column offset 8 does not contain enough blobs to build a compression dictionary. The column must contain at least 2000 blobs to perform this operation. 11:11:28 ERROR Estimate FAILED for table 'db1:"informix".t1' partnum 1001e0 column c3 - iserrno 161. 11:11:28 ERROR Estimate FAILED for table 'db1:"informix".t1'- iserrno 161. The command would have not succeeded due to the "Partition 1001e0, column offset 8 does not contain enough blobs to build a compression dictionary. The column must contain at least 2000 blobs to perform this operation." The 161 error is happening in the error code path and isn't the cause of the problem so can be misleading. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC6. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 (when available) or * * 14.10.xC6 (when available). * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC6. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 (when available) or * * 14.10.xC6 (when available). * **************************************************************** | |
Comment | |
Fixed in Informix Server 12.10.xC15 and 14.10.xC6. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 14.01.2021 11.05.2021 11.05.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |