.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Analysis Services - Query returns a #error result

Posted By:      Posted Date: September 06, 2010    Points: 0   Category :Sql Server
Hi, I have a cube - which i had backed up and just retored it. After the restoration, when i try to reply the cube e.g: select [Time].&[200503] on 0 , {[Process].[All process]} on 1 from [myConsolidations] - i recieve an a result showing #error only. What could be the cause of this?

View Complete Post

More Related Resource Links

Resume SharePoint Services Web Application and returns code 1387 error


Hello everyone! Newbie here. I would like to ask how to start the SharePoint Services Web Application on (WSS3.0,internal database, stanalone users) without getting error 1387 ?

I would love to provide more information regarding this issue but what I got is error 1387 displayed in the browser.

I look forward to seeing you guys feedback from your expertise angle.



SQL Server Analysis Services Backup error "Errors in the metadata manager. Either the database with


I get the following error when this perl script tries to backup the database using ASCMD.exe 2008 command line tool

<return xmlns="urn:schemas-microsoft-com:xml-analysis"><root xmlns="urn:schemas-
microsoft-com:xml-analysis:empty"><Exception xmlns="urn:schemas-microsoft-com:xm
l-analysis:exception" /><Messages xmlns="urn:schemas-microsoft-com:xml-analysis:
exception"><Error ErrorCode="3239313412" Description="Errors in the metadata man
ager. Either the database with the ID of &#39;xyz_old&#39; does not exi
st in the server with the ID of &#39;ABCD\Sql_AS&#39;, or the user doe
s not have permissions to access the object."
Source="Microsoft SQL Server 2008
Analysis Services" HelpFile="" /></Messages></root></return>

I have tried using different account for impersonation but everything fails.

Any help would be really appreciated.


Error trying to select analysis services datasource for new report

Does anyone know how to resolve the issue when presented with the following error message when trying to select a datasource for a report in SQL Server Analysis Services?

Non-Windows user credentials were supplied for a non-http connection to Analysis Services. The Microsoft SQL Server Analysis Services data extension requires Windows Integrated Security unless connecting via http or https.

Selecting Result from Content Query Wb Part gets Webpage cannot be found Error

I have MOSS 2007 running on Windows Server 2008.

I have added a custom List to a MOSS 2007 site sollection. The List works fine.

I have added a new webpage to the site collection Home page that includes a Content Query Web Part. When the Content Query WP is configured it returns items from the custom List as expected. But when I select one of the result items returned by the Content Query WP, the Browser says "The webpage cannot be found."

Why doesn't the Content Query WP result navigate to a page that displays the List item selected from the results list?

I have 2 items returned in the CQWP results list and both generate the same error when selected.

If I go to the custom List, the items display OK when selected.

The URLs generating the error looks like:

BOTH (1) AND (2) Query Returns same result


  select * from tblEmp
  select @@ROWCOUNT

 select * from tblEmp
 select @@ROWCOUNT

BOTH (1) AND (2) Query Returns same result
1. Employee details
2. No of row effected
and which is faster count(*) or global @@ROWCOUNT

Error while creating Analysis services cubes


I am getting the error "The .Net Framework Data Providers require Microsoft Data Access Components(MDAC).  Please install Microsoft Data Access Components(MDAC) version 2.6 or later" when i try to trigger Cube builder job. The datasource to which i am connecting is Netezza Database.

Jothi S

[Analysis Services Execute DDL Task] Error: File system error: A FileStore error from WriteFile occu


Hi ,

iam facing one issue while Running one Dimenstion,i got the data in my fact table,and try to processing into dimenstion,i searched somany sites and Blogs,please find the error details

[Analysis Services Execute DDL Task] Error: File system error: A FileStore error from WriteFile occurred. Physical file: \\?\M:\MSSQL\Data\DnB.0.db\Primary Contacts.0.dim\71.Fact Key.asstore. Logical file: . .


1) i verified space in my server Drives all are sufficent my drive (M:\) is around 459GB free space

2) i verified permissions of this folderCube ,it have proper permissions,actually i ran same cube thrice per a month,iam facing this type of problem this time only

3) i chnaged the settings like Process MeasureGroup like By attribute inplace of ByTable,but not work

4)i changed server configuration setting in msdsrv.ini file and change Bufferlimit  set 1 ,but no Luck

5)i chnaged Maximum connection allowed to reduce 1 or 2

6) i divided my dimenston into subparts based on columns and created New dimenstion but iam seeing same issue.

one more thing iam observing if i processed with By attribute i got the above error,if i processed Bytable i got the

File system error: A FileStore error from WriteFile occurred. Physical file:

Get same result when running MDX in stored procedure and Analysis Services


I have a simple MDX query as follows:

select non empty {descendants([dim fund].[fund structure].&[1])} on rows,
[measures].[amount] on columns
FROM [xyz]

When it runs against Analysis Services, it returns two columns:

All Funds        123,435,567
Fund1            122,400,090
SubFund1      6,445,435
SubFund2      546,343

When it runs it in a stored procedure with Openquery, it returns multiple columns to represent the structure:

create procedure usp_OLAPtest
declare @strMDX_Sql as nvarchar(max)

set @strMDX_Sql = 'select non empty {descendants([dim fund].[fund structure].&[1])} on rows,
[measures].[amount] on columns FROM [xyz]'

exec (N'select * from openquery(xyz_OLAP, ''' + @strMDX_Sql + '''); '

All Funds  NULL    NULL          123,435,567
All Funds  Fund1   NULL          122,400,090
All Funds  Fund1   SubFund1   6,445,435
ALL Funds  Fund1   SubFund2   546,343

Is there any way for the stored proce

Error installing a second instance of Analysis Services


I'm currently running SSAS2008 R2 on a a default instance. I've attempted to install a second instance, and while it successfully completes and the service starts up, I can not connect via management studio.

I receive these errors after the install:

-Failed to initialize SQLSQM timer. One of the following can be the source of the problem: registry doesn't contain all necessary information, server instance name can not be retrieved correctly, failure during timer creation, etc.

-The file '\\?\C:\Program Files\Microsoft SQL Server\MSAS10.ADSERVICES\OLAP\Data\CryptKey.bin' could not be opened. Please check the file for permissions or see if other applications locked it.


I've tried several things to fix, including:

-Copied CryptKey.bin from another server

-Downloaded the iso again, thought it might be corrupted

-Installed 2008 (not R2), same error



I'm absolutely stuck, it seems like there is something else in play here.

Any ideas?




SQL Server 2005: Unearth the New Data Mining Features of Analysis Services 2005


In SQL Server 2005 Analysis Services you'll find new algorithms, enhancements to existing algorithms, and more than a dozen added visualizations to help you get a handle on your data relationships. Plus, enhancements to the Data Mining Extensions to SQL along with OLAP, DTS, and Reporting Services integration make it possible to create a new breed of intelligent apps with embedded data mining technology. Here the author explains it all.

Jamie MacLennan

MSDN Magazine September 2004

OLAP: Build an OLAP Reporting App in ASP.NET Using SQL Server 2000 Analysis Services and Office XP


Many organizations analyze their business-critical data using Online Analytical Processing (OLAP) technology. OLAP-based data mining provides a way to query multidimensional data sets and drill down into the data to find patterns. ASP.NET and the Microsoft Office Web Components (OWC) enable Web-based OLAP reporting. The OWC controls include PivotTable and Chart components that can be embedded in a Web page and scripted by programmers. In this article, the authors build a Web-based OLAP reporting app using ASP.NET, OWC, and SQL Server 2000 Analysis Services to illustrate the process.

Jeffrey Hasan and Kenneth Tu

MSDN Magazine October 2003

Syntax error (missing operator) in query expression

Good Day Gurus!

I have a Excel user application which has a user form (named 'Registo') that displays criteria and an image that has been entered in it's corresponding spreadsheet. This works the way it should.  There's also the ability to search the spreadsheet via a form (by clicking 'Pesquisar' button) this opens a search form. However, I having a bit of a problem with it. When I try to search for something it basically doesn't do anything at all. It just sits there. So I tried to debug it and I think I'm having a problem with either the JET db engine or somethign with teh query or maybe I don't have the correct reference.

I 'borrowed' this Excel application from another forum because it's exactly what I'm looking for! However, I suck at vb.

So I was hoping somebody could take a look at the code and see if I'm missing something?  I'm kinda' desparate to get this working because I'm been trying to figure it out for days and I'm running out of time.  Cry
Option Explicit

'constantes para auxiliar na verificação do código
Private Const Ascendente As Byte = 0

Reporting Services Error



         This is the error I m getting. Can anyone tell me what exactly the problem is

An error occurred during local report processing.
An error has occurred during report processing.
Query execution failed for dataset "DataSet1".
ExecuteReader : CommandText property has not been initialized.


Use DB query result to generate Jquery required lines of code



I 'm gonna query database for photo records. each record include "photo path" where imagesURL  stored in string format

 I Choses my favorite Juqery plugin to show images. Plugin needs some lines of code like below.

How could I  generate these lines

$(function() {
sleep: 2,
fade: 1
}, [
{ src: 'picture1.jpg' },
{ src: 'picture2.jpg' },
{ src: 'picture4.jpg' }

Error installing SharePointRS (Reporting Services AddIn)



I trying to install the SharePointRS AddIn on the SharePoint-Maschine. The installation runs and after the setup does something, it rollback the installation and informs me with just a message, that it was not successful. After searching for the installation log, I've found it in my temp folder. The error was:
"Install error: The 'Mapping' start tag on line 83 does not match the end tag of 'ByExtension'. Line 139, position 7.".
What means this error? How can I solve it?

Greetings, Anatoli.

The whole log file:

User: usrFarmAdmin
Installing Report Server feature.
Calling copyappbincontents command.


copyappbincontents command completed successfully.
Adding Report Server feature to farm.
Installed Report Server feature.
Activating Report Server feature to root level site collections.
Activating feature in web app 'SharePoint - 22222'
Web app 'SharePoint - 22222' does not have a root site collection.
Activating feature in web app 'SharePoint - 80'
Activating feature to root site collection: http://computername
Feature already activated in site collection http://computername
Activating feature in web app 'SharePoint - 8080'
Web app 'SharePoint - 8080' does not have a

On New Item form, select item on choice dropdown based on query result.


I posted this on Experts Exchange awhile back with no answer, so here's hoping someone here has an idea :)

So I've mostly figured this problem out, but I need some help in getting over the hump... note that I'm using JavaScript to do this (SPServices) on SharePoint 07'.

I'm on the New Items page of a list. Based on a user's selection in a "Teacher" dropdown, I'm doing the following:

1.) Get the value of the Teacher field and several other fields (School and Visit Date)
2.) Run a CAML query based on those fields to find the last list item entered for that Teacher

So here's where I'm stuck...

I have 10 choice fields, all with choices 0, 4, 7, and 10. Depending on what they were set to in the last entered item (which I queried), I want to set the selected item on each of those dropdowns to equal that. So "Score 1" was set to "4" on the la

Net Framework 1.0 Error 1904 during setup mscoree.dll H-result 2146232576

I cleaned off all my .Net framework files with the .Net framework cleaner. I then started at 3.5, installed it, went well, installed 3.0, went well, installed 2.0, went well, installed 1.1, went well, then, tried to install 1.0 redistribution package for my windows xp home and it stopped at almost the very end saying ERROR installing 1.0 ERROR 1904 system32\mscoree.dll failed to register. H-result 2146232576. I tried renaming it and installing the 1.0 again but still get the same error. i tried using the IGNORE option, it said it installed but i know the mscoree.dll isn't working. i used the installer cleanup tool also to no avail. i deleted the URTTemp folder and tried a reinstall. This didn't work either. Anyone know what I might can do to get this corrected? I have not done anything myself in the registry. I have used RegCure and registry mechanic but Net Framework 1.0 still gave the error when I tried to install. Any help appreciated. I did read something about 1.1, 2.0,3.0 or 3.5 might have a newer mscoree.dll file and that night be why I can't register the one I have. I need the 1.0 version 3705 though as one of my programs uses it. Also, i am now not able to put any of the updates on my computer. it downloads them but they fail to install. Example, net framework 2.o service pack 2, net framework 3.5 service pack 1, and net framework 3.5 family update. Thanks....
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend