none
AX2009 SP1RU2 on W2K8 + SQL2K8 Reporting Services Error RRS feed

  • Вопрос

  • We are trying to setup a test environment on a single machine, but after
    following the installation steps and AX2009 SP1 update + RU2 steps we are
    getting the following errors on the Role Centers:

    On the CFO Profitability Analysis Web Part:
    Reporting Services Error
    An error has occurred during report processing. (rsProcessingAborted) Get
    Online Help
    The Value expression for the query parameter ‘Year’ contains an error: Index
    was outside the bounds of the array. (rsProcessingError) Get Online Help

    On the Top Customers by YTD Sales Web Part:
    Reporting Services Error
    An error has occurred during report processing. (rsProcessingAborted) Get
    Online Help
    The Value expression for the query parameter ‘EndDate’ contains an error:
    Index was outside the bounds of the array. (rsProcessingError) Get Online
    Help

    The setup is as following:
    1. AD
    2. IIS (no SSL)
    3. SQL2K8SP1
    4. O2K7SP2
    5. VS2K8SP1
    6. Terminal Services
    7. AX2009 RTM (patched for SQL2K8)
    8. .NET Business Connector
    9. Completed the checklist (recompile ...)
    10. Windows SharePoint Services SP2
    11. Enterprise Portal (with all the prerequisites)
    12. Reporting Extensions (with all the prerequisites)
    13. AX2009 SP1
    14. Completed the checklist (recompile ...)
    15. Analysis Extensions (with all the prerequisites)
    16. AX2009 SP1RU2
    17. Completed the checklist (recompile ...)
    18. Delpoyment of ODC files
    19. Workflow
    20. Development extensions
    21. Reports deployment

    The OS is Windows Server 2008 Standard x64 with SP2, also SQL2K8 is Enterprise x64 with SP1.

    User accounts created for:
    AXAOSSvc
    AXBusConn
    AXWorkflowExe
    AXWorkflowSvc
    SharePointSvc
    SQLSrvAgent
    SQLSrvAnalysisSvc
    SQLSrvDBEngine
    SQLSrvIntergrSvc
    SQLSrvRepSvc

    After the configuration steps, when we started again the AX Client we got
    some LogonAs errors, so we included the AXBusConn user into the Domain Admins
    group, this solved the LogonAs problems, but we are stucked at the above
    errors.

    We are trying to connect to AX using Administrator.

    This user is also in the CFO Role in Analysis Services.

    The user SQLSrvAnalysisSvc has public and db_datareader access to
    DynamicsAx1 database.


    Using another user (also with Domain Admin rights, in the same CFO role, and
    in Admin group from AX) we are getting an Access Denied error on the Role
    Center.

    To be able to test the installation we restored the Contoso Trans Demo data, following the DAT import steps

    Any help would be appreciated.
    9 сентября 2009 г. 9:23