'Cannot perform a query on a compressed attribute' error faced

Technote (troubleshooting)


Problem(Abstract)

'Cannot perform a query on a compressed attribute' error faced

Symptom

Steps:
1. A new extended column is added in the DB table.
2. Any get.....List() API is now called to retrieve the data by specifying this extended column in input.
3. On execution, "Cannot perform a query on a compressed attribute" error was thrown.


Cause

For the current scenario to work, a set of attributes have to be set.

CompressionSupported
If the data inserted into a column has both CompressionSupported and UseCompression attributes set to True, then this attribute should not be set back to False. Doing so would result in all compressed data being retrieved without any decompression.

- UseCompression
The value of this attribute should be set to True only if the CompressionSupported attribute is set to True. Optional. Attribute used to enable a compressible column to be used for queries in a List API. Valid values are True or False. If True the column can be used for queries in the List APIs.

- QueryAllowed
If the value of the CompressionSupported attribute is set to true then the value of this attribute should also be set to True.

Resolving the problem

For the current scenario to work, a set of attributes have to be set.

- CompressionSupported
If the data inserted into a column has both CompressionSupported and UseCompression attributes set to True, then this attribute should not be set back to False. Doing so would result in all compressed data being retrieved without any decompression.

- UseCompression
The value of this attribute should be set to True only if the CompressionSupported attribute is set to True. Optional. Attribute used to enable a compressible column to be used for queries in a List API. Valid values are True or False. If True the column can be used for queries in the List APIs.

- QueryAllowed
If the value of the CompressionSupported attribute is set to true then the value of this attribute should also be set to True.

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Sterling Order Management

Software version:

All

Operating system(s):

All

Reference #:

1616380

Modified date:

2013-03-31

Translate my page

Machine Translation

Content navigation