Message Reference > S Message Codes > SORT Messages
  

SORT Messages

SORT_40046 Mmap <number of bytes> bytes of /dev/zero failed: <error message>. Either increase the swap space or decrease the Cache Size in the Transformation <transformation name>.

Explanation:
The Integration Service could not allocate memory for the Sorter or Lookup transformation because there is not enough available memory.
User Response:
Free memory resources or increase the swap space on the Integration Service system. You can also reduce the cache size to match the amount of available memory.

SORT_40090 There are only <amount of available memory> megabytes of <total memory> available. Either increase the swap space or decrease the Cache Size in the Transformation <transformation name>.

Explanation:
You ran the session on a UNIX Integration Service and the necessary cache size of the specified transformation exceeds the maximum memory allowed for processes that run on the UNIX machine.
User Response:
Increase the memory limit for processes on the UNIX machine.

SORT_40095 File or filesystem <file or file system name> could not be accessed.

Explanation:
The Integration Service could not access the specified file.
User Response:
Verify you have read permission for the specified file.

SORT_40096 Temp file <file name> could not be opened: <error message>.

Explanation:
The Integration Service could not open a temporary file for the Sorter transformation.
User Response:
Verify the user who started the Integration Service has read, write, and execute permissions for the Sorter transformation work directory.

SORT_40102 This sort requires at least <value> MB of memory.

Explanation:
You specified too small a value for the Sorter transformation cache size. The Integration Service cannot perform the sort operation.
User Response:
Increase the Sorter transformation cache size.

SORT_40111 This sort has been cancelled.

Explanation:
The Integration Service cancelled the sort operation.
User Response:
Check preceding messages to see the cause of the error.

SORT_40179 Insufficient space to map <amount of memory> MB of memory: <error message>. Either increase the swap space or decrease the Cache Size in the Transformation <transformation name>.

Explanation:
The Integration Service could not allocate memory for the Sorter or Lookup transformation because there is not enough available memory.
User Response:
Free memory resources or increase the swap space on the Integration Service system. You can also reduce the cache size to match the amount of available memory.

SORT_40189 The sort library could not create a thread.

Explanation:
The Integration Service system does not have enough resources to run the sort operation.
User Response:
Free Integration Service system resources by closing applications. After you free system resources, restart the workflow.

SORT_40304 This operation appears to need <value> MB of memory; excessive paging is possible; continuing.

Explanation:
You specified a Sorter cache size above the minimum required cache size, but the Sorter cache size is small compared to the size of the incoming data. The Integration Service can proceed with the sort operation, but the session will have decreased performance.
User Response:
To increase session performance, increase the Sorter transformation cache size.

SORT_40401 A fatal Sort error has occurred in function <function name>. Errno = <error number>.

Explanation:
Internal error.
User Response:
Contact Informatica Global Customer Support.

SORT_40406 In transformation <transformation name>, an error has occurred <error message>.

Explanation:
The Integration Service encountered an error at the specified Sorter or Lookup transformation.
User Response:
Read the error message displayed in this error message and other messages in the session log for more information.

SORT_40407 In transformation <transformation name> in partition <partition number>, an error has occurred <error message>.

Explanation:
The Integration Service encountered an error when it processed a row in the specified partition and transformation.
User Response:
Read the error message displayed in this error message and other messages in the session log for more information.

SORT_40409 Internal sorter error <error>.

Explanation:
Internal error.
User Response:
Contact Informatica Global Customer Support.

SORT_40414 Error: Total row size <row size> in transformation <transformation name> is more than the allowed maximum [8 MB].

Explanation:
The sum of all port sizes in the specified Sorter or Lookup transformation exceeds 8 MB.
User Response:
Disconnect any port that you do not need in the mapping. Consider redesigning the mapping to reduce the number of ports in the specified transformation. Or, reduce the precision of large string or binary ports.

SORT_40415 Work directory <directory name> does not exist.

Explanation:
The directory name specified for the Sorter transformation work directory does not exist.
User Response:
Verify the Work Directory option in the Sorter transformation properties specifies an existing directory.

SORT_40416 Work directory <directory> does not have read/write/execute permission.

Explanation:
The user who started the Integration Service does not have read, write, and execute permissions on the Sorter transformation work directory.
User Response:
Grant read, write, and execute permissions for the Sorter transformation work directory to the user who starts the Integration Service.

SORT_40424 Error: The memory size <memory size> specified for Sorter Transformation exceeds the 32-bit address space. It cannot be more than <number> on a 32-bit server.

Explanation:
The Sorter transformation cache size is too large.
User Response:
Reduce the Sorter transformation cache size in the session properties.