Troubleshooting Informatica Error Messages and Resolution – Part 346


SORT_40414Error: Total row size [row size] in transformation [transformation name] is more than the allowed maximum [8 MB].
Cause:The sum of all port sizes in the specified Sorter or Lookup transformation exceeds 8 MB.
Action:Disconnect any port that you do not need in your 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_40415Work directory <directory name> does not exist.
Cause:The directory name specified for the Sorter transformation work directory does not exist.

Action:Verify the Work Directory option in the Sorter transformation properties specifies an existing directory.
SORT_40416Work directory <directory> does not have read/write/execute permission.
Cause:The user who started the Integration Service does not have read, write, and execute permissions on the Sorter transformation work directory.
Action:Grant read, write, and execute permissions for the Sorter transformation work directory to the user who starts the Integration Service.
SORT_40424Error: 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.
Cause:The Sorter transformation cache size is too large.
Action:Reduce the Sorter transformation cache size in the session properties.

SPC_10027Cannot start process for service on node . Process is shutting down. Try again later.
Cause:The service is shutting down. You cannot enable the service until it completely shuts down.
Action:To enable the service, disable the service, and then enable it again.
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.

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 *