Error 0x800C0008 with multiple subreports

Hi,

strange behaviour in our production environment, while in the test servers all goes ok:

web application with web report viewer, the report is fine but clicking on "preview" or "print" an error 0x800C008 occurs.

The report include 3 subreports, and here's the problem: after some attempts i realized that each subreport (alone in the master report) works fine, but more than 1 in the same master report produces the error!

Here is the log:

w3wp!library!7!04/17/2007-11:23:55:: i INFO: Call to RenderNext( '/WRReports/Orders' )
w3wp!processing!7!04/17/2007-11:23:55:: 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.Library.AsyncExecution.AsyncStartMain(Object state)
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
Microsoft.ReportingServices.Diagnostics.ThreadWorkItem.SafeThreadPoolCallback(Object ctx)
System.Threading._ThreadPoolWaitCallback.WaitCallback_Context(Object state)
System.Threading.ExecutionContext.runTryCode(Object userData)
System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
System.Threading._ThreadPoolWaitCallback.PerformWaitCallback(Object state)

w3wp!library!7!04/17/2007-11:23:55:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: Errore interno nel server di report. Per ulteriori informazioni, vedere il log degli errori., un-named assertion fired for component processing;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: Errore interno nel server di report. Per ulteriori informazioni, vedere il log degli errori.

Any ideas?

Thanks in advance to anyone

Hi all,

we found the solution and so we can post it for public utility.

The problem were related to the size of reports.

When reports exceed a few bytes, reporting services uses a "transfer-enconding: chunked" header in the http message from the rssclientreport object in the html page.

So, a proxy in the middle of our architecture were unable to do its job because it didn't understand that header; an installation of the last version of that proxy solved the problem.

We didn't found any way to change that behavior of ssrs2005 and forcing it to use standard transfer encoding.

bye.

Error 0x800C0008 with multiple subreports

Hi,

strange behaviour in our production environment, while in the test servers all goes ok:

web application with web report viewer, the report is fine but clicking on "preview" or "print" an error 0x800C008 occurs.

The report include 3 subreports, and here's the problem: after some attempts i realized that each subreport (alone in the master report) works fine, but more than 1 in the same master report produces the error!

Here is the log:

w3wp!library!7!04/17/2007-11:23:55:: i INFO: Call to RenderNext( '/WRReports/Orders' )
w3wp!processing!7!04/17/2007-11:23:55:: 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.Library.AsyncExecution.AsyncStartMain(Object state)
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
Microsoft.ReportingServices.Diagnostics.ThreadWorkItem.SafeThreadPoolCallback(Object ctx)
System.Threading._ThreadPoolWaitCallback.WaitCallback_Context(Object state)
System.Threading.ExecutionContext.runTryCode(Object userData)
System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
System.Threading._ThreadPoolWaitCallback.PerformWaitCallback(Object state)

w3wp!library!7!04/17/2007-11:23:55:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: Errore interno nel server di report. Per ulteriori informazioni, vedere il log degli errori., un-named assertion fired for component processing;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: Errore interno nel server di report. Per ulteriori informazioni, vedere il log degli errori.

Any ideas?

Thanks in advance to anyone

Hi all,

we found the solution and so we can post it for public utility.

The problem were related to the size of reports.

When reports exceed a few bytes, reporting services uses a "transfer-enconding: chunked" header in the http message from the rssclientreport object in the html page.

So, a proxy in the middle of our architecture were unable to do its job because it didn't understand that header; an installation of the last version of that proxy solved the problem.

We didn't found any way to change that behavior of ssrs2005 and forcing it to use standard transfer encoding.

bye.

Error : Timeout expired. The timeout period elapsed...

Hi,

Iget this error from our web application every once in a while. " Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding". I emailmyself when an error occurs, and once every 2-3 days I get this timeouterror emails, like 5-10 emails in a span of few minutes. Then it goesaway. I have set the command timeout for 60 secs.

Itdoesn't happen from the same stored procedure, actually I have seen ittimeout from really simple 1 or 2 line stored procedures, which shouldn't normally take 1 sec. Its likesql server just shuts down for few minutes. We have somebackups and maintenance jobs scheduled, but they run only aftermidnight. I have checked theapplication event viewer, there are no warnings orerror messages forMSSQLSERVER.

Canany one tell me how to check whats going on during that short timespanwhen timeout error occurs, and what causes it? I don't want to run sqlprofiler continuously for 2-3 days, I am afraid it will slow down theserver more.

Thanks.

It could be locking|||Sorry, that was a bit laconic. I meant it could be table (or page) locking. I don't think you can do much without running the profiler or at least a good error logging so that you would isolate the scenario. In the mean time you could be looking for concurent access to those records|||

websolutions:

Sorry, that was a bit laconic. I meant it could be table (or page) locking. I don't think you can do much without running the profiler or at least a good error logging so that you would isolate the scenario. In the mean time you could be looking for concurent access to those records

I agree read the performance tuning tips in the link below and run SQL Server profiler to find out what is causing your error. Hope this helps.

http://msdn.microsoft.com/msdnmag/issues/06/07/WebAppFollies/default.aspx

Error : Timeout expired

I am developing a .NET web application. We are using SQL 2000. I am getting
this Exception message while executing a query.
"Timeout expired. The timeout period elapsed prior to completion of the
operation or the server is not responding."
This query fails when I execute it for the first time. After ttat the query
works most of the times, but I still receive this message sometimes. I am
unable to find out why this occurs.
This is query that is causing the timeout exception
private const string SQL_UNASSIGN_TRAINING = "UPDATE tblAssignedTraining
SET IsWaivedOff = 1 WHERE TrainingId = @.TrainingId AND UserId = @.UserId AND
Status <> 4";
The following is the database design for the tblAssignedTraining table.
Status - Integer (can have value 1, 2, 3 or 4)
TrainingId - Integer
UserId - varchar(50)
IsWaivedOff - Bit
Any help would be highly appreciated.
TIA,
GaryWhen posting table structure, please post DDL (CREATE TABLE statements)
including relevant constraints and indexes.
To prevent a table scan, you'll need an index (or primary key or unique
constraint) on TrainingId and/or UserId. This will help both
performance and concurrency.
You can set the CommandTimeout property of your command object to
override the default (which I believe is 30 seconds). Also, there is a
bug in the .NET Framework 1.0 in which the timeout setting was not
honored under certain conditions. This was corrected in .NET Framework
1.0 SP2 and does not occur with .NET Framework 1.1.
--
Hope this helps.
Dan Guzman
SQL Server MVP
--
SQL FAQ links (courtesy Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
--
"Gary" <msnews@.microsoft.com> wrote in message
news:OcOQv6NXDHA.212@.TK2MSFTNGP12.phx.gbl...
> I am developing a .NET web application. We are using SQL 2000. I am
getting
> this Exception message while executing a query.
> "Timeout expired. The timeout period elapsed prior to completion of
the
> operation or the server is not responding."
> This query fails when I execute it for the first time. After ttat the
query
> works most of the times, but I still receive this message sometimes. I
am
> unable to find out why this occurs.
> This is query that is causing the timeout exception
> private const string SQL_UNASSIGN_TRAINING = "UPDATE
tblAssignedTraining
> SET IsWaivedOff = 1 WHERE TrainingId = @.TrainingId AND UserId =@.UserId AND
> Status <> 4";
> The following is the database design for the tblAssignedTraining
table.
> Status - Integer (can have value 1, 2, 3 or 4)
> TrainingId - Integer
> UserId - varchar(50)
> IsWaivedOff - Bit
> Any help would be highly appreciated.
> TIA,
> Gary
>
>|||You should have an index on one of the columns to ensure the query executes
fast...
"Gary" <msnews@.microsoft.com> wrote in message
news:OcOQv6NXDHA.212@.TK2MSFTNGP12.phx.gbl...
> I am developing a .NET web application. We are using SQL 2000. I am
getting
> this Exception message while executing a query.
> "Timeout expired. The timeout period elapsed prior to completion of the
> operation or the server is not responding."
> This query fails when I execute it for the first time. After ttat the
query
> works most of the times, but I still receive this message sometimes. I am
> unable to find out why this occurs.
> This is query that is causing the timeout exception
> private const string SQL_UNASSIGN_TRAINING = "UPDATE tblAssignedTraining
> SET IsWaivedOff = 1 WHERE TrainingId = @.TrainingId AND UserId = @.UserId
AND
> Status <> 4";
> The following is the database design for the tblAssignedTraining table.
> Status - Integer (can have value 1, 2, 3 or 4)
> TrainingId - Integer
> UserId - varchar(50)
> IsWaivedOff - Bit
> Any help would be highly appreciated.
> TIA,
> Gary
>
>

Error "Provider cannot be found. It may not be properly installed." after deploying ap

hello folks

i have recently started to work with the analysis services and i am having some problems.

i have made a web application that for now just tries to connect to an analysis server.

The server is installed on an xp sp 2 system.

for testing, i used my local computer, which is running also win xp sp2. After deploying, the application can connect to the AS server on the other machine. the problem occurs when i try to deploy the applicatuion on the production server, which is running win 2k3 server on 32 bit. When deploying, i use the same connection string, so it should try to connect to the AS server installed on a win xp sp2 system.

The first thing that came to my mind was to check the MDAC versions, be cause of the message: "Provider cannot be found. It may not be properly installed."

on my computer, where the application worked ok, the version is MDAC 2.8 SP 1 Windows XP SP 2

on the win2k3 server, the MDAC version is : MDAC 2.8 SP2.... i thought it was the version of the service pack, so o searched for the update of MDAC 2.8 SP1, trying to install mdac 2.8 sp2 to see if i was to see the same error, but i found that mdac 2.8 sp2 is only for win2k3 server, and for win xp is mdac 2.8 sp1, according to this link: http://support.microsoft.com/default.aspx/kb/884103

Now i got confused and have no clues how to make this work...

Can anybody give any hint?

?|||

The Analysis Services provider is not part of the core MDAC, it is available for download from the feature pack at http://www.microsoft.com/downloads/details.aspx?familyid=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&displaylang=en

look for the downloads under Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider