Running a basic Oracle sql query, exporting to Excel in Automation. When clicking 'Test' to run, it runs fine.
However, when scheduling the same task it seems to run very quickly and doesn't produce the Excel file. On checking the log for the task, the following message is displayed multiple times through the log.
Error ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit when scheduling.
On testing, we found that running the scheduled task uses 4 connections, and running it within Automation uses 3 sessions. Our limit is 3 sessions_per_user.
Questions:
Why so many connections in Automation 'Test'?
Why one more when scheduled?
TDA does use mutliple connections for threading purposes and will always open at least two sessions. However, it has been found that the exporting utility is opening two additional connections and not releasing them
WORKAROUND
Have DBA increase SESSIONS_PER_USER limit to at least 4 if scheduling tasks
STATUS
Waiting for fix in a future release of Toad for Data Analysts
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center