Troubleshooting Informatica Error Messages and Resolution – Part 190

LDBG_8316 Error. The DTM server ran out of buffer pool data blocks for Partition Point <partition point name> where <transformation name> is the transformation name.
Cause:During a user-defined commit session, the Data Transformation Manager ran out of buffer pool data blocks, which caused the session to fail.
Action:In the session properties, increase the DTM buffer block size.
or
Action:Modify the Transaction Control expression or the Custom transformation procedure code so that the transformation issues commits more frequently.

LDBG_21035Datablock write-lock error. offset <offset value>, reason [No space left on device].
Cause:The Integration Service could not write data to the disk because there is not enough space.
Action:Increase the amount of free space on the Integration Service system disk. Verify that the operating system does not limit the amount of disk space for the user who starts the Integration Service.
or
Cause:This message follows CMN_1107. The Integration Service could not write to a Joiner index or data cache file because there is not enough space on the disk.
Action:Increase the Joiner index and data cache sizes. If possible, increase the index and data cache sizes to hold all of the data.

LDBG_21149ERROR determining truncate table order – could not create constraint load dependencies for target.
Cause:You are attempting to truncate target tables, but the Integration Service is unable to determine dependencies between target tables, possibly due to errors such as circular key relationships.
Action:Ensure the validity of dependencies between target tables.
LDBG_21178ERROR: Self-referential constraint in target.
Cause:You have set the session for constraint-based loading, but the Integration Service is unable to determine dependencies between target tables, possibly due to errors such as circular key relationships.
Action:Ensure the validity of dependencies between target tables.

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 *