My application created with visual studion2005 ( .NET version 2) Running on windows server, but few weeks bac my reports is not loading
'Report loading failed'. I search the system and found that Crystal created many temp files in windows temp directtory that files is locked by IIS server process. Then i reset the IIS and clean temp folder and reports worked fine. but again i got the same
error.
In my code i used all the cleaning code in page unlad event
rptDocument.close();
rptDocument.dispose
crViewer.Dispose()
why i am getting such issue ( this application cuncurrently used by 2500 people for reporting).
my IIS user and network service has the privilage to read and write permission. . what should i do to remove temporary files after reports loaded
You are right. this is issue with iis and temp files. whenever we restart iis is resolved for some time.
The main reason is that while iis processing the report ,it create temp file to render and it store in its memory. whenever the memory limit comes it gives this error. You can do this .
1. the proper connection and report doc close and dispose (as you done, but still check any leakage ).
Member
334 Points
224 Posts
Issue with Crystal temp folder
Mar 13, 2013 03:30 AM|binson143|LINK
Dear all,
My application created with visual studion2005 ( .NET version 2) Running on windows server, but few weeks bac my reports is not loading
'Report loading failed'. I search the system and found that Crystal created many temp files in windows temp directtory that files is locked by IIS server process. Then i reset the IIS and clean temp folder and reports worked fine. but again i got the same error.
In my code i used all the cleaning code in page unlad event
rptDocument.close();
rptDocument.dispose
crViewer.Dispose()
why i am getting such issue ( this application cuncurrently used by 2500 people for reporting). my IIS user and network service has the privilage to read and write permission. . what should i do to remove temporary files after reports loaded
Contributor
6602 Points
1742 Posts
Re: Issue with Crystal temp folder
Mar 13, 2013 03:47 AM|Ajay2707|LINK
Hi Binson,
You are right. this is issue with iis and temp files. whenever we restart iis is resolved for some time.
The main reason is that while iis processing the report ,it create temp file to render and it store in its memory. whenever the memory limit comes it gives this error. You can do this .
1. the proper connection and report doc close and dispose (as you done, but still check any leakage ).
2. change the registry key ( http://forums.asp.net/t/984650.aspx/1 , HKEY_LOCAL_MACHINE\SOFTWARE\CRYSTAL DECISIONS\10.0\REPORT APPLICATION SERVER\SERVER\PrintJobLimit )
3. increase memory size to process more report.
4. it is good to remove temp file also dynamically.
also please check this.
http://stackoverflow.com/questions/9579914/crystal-reports-exception-the-maximum-report-processing-jobs-limit-configured-b
http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/d02f7cd3-f18b-2d10-55ad-dab2200f68fc?QuickLink=index&overridelayout=true&53240414858625
http://www.sdn.sap.com/irj/boc/go/portal/prtroot/docs/library/uuid/f053713e-3e3d-2c10-2a81-f79259e54023?QuickLink=index&overridelayout=true&43705587209382