Another "InternalCatalogException: An internal error occurred on the report server"

We have uploaded a report that works fine in development and works OK most
of the time on the production server but produces this internal error from
time to time.
Any advice would be REALLY appreciated.
cheers,
Paul.
w3wp!library!6!12/04/2007-19:15:56:: i INFO: Call to RenderNext( '/CRMTemp_MSCRM/Employee
Payslip' )
w3wp!processing!6!12/04/2007-19:15:56:: a ASSERT: Assertion failed! Call
stack:
Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatReader.Assert(Boolean
condition)
Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatReader.RegisterDefinitionObject(IDOwner
idOwner)
Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatReader.ReadReportItemBase(ReportItem
reportItem)
Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatReader.ReadReport(ReportItem
parent)
Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatReader.ReadSubReportInternals(ReportItem
parent)
Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatReader.ReadReportItem(ReportItem
parent)
Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatReader.ReadReportItemList(ReportItem
parent)
Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatReader.ReadReportItemCollection(ReportItem
parent)
Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatReader.ReadListInternals(ReportItem
parent)
Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatReader.ReadDataRegionInternals(ReportItem
parent)
Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatReader.ReadReportItem(ReportItem
parent)
Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatReader.ReadReportItemList(ReportItem
parent)
Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatReader.ReadReportItemCollection(ReportItem
parent)
Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatReader.ReadReport(ReportItem
parent)
Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatReader.ReadReportSnapshot()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.DeserializeReportSnapshot(GetReportChunk
getChunkCallback, CreateReportChunk createChunkCallback, GetResource getResourceCallback,
RenderingContext renderingContext, Hashtable& instanceObjects, Hashtable&
definitionObjects, State& declarationsRead, Boolean& isOldSnapshot)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(IRenderingExtension
renderer, CreateReportChunk createChunkCallback, RenderingContext rc, GetResource
getResourceCallback)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
Microsoft.ReportingServices.Library.RenderSnapshotAction.Render()
Microsoft.ReportingServices.Library.RSService.RenderFromSessionNoCache(CatalogItemContext
reportContext, ClientRequest session, RenderingResult& result)
Microsoft.ReportingServices.Library.RSService.RenderFromSession(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection&
effectiveParameters)
Microsoft.ReportingServices.Library.RSService.RenderNext(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection&
effecectiveParameters, String[]& secondaryStreamNames)
Microsoft.ReportingServices.Library.RenderNextCancelableStep.Execute()
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
Microsoft.ReportingServices.Library.RenderNextCancelableStep.RenderNext(RSService
rs, CatalogItemContext reportContext, ClientRequest session, JobType type,
Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]&
secondaryStreamNames)
Microsoft.ReportingServices.Library.RenderReportAction.Render(String format,
String deviceInfo)
Microsoft.ReportingServices.WebServer.ReportExecutionService.InternalRender(String
Format, String DeviceInfo, Stream& Result, String& Extension, String& MimeType,
String& Encoding, Warning[]& Warnings, String[]& StreamIds)
Microsoft.Reporting.WebForms.ServerReport.InternalRender(String format,
String deviceInfo, String& extension, String& mimeType, String& encoding,
String[]& streams, Warning[]& warnings)
Microsoft.Reporting.WebForms.ServerReport.Render(String format, String deviceInfo,
NameValueCollection additionalParams, String& mimeType, String& extension)
Microsoft.Reporting.WebForms.ServerReportControlSource.RenderReport(String
format, String deviceInfo, NameValueCollection additionalParams, String&
mimeType, String& fileExtension)
Microsoft.Reporting.WebForms.ReportControlSource.RenderReportHTML4(String
deviceInfo)
Microsoft.Reporting.WebForms.ReportControl.RenderReport(ReportControlSource
controlSource, String instanceIdentifier, String navigationID, ZoomMode zoomMode,
Int32 zoomPercent, Int32 pageNumber, String prefix, String searchText, String
linkTarget, String replacementRoot, String alertMessage, Boolean enableFindNext,
Boolean sizeToContent)
Microsoft.Reporting.WebForms.ReportAreaPage.OnPreRender(EventArgs e)
System.Web.UI.Control.PreRenderRecursiveInternal()
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint,
Boolean includeStagesAfterAsyncPoint)
System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint,
Boolean includeStagesAfterAsyncPoint)
System.Web.UI.Page.ProcessRequest()
System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
System.Web.UI.Page.ProcessRequest(HttpContext context)
System.Web.HttpServerUtility.ExecuteInternal(IHttpHandler handler, TextWriter
writer, Boolean preserveForm, Boolean setPreviousPage, VirtualPath path,
VirtualPath filePath, String physPath, Exception error, String queryStringOverride)
System.Web.HttpServerUtility.Transfer(IHttpHandler handler, Boolean preserveForm)
Microsoft.Reporting.WebForms.ReportAreaPageOperation.PerformOperation(NameValueCollection
urlQuery, HttpResponse response)
Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
System.Web.HttpApplication.ResumeSteps(Exception error)
System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext
context, AsyncCallback cb, Object extraData)
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
w3wp!library!6!12/04/2007-19:15:56:: 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.On Apr 12, 4:32 am, Paul Ritchie <REMOVEpritc...@.xtraREMOVE.co.nz>
wrote:
> We have uploaded a report that works fine in development and works OK most
> of the time on the production server but produces this internal error from
> time to time.
> Any advice would be REALLY appreciated.
> cheers,
> Paul.
> w3wp!library!6!12/04/2007-19:15:56:: i INFO: Call to RenderNext( '/CRMTemp_MSCRM/Employee
> Payslip' )
> w3wp!processing!6!12/04/2007-19:15:56:: a ASSERT: Assertion failed! Call
> stack:
> Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatReader.Assert(Boolean
> condition)
> Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatReader.RegisterDefinitionObject(IDOwner
> idOwner)
> Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatReader.ReadReportItemBase(ReportItem
> reportItem)
> Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatReader.ReadReport(ReportItem
> parent)
> Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatReader.ReadSubReportInternals(ReportItem
> parent)
> Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatReader.ReadReportItem(ReportItem
> parent)
> Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatReader.ReadReportItemList(ReportItem
> parent)
> Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatReader.ReadReportItemCollection(ReportItem
> parent)
> Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatReader.ReadListInternals(ReportItem
> parent)
> Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatReader.ReadDataRegionInternals(ReportItem
> parent)
> Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatReader.ReadReportItem(ReportItem
> parent)
> Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatReader.ReadReportItemList(ReportItem
> parent)
> Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatReader.ReadReportItemCollection(ReportItem
> parent)
> Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatReader.ReadReport(ReportItem
> parent)
> Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatReader.ReadReportSnapshot()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.DeserializeReportSnapshot(GetReportChunk
> getChunkCallback, CreateReportChunk createChunkCallback, GetResource getResourceCallback,
> RenderingContext renderingContext, Hashtable& instanceObjects, Hashtable&
> definitionObjects, State& declarationsRead, Boolean& isOldSnapshot)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(IRenderingExtension
> renderer, CreateReportChunk createChunkCallback, RenderingContext rc, GetResource
> getResourceCallback)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
> createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
> Microsoft.ReportingServices.Library.RenderSnapshotAction.Render()
> Microsoft.ReportingServices.Library.RSService.RenderFromSessionNoCache(CatalogItemContext
> reportContext, ClientRequest session, RenderingResult& result)
> Microsoft.ReportingServices.Library.RSService.RenderFromSession(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection&
> effectiveParameters)
> Microsoft.ReportingServices.Library.RSService.RenderNext(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection&
> effecectiveParameters, String[]& secondaryStreamNames)
> Microsoft.ReportingServices.Library.RenderNextCancelableStep.Execute()
> Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
> Microsoft.ReportingServices.Library.RenderNextCancelableStep.RenderNext(RSService
> rs, CatalogItemContext reportContext, ClientRequest session, JobType type,
> Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]&
> secondaryStreamNames)
> Microsoft.ReportingServices.Library.RenderReportAction.Render(String format,
> String deviceInfo)
> Microsoft.ReportingServices.WebServer.ReportExecutionService.InternalRender(String
> Format, String DeviceInfo, Stream& Result, String& Extension, String& MimeType,
> String& Encoding, Warning[]& Warnings, String[]& StreamIds)
> Microsoft.Reporting.WebForms.ServerReport.InternalRender(String format,
> String deviceInfo, String& extension, String& mimeType, String& encoding,
> String[]& streams, Warning[]& warnings)
> Microsoft.Reporting.WebForms.ServerReport.Render(String format, String deviceInfo,
> NameValueCollection additionalParams, String& mimeType, String& extension)
> Microsoft.Reporting.WebForms.ServerReportControlSource.RenderReport(String
> format, String deviceInfo, NameValueCollection additionalParams, String&
> mimeType, String& fileExtension)
> Microsoft.Reporting.WebForms.ReportControlSource.RenderReportHTML4(String
> deviceInfo)
> Microsoft.Reporting.WebForms.ReportControl.RenderReport(ReportControlSource
> controlSource, String instanceIdentifier, String navigationID, ZoomMode zoomMode,
> Int32 zoomPercent, Int32 pageNumber, String prefix, String searchText, String
> linkTarget, String replacementRoot, String alertMessage, Boolean enableFindNext,
> Boolean sizeToContent)
> Microsoft.Reporting.WebForms.ReportAreaPage.OnPreRender(EventArgs e)
> System.Web.UI.Control.PreRenderRecursiveInternal()
> System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint,
> Boolean includeStagesAfterAsyncPoint)
> System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint,
> Boolean includeStagesAfterAsyncPoint)
> System.Web.UI.Page.ProcessRequest()
> System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
> System.Web.UI.Page.ProcessRequest(HttpContext context)
> System.Web.HttpServerUtility.ExecuteInternal(IHttpHandler handler, TextWriter
> writer, Boolean preserveForm, Boolean setPreviousPage, VirtualPath path,
> VirtualPath filePath, String physPath, Exception error, String queryStringOverride)
> System.Web.HttpServerUtility.Transfer(IHttpHandler handler, Boolean preserveForm)
> Microsoft.Reporting.WebForms.ReportAreaPageOperation.PerformOperation(NameValueCollection
> urlQuery, HttpResponse response)
> Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
> System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
> System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
> System.Web.HttpApplication.ResumeSteps(Exception error)
> System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext
> context, AsyncCallback cb, Object extraData)
> System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
> System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
> System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
> w3wp!library!6!12/04/2007-19:15:56:: 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.
This link MS might be helpful:
http://support.microsoft.com/default.aspx/kb/895980/en-us
Regards,
Enrique Martinez
Sr. Software Consultant|||We have the same problem. This is really annoying. Have anyone found a solution for this problem?
Any - really any help would be useful.
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

Analysis Services Deployment/Management Question

I have a local server for development that is on my local domain that I can work on very easily. However, my production server is offsight and on a different domain. Since Management Studio will only allow Windows Authentication when connecting to an Analysis Services instance, how can I manage the remote cube without having to remote desktop into the production server?

TIA

Right, you need to either TS to the machine, or establish a VPN connection to the domain. One possible, solution would be to use SQL Managment Studio against your local AS database, and instead of committing the changes, script out the XMLA. Then, if you had an http pump setup on a middle-tier, you could send the XMLA to via http using an admin user basic authentication that you create and you'd have a way to effectively do the administrative actions that you want. This isn't straightforward, but would get the job done.

Hope that helps.