AX 2009 Reports are frozen in the Microsoft Dynamics AX VPC In Hyper V server

When we run the AX SSRS reports in the Microsoft Dynamics AX VPC, we find that the reports is generating but don’t show it some times.

The error log in the SQL Reporting server is:

w3wp!library!1!11/20/2009-09:27:08:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An
internal error occurred on the report server. See the error log for more
details., un-named assertion fired for component processing;

 Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details.

w3wp!library!1!11/20/2009-09:27:49:: i INFO: Exception dumped to:
c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles
flags= ReferencedMemory, AllThreads, SendToWatson

w3wp!library!7!11/20/2009-09:28:10:: i INFO: Call to RenderFirst(
‘/Dynamics/en-US/EPS_LeadTimeContactToSold.Leadtimetosold.Leadtimetosold’ )

w3wp!processing!7!11/20/2009-09:28:10:: a
ASSERT: Assertion failed!  


The problem is caused by the CPU for the VPC as we increased 4 CPUs to use but SQL Server 2005 SP2 cannot support multiple CPUs.

The Solution is to install the SQL Server CU5 or upgrade SP2 to SP3. CU5 or above and SP3 can support multiple CPUs.
Advertisements
This entry was posted in Dynamics AX and SQL Server. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s