When you parameterize the lookup expression for an unconnected Lookup transformation in a mapping in SQL ELT mode, and the expression passes an integer or decimal value, the mapping task displays a validation error saying that the argument data types aren't valid.

When you use an intelligent structure model based on a Cobol copybook in a Structure Parser transformation, the output file is invalid if the transformation processes file types other than binary files.

If you change the name or data type of an element in an intelligent structure model, the order of the elements in the output groups changes.

When you run a mapping in

Data Integration

when an Oracle database source includes the BLOB data type, the following error appears:

Failed to create the following transformation: 'AccessPolicy' (500 : [no body])

When you import assets in

Data Integration

, schedules aren't displayed in the

Import Assets

dialog box. However, the schedules are imported when you click

Import

.

The

My Jobs

page in

Data Integration

and the

All Jobs

and

Running Jobs

pages in

Monitor

display the taskflow start time and end time values based on the time zone setting in the user profile. However, when you open a taskflow instance, the values in the

Start time

and

End time

fields appear in Coordinated Universal Time (UTC) regardless of the time zone setting in the user profile.

When you run a mapping task based on a mapping in SQL ELT mode, and the mapping contains a field with the same name as a Snowflake function or data type, the mapping task fails with a parsing error like the following error:

ERROR [<<PM Parse Error>> invalid token&#xa;... &#x24;<<<<ATE] WARNING [] 

User-defined functions with the same name as a built-in function will cause a mapping in advanced mode to fail when that function is used in an expression.

If you enable CLAIRE-powered runtime strategies in a

mapping

task, you can't edit the SQL ELT optimization properties on the

Runtime Options

page if CLAIRE recommendations or the FinOps license is disabled in your organization.

If you override the source, target, or lookup connection in a taskflow that includes a mapping task that is based on a mapping in SQL ELT mode, the task fails when you run the taskflow.

When you create a mapping in SQL ELT mode that contains an Expression transformation with nested variable fields and you declare the variables in the wrong order, the mapping task fails at runtime with a mapping compilation error. For example, the mapping task fails if the Expression transformation contains variable field V1 followed by field V2, but V1 uses V2 in its expression.