Troubleshooting Informatica Error Messages and Resolution – Part 78

SQLServerF1

CMN_1094ERROR: No valid field from the master relation.
Cause:One of the Joiner transformations in the mapping has a master port that is not used in the join condition or the output port.
Action:Make sure to use the master ports as required.
or
Cause:If there are no extraneous input ports connected to the Joiner transformations, you may have repository inconsistencies.
Action:Contact Informatica Technical Support.

CMN_1095ERROR: Field name used in join not found in transform definition.
Cause:The Integration Service could not locate a port specified in the Joiner transformation. You may have repository inconsistencies.
Action:Contact Informatica Technical Support.
CMN_1096ERROR: Operator not supported in the join condition.
Cause:The join condition for a Joiner transformation contains an operator that is not supported. The equal sign (=) is the only operator supported in a Joiner transformation.
Action:Edit the join condition in the session properties, using an equal sign (=) as an operator.
CMN_1097ERROR: No valid output field.
Cause:A Joiner transformation has no output links. Each Joiner transformation needs to have at least one output link.
Action:Make sure each Joiner transformation has at least one linked output port.

CMN_1098ERROR: Cache Directory may not exist or insufficient privilege/space in the supplied cache directory.
Cause:The directory specified for the index and data caches has run out of memory.
Action:Free up disk space in the cache directory.
or
Cause:You do not have the appropriate privileges to access that directory.
Action:Have the system administrator check your file system privileges.

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 *