SQL Server Analysis Services error:
When I try to browse a cube in either Visual Studio 2008 or the SQL Management Studio, I get the following error: Error HRESULT E_FAIL has been returned from a call to a COM component.Even before you do anything to get that error, the section which would normally say "Drop Totals or Detail Fields Here" instead has a message saying "The query could not be processed: o XML for Analysis parser: The LocaleIdentifier property is not overwritable and cannot be assigned a new value."
Fix:
1. Here is the exact fix to solve this issue,
http://yahawana.wordpress.com/2011/07/06/ssas-localeidentifier-property-not-overwritable-and-cannot-be-assigned-new-value/
2. Check your SQL Server Browser Services were running.
3. Change the system locale as well (on Win7: Control panel > Region and Language > Administrative > Change system locale) to en-US, then it works.
Cheers,
Venkatesan Prabu .J
Head, KaaShiv InfoTech
When I try to browse a cube in either Visual Studio 2008 or the SQL Management Studio, I get the following error: Error HRESULT E_FAIL has been returned from a call to a COM component.Even before you do anything to get that error, the section which would normally say "Drop Totals or Detail Fields Here" instead has a message saying "The query could not be processed: o XML for Analysis parser: The LocaleIdentifier property is not overwritable and cannot be assigned a new value."
Fix:
1. Here is the exact fix to solve this issue,
http://yahawana.wordpress.com/2011/07/06/ssas-localeidentifier-property-not-overwritable-and-cannot-be-assigned-new-value/
2. Check your SQL Server Browser Services were running.
3. Change the system locale as well (on Win7: Control panel > Region and Language > Administrative > Change system locale) to en-US, then it works.
Cheers,
Venkatesan Prabu .J
Head, KaaShiv InfoTech
I've found a permanent fix - from another post somewhere but I can't find it again. It's simple (daft, but simple):
ReplyDeleteIn my case, SSMS on my laptop was fine but SSMS and BIDS on the server showed the error, for at least 2 users.
1. ON THE CLIENT FROM WHICH YOU HAVE THE PROBLEM (in my case, an RDP session on the server) open Start - Control Panel, find Location Settings (or Regional Settings or Region and Language or whatever it's called - mine is Win Server 2008R2).
2. Find the Format setting (which determines date and time formats).
3. Change it from your normal setting to English (United States). Apply the change.
4. Set it back to what it was before. Apply the change.
5. You may need to restart the SSMS or BIDS session, not sure, but this should then be a permanent fix.
Note that it seems to need to be done for each user separately but for each user for whom it's been done, it seems to be a permanent fix.