Troubleshooting Informatica Error Messages and Resolution – Part 414

WRT_8020No column marked as primary key for table

Cause:The Integration Service could not locate the primary key for the specified target table, so it could not perform the update operation.
Action:In the Target Designer, specify a primary key in your target table definition, then generate and execute the SQL.
WRT_8023 Error truncating target table . .
Cause:Could not truncate the target table.
Action:Look at the database error string for more information.

WRT_8028 Error forking external loader process for target .
Cause:The external loader process could not be forked.
Action:Look up the error code in errno.h on UNIX or winerror.h on Windows.
WRT_8031 Error unlinking named pipe .
Cause:The Integration Service on UNIX could not unlink a named pipe used for external loading.
Action:Look up the error code in errno.h.

WRT_8032External loader error.
Cause:An error occurred related to the external loader. See additional information logged with this error. Known additional messages:
Error getting [Oracle or Sybase] loader information.
Error executing external loader process.
Error generating control file.
Error opening the control file.
Action:Make sure the loader information is entered correctly.
In Oracle, verify that the loader executable name entered is correct, and that the executable directory is in the path. Make sure the user name, password and connect string are correct.
Make sure all fields contain a value when setting up an external loader connection.
Check the permissions on the directory where the output file is to be generated.

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 *