Error "The process cannot access the file it is being used by another process" occurs while using function "ExportToStream"

Question

0.00/5 (No votes)

See more:

Dear all,
I sometimes get the following error while printing crystal report to pdf:

VB

   System.Runtime.InteropServices.COMException (0x80004005): The process cannot access the file because 
it is being used by another process. at CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export
(ExportOptions pExportOptions, RequestContext pRequestContext) at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream
(ExportRequestContext reqContext) at CrystalDecisions.CrystalReports.Engine.FormatEngine.ExportToStream(ExportRequestContext reqContext)
 at CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToStream(ExportOptions options) at 
 CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToStream(ExportFormatType formatType) at 
 CommonWA.CommonFunc.GetPDFMemoryStream(DCMSReportDoc _dcmsreportdoc, Boolean& _DataExist) in E:\wwwroot\ASPWA\CommonWA\CommonCom.vb:line 382

The error not occurs frequently but sometimes it will happen, can someone tell me why the error occurs and how can I solve the problem?
Thank you very much.
Ray

Posted 30-Aug-10 17:06pm

Ray, SWChan

Updated 30-Aug-10 20:32pm

Prosanta Kundu online

v2

Add a Solution

5 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Christian Graus · Answer 1 · 2010-08-30T17:11:00

Solution 1

It occurs for the reason the error states - some other code has opened the file and not closed it.

Posted 30-Aug-10 17:11pm

Christian Graus

Ray, SWChan · Answer 2 · 2010-08-30T20:17:00

Solution 3

Hi Christian,
If a file is used by other process, is it the crytal report file being used by other process?
Orignally, I load the report using the default OpenReportMethod. If I change to "OpenReportByTempCopy", is that ok? Moreover, I would like to ask if a temp copy rpt will be generated when I use "OpenReportByTempCopy"? If so, where will be the temp copy will be saved? In temporary internet files or somewhere else?
Thanks,
Ray

Posted 30-Aug-10 20:17pm

Ray, SWChan

Comments

Christian Graus 31-Aug-10 2:34am

You should not push 'answer' to ask a question, you can comment, or edit your post. I don't use Crystal Reports, but the error does mean you're trying to save on top of a file that is open, so you need to look at your code that accesses this file and see if there's a method you can use to close it. otherwise you need to save to another file name.

Ray, SWChan 31-Aug-10 21:36pm

Hi, Christian, Thanks. But I cannot test that out since it will not happen in development server, it only happen in production server. So I would like to ask if anyone has the same problem before and solve that. Thanks.

MnaveedAli · Answer 3 · 2011-04-14T21:20:00

Solution 4

Ray, did you get any solution to this problem?

Posted 14-Apr-11 21:20pm

MnaveedAli

Kschuler · Answer 4 · 2011-04-15T05:32:00

I'm guessing that you are exporting to a PDF name that already exists and is currently open in Adobe Reader. When you export to PDF you may want to first check to see if that PDF name already exists, and if so use another name. Or include a datetime stamp in your PDF name to ensure that it doesn't already exist.

#realJSOP · Answer 5 · 2011-04-15T05:44:00

It probably happens because another user has hit the same page/piece of code, and you always use the same filename for the task. Try using a new GUID for the file name each time the code is hit, or have the code retry after a number of seconds. If my theory is correct, it'll clear itself up after a few seconds, and you'll be allowed to do whatever you're trying to do with the file. If the file is simply being read, you can open it for unexclusive read, and the file can be opened by multiple users at the same time.