Troubleshooting Informatica Error Messages and Resolution – Part 396

SQLServerF1

TT_11122Error: The index cache size [index cache size] specified for transformation [transformation name] exceeds the 32-bit address space. It cannot be more than [number] on a 32-bit server.
Cause:The index cache size is too large.
Action:Reduce the index cache size for the specified transformation in the session properties.

TT_11123Error: The data cache size [data cache size] specified for transformation [transformation name] exceeds the 32-bit address space. It cannot be more than [number] on a 32-bit server.
Cause:The data cache size is too large.
Action:Reduce the data cache size for the specified transformation in the session properties.
TT_11124 Warning: The number of rows output by a group of the DSQ <Source Qualifier Name> has exceeded the limit of <number of rows specified in the IDN license> rows. This restriction is imposed due to server license being used. No more rows will be processed on this group of the DSQ, waiting for the read to finish…
Cause:The IDN license restricts the number of rows you can process in a group.
Action:Decrease the number of rows in the group or obtain a different license from Informatica.

TT_11134 Error: The lookup cache file with the named prefix <prefix name> used by Lookup <Lookup transformation name> cannot be reused.
Cause:You attempted to use a persistent lookup cache that was incompatible with the Lookup transformation, and the Integration Service does not delete the lookup cache files when you use a named prefix. The lookup cache files may be unusable for several reasons:
−You modified Lookup transformation attributes. If you change an attribute in a Lookup transformation, the persistent cache may become incompatible with the Lookup transformation. For example, if you change a database connection, the lookup cache may become unusable.
−More than one session uses the same lookup cache name. If more than one session uses the same lookup cache name, the lookup cache may be incompatible with a Lookup transformation in one of the sessions. For example, two sessions share the same lookup cache. If you modify the attributes for a Lookup transformation in one session, but do not modify the Lookup transformation in the second session, the lookup cache becomes unusable for the second session.
−You upgraded the Integration Service. The format for information in the Lookup transformation in the new version of the Integration Service is incompatible with the format of information in the cache file that was created by an earlier version of the Integration Service.
Action:Fix the incompatibility by changing the Lookup transformation attributes.
or
Action:Remove the existing lookup cache files. You must remove both the .idx and .dat files. This allows the Integration Service to create a new lookup cache.

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 *