You are sending to many values into your automatic generated sql where statement. Oracle have a limit on 1000 values in is where statement and you are sending.
Field IN value1, value2, ..., value1000, value 1001 etc.
Try limit the number of values in your D discovery. Maybe you could use a dimension and not a transaction key?