When using an Oracle Fusion connection - if you have a saved automation .TAS file, it runs manually in Toad Data Studio (TDS) fine, but as a scheduled task it isn't working correctly, even with full permissions. The error 'Elevation target 'SaveTaskAction' is not supported' appears when saving the scheduled task.
It does save to Task Scheduler, but doesn't run successfully.
Also it isn't possible to amend the settings of the saved task in TDS, as it doesn't update, and can only be changed directly in Task Scheduler.
When it does run from Task Scheduler, is the error seen in the attached log:
-- 29/07/2026 17:02:58: Project_2026-07-29_17-02-44-536.log: Last schema: FUSION
-- 29/07/2026 17:02:58: Project_2026-07-29_17-02-44-536.log: Default schema: FUSION
-- 29/07/2026 17:02:58: Project_2026-07-29_17-02-44-536.log: Auto Commit: True
-- 29/07/2026 17:02:58: Project_2026-07-29_17-02-44-536.log: file2 - Tried to access unsupported Sql (Quest.Toad.Db.CommonSql.ChangeCurrentDatabase) for database type (OracleFusion)
-- 29/07/2026 17:02:58: Project_2026-07-29_17-02-44-536.log: Tried to access unsupported Sql (Quest.Toad.Db.CommonSql.ChangeCurrentDatabase) for database type (OracleFusion)
-- 29/07/2026 17:02:58: Project_2026-07-29_17-02-44-536.log: System.Exception - file2 - Tried to access unsupported Sql (Quest.Toad.Db.CommonSql.ChangeCurrentDatabase) for database type (OracleFusion)
Inner exception:
System.IndexOutOfRangeException - Tried to access unsupported Sql (Quest.Toad.Db.CommonSql.ChangeCurrentDatabase) for database type (OracleFusion)
at Quest.Toad.Db.Sql.Version(IConnection conn, Boolean skipMissedException)
at Quest.Toad.Db.Sql.String(IConnection conn, Boolean skipMissedException)
at Quest.Toad.Db.Connection.ChangeSchema(IDbConnection conn, String database)
at Quest.Toad.Workflow.Activities.Database.DatabaseConnectionActivity.CheckDefaultSchema()
at Quest.Toad.Workflow.Activities.Database.DatabaseConnectionActivity.Connect(ToadWorkflowService service, Activity activity)
at Quest.Toad.Workflow.Activities.Database.SelectToExcelActivity.Execute(ActivityExecutionContext executionContext)
-- 29/07/2026 17:02:59: Project_2026-07-29_17-02-44-536.log: Failed
Repro Steps:
1. Connect to an Oracle Fusion db
2. Create .TAS file with Export to File and save it
3. Run it manually to check it works ok
4. Schedule it and the 'Elevation target 'SaveTaskAction' is not supported' error appears
5. It isn't possible to reschedule the task from within TDS, only Task Scheduler itself
6. When it does run, there is an error (above), and 'Error 999' shown in TDS.
WORKAROUND:
None
STATUS:
Waiting for fix in a future release of Toad Data Studio
