Thursday 28 July 2011

How to force a SharePoint 2010 Business Connectivity Services (BCS) Client Cache to rebuild

WARNING! This tip involves potential loss of data.
The Business Connectivity Services (BCS) Client Cache is a combination of PST files and a SQL Server Compact Edition database - that allows for you to operate with Business data while in disconnected or limited-connection scenarios.

It contains all the subscription information and data for any items that you have made available offline via Business Connectivity Services. However, there is no official way of flushing this cache - your BusinessDataCache.sdf file will just keep growing and growing ad infinitum. You can query this data by connecting to it via Visual Studio 2010 via the Server Explorer/Data Connections task pane.(For reference, the Schema of the BCS Client Business Data Cache is shown below)

At the risk of data loss (if you have any unsynched items), there is a way of recreating your cache without deleting your whole Windows Logon profile. This is as follows:

  1. Uninstall any Office Add-ins you have e.g. Outlook Addins that use the BCS cache or create subscriptions in the BCS cache.
  2. Kill the BCSSync.exe process in memory using Windows task manager.
  3. Go to the following folder on the machine:
  4. Rename BusinessDataCache.sdf to zzBusinessDataCache.sdf
  5. Run "%ProgramFiles%\Microsoft Office\Office14\BCSSync.exe" /Restart /Activation /RestartApps to restart the BCS Synchronization service.
  6. Your BusinessDataCache.sdf  file will be regenerated.


myhuonglequyen said...

Thanks for sharing, nice post! Post really provice useful information!

Giaonhan247 chuyên dịch vụ chuyên dịch vụ mua hàng trên Amazon ship về Việt Nam uy tín, dịch vụ mua hàng trên Ebay tại Việt Nam và dịch vụ vận chuyển gửi hàng đi Mỹ giá rẻ tại TPHCM, Hà Nội và toàn quốc.

Industry Consultant said...

Nice one and such a useful post, If you are freelance business consultant who is looking for consulting projects, then kindly register with SolutionBuggy, India's largest business consulting platform dedicated to MSMEs. We act as a bridge between consultants and industries.

FssaiConsultants said...

Looking FSSAI Consultants, Food Safety License Consultants, FSSAI Registration Consultants, FSSAI License Consultants. Connect with 1500+ Consultants to Assist You.

Industry Consultants said...

Connect with 600+ energy consultants &amp Solar Consultants in India. Our Energy Consultants and Solar Consultants Help You Address Your End-to-End Requirements. said...

For the Best Information provided.
please keep sharing the similar information
For the Best Best Food Consultancy in Hyderabad Choose My Food Xpert.

Manufacturing Business Ideas said...

Searching For Best manufacturing business ideas With Low Cost and High Profit? Discuss with 8,000+ Manufacturing Consultants to Assist You to set up a Profitable Business.