Troubleshooting Informatica Error Messages and Resolution – Part 344

SQLServerF1

SORT_40046Mmap <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].
Cause:The Integration Service could not allocate memory for the Sorter or Lookup transformation because there is not enough available memory.
Action: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_40090There 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].
Cause: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.
Action:Increase the memory limit for processes on the UNIX machine.
or
Same as SORT_40046.
SORT_40095File or filesystem <file or file system name> could not be accessed.
Cause:The Integration Service could not access the specified file.
Action:Verify you have read permission for the specified file.

SORT_40096Temp file <file name> could not be opened: <error message>.
Cause:The Integration Service could not open a temporary file for the Sorter transformation.
Action:Verify the user who started the Integration Service has read, write, and execute permissions for the Sorter transformation work directory.
SORT_40102This sort requires at least <value> MB of memory.
Cause:You specified too small a value for the Sorter transformation cache size. The Integration Service cannot perform the sort operation.
Action:Increase the Sorter transformation cache size.
SORT_40111This sort has been cancelled.
Cause:The Integration Service cancelled the sort operation.
Action:Check preceding messages to see the cause of the error.

Above are list of Informatica Error Messages or Warnings received while performing certain operation against Informatica related products.

What are Informatica Error Messages?

Informatica error codes are a set of error codes for use by all Informatica products. Every Informatica error message returned by Informatica, is self explanatory and contains the object name in cases where required.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Informatica Error Code Messages or Warning Messages on Windows and Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *