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

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

Dimension browse using Role fails with Error retrieving children

Posted By:      Posted Date: October 13, 2010    Points: 0   Category :Sql Server
Hi, this concerns SSAS 2008 R2. I've created a test user and I want to give this test user re-only access to a cube and all of its dimensions. So, I created a Role as follows: General: Checked the Read Definition for database permissions Membership: users and groups set to Domain\Testuser Data Sources: (cube data source name), Access None, Read definition (grayed and checked) Cubes: (cube name), Access Read, Local Cube/Drillthrough Drillthrough, Process (unchecked) Cell Data: all blank Dimensions: All database dimensions, Access Read, Read Definition (grayed and checked), Process (unchecked) Dimension Data: (default, all checked) Mining Structures: (default, all blank) The Testuser can browse the cube using Management Studio, no problem. This includes access to all dimension members and browing the member hierarchies (as part of the cube). However, Testuser cannot browse the dimensions. The primary error is a blank pane saying that "the dimension does not contain hierarchies". So, I investigated. While logged on as Testuser, I looked at the properties of the Role as displayed in Management Studio. No suprises until I got to Dimension Data. Then, for each dimension, instead of the list of members and checkboxes in the main display pane, I saw "Error retrieving children: The '$dimensionname' object was not found. Parameter name: index" (where dimension

View Complete Post

More Related Resource Links

"An error occurred while retrieving data from Oracle Instance..."


I have succeffuly Imported the ADF and have also successfully created a Business Data Column. But when I try to query data , I get the following error

An error occurred while retrieving data from Oracle Instance. Administrator, see the server log for more information

And this is what I found in the Application Logs
A Metadata Exception was constructed in App Domain '/LM/W3SVC/81256521/ROOT-1-129217212004078822'. The full exception text is: LobSystem could not be found using criteria 'id=476'.

How to Get Error Message from Job History if SQLAgent Job Fails

Hello, I am using "last_run_outcome" value = 0 (fail) or 1 (pass)  from sysjobsteps to identify if the job has failed. So if the job has failed, can I get the Error Message from SQL ? (which we can see in Job History). Thanks, Prabhat

SQL Server 2008 installation fails There was an error generating the XML document. Error code 0x84B

My system config: window XP - SP3 4 GB RAM, I have VS2008 with SP1, VS2010 Ultimate installed First when I tried to install SQL 2008 R2 Dev edition I got an error saying vs2008 SP1 was not installed, infact I had the SP1 installed in my m/c.  I did reinstalled the SP1 and tried to install SQL again. while in the final installation process I got the error  "Setup has encountered the following error: There was an error generating the XML document. Error code 0x84B10001." I uninstall the SQL server again to remove the files which were created from Unsuccessful installation I removed the register entry as suggested by this forum. reinstalled but no chance, I have tried all the option which I can get know in web. Please help me. here is the log files details  Exception type: Microsoft.SqlServer.Chainer.Infrastructure.ChainerInfrastructureException 2010-08-26 14:54:53 Slp:     Message: 2010-08-26 14:54:53 Slp:         There was an error generating the XML document. 2010-08-26 14:54:53 Slp:     Stack: 2010-08-26 14:54:53 Slp:         at Microsoft.SqlServer.Chainer.Infrastructure.DataStoreService.SerializeObject(String rootPath, Object objectToSerialize, Boolean saveToCache) 2010-08-26 14:54:53 Slp:   &nb

Strange Problem - SSIS Fails with "Syntax error, permission violation, or other nonspecific error".

Hello, I have a strange issue while I am deploying a package to one of the environment server. I have 2 XML Source, in the DataFlow, and one will extracted based on a value of variable that is passed from run time (package is executed from a Job) and other will be extracted all time. The next Step I have is a Execute SQL Task in ControlFlow wihich will execute after DataFlow. This has 2 input parameters and some SQL query that uses the param. Now this one fail on the target environment with below error: failed with the following error: "Syntax error, permission violation, or other nonspecific error". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. I got the error when I did a SSIS Text File Log. Note: If I run the package in BIDS with the same XML files it work. Also when I deploy the package to my Dev Server it works. When I compare the Dev DB with the target environment DB - Both are same. The Service Acount has permission - as I can see the DataFlow task completed. Another Point: The XML Load Data Flow that executes based on the Variable Value does not execute on target environment, even if the value is passed as "True" (It is Boolean Type) But this variable is NOT an input for the Execute SQL task that fails. I am not sure w

Crawling fails with 404 error message, but the IIS log tell a different story

In our clean SP2010 install, crawling stops immediately, just logging a single error message:   The object was not found. ( Error from SharePoint site: HttpStatusCode NotFound The request failed with HTTP status 404: Not Found. )   Looking at the IIS log does, surprisingly, not  confirm this. Here are all the log entries related to crawling:   #Fields: date time s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username c-ip cs(User-Agent) sc-status sc-substatus sc-win32-status time-taken 2010-09-01 15:20:42 GET / - 80 - Mozilla/4.0+(compatible;+MSIE+4.01;+Windows+NT;+MS+Search+6.0+Robot) 401 1 2148074254 15 2010-09-01 15:20:42 GET / - 80 0#.w|global\cre-nhk Mozilla/4.0+(compatible;+MSIE+4.01;+Windows+NT;+MS+Search+6.0+Robot) 200 0 0 46 2010-09-01 15:20:42 GET /Pages/Forside.aspx - 80 0#.w|global\cre-nhk Mozilla/4.0+(compatible;+MSIE+4.01;+Windows+NT;+MS+Search+6.0+Robot) 200 0 995 937 2010-09-01 15:20:43 GET /_vti_bin/sitedata.asmx - 80 - Mozilla/4.0+(compatible;+MSIE+4.01;+Windows+NT;+MS+Search+6.0+Robot) 401 1 2148074254 0 2010-09-01 15:20:43 GET /_vti_bin/sitedata.asmx - 80 0#.w|global\cre-nhk Mozilla/4.0+(comp

filtering a role playing dimension

I have a role playing dimension and need to run a query that will select the intersection of members that are common on a single attribute...    So Dim1 and Dim2, they both have the attribute [Name] (though the fact table has two different foreing keys mapping to the single primary key on the dimension table) I need to select the members where both foreign keys on the fact table map to the same member in the dimension table so for example,  Dim1.Name = 'John Smith' and Dim2.Name = 'John Smith' Any ideas? Javier Guillen

infopath 2003 user role error

hi, i'm trying to create a user role for my form in infopath 2003. but when i add a user and click on the icon next to the texbox it gives me this error: The program cannot open the required dialog box beacause no locoation can be found

Mirroring fails (Error: 1418)

Our configuration: Two separate boxes running SQL Server 2008 R2.  On box A we have the principal database.  Box B holds both the mirror and the witness.  We are using the Mirroring Wizard.  Both boxes are on the same domain. We followed the following steps to try and establish the mirror: Backed up the database from  box A Backed up the transaction log from box A Restored the backup on box B using the RESTORE WITH NORECOVERY option Restored the transaction log on box B using the RESTORE WITH NORECOVERY option Run the mirrorring wizard on box A At this point I get an error message saying that the mirror database on box B cannot be reached (Error: 1481).  The mirror database on box B is in the "Recovering" state because we used the RESTORE WITH NORECOVERY option.  It's interesting to note that if we restore the database on box B using RESTORE WITH RECOVERY, we then get the same error message but this time it says that the principal database on box A cannot be reached. What gives?JC

SQLTask fails :: f"Retrieving the COM class factory for component with CLSID {19E353EF-DAF4-45D8-9A0

OS :: Windows 2008 R2 x64 SQL :: 2008 R2 Enterprise x64 The package and task worked fine untill I migrated to a different server, now the SQL Task fails with the following error msg, see below. The package was developed on the same OS & version of SQL.   SSIS package "Package.dtsx" starting. Error: 0xC002F210 at Execute SQL Task, Execute SQL Task: Executing the query "" failed with the following error: "Retrieving the COM class factory for component with CLSID {19E353EF-DAF4-45D8-9A04-FB7F7798DCA7} failed due to the following error: 800700c1.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. Task failed: Execute SQL Task SSIS package "Package.dtsx" finished: Success.  

Analysis Service Process Dimension Cause : OLE DB error: OLE DB or ODBC error: ORA-00942: table or v

Dear Gurus, I'd face a "STRANGE" problem. I'm using SQL2008 connect to Oracle Data Source (OracleOldDB.1) When I process a snow-flake dimension . There is a ORA-00942 problem. But if I past the SQL Statement to a Oracle Tool . It worked without any problem. Does any body ever face this "STRANGE" problem ? And I'd try to remove this table from data-source-view and re-join it . Still same problem !!  Wilson

sqlcmd - linkedserver - ALL queries fails after FIRST error from remote server - ANONYMOUS LOGON

Hello, I have very strange problem with sqlcmd , it stop working after first error returned from remote sql server (like permission denied), lets try show what I'm doing, configuration is quite simple C- client (windows 2003 x64, standalone sqlcmd client sp3) S1 - server1(windows 2003 x64, sql 2005 sp3) S2 - server2 (windows 2003 x64, sql 2005 sp3) I need connect via middle Linked Server (S1) from C to to S2, each machines have the same LOCAL Windows account C\LSUser, S1\LSUser, S2\LSUser with the same password, LSUser is not domain account, linked server is configured for Windows Account Impersonation (checked Impersonate) Example, query executed from client C: 1>exec [LS1].[DB].[dbo ].[ListTab1]; - works well, no problem 1>exec [LS1].[DB].[dbo ].[ListTab2]; - works well, no problem ok , now try modify permission on S2, I explicitly deny execute procedure [DB].[dbo ].[ListTab1] on S2 to S2\LSUser, 1>exec [LS1].[DB].[dbo ].[ListTab1]; Msg 229, Level 14, State 5, Server S2, Procedure ListTab1, Line 1 The EXECUTE permission was denied on the object 'ListTab1', database 'DB', schema 'dbo'. expected message :), but look now: 1> exec [LS1].[DB].[dbo ].[ListTab2]; Msg 18456, Level 14, State 1, Server S2, Line 1 Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. all remote queries STOP working from client C 1> select top 10 * from [L

Getting error while retrieving data from sql server 2008 to infopath 2007 in sharepoint 2007

Hi, I have created an InfoPath form in InfoPath 2007. In this form I am getting data from SQL Server. To do this I have created data source for SQL Server 2008’s Tables. I have created 4 connections for 4 tables. When I am previewing this form from InfoPath Designer 2007, it is working. But when I am publishing this, it is giving me an error ‘Can not update content type’. If I skip this error then my form published but when I open this form from Share Point 2007. It gives me an error:   There has been an error while processing the form. Click Continue to resume filling out the form. You may want to check your form data for errors. Click Start Over to load a new copy of the form.   An error occurred accessing a data source. An entry has been added to the Windows event log of the server. Log ID: 6932 G. Goyal

SQL Reporting Services 2008 Role in SCCM 2007 R2 has error component status message (SMS SRS web ser

SQL Reporting Services 2008 (SMS SRS web service is not running on SRS Reporting point server) with SCCM 2007 R2 -error component status message My environment is (x86) Windows Server 2008 SCCM 2007 R2 with SQL 2008.  The configuration is as follows: SCCM Configuration 1.The reporting Point role on SCCM is installed (SMSSRSRP Setup log is states the install was successful)2.DataSource Settings are SCCMSERVER\SCCM_DB  Test Connection Succeeded3.Database Authentication is set to use (Credentials Stored Securely on the Report Server) I've configured the same credentials in the Reporting Services Configuration ManagerI can access SQL Reporting Services without issue and run reports, etc; but I'm continuing to receive these error status messages..  SRSRP.log Repeats the following: Timed Out... SMS_SRS_REPORTING_POINT 4/17/2009 1:01:58 PM 2076 (0x081C)STATMSG: ID=7403 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_SRS_REPORTING_POINT" SYS=SMS Server SITE=SITE_CODE PID=2748 TID=2076 GMTDATE=Fri Apr 17 17:01:59.165 2009 ISTR0="SMS Server" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_SRS_REPORTING_POINT 4/17/2009 1:01:59 PM 2076 (0x081C)Failures reported during periodic health check by the SRS Server SMS Server. Will retr

Different attribute name in each dimension for a role playing dimension

Is it possible to name the attribute differently in a role playing dimension. For example I use the Date dimension as the role playing dimension for Ship Date and Order Date. When I use these attributes on the report, both of them show as 'Date' which is the name of the attribute in the Date dimension. Is there any work around to implement these names differently?

SQL Server 2008 Windows Authentication Mode fails for Database Engine, error 18456

I installed SQL Server 2008 Developer Edition (10.0.1600.22.080709-1414) on a Windows Vista 32-bit development machine with Windows Authentication Mode only (no SQL Server Authentication).   Since this is a development machine, I saw no need for Mixed Mode when I did the install.  The SQL Server Management Studio allows me to login to Analysis Services, Integration Services, Reporting Services, BUT NOT the Database Engine!Windows Authentication for the Database Engine gives the following error: EventID: 18456Login failed for user MYDOMAIN\MYLOGIN'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: <local machine>]The 'fix' I have found online is to login as SA in SQL Server Authentication mode & add MYDOMAIN\MYLOGIN as a administrator for the Database Engine.  Unfortunately, I can't since I didn't install SQL Server Authentication mode (only Windows Authentication Mode).  It appears my only recourse is to uninstall, then reinstall in Mixed mode, then to login as SA in SQL Server Authentication mode & add MYDOMAIN\MYLOGIN as a administrator for the Database Engine. Before I do so, does anyone know of a better approach?Scott D Duncan

EBS 2008 WSS 3.0 fails with Error 500

Hi all, I have problem with Essential Business Server (EBS) 2008 WSS. It was deployed and WSS was configured and working properly. After sometime, it returned an error " the page cannot be displayed" after some troubleshooting, I discovered that 2 applications were using same port. Following some steps I found online, i removed Binded ports on IIS. Now, anytime I tried to browse any of the sites on IIS. It returned "Error 500 - The page cannot be displayed". I cannot also have access to management page as well. Info: EBS is installed on 3 physical servers - HP Proliant DL 380 G5 Please help.  

SQL Server 2008 R2 rebuild master database fails with error -2068643838

I want to change the server collation setting for SQL 2008 R2.  I'm using the command: Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=MyServerName /SQLSYSADMINACCOUNTS="MyDomain\Special Account Group" "NT AUTHORITY\SYSTEM" "NT SERVICE\MSSQLSERVER" "NT SERVICE\SQLSERVICEAGENT" sa /SQLCOLLATION=Latin1_General_CI_AI The setup program starts, runs a while, then exits with a return code: Error result: -2068643838 Result facility code: 1203 Result error code: 2 The final lines of the Detail.txt file in the ...\Setup Bookstrap\Log\<specific timestamp>\ directory are: 2010-07-12 14:54:58 Slp: Running Action: ProduceStatusLogsBeforeFinishPage 2010-07-12 14:54:59 Slp: Completed Action: ProduceStatusLogsBeforeFinishPage, returned True 2010-07-12 14:55:00 Slp: Received request to add the following file to Watson reporting: C:\Users\<MyLoginName>\AppData\Local\Temp\2\tmpDAAF.tmp 2010-07-12 14:55:00 Slp: The following is an exception stack listing the exceptions in outermost to innermost order 2010-07-12 14:55:00 Slp: Inner exceptions are being indented 2010-07-12 14:55:00 Slp: 2010-07-12 14:55:00 Slp: Exception type: Microsoft.SqlServer.Setup.Chainer.Workflow.NoopWorkflowException 2010-07-12 14:55:00 Slp:     Message: 2010-07-12 14:55:00 Slp:         The state of your
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