Excel Locking Documents Sporadically -- File Server



  • I'm having a weird issue occurring on my file server. Basically when a user accesses an excel file on our file server it sometimes opens it as a read only file (NOTE: This applies to users on the LAN or on replicated domains accessing the same server; No other users have the file open). I thought it was:

    1. The Antivirus--which it isn't.
    2. Virtual Disk Service--possible issue with the backup, which it isn't.

    I'm going through my audit logs and I see something odd. Remember, I'm a novice in comparison to most of you. Anything in bold I edited to be generic.

    This below attempt to access was fine.

    A handle to an object was requested.

    Subject:
    Security ID: domain\username
    Account Name: username
    Account Domain: domain
    Logon ID: 0x120f2e6

    Object:
    Object Server: Security
    Object Type: File
    Object Name: path to file
    Handle ID: 0x4a5c

    Process Information:
    Process ID: 0x4
    Process Name:

    Access Request Information:
    Transaction ID: {00000000-0000-0000-0000-000000000000}
    Accesses: DELETE
    READ_CONTROL
    ReadData (or ListDirectory)
    WriteData (or AddFile)
    AppendData (or AddSubdirectory or CreatePipeInstance)
    ReadEA
    WriteEA
    ReadAttributes
    WriteAttributes

    Access Mask:		0x3019f
    Privileges Used for Access Check:	-
    Restricted SID Count:	0
    

    *This one below wasn't although nothing was changed. It's just sporadic. *

    A handle to an object was requested with intent to delete.

    Subject:
    Security ID: domain\username
    Account Name: username
    Account Domain: domain
    Logon ID: 0x120f2e6

    Object:
    Object Server: Security
    Object Type: File
    Object Name: path to file
    Handle ID: 0x0

    Process Information:
    Process ID: 0x4

    Access Request Information:
    Transaction ID: {00000000-0000-0000-0000-000000000000}
    Accesses: -
    Access Mask: 0x0
    Privileges Used for Access Check: -

    Q: What dictates intent on a file server? I have never run into this problem until now (I did post about this awhile ago thinking it was fixed).



  • tagging @scottalanmiller as he would probably know



  • LOL, not so likely. Not much of an Excel user.



  • This post is deleted!


  • 0_1457537831621_error.jpg

    wat

    why

    Friends of the internet assemble @Dashrender @dafyre @MattSpeller @coliver @travisdh1



  • @wirestyle22 said:

    0_1457537831621_error.jpg

    wat

    why

    Friends of the internet assemble @Dashrender @dafyre @MattSpeller @coliver @travisdh1

    Is that the event you are getting when somebody tries to open the locked file?



  • @dafyre said:

    @wirestyle22 said:

    0_1457537831621_error.jpg

    wat

    why

    Friends of the internet assemble @Dashrender @dafyre @MattSpeller @coliver @travisdh1

    Is that the event you are getting when somebody tries to open the locked file?

    Yeah. The thing is it's not really locked. It opens a bunch of times perfectly fine but sporadically says it's locked. No one else has the file open. Another thing is I'm using two different version of Excel--BOTH VERSIONS have this happen. They can close it afterwards and then open it perfectly fine. It's not just one file either its any excel files. Driving me nuts



  • @wirestyle22 said:

    @dafyre said:

    @wirestyle22 said:

    0_1457537831621_error.jpg

    wat

    why

    Friends of the internet assemble @Dashrender @dafyre @MattSpeller @coliver @travisdh1

    Is that the event you are getting when somebody tries to open the locked file?

    Yeah. The thing is it's not really locked. It opens a bunch of times perfectly fine but sporadically says it's locked. No one else has the file open. Another thing is I'm using two different version of Excel--BOTH VERSIONS have this happen. They can close it afterwards and then open it perfectly fine. It's not just one file either its any excel files. Driving me nuts

    Is it ONLY Excel files? What about Word files?



  • Just curious, have you tried restoring it from the latest backup (change the filename or directory to restore to), and seeing if the restored file has the same issue? Could be something as simple as a corrupted bit in the wrong place.



  • @travisdh1 said:

    Just curious, have you tried restoring it from the latest backup (change the filename or directory to restore to), and seeing if the restored file has the same issue? Could be something as simple as a corrupted bit in the wrong place.

    It's not just a single file it's all files and I'm not sure when this started. I think it most likely has been longer than 7 days (backup tapes). I don't think it's the files themselves.



  • @wirestyle22 They have a procedure for this type of thing here, it's called "Throw it in the pond." Good luck, I'll be watching to see the cause/fix.



  • @travisdh1 said:

    @wirestyle22 They have a procedure for this type of thing here, it's called "Throw it in the pond." Good luck, I'll be watching to see the cause/fix.

    Sad frowny time



  • @dafyre said:

    @wirestyle22 said:

    @dafyre said:

    @wirestyle22 said:

    0_1457537831621_error.jpg

    wat

    why

    Friends of the internet assemble @Dashrender @dafyre @MattSpeller @coliver @travisdh1

    Is that the event you are getting when somebody tries to open the locked file?

    Yeah. The thing is it's not really locked. It opens a bunch of times perfectly fine but sporadically says it's locked. No one else has the file open. Another thing is I'm using two different version of Excel--BOTH VERSIONS have this happen. They can close it afterwards and then open it perfectly fine. It's not just one file either its any excel files. Driving me nuts

    Is it ONLY Excel files? What about Word files?

    Word seems fine. I cannot replicate the problem and the user can't either (in word).

    Note: This doesn't just happen with one user as well. I am just using one person to test it in addition to my accounts. User has full access permissions to the folder and inherited permissions are on for it. I also removed inherited permissions and applied them manually. Same thing.


  • Banned

    Argh grief, had this SOOO many times when I was mainly helpdesk based.

    Excel files like to be annoying.

    What file format are the spread-sheets exactly?



  • If what I think I found is the cause of this I'm going into the woods to punch dance until I can't feel feelings anymore



  • So I noticed indexing was enabled. I disabled it.

    I have not been able to reproduce the problem. Might be too early to judge but after opening over 60 documents I have not run into the issue.



  • @wirestyle22 said:

    So I noticed indexing was enabled. I disabled it.

    I have not been able to reproduce the problem. Might be too early to judge but after opening over 60 documents I have not run into the issue.

    I find the indexing system to almost always be bad.



  • @scottalanmiller said:

    @wirestyle22 said:

    So I noticed indexing was enabled. I disabled it.

    I have not been able to reproduce the problem. Might be too early to judge but after opening over 60 documents I have not run into the issue.

    I find the indexing system to almost always be bad.

    I never enable indexing. I have no idea why it is enabled. I must have not noticed it when I started here. I will keep everyone updated once I test this further.



  • @wirestyle22 said:

    @scottalanmiller said:

    @wirestyle22 said:

    So I noticed indexing was enabled. I disabled it.

    I have not been able to reproduce the problem. Might be too early to judge but after opening over 60 documents I have not run into the issue.

    I find the indexing system to almost always be bad.

    I never enable indexing. I have no idea why it is enabled. I must have not noticed it when I started here. I will keep everyone updated once I test this further.

    Microsoft has "helpfully" enabled that feature in updates for desktop versions of Windows, I wonder if that's what happened here?



  • @wirestyle22 said:

    @scottalanmiller said:

    @wirestyle22 said:

    So I noticed indexing was enabled. I disabled it.

    I have not been able to reproduce the problem. Might be too early to judge but after opening over 60 documents I have not run into the issue.

    I find the indexing system to almost always be bad.

    I never enable indexing. I have no idea why it is enabled. I must have not noticed it when I started here. I will keep everyone updated once I test this further.

    On by default.



  • What error message does the user get when they try and open one that has this problem?

    Oh, never mind - read only. One minute.



  • http://www.ozzu.com/mswindows-forum/word-files-saved-network-randomly-opening-read-only-t75734.html

    "I checked. Before we tried opening a file, nothing was listed as being open. Once we tried to open a file. The file opened in word as read only. When I checked the open files then, it showed the file being accessed. But not by her, it was showing being accessed by one of the service accounts we have set up for our fax server. I checked and she is logged in as herself, this is very strange. "

    "Double check her machine to make sure the fax service is not set as her default printer."



  • @MattSpeller said:

    http://www.ozzu.com/mswindows-forum/word-files-saved-network-randomly-opening-read-only-t75734.html

    "I checked. Before we tried opening a file, nothing was listed as being open. Once we tried to open a file. The file opened in word as read only. When I checked the open files then, it showed the file being accessed. But not by her, it was showing being accessed by one of the service accounts we have set up for our fax server. I checked and she is logged in as herself, this is very strange. "

    "Double check her machine to make sure the fax service is not set as her default printer."

    Are you shitting me right now Matt? Hold on. Sigh.



  • Nah. Her default printer is an HP 1350.



  • @wirestyle22 said:

    Nah. Her default printer is an HP 1350.

    I tried 😛



  • @MattSpeller said:

    @wirestyle22 said:

    Nah. Her default printer is an HP 1350.

    I tried 😛

    Appreciate the effort. For the record she told me it said "read only" but it actually says "open by another user". She was making an assumption which I specifically asked her about and she gave me false information. The thing is there is no other open version of the file from the servers point of view. I think this might be a case of excel being closed improperly so to test this I had her start excel, open the file within excel, close the file in excel (while keeping excel running) and then open a new file. Rinse and repeat. We have not had this issue occur since then. We have probably opened at least 150 documents up until this point. So my question is where do i go from here?

    @MattSpeller tagging you so you know I edited this.



  • My boss has gotten these errors many times over the years. I look around find nothing wrong and go about my day. No other user has ever complained about it, even the ones that I know use Excel a fair amount.

    I'll be checking on the indexing option as well.

    Question - indexing on the server or on the workstation?

    indexing a network share I don't think is on from a workstation perspective by default - or am I mistaken?



  • @wirestyle22 said:

    Appreciate the effort. For the record she told me it said "read only" but it actually says "open by another user". She was making an assumption which I specifically asked her about and she gave me false information.

    Dictionary Entry for User: "One who lies about trivial items for which there is no reason to refuse accurate information."



  • @scottalanmiller said:

    @wirestyle22 said:

    Appreciate the effort. For the record she told me it said "read only" but it actually says "open by another user". She was making an assumption which I specifically asked her about and she gave me false information.

    Dictionary Entry for User: "One who lies about trivial items for which there is no reason to refuse accurate information."

    what's amazing, if you them into a lie detector, they would pass saying the first thing because they don't care enough to accurately report the problem.



  • @Dashrender said:

    @scottalanmiller said:

    @wirestyle22 said:

    Appreciate the effort. For the record she told me it said "read only" but it actually says "open by another user". She was making an assumption which I specifically asked her about and she gave me false information.

    Dictionary Entry for User: "One who lies about trivial items for which there is no reason to refuse accurate information."

    what's amazing, if you them into a lie detector, they would pass saying the first thing because they don't care enough to accurately report the problem.

    That would be an interesting test. It also suggests that they are sociopaths as that is what that means - that they do evil because they have no conscious.


Log in to reply