(TR2934) SORT-E-FILECREATE, 1

[spicysudhi]

Hi

We are getting the following error when we build the cube, this is the message from the log file.

26/06/2004 21:21:40 4 000266B3 --- Performing Pass 0 with 1463774 rows and 216009 categories remaining.
26/06/2004 21:21:40 4 000266B3 Selected Dimension 2 for next pass of partitioning.
26/06/2004 21:21:40 4 00000000 Sorting the work file.
26/06/2004 21:21:41 0 00000000 (TR2934) SORT-E-FILECREATE, Unable to create file.
26/06/2004 21:21:41 0 00000000 (TR2934) FIO-E-DISK_FULL, The disk is full.
26/06/2004 21:21:41 4 00000000 An error occurred while sorting temporary data file. Cognos debug info: Y:\src\transformer\App\port\rswrkfil.cpp (1385)
26/06/2004 21:21:41 4 00000000 Committing PowerCube(s).
26/06/2004 21:21:44 4 00000000 Timing, CUBE COMMIT,00:00:03
26/06/2004 21:21:57 4 00000000 End cube update.

This occurs when the cube building process reaches writing to file and this is happening for only one cube. The cube size is around 130MB and processes around 5 million records from a query.

The most possible solution mentioned in the knowledgebase suggested to check the UDA configuration folders which didnot help me as the free disk space on the drive is 112GB. Can you please suggest what are other parameters to check.

thanks and regards,
Sudhi

 

[CognosTechUser]

Increase the SORT_MEMORY size - should be a setting in Configuration Manager, otherwise the entry can be found in the cer3.ini file under the [Services] section. This value should be increased in increments of 512.

 

[spicysudhi]

many thanks.
regards,
Sudhi