Cloud Data Integration Connectors All Products
The CDC for mainframe and midrange connectors do not support data preview. Attempting to preview the data for a CDC connection can cause errors.
Workaround: Do not attempt to preview data for the CDC for mainframe and midrange connectors.
An attempt to create a mapping fails if the PowerExchange Listener does not respond within 30 seconds of the request.
Workaround: Verify that the PowerExchange Listener for the connection is running and attempt the connection again.
If you import a mapping task and change a non-CDC connection to a CDC connection, the CDC runtime properties are missing from the imported information.
Workaround: Edit the imported mapping task to reset the properties on the
If you create a mapping that maps a CDC source field to an Oracle target column that has the data type of RAW and select Data Driven as the target operation type, the Datatype Transformation Manager (DTM) process ends with a fatal error. Also any associated mapping tasks will end.
Workaround: Do not map CDC source columns to Oracle target RAW columns.
If you try to test a CDC connection that has no value in the
Connection Retry Periodor
Pacing Sizeproperty, the test fails with an error message that reports an empty input string. If you try to run a mapping task that uses a CDC connection with one of these properties empty, the mapping task also fails.
Workaround: When you define or edit the CDC connection, accept the default value of 0 or enter a positive number in the
Connection Retry Periodand
If you add a Lookup transformation to a mapping, you can select a CDC connection for the lookup object even though CDC connections are not valid for lookup objects.
Workaround: Do not select a CDC connection when you define a Lookup transformation in a mapping.
If a mapping includes source tables or columns that have special characters in their names, the associated mapping task will fail because it cannot import the source metadata. Special characters include s #, $, @, %, *, !, and ~.
Workaround: Ensure that none of the source tables and mapped columns have names with any special character. Rename the tables and columns if necessary.
If you use a parameter for a source connection in a mapping and try to edit the metadata field
Native Scaleon the
Fieldstab of the source properties, the native type value is cleared and you cannot enter another value.
Workaround: Do not try to edit any "native" metadata field if you specified a parameter for the source connection in the mapping. If you accidentally click one of these fields and the native type value disappears, you can reinstate the original type value by clicking another tab under source properties or refreshing the page.
If you create a mapping that contains multiple sources and that specifies a parameter for a source connection, you must enter a specific source connection for the mapping task. For this connection, you can enter
SQL Query Overrideadvanced properties. However, these advanced properties will be used only for the first source in the mapping.
Workaround: In the mapping, define a connection parameter for each source. On the
Sourcespage of the mapping task wizard, select the same specific connection for each source. Then click
Advancednext to each connection to define the
SQL Query Overrideattributes. The advanced attributes will then be used for every source.
Filter Overridesadvanced property for a source, if you define a filter condition that uses a CHAR or VARCHAR2 column with the equals (=) operator, the comparison fails when the columns are wider than 255 characters.
Workaround: Do not filter on CHAR or VARCHAR2 columns wider than 255 characters or use another type of operator in the filter condition.
If you enter a SQL statement that includes a line feed in the
SQL Query Overridesource property in a mapping and run the associated mapping task, data is not written to the target. The error message indicates that the error is related to the SQL statement but does not describe the problem.
Workaround: Ensure that the SQL statement that you enter in the
SQL Query Overrideproperty does not include a line feed. You can use a space instead.