Expected a sequence with more than 1 item this error is generated when a count function is applied on a non repeated item/element in BWCE 2.6.2

[sushma v]

When migrating code from BW 5.xto BWCE 2.6.2 the below issue/error occured.

A single non repeated sequence of structure is received from Assign activity to JDBC update activity.

When a count() function is applied on an item/element to check its existence/occurance, an error is generated stating "Expected a sequence with more than 1 item".

The same code did not generate any error in BW 5.xbut is generated in BWCE 2.6.2

Could you please let me know about workarounds and alternatives on how to manage the scenario

Attached the example to show when the error is generated.

[Emmanuel Marchiset 2]

The error message you are seeing is just a design time validation warning (the code will work at runtime).

If you want to remove it you can replace the 'count()' function by the 'exists()' function.