I have OnTime 2007 installed on a windows 2003 server (SP1) running MS SQL 2005 with 2GB of RAM installed, running IIS v6.0, and Xeon processor 2.33 GHZ.  Currently, only 50 defects have been entered into the DB so far - no features or defects.

 
When running the 'Defect Details' report, my client hangs and the server performance is terrible - no one can do anything while it is running.  I've yet to get it to run successfully.  I have had to disable the ability to run that report for the users so that the system doesn't crash during the day.  We are currently evaluating the product (hence only a small number of defects entered).  Is this a known issue or a problem with my particular installation?

I have found the following post, but this isn't a reasonable 'solution' or workaround:

http://community.axosoft.com/forums/thread/10604.aspx

The solution says:

"The CPU spike that is happening when attempting to run the defects detail report is related to the content that has been entered in the individual defects under the large text fields such as Description, Notes and Reproduction Steps. Copied HTML content and text from other applications such as Microsoft Word or Microsoft Outlook tend to generate this problem in the OnTime application. If you are able to find a single defect in the list that is causing this problem for you, try copying the current information that you have in the defect and paste it into Notepad. Once you have the necessary items pasted in Notepad, you can copy this text back into the defect which should resolve this problem for you."

 I might be able to do this for 50 defects, but I can't afford to go through each defect each time I want to run this report across multiple concurrent projects.

 Would love to know if there is some work being done with this or if there is a something else that can be done so that we can use this report.

Thank you..

Ross