[sims] Issue with attendance letters

[localzuk]

We have an issue when staff run attendance letters in SIMS.net where it simply won't work, returning the following error:

 

The process cannot access the file

"\\8014042-fp01\schooladminfolders$\USER\My SIMS Documents\Hough

Kevin\TempAbsence letters.csv' because it is being used by another process.

 

This usually happens when there is another template or document open but

this wasn't the case.

 

These reports don't need to be ran again yet but when they do I'll do some

more tests myself.

 

Does anyone have any ideas?

[vikpaw]

Is the user logged in elsewhere. Presuming USER is replace by user name in that location, do they have permissions problems?

I'm pretty sure since the more to 2010 the lower powered users have had issues with this for us. will double check with some staff tomorrow.

[localzuk]

That folder is their home directory basically - they have full control of it as far as I can remember. Also, we don't use 2010.

[vikpaw]

Is SIMS running as admin, so that user doesn't have access?

 

There is a folder on the SIMS share they also need access to. I think it's the ATTEND folder..? I tried on my test machine but it's connected to the test server which is undergoing planned downtime . I remember having an issue when locking the share down.

 

None of which match your error message. What if you delete the temp file, or copy it off somewhere and see what happens?

Are you on Win7. I remember when we first went to Win 7 it was okay to create a file once, but then the next edit would not work.

[jinnantonnixx]

I've had some success with tools like this:

 

OpenedFilesView - View opened/locked files in your system (sharing violation issues)

 

Once you know what you're dealing with, you're halfway there.

[localzuk]

I've just ran Processmon on the machine and tried to run the process. All it finds is Winword.exe trying to read the file a few times (which it should, as it is doing Mailmerge from it).

 

Nothing tries to write to it. Not even SIMS.

 

I've checked permissions everywhere I can and the users have read and write permissions to the path, and to the Attend folder on the S drive.

 

I'm kinda at a loss here - it just makes no sense.

[jinnantonnixx]

You could try resetting the NTFS permissions

 

icacls /reset

 

It's not uncommon for NTFS to go wrong, but the 'in use by process' message would suggest otherwise. Can't hurt to try it though.

 

 

Also, if you just list the acls for the file with 'icacls ' do you get any unresolved users associated with the file?

Edited May 15, 2012 by jinnantonnixx

[localzuk]

Just given that a try, and no luck. No unresolved users either.

[jinnantonnixx]

I'd put money on the file not being released by SIMS. Maybe they forgot a file.dispose() or a file.close().

If you reboot the server I bet the problem will go away.

 

Other than that, use a file enumerator to release the lock.

[localzuk]

I've checked a file enumerator and the file isn't locked.

[vikpaw]

Can you edit the file, at the location? If not, then it is locked and a reboot like Jin' said. I know i get similar with photos and especially thumb files when doing photo imports.