Explanation: | In an external procedure, the Integration Service cannot convert the datatype of the port to the datatype of the corresponding parameter, or vice versa. For example, the port may have a Date/Time datatype, while the parameter has an Integer datatype. The Integration Service cannot convert a Date/Time datatype to an Integer datatype. |
User Response: | Either change the external procedure datatype or the port datatype before running the session again. |
Explanation: | The Integration Service encountered an error while closing a DLL or shared object. |
User Response: | This error does not adversely affect the session run. If the message recurs, however, contact Informatica Global Customer Support. |
Explanation: | The Integration Service cannot initialize the external procedure. |
User Response: | This is a general error message. Check the session log for related error messages. |
Explanation: | The Integration Service cannot initialize the external procedure. |
User Response: | This is a general error message. Check the session log for related error messages. |
Explanation: | The Integration Service cannot initialize the external procedure. |
User Response: | This is a general error message. Check the session log for related error messages. |
Explanation: | The entry for the Module/Programmatic Identifier property for the External Procedure transformation is empty. |
User Response: | Enter a valid entry for the Module/Programmatic Identifier property. |
Explanation: | The Integration Service cannot create the External Module Manager. |
User Response: | This is a general message. Check the session log for related error messages. |
Explanation: | The Integration Service cannot locate the DLL or considers the DLL invalid. |
User Response: | Verify the name, the location of the DLL, and the Module/Programmatic Identifier property before running the session again. |
Explanation: | The class factory function CreateExternalModuleObject failed to create an external module object in the Informatica external module. |
User Response: | Examine the CreateExternalModuleObject function and the constructor for the external module object called within it. |
Explanation: | You did not enter the procedure name in the External Procedure transformation. |
User Response: | Enter a valid name for the procedure. |
Explanation: | A call to the TINFExternal Module Impl::GetProcSignature function failed. |
User Response: | Examine this function in the file infemimp.cpp. Also, make sure that the INFEMProcSignatures and the p*ParamVector data structures in the module_nameEM.CPP file have not been altered. |
Explanation: | The Integration Service cannot match the number of ports in an External Procedure transformation with the number of formal arguments in the external procedure. |
User Response: | Correct either the number of arguments in the external procedure or the number of ports in the External Procedure transformation before running the session again. |
Explanation: | Internal error. |
User Response: | Contact Informatica Global Customer Support. |
Explanation: | Internal error. |
User Response: | Contact Informatica Global Customer Support. |
Explanation: | The external procedure has a return value, but the External Procedure transformation does not. |
User Response: | Either add a return value to the External Procedure transformation or remove it from the external procedure code. |
Explanation: | The External Procedure transformation has a return value, but the external procedure does not. |
User Response: | Either add a return value to the external procedure code or remove it from the External Procedure transformation. |
Explanation: | The external procedure code has a return value, but it is not the last parameter. |
User Response: | Make sure the return value of the external procedure code is the last parameter. |
Explanation: | The External Procedure transformation has a return value, but it is not the last port. |
User Response: | Make sure the return value of the External Procedure transformation is the last port. |
Explanation: | An External Procedure transformation port name does not match the corresponding external procedure argument. |
User Response: | Change the external procedure argument or the External Procedure transformation port name before running the session again. |
Explanation: | Internal error. |
User Response: | Contact Informatica Global Customer Support. |
Explanation: | Internal error. |
User Response: | Contact Informatica Global Customer Support. |
Explanation: | The Integration Service encountered an error converting decimal numbers on input to or output from an external procedure. |
User Response: | Evaluate the external procedure to see if the Decimal datatype is necessary. If possible, change the Decimal datatype to Double. |
Explanation: | Internal error. |
User Response: | Send the external procedure to Informatica Global Customer Support with a description of the error. |
Explanation: | The Integration Service encountered a serious exception while running the external procedure. |
User Response: | Debug the external procedure code before running the session again. |
Explanation: | The Integration Service encountered an error initializing a COM-style external procedure. |
User Response: | This is a general error. Check the session log for related error messages. |
Explanation: | Internal error. |
User Response: | Contact Informatica Global Customer Support. |
Explanation: | Internal error. |
User Response: | Contact Informatica Global Customer Support. |
Explanation: | Internal error. |
User Response: | Contact Informatica Global Customer Support. |
Explanation: | Internal error. |
User Response: | Contact Informatica Global Customer Support. |
Explanation: | The Integration Service encountered an error initializing an external procedure. |
User Response: | This is a general error. Check the session log for related error messages. |
Explanation: | The Integration Service encountered an error creating buffers. |
User Response: | This is a general error. Check the session log for related error messages. |
Explanation: | The Integration Service found an invalid programmatic identifier in the registry. |
User Response: | Correct the programmatic identifier key in the registry. The key must appear in a two-dot format, such as abc.def. For more information, see the COM documentation. |
Explanation: | The Integration Service cannot match the programmatic identifier module with its corresponding key in the registry. |
User Response: | Either change and compile the module or register the COM.dll in the registry. For more information, see the COM documentation. |
Explanation: | In the registry, the programmatic ID does not map to the CLSID. |
User Response: | Check the programmatic ID in the registry. For more information, see the COM documentation. |
Explanation: | Internal error. |
User Response: | Contact Informatica Global Customer Support. |
Explanation: | The Integration Service call to the CoCreateInstance file failed. |
User Response: | Check the CoCreateInstance documentation for appropriate action. |
Explanation: | The Integration Service encountered an error accessing a COM type library. |
User Response: | Contact Informatica Global Customer Support. |
Explanation: | The Integration Service encountered a major exception in a COM-style external procedure. |
User Response: | Debug the external procedure code. |
Explanation: | The Integration Service could not find the named key in the registry. |
User Response: | In the registry, enter a valid library ID. For more information, see the COM documentation. |
Explanation: | The named key has a registry location, but that location is empty. |
User Response: | Enter a valid key at that location. For more information, see the COM documentation. |
Explanation: | Internal error. |
User Response: | Contact Informatica Global Customer Support. |
Explanation: | The Integration Service could not find the named key in the registry. |
User Response: | In the registry, enter a valid library ID. For more information, see the COM documentation. |
Explanation: | The Integration Service could not open the named key because it is invalid or not at that location. |
User Response: | In the registry, make sure the named key exists at the right location and is a valid key. For more information, see the COM documentation. |
Explanation: | The Integration Service cannot load the type library because it is not there or because the file is invalid. |
User Response: | In the registry, make sure the type library is valid and in the correct location. For more information, see the COM documentation. |
Explanation: | The Integration Service encountered an error accessing a COM type library. |
User Response: | Contact Informatica Global Customer Support. |
Explanation: | The Integration Service could not open the named key because it is invalid or not at that location. |
User Response: | In the registry, make sure the named key exists at the right location and is a valid key. For more information, see the COM documentation. |
Explanation: | The named key has a registry location, but that location is empty. |
User Response: | Enter a valid key at that location. For more information, see the COM documentation. |
Explanation: | The Integration Service encountered an error accessing a COM type library. |
User Response: | Contact Informatica Global Customer Support. |
Explanation: | The Integration Service encountered an error accessing a COM type library. |
User Response: | Contact Informatica Global Customer Support. |
Explanation: | The Integration Service encountered an error accessing a COM type library. |
User Response: | Contact Informatica Global Customer Support. |
Explanation: | The Integration Service encountered an error accessing a COM type library. |
User Response: | Contact Informatica Global Customer Support. |
Explanation: | The Integration Service encountered an error accessing a COM type library. |
User Response: | Contact Informatica Global Customer Support. |
Explanation: | The Integration Service encountered an error accessing a COM type library. |
User Response: | Contact Informatica Global Customer Support. |
Explanation: | The Integration Service encountered an error accessing a COM type library. |
User Response: | Contact Informatica Global Customer Support. |
Explanation: | The Integration Service encountered an error accessing a COM type library. |
User Response: | Contact Informatica Global Customer Support. |
Explanation: | The Integration Service encountered an error accessing a COM type library. |
User Response: | Contact Informatica Global Customer Support. |
Explanation: | A COM external procedure did not allocate memory for a B-String in a COM-style procedure. |
User Response: | Allocate more memory for the B-String. |
Explanation: | The Integration Service encountered an error converting between a COM and Informatica datatype. Either the external procedure attempted an invalid conversion, or a data overflow occurred. |
User Response: | Check the session log for messages related to data overflow or invalid datatype conversions. If data overflowed, change the external procedure or mapping to accommodate the data. Otherwise, make sure the external procedure uses valid datatype conversions. |
Explanation: | The Integration Service encountered an error converting between a COM and Informatica datatype. Either the external procedure attempted an invalid conversion, or a data overflow occurred. |
User Response: | Check the session log for messages related to data overflow or invalid datatype conversions. If data overflowed, change the external procedure or mapping to accommodate the data. Otherwise, make sure the external procedure uses valid datatype conversions. |
Explanation: | The external procedure uses a COM datatype that is not supported. |
User Response: | Check the supported COM datatypes and make the appropriate changes to the external procedure. |
Explanation: | The Integration Service call to CoInitialize failed. |
User Response: | Check the CoInitialize documentation for appropriate action. |
Explanation: | You tried to run a COM external procedure on a UNIX server. COM-style external procedures only run on Windows platforms. |
User Response: | If possible, move the session to a Windows server before running the session again. Otherwise, create an Informatica style external procedure to replace the COM-style procedure. |
Explanation: | Internal error. |
User Response: | Contact Informatica Global Customer Support. |
Explanation: | The Integration Service encountered a parameter with an invalid datatype in the Informatica-style external procedure. |
User Response: | Change the datatype to a supported type before running the session again. |
Explanation: | This message appears when the external procedure creates a log message. |
User Response: | If necessary, examine the external procedure for the cause of the message. |
Explanation: | A session configured with an external procedure has encountered an error. |
User Response: | Examine the external procedure for the cause of the message. |
Explanation: | The Integration Service encountered an external procedure that is not supported. |
User Response: | Do not use unsupported external procedure modules. |
Explanation: | The Init or InitParams method in the specified external procedure returned a fatal error. |
User Response: | Check the code for the Init or InitParams method in the specified external procedure and correct the fatal error. Read the session log for related messages logged by the external procedure. |
Explanation: | The Integration Service cannot convert a String port from the External Procedure transformation to a Date/Time input port in the external procedure. The string is not in the default date format (MM/DD/YYYY HH24:MI:SS). |
User Response: | Use TO_DATE with the appropriate format string to convert a string to a date. |
Explanation: | The Integration Service cannot convert data from an external procedure Date/Time output port to a String port in the External Procedure transformation. |
User Response: | Change the External Procedure transformation port to Date/Time. |
Explanation: | In the initialization properties for the External Procedure transformation, you specified a parameter that the Integration Service cannot convert to the COM datatype for the constructor in the external procedure. Before the Integration Service calls the constructor in the external procedure, it tries to convert the initialization parameters in the External Procedure transformation to the required COM datatypes. |
User Response: | Edit the parameters in the Initialization Properties tab of the External Procedure transformation. Enter values that the Integration Service can convert to the required COM datatypes for the constructor. |
Explanation: | The specified external procedure returned a fatal error. |
User Response: | Check the code for the specified external procedure and correct the fatal error. Read the session log for related messages logged by the external procedure. |
Explanation: | The Init or InitParams method in the specified external procedure returned a fatal error. |
User Response: | Check the code for the Init or InitParams method in the specified external procedure and correct the fatal error. Read the session log for related messages logged by the external procedure. |
Explanation: | The Custom transformation procedure code uses the INFA_CTSetPassThruPort() function when the transformation scope is transaction or all input and the data access mode is row-based. |
User Response: | Change the transformation scope to row. |
Explanation: | The procedure code for an active Custom transformation uses the INFA_CTSetPassThruPort() function and the data access mode is array-based. |
User Response: | Edit the procedure code and use the array-based mode data handling functions to set the data for all output ports. Do not use the INFA_CTSetPassThruPort() function. |
Explanation: | The Custom transformation procedure code uses the INFA_CTSetRowStrategy() function to define the default row strategy to pass through when the transformation scope is transaction or all input and the data access mode is row-based. |
User Response: | Change the transformation scope to row. |
Explanation: | The procedure code for an active Custom transformation uses the INFA_CTSetRowStrategy() function to define the default row strategy to pass through and the data access mode is array-based. |
User Response: | Edit the procedure code and use the INFA_CTASetRowStrategy() function to define the default row strategy to pass through. |
Explanation: | The Custom transformation procedure code uses the INFA_CTASetInputErrorRowM() or INFA_CTASetInputErrorRowU() function and the data access mode is row-based. |
User Response: | Edit the procedure code and remove the INFA_CTASetInputErrorRowM() or INFA_CTASetInputErrorRowU() function. Instead, you can return INFA_ROWERROR in the input row notification function to notify the Integration Service that a particular input row has an error. |
Explanation: | The Custom transformation procedure code uses the INFA_CTGetRowStrategy() function inside a function other than the p_<proc_name>_inputRowNotification() function. |
User Response: | Edit the procedure code and only use the INFA_CTGetRowStrategy() function inside the p_<proc_name>_inputRowNotification() function. |
Explanation: | The Custom transformation procedure code uses the INFA_CTGetRowStrategy() function when the data access mode is array-based. |
User Response: | Edit the procedure code and use the INFA_CTAGetRowStrategy() function to get the default row strategy. |
Explanation: | The Custom transformation procedure code uses the INFA_CTOutputNotification() function inside a function other than the p_<proc_name>_inputRowNotification() function when the transformation scope is row. |
User Response: | Change the transformation scope to transaction or all input. |
Explanation: | The Custom transformation procedure code uses the INFA_CTASetNumRowsInBlock() function to set the number of rows in a block. However, the number of rows is invalid. |
User Response: | Edit the procedure code and verify the value for the nRows argument in the INFA_CTASetNumRowsInBlock() function is greater than 0 and less than or equal to the value returned by the INFA_CTAGetOutputRowMax() function. |
Explanation: | The Custom transformation procedure code contains the INFA_CTASetOutputNumRowMax() function in a notification function. |
User Response: | Edit the procedure code and only use the INFA_CTASetOutputNumRowMax() function in an initialization function. |
Explanation: | The Custom transformation procedure code uses the INFA_CTASetOutputNumRowMax() function, but the nRowsMax argument is an invalid number. |
User Response: | Edit the procedure code and verify nRowsMax is a positive number. |
Explanation: | A transformation downstream from a Custom transformation encountered a fatal error. |
User Response: | Read the session log for other error messages. |