Explanation: | The Unstructured Data transformation is configured to run a Data Transformation service that is not in the Data Transformation repository. |
User Response: | Publish the service from the Data Transformation Studio. |
Explanation: | The Unstructured Data transformation output type is file, but the Unstructured Data transformation did not receive a file name in the source data. The Unstructured Data transformation receives the output file name in the OutputFileName port. The Integration Service can not create the file without a file name. |
User Response: | Verify that the source data contains a valid output file name. |
Explanation: | The output of the Data Transformation service is larger than the precision of the output port. |
User Response: | Increase the size of the output port. |
Explanation: | The number of row errors reached the allowable limit that is configured in the Stop on Errors session property. The Integration Service counts non-fatal errors that occur in the reader, writer, and transformation threads. |
User Response: | Review the errors in the session log. Correct the source data or change the error threshold limit. |
Explanation: | The Data Transformation Engine is the Data Transformation run-time module that executes Data Transformation services. The Integration Service failed to run the Data Transformation service. |
User Response: | Verify that Data Transformation Engine is installed on the same machine as the Integration Service. |
Explanation: | The Unstructured Data transformation OutputType attribute is not valid. |
User Response: | Open the Unstructured Data transformation UDT Settings tab. Choose file, buffer, or splitting OutputType. |
Explanation: | An error occurred while flushing XML from the output buffer downstream in the pipeline. |
User Response: | Check system resources and review session log for other errors. |
Explanation: | The Unstructured Data transformation must have only one OutputBuffer port. |
User Response: | The Designer does not allow you to delete OutputBuffer ports. Recreate the transformation or export the transformation, edit the .XML file, and re-import the definition to the repository. |
Explanation: | The Unstructured Data transformation must have only one InputBuffer port. |
User Response: | The Designer does not allow you to delete an InputBuffer port. Recreate the transformation or export the transformation, edit the .XML file, and re-import the definition to the repository. |
Explanation: | The Unstructured Data transformation is configured for file output. When the output type is file, the Unstructured Data transformation receives the source file in the InputBufferPort and the output file name in the OutputFileName port. One of the default input ports is missing or one of the ports is a duplicate. |
User Response: | The Designer creates the default input ports. You cannot delete or add them. You can change the output type to update the default ports or recreate the transformation. |
Explanation: | The Unstructured Data Option does not have valid license key to run in PowerCenter. |
User Response: | View license details using the Administrator tool or the infacmd ShowLicense command. Contact Informatica Global Customer Support to obtain a new incremental license key for the Unstructured Data Option. |
Explanation: | The Unstructured Data transformation failed to write data to the OutputBuffer port. |
User Response: | Review the session log for related messages. |
Explanation: | The Data Transformation Engine cannot open a source file because the file is missing or the file location is invalid. |
User Response: | The Unstructured Data transformation is passing a file name and path from the InputBuffer port to the Data Transformation Engine. Verify the file name and location are valid in the source data. |
Explanation: | The API function to execute a Data Transformation streamer service failed. |
User Response: | Review the status code to determine the error. |
Explanation: | The API function to execute a Data Transformation streamer service failed. |
User Response: | Review the status code to determine the error. |
Explanation: | The API function to get the next Data Transformation streamer message failed. |
User Response: | Review the status code to determine the error. |
Explanation: | The Data Transformation service is returning data to ports that you defined on the Relational Hierarchy tab of the Unstructured Data transformation. A port is missing from one of the groups on the tab. |
User Response: | When you define hierarchical output groups in the Unstructured Data transformation, you must define the same structure in the Data Transformation project. To change the Data Transformation project, export the group hierarchy schema file from the Unstructured Data transformation. Import the schema to the Data Transformation project and recreate the project. |
Explanation: | The Data Transformation service is returning data to groups of ports that you defined on the Relational Hierarchy tab of the Unstructured Data transformation. A group is missing from the Unstructured Data transformation. |
User Response: | When you define hierarchical output groups in the Unstructured Data transformation, you must define the same structure in the Data Transformation project. To change the Data Transformation project, export the group hierarchy schema file from the Unstructured Data transformation. Import the schema to the Data Transformation project and recreate the project. |
Explanation: | The Data Transformation service failed because the schema that describes the output group hierarchy is no longer a valid schema. |
User Response: | Verify that the schema you referenced when you created the Data Transformation service has not changed in the Data Transformation projects folder. You can recreate the schema in the Unstructured Data transformation Group Hierarchy tab. Export the schema to the Data Transformation Studio. |
Explanation: | The Data Transformation Engine could not run a service from the Data Transformation repository. |
User Response: | Verify that the service name in the Unstructured Data transformation references a valid service name in the Data Transformation repository. |
Explanation: | The Data Transformation service returned a status code that is not recognized by the Unstructured Data transformation. The status code should be between 1 and 5. |
User Response: | You can view the Data Transformation event log when a failure occurs in a Data Transformation service. By default, the Engine stores the log in the following location: C:\Documents and Settings\<USER>\Application Data\Informatica\DataTransformation\CMReports. |
Explanation: | The Unstructured Data transformation input port is not connected to a source in the mapping. The mapping is invalid because the transformation is not receiving source data. |
User Response: | Connect the Unstructured Data transformation input port to a source in the mapping. |
Explanation: | The Data Transformation service cannot run because the service name is not in the Data Transformation repository or the Data Transformation Engine is not running on the machine where the PowerCenter Client is installed. |
User Response: | Verify that the Data Transformation service is in the ServiceDB folder of the Data Transformation installation and the Data Transformation server component is installed on the PowerCenter Client machine. |
Explanation: | The Service Name attribute is blank in the Unstructured Data transformation. The Service Name attribute contains the name of the Data Transformation service to run. The service name cannot be blank unless you enable dynamic service names. |
User Response: | Enter a valid Data Transformation service on the UDT Settings tab of the Unstructured Data transformation. The service must be present in the Data Transformation repository. |