1 of 1 people found this helpful
This may be an expected behavior. Tableau sometimes has to place locks on files that are over 1MB. If you contact support, they should be able to help you out with some instructions that you can use to try and change this behavior. I cannot be certain that the setting will change this but it is worth a shot.
Please don't ping me like this for all your posts, especially your initial post:
I check the forums pretty much every workday so this is unnecessary. Like many others I have a full-time job that takes precedence so my work here is voluntary. Please be judicious when pinging people otherwise your requests go from informational to noise and thus get ignored. It's like the folks who always post "URGENT!" in their subject line, I ignore the post and any other post the person makes if they over-do it. I'm not ignoring you...for now...
Now, if you have a post where you think someone could provide input and they haven't shown up then this would be a good way to give them a nudge towards it I don't mind that
well I recognized a group of experts on this community who's comments always helped me ,and you were one of them that's why I always interested to hear from you ,but accept my apology if you take it ill.I will keep this thing in mind for future post .
Hi Dan Huff
Thanks for your reply , I asked user and found that file size is less then 1 MB however I asked support to check ,if they can find out the cause of this error.
I will update here whatever be the outcome of this support analysis.
1 of 1 people found this helpful
Sunil Tikar wrote:
well I recognized a group of experts on this community who's comments always helped me ,and you were one of them...
Thank you but I'm really just a beginner, Jeff and Mark and Dan (naturally) are far more experienced than I. I'm not upset and I typically read your posts here because you ask some good questions
- As to your question, is the location of the workbook on a SharePoint site? I just want to make sure nothing unusual is happening.
- Is the lock occurring only during the extract times?
- When it's locked, open Excel and then File >> Open... and open the Excel file. If it's in use by "someone" then the error message should state who has it opened and thus locked. Example:
Here is what I got from user over your queries .
1. The location of the workbook is not in sharepoint,
2. User tried open Excel and then File >> Open... and open the Excel file but still getting same generic error message .
3.This lock is appearing for all uses .
I have asked organization IT support to look in to it.
I will update here if I will get something to share .
Thanks for your reply .
Thanks for the update. This is an odd one
I encountered this same issue - after a bit of research, we found in the release notes that version 8.2.2 (version we're currently running) and others slightly before or after have a known issue where .xls files used as data sources will lock after .tde's are refreshed. We contacted customer support, who confirmed the issue, and we were advised to upgrade to one of the versions where this issue has been resolved.
We have decided to upgrade to 8.3.6 but cannot do so until end of July-ish. Hopefully, this will resolve our problem. Will try to post an update after we upgrade.
I'm getting the same problem (Re: RunAs account constantly accessing network file?), in fact, Toby and Brian have replied to my post there.
I've been trying to sort it out for a week now, and it's really getting frustrated. I've not had this problem with a similar set up, but the folders are read only and they are under 1MB, which might explain why it's working.
Just to clarify:
- The RunAs account has read only permissions for the network folder
- The file is 35MB
- I've published the workbook to Server with the live connection, un-ticking "Include External Data"
- The dashboard seems to work fine, but when I go to edit the network file, it says the file is currently in use, but doesn't prompt me that a specific user has the file open.
- We're using Tableau Server v9
I'm waiting for a response from ICT regarding SharePoint. I'll also ask tableau about the file lock mentioned above. I'll keep you posted.
Alex, given your reply here, you are using SharePoint whereas Sunil is not. That is a big difference. Please update your thread and let's keep your issue over there. Also, please post in your thread what version of SharePoint and Tableau Server you are using. If you are using SharePoint 2010 or older then please read this: Connecting to a SharePoint 2007/2010 object to use as a data source
Thanks for the reply. I've found the following KB article on setting isolation levels, which should help get around the lock issue.
I've forwarded it to our ICT team and will do the same with your article on SharePoint.
Many thanks, much appreciated.
Instead of upgrading from 8.2.2 to 8.3.6, we decided to wait a little longer to upgrade all the way to 9.1.1... so, end of July-ish became end of November-ish. Better late than never I guess!!
I'm pleased to say that we tested this today and the upgrade resolved the issue we were having with shared .xls files on a network drive getting locked upon extract refresh.
Hope this helps!