Troubleshooting Informatica Error Messages and Resolution – Part 191


LDBG_21409Target [target name] Warning: Primary key table for Foreign key [foreign key port name] is not from the same active source or transaction generator. This constraint will not be enforced; as a result, the session may hang because of potential deadlock.
Cause:The mapping writes to target tables that have a primary key-foreign key relationship, but the targets receive data from different transaction generators, such as a Transaction Control transformation, or active sources. The Integration Service cannot enforce the primary key-foreign key relationship. The session might hang depending on the source data.
Action:If the session hangs, design the mapping to enforce constraint-based loading. Or, remove the primary key-foreign key relationship between the targets in the target database.
LDBG_21604Data block read-lock error, offset <number>, reason: <reason>.
Cause:Error occurred trying to read from the joiner cache.
Action:Truncate the targets and run the session again.

LDBG_21605Cannot open files in the directory <directory name>.
Cause:Cannot open files in the joiner cache directory.
Action:Check file system permission and free space in the cache directory.
LDBG_21633For the dynamic lookup cache for [Lookup transformation], an input row has NULL value in condition fields. This row will not be used for update of the lookup cache.
Cause:The Lookup transformation in the mapping uses a dynamic lookup cache, and the source row contains a null value in a column used in the lookup condition.
Action:None. When the row exists in the lookup cache, the Integration Service does not update the row in the cache or target table.

LDBG_21668Error: The Informatica server license does not allow more than one database license to be used at a time.
Cause:The Integration Service configuration contains more than one database license.
Action:Your Informatica license does not allow you to use more than one database license at a time. Configure the Integration Service with only one database license. For more information, contact the Informatica Developer Network.

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 *