We have recently changed our main fileserver from NetWare on workstation hardware to Windows Server 2003 Enterprise SP2 on actual server hardware. Ever since then we've had an occasional issue where our internal applications that use Crystal Reports can't open the .rpt files on the server. I have finally tracked it down...whenever a particular .rpt file gets a total of 20 locks from all users, then the problem starts. Now we just have to figure out how to fix it.
When a particular report file is called from one of our programs it gets a lock on the server. However, the only way it seems that the lock is released is to close the program itself, not just the report. So these locks keep adding up for each user until there is a total of 20 and everyone starts to get errors. Now everyone has to restart the program to release all of the locks and everything is happy again for a while. This never happened when everything was on the NetWare server, which leads me to believe that it is a Windows issue. But is it Windows not releasing the locks? Is there a way to increase this apparent 20-lock limit we are seeing? Would there be a setting on each workstation (Windows 2000 and XP) that is causing this?
I did find a posting on experts-exchange.com (http://www.experts-exchange.com/Database/Reporting_/Crystal_Reports/Q_20624991.html) that says Crystal Reports limits the number of copies of a single report being open at a time to 20, and that the application probably isn't cleaning up after itself properly. But, like I said, we never had this issue with NetWare, but we do now that we are on Windows.
Just looking to see if anyone has any ideas.
Thanks!