Regarding oracle tuning I refer to orafaq How to tune SQL or Identify Performance Problem and Bottleneck

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