Troubleshooting Informatica Error Messages and Resolution – Part 297

SQLServerF1

REP_32136Error: Invalid scale: specified for field: . The scale cannot be greater than the precision or the maximum scale which is 65535.
Cause:You defined the scale for a field in the XML file with an invalid number. The scale is either greater than the corresponding precision or greater than the maximum scale allowed, which is 65,535.
Action:Edit the XML file and make sure the scale for the field is less than or equal to the precision for the field.

REP_32137The first field of lookup transformation has to be a Dynamic Lookup field when dynamic lookup cache is enabled. Transformation is not valid.
Cause:In the XML file, you defined the dynamic lookup cache attribute to YES, but you did not define the first lookup port as NewLookupRow.
Action:When the dynamic lookup cache attribute is set to YES, the first field has to be NewLookupRow. Edit the XML file, or export the object again and then import it.
REP_32138Field for lookup transformation cannot be a Dynamic Lookup field when dynamic lookup cache is disabled. Transformation is not valid.
Cause:In the XML file, you defined a lookup port as NewLookupRow, but you defined the dynamic lookup cache as NO.
Action:You cannot have the NewLookupRow when the dynamic lookup cache attribute is set to NO. Edit the XML file, or export the object again and then import it.

REP_32139In Lookup transformation , the content(s) of the generated Dynamic Lookup field has been changed. Transformation is not valid.
Cause:You modified the definition of the NewLookupRow port in the XML file.
Action:Do not change the NewLookupRow port in the XML file. Export the object again and then import it.
REP_32140In Rank transformation , the content(s) of the RANKINDEX field has been changed. Transformation is not valid.
Cause:You modified the contents of the RANKINDEX field in the Rank transformation in the XML file.
Action:Do not modify the RANKINDEX field in the XML file. Export the object again and then import it.

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 *