We help IT Professionals succeed at work.

Access Not Granted to the Report File

266 Views
Last Modified: 2013-11-26
  I am adding some pages to our existing intranet.  I have a web page with a crystal report file incorporated into the page.  As a project itself it works but as when the  web page is put into the intranet collection it does not work.  Here is the error:

Error in File C:\WINDOWS\TEMP\YAT_OnPremises {853764C4-B582-4744-A78D-A0137653BD6E}.rpt:
Access to report file denied. Another program may be using it.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Runtime.InteropServices.COMException: Error in File C:\WINDOWS\TEMP\YAT_OnPremises {853764C4-B582-4744-A78D-A0137653BD6E}.rpt:
Access to report file denied. Another program may be using it.

    I have tried shutting down VS 2005, deleting the file and readding it.  I've deleted the temp files but it keeps creating them.  I've checked the access of the file and assigned proper permissions.  Yet my attempts are not successful.  
    Any help is appreciated!  Thank you in advance!
 
Comment
Watch Question

CERTIFIED EXPERT

Commented:
Try changing the path from
C:\WINDOWS\TEMP\YAT_OnPremises
-to-
C:\TEMP\YAT_OnPremises

\WINDOWS\ and \Program Files\  folders have restrictions to be accessed from browsers -intranet or Internet
Senior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Ok.... I went in and ganrted the user permissions to write to the temp directories... but that did not work.   I do not have a temp folder under the c: to move the file to.   I have an outstanding crystal report file (from couple of weeks ago) that will not let delete it.  Any suggestions on how to get the temp file to be released?
CERTIFIED EXPERT

Commented:
For the delete part
If you can login as Administrator, take Ownership of the dir or file and try to delete it

as for the c:\temp, a silly question. Can't you create one?

Author

Commented:
I do have ownership of that temp file.  Please excuse me for asking a "silly question" I've been looking at this stuff so long, I've my brain tends to leave me.

Author

Commented:
 As I stated before the web page I am trying to incorporate, was orginally working on my local host.  The temp pages keep appearing I set the caching to =60 sec.  For whatever reason it also keeps referencing line 37 of my code.  I have posted this below:  Any help?

Line 35:
Line 36:     Private Sub setdblogonforreport(ByVal myconnectioninfo As ConnectionInfo)
Line 37:         Dim mytablelogoninfos As TableLogOnInfos = CrystalReportViewer1.LogOnInfo
Line 38:         For Each mytablelogoninfo As TableLogOnInfo In mytablelogoninfos
Line 39:             mytablelogoninfo.ConnectionInfo = myconnectioninfo
 

Source File: D:\InetPub\yatintranet-dev\Shopvue\On_Premises.aspx.vb    Line: 37
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
What Crystal dlls or merge modules did you install on the server?

mlmcc

Author

Commented:
Crystal Report Server 10 and merge modules 10

Author

Commented:
Mlmcc directed me in the correct direction.  

I found the specifics to solve my problem.
This site specified the permissions that needed to be set is:
http://aspadvice.com/blogs/rjdudley/archive/2005/03/15/2567
.aspx

Thanks for your help!
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
Glad i could help

mlmcc
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.