none
Project 2010 - Cube Build failed - Parameter is incorrect RRS feed

  • Question

  • Hi,

    We are currently expenriencing a strange issue in CBS.

    Here's the error in the ULS log :

    PWA:http://url, ServiceApp:SA-Project-01, User:DOMAIN\Admin, PSI: [CBS] Status message: ProjectServer BuildOlapCubes failed with exception: Microsoft.Office.Project.PI.CBSCommon.CBSProcessException: Error Setting Olap Database 'NameOfTheCube01' roles: Error: The following system error occurred: The parameter is incorrect.  ---> Microsoft.AnalysisServices.OperationException: The following system error occurred: The parameter is incorrect.   
     at Microsoft.AnalysisServices.AnalysisServicesClient.SendExecuteAndReadResponse(ImpactDetailCollection impacts, Boolean expectEmptyResults, Boolean throwIfError)  
     at Microsoft.AnalysisServices.AnalysisServicesClient.Alter(IMajorObject obj, ObjectExpansion expansion, ImpactDetailCollection impact, Boolean allowCreate, XmlaWarningCollection warnings)  
     at Microsoft.AnalysisServices.Server.Update(IMajorObject obj, UpdateOptions options, UpdateMode mode, XmlaWarningCollection warnings, ImpactDetailCollection impactResult)  
     at Microsoft.AnalysisServices.Server.SendUpdate(IMajorObject obj, UpdateOptions options, UpdateMode mode, XmlaWarningCollection warnings, ImpactDetailCollection impactResult)  
     at Microsoft.AnalysisServices.MajorObject.Update(UpdateOptions options, UpdateMode mode, XmlaWarningCollection warnings)  
     at Microsoft.Office.Project.Server.CBSLayer.OlapDatabaseBuilder.SetDatabasePermissionsToRoles(Database ASDatabase, ArrayList cubeViewDomainAccountList)   -
     -- End of inner exception stack trace ---  
     at Microsoft.Office.Project.Server.CBSLayer.OlapDatabaseBuilder.SetDatabasePermissionsToRoles(Database ASDatabase, ArrayList cubeViewDomainAccountList)  
     at Microsoft.Office.Project.Server.CBSLayer.OlapDatabaseBuilder.GenerateOlapDatabase()  
     at Microsoft.Office.Project.Server.CBSLayer.ProcessCBSRequestMessage.BuildOlapCubes(BuildStage buildStage, CubeAdmin cubeAdmin, CBSResource cbsResource, CubeGenerationSettings cubeGenerationSettings, OlapDatabaseDescription olapDatabaseDescription, String publishedDBConnectionString, Guid requestUid)
    

     and

    Standard Information:PSI Entry Point:  Project User: DOMAIN\Admin Correlation Id: 0c446604-dcc0-40b8-98a0-f06cdf31bc20 PWA Site URL: http://url SSP Name: SA-Project-01 PSError: CBSOlapDatabaseSetupFailure (17007) Project Server failed to generate an OLAP object. CBS queued message: 
    Setting UID=826307eb-5b55-4dae-ac06-f937924be574 ASServerName=AS-Server-DB10 ASDBName=NameOfTheCube01 ASExtraNetAddress= RangeChoice=2 PastNum=1 PastUnit=0 NextNum=1 NextUnit=0 FromDate=01/01/2011 00:00:00 ToDate=03/28/2011 00:00:00 HighPriority=True. Error: Error Setting Olap Database 'NameOfTheCube01' roles: Error: The following system error occurred: The parameter is incorrect.
    

     This error seems to have began when we added in the AD Enterprise Resource Pool group thousands of additional users.

    Also, we have done a SQL profiler of AS server when running the cube build process and retrieve this specific query which seems be the issue :

    <Alter AllowCreate="true" ObjectExpansion="ObjectProperties" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
         <Object>
          <DatabaseID>NameOfTheCube01</DatabaseID>
          <RoleID>ProjectServerViewOlapDataRole</RoleID>
         </Object>
         <ObjectDefinition>
          <Role xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:ddl200="http://schemas.microsoft.com/analysisservices/2010/engine/200" xmlns:ddl200_200="http://schemas.microsoft.com/analysisservices/2010/engine/200/200">
           <ID>ProjectServerViewOlapDataRole</ID>
           <Name>ProjectServerViewOlapDataRole</Name>
           <Members>
            <Member>
             <Name>DOMAIN\username</Name>
             <Sid>sid-numbers</Sid>
            </Member>
           </Members>
          </Role>
         </ObjectDefinition>
        </Alter>
    

    The members section contains all the Resource Pool accounts (~7300 accounts). I tried to parse this query directly in the Analysis Server and get the same error.

    Parsing the query ...
    The following system error occurred: The parameter is incorrect. 
    
    Parsing complete

    I'm able to parse the query correctly only if I limit the number of members. I was able to define that this query would parse correctly for 1820 members item and fail if members item > 1820.

    Is this somekind of limitation ?
    Is there a way to bypass this ?

    Regards,
    Wesley
     

    Thursday, March 31, 2011 4:30 PM

Answers

  • Well, after digging the whole process, we were able to resolve the issue and raise 2 important facts :
    - MS Analysis Server role's (at least for the ProjectServerViewOlapDataRole) members are limited to 1820 entries (user or group objects).
    - Project server will add individually the members of a security group (AD synched) which has the global permission "View OLAP Data" (instead of adding directly the AD group).

    Consequently, if your security group AD synchronized with the permission View OLAP Data contains more than 1820 members, the cube build (CBS) will fail with the very explicit error : "The following system error occurred: The parameter is incorrect."

    This can be reproduced at will either by running a XMLA operation in SSMS or directly by the GUI in SMSS.

    Maybe a MS engineer could  validate this behavior and provide a patch.

    Thanks,
    Wesley

    Thursday, March 31, 2011 7:17 PM

All replies

  • Well, after digging the whole process, we were able to resolve the issue and raise 2 important facts :
    - MS Analysis Server role's (at least for the ProjectServerViewOlapDataRole) members are limited to 1820 entries (user or group objects).
    - Project server will add individually the members of a security group (AD synched) which has the global permission "View OLAP Data" (instead of adding directly the AD group).

    Consequently, if your security group AD synchronized with the permission View OLAP Data contains more than 1820 members, the cube build (CBS) will fail with the very explicit error : "The following system error occurred: The parameter is incorrect."

    This can be reproduced at will either by running a XMLA operation in SSMS or directly by the GUI in SMSS.

    Maybe a MS engineer could  validate this behavior and provide a patch.

    Thanks,
    Wesley

    Thursday, March 31, 2011 7:17 PM
  • I am encountering a similar issue with 2008 R2 while running an XMLA script in SSMS.  I've confirmed the same magic #: 1,820 members is the maximum allowed.  Is there any word as to a fix for this issue?

    Thanks!

    Edward

    Thursday, October 10, 2013 7:08 PM
  • Hi Edward,

    Unfortunately, I never had any feedback from MS on this subject.

    Cheers,
    Wes

    Thursday, October 10, 2013 7:11 PM
  • Unfortunately this is a limitation on any SSAS Role, not just the ProjectServerViewOLAPData role.

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

    Thursday, October 10, 2013 8:43 PM
    Moderator