Is it possible to tune the data driven query for your subscriptions, so it only returns persons who weren't in the previous dataset?

Trying to restore data for comparison (before & after) and find out the backupprocess missed the necessary archivelogs for a restore to time.
Luckily it could be reconstructed from other...

Mainstream vs extended support
If possible contact your MS person

Some recent blogs about parametersniffing
Parametersniffing 1
Parametersniffing 2
Parametersniffing 3

"obviously replacing the params with the actual values"
do you mean

SELECT *
FROM  A
where col1=@param1

with

SELECT *
FROM  A
where col1=1

or you could use the oracle to_date function

AND SLD.docenimerosisdate >='02/02/2018'
AND SLD.docenimerosisdate >=TO_DATE('02/02/2018','DD/MM/YYYY')


I've only used PDF for exact layouts. Does it "print" correctly there?
Have you played around with HTML device settings html-device-information-settings

Can you provide a hint to the solution?

Rendering as web or rendering as PDF?

Have you tried a textual dump of the offending field to see what value might give the error?

SELECT dateasstring from openquery(progresssource,'select tostring(offendingfield) dateasstring ...') progress


Glad you found it.
Thanks for the solution

I don't use SSAS yet but Have you looked at the logs?
Following link is a bit old but might still be relevant
CU7...

All the packages of the project are checked out?

Does the statement work outside sql server agent? It might be a permission problem.
You can run sql agent jobs under a different windows account using proxies and credentials

spid= connection id, usually < 50 are system connection.
About your memory error, it is mentioned in de MS docs Resolve page allocation failures due to insufficient memory...