No results are returned when searching for %40716% in the Chart of Accounts-Account Number field when an exact match exists in the data. In a SQL trace there is a difference in the select statement when searching for %40.
SELECT * FROM chart_of_accounts WHERE UPPER(chart_acct) like...
Multiple runrepor.exe are displaying in task manager and the server is at max memory usage while users are working in Millennium and running reports.
There may be an error from SQL server that displays : 1455: The paging file is too small for this operation to complete.
The years utility is being run by the 'sa' account. The utility runs for a few minutes and then the queue displays "Utility error".
The error in createyearsout.log file in the queue folder displays the following error:
"Error Encountered when dropping temporary table. Above...