Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

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

Recommended Posts

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.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...