When executing a batch optimize on a .XML file:
1. From Batch List, right-click and select "Add Jobs | Source Code".
2. Select a .XML file with embedded SQL code.
3. After batch optimize is completed, click on 'Job Report' and Toad will generate the following error
The following unhandled error has occurred
Collection was modified; enumeration
operation may not execute
4. Clicking on OK gave the following error and SQL Optimizer disappears.
Quest.Tuning.Oracle.Main has encountered a problem and needs to close.
WORKAROUND:
None
STATUS:
Issue fixed in version v7.5.
The current commercial version can be downloaded at the Support Portal.
This issue is only observed in the "trial" version of SQL Optimizer 7.5.2.1216. The commercial version as well as v7.5.3 (trial and commercial) do not have this problem.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center