cffile write error

You should wrap this cffile inside a cflock. And put all that inside a cftry for good measure.

Could there ever be an instance of the code trying to write the same file simultaneously? e.g. if two users accessed the same code, or if the file looped when you weren't expecting to.

Do u have the file open while your trying to write to it? The file is most likely locked for writing at the time you are attempting to write.

ASKER

duncancumming - The attached code returns failed.

Jones911 - The code below is separate from the application. There is a 0.0001% chance that someone is actually trying the same test on our server.

<cftry>
<cflock timeout="10">
<cffile action="write" file="\\myserver\D\Intranet\TechFolder\Test\NewExcel.xls" output="
		<table>
		<tr>
			<td  colspan='2'>Item One</td>
			<td  colspan='2'>Item Two</td>
			<td  colspan='2'>Item Three</td>
		</tr>
		</table>
" addnewline="Yes">
</cflock>
<cfcatch>
Failed
</cfcatch>
</cftry>

Open in new window

Inside your cfcatch, put:
<cfdump var="#cfcatch#">

That might give you more of an idea (or it might just repeat the Access is denied information).

ASKER

duncancumming - I attached a spreadsheet of the verbose error
TestFileWriting.xls

Does the file exist? Are you trying to over write it?

Perphaps add a random number to the fliename.xls ie filename9999.xls

You say this problem only happens sometimes, but it sounds like it's happening consistently for you. Try remove the addnewline attribute. Check your filepath.

ASKER

Jones911 - File does not exist. This a test piece of code because of a piece of code in a web app that we have is not working.

duncancumming - I compare it to timeouts. If people are getting timeouts, then it is easy to duplicate the timeout error. If you resolve the issue behind timeouts (eg you killed an open trans) then it is hard to duplicate the error. Today we are in the midst of this problem. Hence the urgency to test this issue while it exists. I tried removing the addnewline attribute to no avail. Also putting the UNC in to Windows Explorer returns the appropriate path every time on both the server and local machines.

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER

Jones911 - The CF User does not change, nor does the roles/permissions change. By nature of the fact the system DOES work when it wants, we are assuming that the roles are correct. The network admin has looked at it several times without seeing anything wrong. He is one of the 3 of us that are scrambling to resolve this today.

Thanks!!

OK just to be sure what exact user is Coldfusion running as? system? the issues seams to me that CF doe not have access to the share.

But as you said it works sometimes? If it works sometimes then the file must be locked but something else at exactly that moment. Are you trying to write to the file in only 1 app?
Capture.JPG

ASKER

Jones911 -

Q: OK just to be sure what exact user is Coldfusion running as? system?
A: This would be on the network admin. I know that we checked this. Why would this matter if the issue does work sometimes? Doesn't this mean that the user has sufficient privileges?

Q: If it works sometimes then the file must be locked but something else at exactly that moment. Are you trying to write to the file in only 1 app?
A: I have stated before there is a 0.0001% chance that someone is actually trying the same test on our server. This is a lone piece of code that I created apart from our web app because of the web app having issues.

Have you tried resetting CF services since the problem started?

Well your code is totally valid there is no issue with the code itself. This is why I keep repeating to check all the values and settings.

got all the hotfixes applied?

http://kb.adobe.com/selfservice/viewContent.do?externalId=kb402465&sliceId=1

ASKER

duncancumming - Yes; it works and then stops and works and then stops... no rhyme or reason...
Jones911 - I understand, but we have ruled out as issues.
SidFishes - I am checking with our network admin. I will have to get back to you on this.

Thanks!!

ASKER

SidFishes - I checked with our network admin. The hotfix has been applied. This is not the issue.

looking at this again...you reference

\\myserver\D\Intranet\TechFolder\Test\NewExcel.xls.

the erroring template is D:\Intranet\TechSupport\TestFileWriting.cfm so I'm assuming everything is on the same local machine

make the path D:\Intranet\TechFolder\Test\NewExcel.xls

and see what happens

Or even D:\NewExcel.xls just to try.

ASKER

In short, this worked, but being cross servers in the app, it is not resolved. We need to be able to access this via UNC.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER

If this was an AD Issue, then why does the attached code output:

0
1

<cfdirectory directory="\\myserver\D\Intranet\TechFolder\Test\" name="qryOutput" action="LIST">
<cfoutput>#qryOutput.recordcount#</cfoutput><br />
<cfdirectory directory="D:\Intranet\TechFolder\Test\" name="qryOutput" action="LIST">
<cfoutput>#qryOutput.recordcount#</cfoutput>

Open in new window

firstly...you -need- to set up cf as i've outlined or you are simply not going to have any luck accessing network resources...period. If you don't believe me then search for coldfusion accessing network resources

secondly, your unc path doesn't make sense to me

afaik, you would never put a drive letter in a unc path it should be \\myserver\Intranet\TechFolder\Test

-except- when using an administrative share in which case it would be \\myserver\D$\Intranet\TechFolder\Test but cf won't be able to access that unless you run it under an admin account.

as for why you are getting 0 returned, it's likely because of permissions or simply the fact that the path doesn't make sense to cf either

ASKER

I talked to our network admin about this and we looked at the 2000 server that we switched from. The CF User was setup the same way.

How could it be different now?

ASKER

UPDATE: I cannot confirm results unless someone can point me to the reason this error is occurring when it didn't on server 2000.

Please take a screen shot of the user the CF is runnign as. Ie the same screen shot I posted. If its running as system then there is your problem.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER

Jones911 - It is being used by the local account for now. My question remained as if this was the solution, give me the reason.

SidFishes - Well explained. I am going to take this to the network admin for application and will respond shortly.

Thanks!!

The reason is that Windows requires user authentication to access remote resources. The 2000 server may have been an authenticated machine in Activedirectory and the system account of the 2000 machine had access to the remote file server. I would hazard a guess that somewhere the 2000 machine did have more permissions then the 2003 one which is why you were unable to write to the remote fileserver.

ASKER

As a qualified expert myself, point distribution is important to me. Here is the how and why of the distribution.

Jones911 - First identification = 200 points
SidFishes - Explanation of resolution + Explanation of issue = 300 points (150 each)