@tsteur I think that error actually only occurs as API.getProcessedReport can't be exported as a CSV. Normally I guess this part should throw an exception as the data structure can't be converted:

But it tries to add the full array content to the exception message. Locally that ends up for me in a memory exhausted error. Maybe the message above would occur if I would have a more memory available.

We maybe should change the error messages in that case, so it no longer tries to add the full data content.

Truncating the exported array makes sense and could be a good quick fix 👍 We could limit it to the first 1M characters or so

Actually I'm not sure if it's worth to include it at all. The variable is an array, so doing a var_export on it will double the amount of used memory for it. So we would need to truncate the array before dumping it, but hard to say how big the dump will be without looking through the array content and its structure.

Not sure if I understand correctly. I thought in this case it's not a memory issue but maybe a limitation in sprintf?
If there's a memory issue or so, we could otherwise always extract the first say 1K entries and then do the var_export?

I think the problem is, that the array is too big in some cases. But we can't know which part of the array is how big. So using the first 1000 entries in the array might still be too big, depending on the complexity of the array.

We had the same problem again

Error: {"type":1,"message":"Field width 2699393714 is too long","file":"/core/DataTable.php","line":1587,

Request:

GET: {"expanded":"1","filter_limit":"100","format":"CSV","flat":"1","date":"2022-01-01,yesterday","format_metrics":"1","idGoal":"","idSite":"29","language":"fr","method":"API.getProcessedReport","apiModule":"Referrers","apiAction":"getReferrerType","module":"API","period":"day","segment":"","showAllGoalSpecificMetrics":"0","token_auth":"XYZANONYMIZED","translateColumnNames":"1","convertToUnicode":"0"}

POST: {"token_auth":"XYZANONYMIZED","expanded":"1","filter_limit":"100","format":"CSV","flat":"1","date":"2022-01-01,yesterday","format_metrics":"1","idGoal":"","idSite":"29","language":"fr","method":"API.getProcessedReport","apiModule":"Referrers","apiAction":"getReferrerType","module":"API","period":"day","segment":"","showAllGoalSpecificMetrics":"0","translateColumnNames":"1","convertToUnicode":"0"}

I'll prepare a PR to adjust the exception messages. I guess there is no much value in printing the whole content in the exception anyway.