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
