Access Violation "Access is Denied" when saving results of query (Export Dataset) on Citrix (4311810)

Access Violation "Access is Denied" when saving results of query (Export Dataset) on Citrix

Toad is installed on a Citrix / Terminal Server. When some users try to save results from the Save As (Export Dataset) window an Access Violation occurs. This is an excerpt from the error log file toad.elf

Exception:
----------------------------------------------------
2.1 Date : Mon, 8 Dec 2008 10:40:14 -0600
2.2 Address : 0055598B
2.3 Module Name : toad.exe - (Toad for Oracle)
2.4 Module Version: 9.7.2.5
2.5 Type : EOleSysError
2.6 Message : Access is denied.
2.7 ID : 5C79
2.8 Count : 1
2.9 Status : New
2.10 Note :

Active Controls:
---------------------------------------
4.1 Form Class : TFormGridSaveAs
4.2 Form Text : Save Grid Contents
4.3 Control Class: TFormGridSaveAs
4.4 Control Text : Save Grid Contents

Issue related to policy domain group not having the necessary permissions to access the Task Scheduler (Save As/Export Dataset has a Schedule button)

Or issue related to ToadActions.dat file getting full.

WORKAROUND 1:
Ensure users have the necessary permissions to access Task Scheduler on server

WORKAROUND 2:
1) Close Toad for Oracle.
2) For Windows XP - Go to 'C:\Documents and Settings\<OS_USER>>\Application Data\Quest Software\Toad for Oracle\<Toad Version>\User Files' directory.
or
For Windows Vista and 7 - Go to 'C:\Users\<OS USER>\AppData\Roaming\Quest Software\Toad for Oracle\<Toad Version>\User Files' directory.
(a) Rename the ToadActions.dat file to ToadActions.dat.backup.
(b) Rename the ToadActions.log to ToadActions.log.backup
3) Launch Toad and test issue.

 

STATUS:
Waiting for fix in a future release of Toad for Oracle

ST73972

Other workarounds... WORKAROUND 3: Upgrade to Toad 12.0 to check for better handling of the situation and error. WORKAROUND 4: Clear out TEMP folder of unwanted temporary files WORKAROUND 5: Rename the whole Toad User Files folder: NOTE: Make sure to back up your Toad Authorization Key and Site Message. You can get this from the Toad Help menu | Licensing or from your own records. 1) Fully Exit Toad 2) Go to: XP: C:\Documents and Settings\\Application Data\Quest Software\Toad for Oracle\10.x\ Vista and 7: C:\Users\\AppData\Roaming\Quest Software\Toad for Oracle\10.x\ 3) Rename the “User Files” folder to “User Files_OLD” 4) Start Toad 5) When prompted to Migrate previous Toad settings, do NOT migrate any settings (choose “Clean Install”) 6) Start Toad again and re-test the issue NOTE: If you want to copy over your Connections History , please see the steps below. Re-test the issue before moving over your Connections History and just to make sure the issue is not coming from the old files. To move your Connections History, please see steps below: 1) Fully Exit Toad (make sure you have checked the “Save Passwords” box mentioned in Step 6 above) 2) Go to the ‘old’ “10.x_OLD\User Files\” folder that you renamed earlier 3) Copy (not Cut or Move) both the CONNECTIONS.INI and the CONNECTIONPWDS.INI files 4) Paste both files in the ‘new’ “10.x\User Files\” folder and replace the existing ones 5) Start Toad and you should now see your Connections History in the log in screen