There is a process which is used for exporting data to excel as shown below:
the process is breaking at script task where we are calling rule rule!QueryandCovertToExportableCDT(pv!id)
error- An error occurred while evaluating expression: rule!QueryandCovertToExportableCDT(pv!id) (Expression evaluation error in rule 'QueryandCovertToExportableCDT' at function a!queryEntity [line 2]: An error occurred while retrieving the data. Details: Unexpected error executing query (type: [ExportableCDT], query: [queryentity expression], order by: [[Sort[id asc]]], filters:[(id in TypedValue[it=101,v={1,2,3...2800}])])) (Data Outputs)
Investigation - As per my investigation it is failing in the the expression rule QueryandCovertToExportableCDT while passing rule input "id" which is of integer type array as it is not accepting more then 4000 character.
Can anyone help me with some input in order to resolve this issue.
Discussion posts and replies are publicly visible
Hi, and if you pass only a few ids i.e. {1,2,3,4,5} then it is working?
Edit: If yes check your batch size.