Tuesday, October 12, 2010

Error: Unable to create or access workbook cache at C:\WINDOWS\TEMP\Excel Server\FileCache\SharedServices1-1078443246\Ranges. Excel Services is unable to function without a workbook cache

Error: 
Unable to create or access workbook cache at C:\WINDOWS\TEMP\Excel Server\FileCache\SharedServices1-1078443246\Ranges. Excel Services is unable to function without a workbook cache.

(you can see this error in Event viewer)

Reason:
Unknowingly you may have deleted the above mentioned folders. So, Excel services is not able to save the temporary files under the "Ranges" folder.

Solution:
Login inside the SharePoint server and create the "Ranges" folder as per the above mentioned folder structure. If you are not able to see the "Excel Server" folder inside "C:\Windows\Temp" folder, just create it manually.

If you see any other error like this, create the missing folder.

Thats it... 

Monday, October 11, 2010

Error: The Managed Metadata Service or connection is currently not available. The Applicaiton Pool or Managed Metadata web service may not have been started. Please contact your Administrator.

Error:
The Managed Metadata Service or connection is curretnly not available. The Applicaiton Pool or Managed Metadata web service may not have been started. Please contact your Administrator.




Reason:
The "SharePoint web services root" site may be stopped in your IIS. 

Solution:
Just follow the solution that I have given in my another post 

Now, you will be able to see the MetaData service in your central admin.

Thats it...

Error: The Security Token Service is not available. The Security Token Service is not issuing tokens. The service could be malfunctioning or in a bad state.

Error:


The Security Token Service is not available. 
The Security Token Service is not issuing tokens. The service could be malfunctioning or in a bad state.

(Or) 

An exception occurred when trying to issue security token: Could not connect to http://localhost:32843/SecurityTokenServiceApplication/securitytoken.svc. TCP error code 10061: No connection could be made because the target machine actively refused it 127.0.0.1:32843. 

(Or)

The Managed Metadata Service '' is inaccessible.

Reason:
These are all unusual errors and you will get these kind of errors, if you have installed the SSL certificate on your SharePoint server. In my situation, I have installed SSL & Lync Server 2010 RC in my SharePoint 2010 server. 

Solution:
I found an very nice post about this issue in the below URL:

But unfortunately, the above post is not useful for me. Anyhow, it gave me some ideas about the actual issue. Finally I have found an simple solution. 

1. Go to InetMgr
2. Just start the "SharePoint Web Services" site and "SharePoint Web Services Root" application pool as per the below screenshot.
















3. To make sure everything, do the "IISReset". 


Thats it....