（cognos高手求救）(TR1901)PDS-PCT-0010 数据高速缓存表或索引已满

Technote (troubleshooting)

Problem(Abstract)

Unable to build a cube in Transformer.

Error Message - [TR1901] A PowerCube Table or index is full. (Bitmap) in <cube.mdc>
Resolving the problem

This error means that Transformer can no longer write to the Temporary Cube files.

Verify the following -

1. The environment variables TEMP and TMP for System, and User are pointing to a directory on the server with enough space.
2. The TEMPORARY variables in the CER1.INI (or Cer2.ini) file under [Services L and/or K] or [Services] TEMPFILEDIRS for Series7

are also all pointing to the same drive with enough space.

1. The SORTMEMORY is set to an value other than the default 512.
2. The WriteCacheSize is set to an reasonable value 16384, 32768.
3. Check that in the TRNSFRMR.INI file in the ..\CerX\bin directory the WorkFileMaxSize is set to 2000000000 ( 2 Billion = 9 zero's ).
4. The TRNSFRMR.INI file that the MultiFileCubeThreshold is set to a value other than Zero.

If it is Zero the maximum cube file size is 2 GigaBytes, the file size limit for Windows 95/98/NT/2000.
A good starting value for this MultiCubeFileThreshold is 300000 ( 300,000 )

Increase this value by 500,000 at a time, and monitor the building process of the multifile cubes (One Cube.MDC file and multiple Cube.MDP files). Increasing the size of the MultiCubeFileThreshold will now create larger MDP files. A target MDP file size should be around 1.6 GB in order to have improved efficiency.

Note:

This document is no longer valid for the later versions of the product. The maximum workfile size since 7.1 MR3 is 1500000000. This applies at least to Windows version of the product. If you try to set workfile size higher than this limit Transformer will automatically revert the value back to 1500000000.

Cross Reference information