Not sure if anyone else has experienced this, but…
When setting up variables in an automation report that use an SQL select, TDA CPU usage will jump to 50% or higher and cause the application to go unresponsive for at least 5 minutes (currently looking at 10 for the latest instance) when adding another variable or moving between existing variables.
My variables are nothing complex - just variations on:
SELECT TO_CHAR(SYSDATE,‘MMDDYYYY’) FROM DUAL;
So that I can get various date information to fill in the email and file names. I’ve used the VB definitions in the past, but they aren’t flexible enough and tend to break at random times for unknown reasons.