Why do I receive this error 2245: Maximum values for compression group from ttImportFromOracle?
Last updated on MAY 10, 2016
Applies to:Oracle TimesTen In-Memory Database - Version 188.8.131.52.0 to 184.108.40.206.9 [Release 11.2]
Information in this document applies to any platform.
The customer has described this problem.
When attempting to load in a table into TimesTen (see version below) using the PDL scripts generated by ttImportFromOracle we intermittently get the following error with the compressed columns:
2245: Maximum values for compression group containing column <compressed column name> already present
We have verified that the total amount of distinct values (3) does not exceed the DICTIONARY MAXVALUES setting used. And as part of the data load all tables in timesten are truncated (and statistics gathered) before data is loaded. When we re-attempt the load for this table using the same script it will work, the issue is very intermittent.
Note ttImportFromOracle is calling ttLoadFromOracle, so the problem lies here.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms