Internal Error during Cube Processing

Hi,

for almost 3 Months my cubes got processed without errors.

Since last night, I get an error saying that (freely translated from german):

"Internal error: Unexpected error (File 'pffilestore.cpp', Row 3311, PFFileStore::HandleDataPageFault-Function)"

Nothing else.

Google has nothing to say to that.

Anybody gaining the same error or even a hint?

Thanks.

Are you running out of disk space by any chance?|||

Hi,

monitored this already. No Problem, more than 0.5TB left on HD space.

Thanks.

|||

I am also receiving the 3311 Internal Error message when trying to process my cube.

Cube processing was working fine for months, then at the end of April / beginning of May I started getting the following Internal Error: file 'pffilestore.cpp', line 3267, function 'PFFileStore::HandleDataPageFault'

I installed SQL Server 2005 SP2 this week, and now I am getting the file 'pffilestore.cpp', line 3311, function 'PFFileStore::HandleDataPageFault' error.

In the processing options, I am specifying to "ConvertToUnknown" and "Ignore Errors".

Any help or suggestions are appreciated. Thanks.

|||

You will need to contact Microsoft support (tech support # 1-888-677-9444) to get the hotfix to either bring you to build 2223 if you are using SQL 2005 SP1 or build 3166 if you are using SQL 2005 SP2. If this hotfix does not resolve your issue, because it did not fix the issue for my MDX query that I was running, there is still an open bug SQL BU Defect Tracking #524029.

Here is a link to the knowledge base article for your issue (possibly): http://support.microsoft.com/default.aspx/kb/932610?sd=dell

You might be encountering the open bug though.

|||

I got the same thing today and searched msdn.

MS released 3157 build and it is fixed in that build.

http://support.microsoft.com/kb/936305/en-us .

You can find 932610.

James B. Lim

sql

internal error after applying post Sp2 fix KB901383-v8.00.1042

This is the error from the logfile. Any idea anyone?
w3wp!webserver!1228!08/16/2005-15:27:04:: e ERROR: Internal error:
System.MissingMethodException: Method not found: Int32
Microsoft.ReportingServices.Library.Global.get_ResponseBufferSizeBytes().
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
w3wp!library!1228!08/16/2005-15:27:04:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.MissingMethodException: Method not found: Int32
Microsoft.ReportingServices.Library.Global.get_ResponseBufferSizeBytes().
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
-- End of inner exception stack trace --I had previously installed Sp2 and the server worked fine. The installer
package for KB901383 would not install (reported some error about components
not included in package), so I extracted that file and found a xxx.msp file
which semed to install fine. I restarted the server and now when I try to
show a report then the result is:
* An internal error occurred on the report server. See the error log
for more details. (rsInternalError) Get Online Help
o Method not found: Int32
Microsoft.ReportingServices.Library.Global.get_ResponseBufferSizeBytes().
"Fredrik" wrote:
> This is the error from the logfile. Any idea anyone?
> w3wp!webserver!1228!08/16/2005-15:27:04:: e ERROR: Internal error:
> System.MissingMethodException: Method not found: Int32
> Microsoft.ReportingServices.Library.Global.get_ResponseBufferSizeBytes().
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> w3wp!library!1228!08/16/2005-15:27:04:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for more
> details., ;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for more
> details. --> System.MissingMethodException: Method not found: Int32
> Microsoft.ReportingServices.Library.Global.get_ResponseBufferSizeBytes().
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> -- End of inner exception stack trace --

Internal Error / internal catalog exception

Hi,

I've read already every thread in this forum regarding this topic with no results.

SQLServer and the corresponding services are at actual update level. The reporting services worked for 4 months without this problem. Suddenly, most of the time all reports return an internal error (it is like 70-30 for internal error) not depending which render format is used.

The system logs (eventlog, iis) show no errors. The ExecutionLog of RS show rsInternalError.

Looking in the log files in RS log directory, there is following stacktrace:

w3wp!processing!1!05/11/2007-10:40:06:: a ASSERT: Assertion failed! Call stack:
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension renderer, DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc, CreateReportChunk cacheDataCallback, Boolean& dataCached)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc)
Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext reportContext, ItemProperties properties, ParameterInfoCollection effectiveParameters, Guid reportId, ClientRequest session, String description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, Boolean cachingRequested, Boolean isLinkedReport, Warning[]& warnings, ReportSnapshot& resultSnapshotData, DateTime& executionDateTime, RuntimeDataSourceInfoCollection& alldataSources, UserProfileState& usedUserProfile)
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobType type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.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)

I don't see any hint in stack trace, Maybe one of yours.

As it seems, after an iisreset the first rendering always works perfect. HD space is enough.

Any ideas?

Got it.

As the error occured not every time and not depending any actions or rules, we decided to check the hardware and their corresponding drivers.

For the AMD Opteron single core processors in a multi processor environment, we used the generic microsoft drivers. After changing these to the original AMD ones, it works perfectly again.

Why it occured suddenly without any update or reboot is still not solved, but it works now.

Greez

T.

Internal Error / internal catalog exception

Hi,

I've read already every thread in this forum regarding this topic with no results.

SQLServer and the corresponding services are at actual update level. The reporting services worked for 4 months without this problem. Suddenly, most of the time all reports return an internal error (it is like 70-30 for internal error) not depending which render format is used.

The system logs (eventlog, iis) show no errors. The ExecutionLog of RS show rsInternalError.

Looking in the log files in RS log directory, there is following stacktrace:

w3wp!processing!1!05/11/2007-10:40:06:: a ASSERT: Assertion failed! Call stack:
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension renderer, DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc, CreateReportChunk cacheDataCallback, Boolean& dataCached)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc)
Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext reportContext, ItemProperties properties, ParameterInfoCollection effectiveParameters, Guid reportId, ClientRequest session, String description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, Boolean cachingRequested, Boolean isLinkedReport, Warning[]& warnings, ReportSnapshot& resultSnapshotData, DateTime& executionDateTime, RuntimeDataSourceInfoCollection& alldataSources, UserProfileState& usedUserProfile)
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobType type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.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)

I don't see any hint in stack trace, Maybe one of yours.

As it seems, after an iisreset the first rendering always works perfect. HD space is enough.

Any ideas?

Got it.

As the error occured not every time and not depending any actions or rules, we decided to check the hardware and their corresponding drivers.

For the AMD Opteron single core processors in a multi processor environment, we used the generic microsoft drivers. After changing these to the original AMD ones, it works perfectly again.

Why it occured suddenly without any update or reboot is still not solved, but it works now.

Greez

T.

Internal Email subscription fail

I'm having an issue with subscriptions. I created a subscription to
email a report both to an external address and internal address. The
subscription worked fine (Mail sent to ... ) in RS. The outside
entity received the email, but the internal entity does not receive
the email. Is there some configuration I'm missing on the exchange
side in order to accept a connection from RS? Thanks
DaveOn Aug 31, 3:29 pm, Dave <david.brueg...@.gmail.com> wrote:
> I'm having an issue with subscriptions. I created a subscription to
> email a report both to an external address and internal address. The
> subscription worked fine (Mail sent to ... ) in RS. The outside
> entity received the email, but the internal entity does not receive
> the email. Is there some configuration I'm missing on the exchange
> side in order to accept a connection from RS? Thanks
> Dave
It sounds more like your Exchange Server is filtering out the
extension type (i.e., PDF, MHTML, etc) of the report attached to the
email. Also, I'm not sure what the 'from' email is set to from SSRS;
however, if it is different than what is expected by the Exchange
Server, it may flag it as Spam. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultantsql

Internal Consistency Error, Restoring Backup

Hello,
I was wondering if any body has come accross this before, and if so could
offer some advice. It's got me scratching my head.
I have a database that is backed up each night using a maintenance plan.
I have come to attempt to restore this database and it always fails with the
following error,
"An internal consistency error occured. Contact technical support for
assistance.
RESTORE DATABASE terminating abnormaly"
No matter which of the 30 odd backups from the last month I try and on any
machine, I always get the same error.
Many thanks in advance for any help offered
Yours hopefully
Chris
chris.roberts@.optima-ws.comYOu should do as the error suggests and call PSS... It is possible your
database has been corrupt for quite some time, and therefore all of your
backups are also corrupt...
"Chris Roberts" <chris.roberts@.optima-ws.com> wrote in message
news:bivr6s$39p$1@.newsg1.svr.pol.co.uk...
> Hello,
> I was wondering if any body has come accross this before, and if so could
> offer some advice. It's got me scratching my head.
> I have a database that is backed up each night using a maintenance plan.
> I have come to attempt to restore this database and it always fails with
the
> following error,
> "An internal consistency error occured. Contact technical support for
> assistance.
> RESTORE DATABASE terminating abnormaly"
> No matter which of the 30 odd backups from the last month I try and on any
> machine, I always get the same error.
> Many thanks in advance for any help offered
> Yours hopefully
> Chris
> chris.roberts@.optima-ws.com
>|||No sure if it is corrupt, one more bit off info I've found out is that if I
preform a manual backup, it restores OK, it's only when I do a backup from
the maintenance plan that I get this error. It's also the same with all the
databases, not just one
"Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
news:O3C0XfUcDHA.652@.tk2msftngp13.phx.gbl...
> YOu should do as the error suggests and call PSS... It is possible your
> database has been corrupt for quite some time, and therefore all of your
> backups are also corrupt...
> "Chris Roberts" <chris.roberts@.optima-ws.com> wrote in message
> news:bivr6s$39p$1@.newsg1.svr.pol.co.uk...
> > Hello,
> >
> > I was wondering if any body has come accross this before, and if so
could
> > offer some advice. It's got me scratching my head.
> >
> > I have a database that is backed up each night using a maintenance plan.
> >
> > I have come to attempt to restore this database and it always fails with
> the
> > following error,
> >
> > "An internal consistency error occured. Contact technical support for
> > assistance.
> > RESTORE DATABASE terminating abnormaly"
> >
> > No matter which of the 30 odd backups from the last month I try and on
any
> > machine, I always get the same error.
> >
> > Many thanks in advance for any help offered
> >
> > Yours hopefully
> >
> > Chris
> > chris.roberts@.optima-ws.com
> >
> >
>

internal consistency error occurred while restoring a database

this is what i get when restoring a database from a *.bak file, knowing that this is the only backup file i have for my DELETED databases !!!
please help ASAP
Microsoft SQL-DMO (ODBC SQLState: 42000)
An internal consistency error occurred. Contact Technical Support for assistance.
RESTORE DATABASE is terminating abnormally.
I would try what the message suggests: contact PSS.
David Portas
SQL Server MVP