Locked File Issue

[eswbitto]

Hello Everyone,

Ok so I have 3 users that are all accessing one particular file. Not at the same time, but each of them access it at different times after making sure the file is not locked and is able to be edited online.

The problem is that its a excel spreadsheet that shows it is able to be edited online, but when you click on the edit online button and it opens up in M$ office it then gives an error that the document is locked for editing.

Logs show this…

11:03:52,787 INFO  [org.alfresco.module.vti.web.VtiRequestDispatcher] Note - no handler was found for HEAD to uri='/crc-reports/documentLibrary/eCRC submission report 2013-1.xlsx'
11:03:52,909 INFO  [org.alfresco.module.vti.web.VtiRequestDispatcher] Note - no handler was found for GET to uri='/crc-reports/documentLibrary/eCRC submission report 2013-1.xlsx'
11:03:53,123 INFO  [org.alfresco.module.vti.web.VtiRequestDispatcher] Note - no handler was found for GET to uri='/crc-reports/documentLibrary/eCRC submission report 2013-1.xlsx'
11:03:53,267 INFO  [org.alfresco.module.vti.web.VtiRequestDispatcher] Note - no handler was found for GET to uri='/crc-reports/documentLibrary/eCRC submission report 2013-1.xlsx'
11:04:23,182 INFO  [org.alfresco.module.vti.web.VtiRequestDispatcher] Note - no handler was found for HEAD to uri='/crc-reports/documentLibrary/eCRC submission report 2013-1.xlsx'
11:05:00,196 WARN  [org.alfresco.repo.cache.TransactionalCache.org.alfresco.userToAuthorityTransactionalCache] Transactional update cache 'org.alfresco.userToAuthorityTransactionalCache' is full (100).
11:06:30,181 WARN  [org.alfresco.repo.cache.TransactionalCache.org.alfresco.userToAuthorityTransactionalCache] Transactional update cache 'org.alfresco.userToAuthorityTransactionalCache' is full (100).
11:09:19,632 INFO  [org.alfresco.module.vti.web.VtiRequestDispatcher] Note - no handler was found for HEAD to uri='/crc-reports/documentLibrary/eCRC submission report 2013-1.xlsx'
11:13:04,347 INFO  [org.alfresco.module.vti.web.VtiRequestDispatcher] Note - no handler was found for HEAD to uri='/crc-reports/documentLibrary/eCRC submission report 2013-1.xlsx'
11:14:01,522 WARN  [org.alfresco.repo.cache.TransactionalCache.org.alfresco.userToAuthorityTransactionalCache] Transactional update cache 'org.alfresco.userToAuthorityTransactionalCache' is full (100).
11:16:01,138 INFO  [org.alfresco.module.vti.web.VtiRequestDispatcher] Note - no handler was found for HEAD to uri='/crc-reports/documentLibrary/eCRC submission report 2013-1.xlsx'
11:16:46,294 INFO  [org.alfresco.module.vti.web.VtiRequestDispatcher] Note - no handler was found for HEAD to uri='/crc-reports/documentLibrary/eCRC submission report 2013-1.xlsx'
11:21:28,182 INFO  [org.alfresco.module.vti.web.VtiRequestDispatcher] Note - no handler was found for HEAD to uri='/crc-reports/documentLibrary/eCRC submission report 2013-1.xlsx'
11:21:28,292 INFO  [org.alfresco.module.vti.web.VtiRequestDispatcher] Note - no handler was found for GET to uri='/crc-reports/documentLibrary/eCRC submission report 2013-1.xlsx'
11:22:02,779 INFO  [org.alfresco.module.vti.web.VtiRequestDispatcher] Note - no handler was found for HEAD to uri='/crc-reports/documentLibrary/eCRC submission report 2013-1.xlsx'
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

The only thing that I can think of it being is that either the users have accessed it at the same time. Or Alfresco hasn't released the status on the file being edited. Either way…anyone have any ideas on the warning that is coming up?

My setup is 4.2.d community on Centos 6.4 with apache as the front end ssl connection.

[eswbitto]

I have done a full day of research and I have not found any solution on this. Is there anyone else having this issue?

[eswbitto]

Hopefully someone can answer this…I'm not sure if it is related to my issue or not, but I was looking at my vti-context.xml file.

I have edited this file and commented out the connectors and added my ajp connector for the front end SSL connection with apache.

<bean id="vtiServerConnector" class="org.mortbay.jetty.ajp.Ajp13SocketConnector">
        <property name="port">
             <value>${vti.server.port}</value>
        </property>
        <property name="headerBufferSize">
             <value>8192</value>
        </property>
    </bean>

‍‍‍‍‍‍‍‍‍‍‍

Now I noticed that the buffer size is 8 KB and the other two connectors that the install has is at 32 KB. I'm wondering if this is causing my issue and if I should change that buffer amount. (regardless) thoughts?

[lista]

Have a look through node browser and see if you have any weird properties on that node?

[eswbitto]

I took a look at it and didn't find anything out of the ordinary. I compared the properties to another file that wasn't having any issues. Thanks for the suggestion! I didn't think to look there. Unfortunately, it didn't help 😕

[eswbitto]

Update: Still have this ongoing issue.

I looked at both cache-context.xml and caches.properties in tomcat/webapps/alfresco/WEB-INF/classes/alfresco/

I am showing in catalina.out a warning about a cache that is full. I'm wondering if there is a way to change the cache amount like what is set in the caches.properties file.

[alfresquiviris]

Hi,

We have the same behavior with powerpoint files.
Did you solve this issue?

Thanks

[eswbitto]

No I haven't. I ended up having to move the spreadsheet off of Alfresco because the users were accessing it more like that of a database rather than what Alfresco is intended for.