Get error message when trying to save data in application while running a report in Crystal Reports
Posted on 2009-04-29
When I'm running a complex report in Crystal Reports, I'm unable to save data in the SQL Server 2005 database through an accounting application. The user will get the following message:
Error 1222 [Microsoft] [ODBC SQL Server Driver] Lock Request Time Out Period Exceeded
The data in the report is good, though it is quite long to generate (3 minutes). I'm running several reports that do not cause any problem, but they are usually simpler and don't take as long to calculate.
I tried to figure out why would SQL Server 2005 prevent writing to the database while I'm running this report, without success. The total size of the 13 tables I'm using for the report is around 3 GB. Therefore Crystal should be able to put all the data it might need in a temporary file that it will use for selecting and sorting and let the database alone. Instead, it seems like it still needs to prohibit writing on it to avoid a conflict that I can't explain.
Have you got any idea if a solution exists for this problem?