Troubleshooting Informatica Error Messages and Resolution – Part 303

SQLServerF1_Header_Small

REP_32203Error: the number of partition <PARTITION name> is out of range [1-32] for session transformation <SESSTRANSFORMATIONINST name> in session <session name>.
Cause:The number of PARTITIONs under SESSTRANSFORMATIONINST is invalid.
Action:Remove, as appropriate, the PARTITIONs from under the SESSTRANSFORMATIONINST so that the number of PARTITIONs is less than or equal to 32.
REP_32204 Error: building session <session name>.
Cause:The SESSION element or some of its sub-elements are invalid.
Action:View the Output window for more information. Export the object again and then import it.

REP_32205Error: Invalid DSQ <Source Qualifier transformation> of type <DSQINSTTYPE> for the extension in session transformation instance <SESSTRANSFORMATIONINST name>.
Cause:In the XML file, you specified a DSQINSTNAME and DSQINSTTYPE attribute in a SESSIONEXTENSION element that references a non-existent SESSTRANSFORMATIONINST element or a SESSTRANSFORMATIONINST element that does not match the name and type specified in the SESSIONEXTENSION element.
Action:Edit the XML file, and verify the DSQINSTNAME and DSQINSTTYPE attributes match the SESSTRANSFORMATIONINST element name and type. Or, export the object again and then import it.
REP_32207Error: Invalid datatype for workflow variable <workflow variable name>
Cause:In the XML file, you specified an invalid DATATYPE attribute for the WORKFLOWVARIABLE element.
Action:Edit the XML file, and specify a valid DATATYPE attribute for the WORKFLOWVARIABLE element. Or, export the object again and then import it.

REP_32208Error: The extension of type <SESSIONEXTENSION type> and subtype <SESSIONEXTENSION subtype> does not exist for session transformation instance <SESSTRANSFORMATIONINST name>.
Cause:In the XML file, the TYPE and SUBTYPE attributes for the SESSIONEXTENSION element are not supported for the SESSTRANSFORMATIONINST element.
Action:Edit the XML file, and specify TYPE and SUBTYPE attributes in the SESSIONEXTENSION element that the SESSTRANSFORMATIONINST element supports.

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 *