FM Server 8/9 Advanced CWP unexpected error
Description of the issue
FileMaker Product(s) involved:Filemaker Server 8.0v4 Advanced/Filemaker Server 9.0v3 Advanced Operating System(s) involved:Windows 2003 Server/Mac OS X Detailed description of the issue:In Custom Web Publishing with XSLT: when executing a query that retrieves a large number of records (I don't know the exact limit but 10 000+), after a long time waiting (> 30 seconds) an error message is retrieved "an unexpected error has occurred". It only occurs in searches where at least one search criteria is used, and not when you choose to show all records (> 300 000 records in the database). Exact steps to reproduce the issue:(?) Set up a form using custom web publishing with xslt and query a large database. Expected Result:The search might take a few seconds more than some other searches or, at worst, time out. An understandable error message should at least show up.Actual Result:After a long time waiting for the result, the error message "an unexpected error..." shows up.Exact text of any error message(s) that appeared:pe_application_log: XSLT-CWP: An unexpected error has occurred (null) File: /fmi/xml/fmresultset.xmlThe other logs show nothing special.Any additional configuration information/troubleshooting that is relevant to the issue:IIS on Windows 2003 Server, Apache on Mac OS X. Single machine configuration. Can't find anything in event viewer etc. Performing the same find in the same database in FileMaker Pro is very fast.