Inconsistent Error: Subreport could not be shown -- timeout proble

[AJ Cohen]

I'm running several hundred parameterized versions of the same report on a
single shared (timed) schedule. The reports have a dozen or more sub-reports.
I'm getting sporadic instances of the report where I get the infamous "Error:
Subreport could not be shown." Usually all of the subreports fail, but
sometimes the failure occurs late in the report. When that happens, all of
the rest of the sections fail, except the last section which is text-only and
has no data connection.

It appears that the problem is related to the data connection for that
report. I have the Site Settings page set for "Do not timeout report
execution".

When the reports fail, I am able to generate the report using the failed
parameters through a manual request, with no errors. The problem appears only
when I run the reports on a schedule. Some of the reports have no data. But
there are reports with no data that generate correctly (they have no data,
and no un-user-friendly error message). But several of the failing reports do
have data.

Any thoughts on this issue? Anyone having similar problems?

TIA...

[Peter Yang [MSFT]]

Hello,

It seems to be a performance related issue. You may want to check the
report log to see if there is any related errors. You can specify the level
of information that gets recorded to trace logs and which components are
traced. All configuration settings that affect tracing are located
in the ReportingServicesService.config file and the Web.config file in the
c:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer
directory.

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================


This posting is provided "AS IS" with no warranties, and confers no rights.




--------------------
| Thread-Topic: Inconsistent Error: Subreport could not be shown -- timeout
proble
| thread-index: AcWL6g5x/FsoFVWvQA617ctmNcNLKg==
| X-WBNR-Posting-Host: 67.165.139.165
| From: "=?Utf-8?B?QUogQ29oZW4=?=" <***@nospam.nospam>
| Subject: Inconsistent Error: Subreport could not be shown -- timeout
proble
| Date: Mon, 18 Jul 2005 15:43:03 -0700
| Lines: 22
| Message-ID: <7690B213-4C40-4104-A200-***@microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:48318
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I'm running several hundred parameterized versions of the same report on
a
| single shared (timed) schedule. The reports have a dozen or more
sub-reports.
| I'm getting sporadic instances of the report where I get the infamous
"Error:
| Subreport could not be shown." Usually all of the subreports fail, but
| sometimes the failure occurs late in the report. When that happens, all
of
| the rest of the sections fail, except the last section which is text-only
and
| has no data connection.
|
| It appears that the problem is related to the data connection for that
| report. I have the Site Settings page set for "Do not timeout report
| execution".
|
| When the reports fail, I am able to generate the report using the failed
| parameters through a manual request, with no errors. The problem appears
only
| when I run the reports on a schedule. Some of the reports have no data.
But
| there are reports with no data that generate correctly (they have no
data,
| and no un-user-friendly error message). But several of the failing
reports do
| have data.
|
| Any thoughts on this issue? Anyone having similar problems?
|
| TIA...
|

[Julich]

Subreport could not be shown." Usually all of the subreports fail, but
sometimes the failure occurs late in the report. When that happens, all
of
the rest of the sections fail"

--> I encounter the very same problem. I have a report (with 5
parameters) with 3 subreports. Subreports 1 and 3 always work. But
sometimes, when particular parameter is chosen, some data is missing
and the second subreport may not be displayed correctly and the
"Subreport could not be shown" is displayed.

As soon as the second subreport doesn't work, the third one doesn't
work either (and I know it should work all the time, since it works
when I call it directly through a manual request, with the very same
parameters which make the second subreport fail...)

Julich