Troubleshooting Informatica Error Messages and Resolution – Part 298

SQLServerF1

REP_32141In Sequence Generator transformation <transformation name>, the content(s) of field <field name> has been changed. Transformation is not valid.
Cause:You modified the definitions of the NEXTVAL and CURRVAL fields in the Sequence Generator transformation in the XML file.
Action:Do not modify these fields in the XML file. Export the object again and then import it.

REP_32144Error: Missing or invalid attribute <attribute name> for <element name>: <attribute value>.
Cause:In the XML file, you entered an invalid value or no value for the specified attribute in the specified element.
Action:Edit the XML file and define a valid value for the specified attribute. Or, export the object again and then import it.
REP_32148Error: Invalid datatype for mapping variable <MAPPINGVARIABLE name>.
Cause:You entered an invalid value for the DATATYPE attribute in the specified MAPPINGVARIABLE element in the XML file.
Action:Edit the XML file and define a valid value for the DATATYPE attribute in the specified MAPPINGVARIABLE element. Or, export the object again and then import it.

REP_32149Error: Invalid datatype for aggregate COUNT for mapping variable <MAPPINGVARIABLE name>.
Cause:In the XML file, you specified COUNT for the AGGFUNCTION attribute, and you entered an invalid value for the DATATYPE attribute for the specified MAPPINGVARIABLE element.
Action:Edit the XML file and enter either LONG or SHORT for the DATATYPE attribute for the MAPPINGVARIABLE element. Or, export the object again and then import it.
REP_32150Error: Invalid aggregate type for mapping variable <MAPPINGVARIABLE name>.
Cause:In the XML file, you specified NO for the ISPARAM attribute, and you entered an invalid value for the AGGFUNCTION attribute for the specified MAPPINGVARIABLE element.
Action:Edit the XML file and enter COUNT, MIN, or MAX for the AGGFUNCTION attribute for the MAPPINGVARIABLE element. Or, 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.

 

One comment

  • We have an issue in Informatica 9.1.0 Hotfix6 0112 496 (R181 D90) to do with REP_32141 documented above when trying to import a mapping from XML in which we have changed nothing. (Ultimately we do want to make changes but in this case we are demonstrating that the problem exists at the simplest level.)

    REP_32141 is “In Sequence Generator transformation , the content(s) of field has been changed. Transformation is not valid.”

    You state:
    Cause: You modified the definitions of the NEXTVAL and CURRVAL fields in the Sequence Generator transformation in the XML file.
    Action: Do not modify these fields in the XML file. Export the object again and then import it.

    We have changed nothing in the XML; the definitions of the NEXTVAL and CURRVAL are precisely what were exported. The value of attribute “Current Value” is given but that too remains unchanged.

    This is affecting any mapping that refers to a sequence generator (even by a shortcut). I am sure I have imported mappings in other versions of Informatica but have never seen this message before.

     

Leave a Reply

Your email address will not be published. Required fields are marked *