|
Problem IT31720
|
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 / C10 - IDS 12.10 |
| 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 :
| 31.01.2020
13.05.2021
13.05.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
