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?
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center