Some reports from Reporting extensions can raise error when running on SQL 2008 R2

Thanks to our colleague in Japan we found problem when running some Dynamics AX reporting extensions report on SQL 2008 R2. When we open some standard SSRS reports with SQL2008R2 (ie. TSInvoicedPurchaseAmount.TS_InvoicedPurchaseAmountDetail.Report ), we receive following error. An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset ‘InvoiceAmountDetailedReport’. (rsErrorExecutingCommand) Query (58, 19)…

0

Dynamics AX OLAP cubes shows data only till 2008 year

Some time ago we run into following problem. When we browsed Accounts Receivable Cube for Total Sales dimension we could see data only till 2008 year, the data for years: 2009, 2010 and 2011 where just simple not displayed. The first idea was to try solution from following post: http://blogs.msdn.com/b/emeadaxsupport/archive/2011/01/07/olap-time-dimension-does-not-contain-dates-for-year-2011.aspx but it did not help….

0

Query execution failed for data set ‘Company’

Recently we were having problems to get the Role Center up and running. Report Server is setup and working in a correct way. Most reports can be generated, but a few does not answer correct. For those report the following error is generated: “Query execution failed for data set ‘Company’” Reports in Role Center can…

0

Unable to install Dynamics AX 2009 Analysis extensions when the default SQL Server Analysis Server collation is set to Turkish_CI_AS or Turkish_CS_AS

We came across an issue where by after installing the Dynamics AX 2009 Analysis Extensions sucessfully, no database is created! Even if you manually try to create the Dynamics AX Analysis database from the analysis script file DynamicsAX.xmla (found under the installation media in “\support\Analysis Services\Scripts\” folder), you get the following error message: <BR><return xmlns=”urn:schemas-microsoft-com:xml-analysis”>   <results xmlns=”http://schemas.microsoft.com/analysisservices/2003/xmla-multipleresults“>     <root…

0

Kerberos authentication issues in a multi server environment affecting only the KPI web part

When you are setting up Dynamics AX 2009 Role Center and Enterprise Portal in a multi server environment where each component is running on Windows Server 2008 you may get confronted with an authentication issue. The base requirement for a multi server scenario to work is to use Kerberos authentication and configuring Service Principle Names…

0

SQL Execution Error. The multi-part identifier … could not be bound.

We were running lately into an issue with Dynamics AX 2009 and Microsoft SQL Server 2008 Analysis Services after switching the data source provider from SQLNCLI.1 (Microsoft SQL Server 2005 Native Client) to SQLNCLI10.1 (Microsoft SQL Server 2008 Native Client). The switch was necessary as the provider SQLNCLI.1 (Microsoft SQL Server 2005 Native Client) was…

0

An error has occurred during report processing. (rsProcessingAborted)

In Dynamics AX 2009 a very common scenario with Enterprise Portal and Role Center is that only users that are local Administrators on the machine where Microsoft SQL Server 2005 is installed can correctly see Microsoft SQL Server 2005 Reporting Services reports (based on Microsoft SQL Server 2005 Analysis Services). All the non-admin users see…

0

Connecting from Dynamics AX 4.0 Client to Microsoft SQL Server 2008 Analysis Services fails

Recently when I was trying to access an OLAP cube on Microsoft SQL Server 2008 Analysis Services from within the Dynamics AX 4.0 Client I was running into the error message: One or more required client components that support OLAP analysis are not installed on this computer. For details on the required components, in Administrator…

1

Installing Microsoft Dynamics AX 2009 Analysis Extensions on a Microsoft SQL Server 2005 Analysis Services Failover Cluster

When you are trying to install the Microsoft Dynamics AX 2009 Analysis Extensions on a Microsoft SQL Server 2005 Analysis Services Failover Cluster you will run into the following error: Connecting to SQL Server 2005 Analysis Services on server ‘SQLAS’ and instance ‘MSOLAP$SQLASCLUSTER’. A connection cannot be made. Ensure that the server is running. No…

1