Skip to main content
Solved

Read Multiple Values Projection Delegate

  • September 6, 2024
  • 6 replies
  • 132 views

Forum|alt.badge.img+10

We are unable to retrived all customers using BPA projection delegate

I have recreated the issue with simple workflow 

 

The Get Clients is a Projection Delegate from CustomersHandling.CustomerInfoSet with no filters.

All clients should be recovered.

 

When inspecting i encouter the following error : 

 

Red Eye : 

Black eye : 

Any idea please?

 

Best answer by IFSRUNINNOVAL

@dsj 

There is a restriction to prevent high volume of data being loaded and causing issues in workflows.

This restriction is based on the projection task and the global workflow.

The Number of rows in the collection should be <10000, and the sum of the character length of the response should be < 2097152

 

There is no plan to alter this limits. It is there to avoid unexpected situations arising because of high volume of data. It is there by design.

 

 

6 replies

Forum|alt.badge.img+10
  • Author
  • Hero (Customer)
  • 122 replies
  • September 6, 2024

@dsj  @Lahirumala de Mel  was wondering if you have any thought on the matter please 


dsj
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • 905 replies
  • September 9, 2024

Hi @IFSRUNINNOVAL 

 

I guess the null value is due to workflow IFS API call receives more values than it can handle in the response. Add some search conditions to limit the result set and se if it works :)

 

Cheers!

Damith


Forum|alt.badge.img+10
  • Author
  • Hero (Customer)
  • 122 replies
  • September 11, 2024

thank’s.

Even by adding some filters the collection still huge.

IFS is currenlty looking into it.


Forum|alt.badge.img+10
  • Author
  • Hero (Customer)
  • 122 replies
  • Answer
  • September 13, 2024

@dsj 

There is a restriction to prevent high volume of data being loaded and causing issues in workflows.

This restriction is based on the projection task and the global workflow.

The Number of rows in the collection should be <10000, and the sum of the character length of the response should be < 2097152

 

There is no plan to alter this limits. It is there to avoid unexpected situations arising because of high volume of data. It is there by design.

 

 


dsj
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • 905 replies
  • September 13, 2024

@dsj

There is a restriction to prevent high volume of data being loaded and causing issues in workflows.

This restriction is based on the projection task and the global workflow.

The Number of rows in the collection should be <10000, and the sum of the character length of the response should be < 2097152

 

There is no plan to alter this limits. It is there to avoid unexpected situations arising because of high volume of data. It is there by design.

 

 

@IFSRUNINNOVAL Thanks for sharing that. I didn’t knew the exact limits but I also had been ran into the same error due to large data load. Would be nice if IFS can give a proper error message when the result lime is exceeded.


Forum|alt.badge.img+10
  • Author
  • Hero (Customer)
  • 122 replies
  • September 16, 2024

R&D identified showing null is a defect and they will fix this in next releases.