Are you able to reboot your SQL Server computer, and than log back into AyaNova, print a summary report template in Quotes, and than select to create a new detailed report template?

I've got eight quotes set up here in a test SQL Server database, but no errors where filtered or not with just that many. Rebooting may "refresh" the SQL Server so we can than see what is actually happening.

We posted at the same time, so I have edited this reply to include your observation above:

v3.1.4 did not include the Filtering Drop List and saved filter ability. The grids were completely rewritten to allow for this.

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

Its totally different now with the Filter Drop List and the saved filter ability - yes I do understand that the issue did not previously occur with v3.1.4  but v3.1.4 did not have all the additional code etc to allow for saved filters and the Filter Drop List feature, as well as v3.1.4 requiring Microsoft.NET Framework 1.1 whereas v3.2.4 requires Microsoft.NET Framework 2. They are two totally different versions with totally different specs.

Have you rebooted the server as suggested for troubleshooting?

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

the server was rebooted and I am getting the same result.

Rebooting the SQL Server, directly opening AyaNova, and directly attempting to print a Quotes detailed report template on 8 or less records does now lead me to your SQL Server itself and/or your SQL AyaNova database. As the SQL Server is in esscense "fresh" because nothing else on it has yet run, getting the timeout right away on so little records does indicate something additional here with your SQL Server itself and/or your data.

Please provide the following information:

• Confirm that the latest service patches for SQL Server 2000 are applied
• What is the operating system being used with this SQL Server 2000 and are all service patches applied.
• What else is running on this computer in addition to SQL Server?
• Is there more than one database being run by this SQL Server - other than AyaNova, is there anything being run by this SQL Server?
• .
• In the Properties for this SQL Server 2000, is memory set to be used dynamically or is a fixed amount of memory in to be used
• What is the maximum concurrent user connecitons set to

In a separate direct email to  support@ayanova.com or attach to a private message to me via this forum, provide the following:

• Zip up a backup of your SQL Database files (use a full backup or shut down SQL Server, and zip up the two files AyaNova.mdf and AyaNova_log.LDF)
• Zip up a copy of your AyaNova.exe.config file
• Provide the AyaNova Administrator username and password

I will than identfiy if I get the same timeout on Quotes using your data and go from there

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

I was hoping that you would be sending the requested information so that I may help troubleshoot.

Please provide the information above, and also - please provide what is the size of your AyaNova.mdf file and the AyaNova_log.LDF file (The AyaNova SQL database and log file).

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

I have resolved this issue. The problem was in the database it self. I ran SQL database optimization against the database, which reorganized and re-indexed data.

**Recommendations**

any one running SQL setup a maintenance plan on the database, depending on the size and usage run once a week or monthly (excluding backup which should be run nightly). If you experience issues like mine, they could be quickly and easily resolved by database planning.

If you are using MSDE setting this up may be a little more involved. There are a number of free MDSE managers that will help with this routine maintenance plan.