Reporting Service ReportRendering Error

Hello,
After running a report using reporting services, we are receiving the
following error:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. (rrRenderingError) Get Online Help
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
An error has occurred during rendering of chart chart1. Details: Cannot find
font '?'. (rsErrorDuringChartRendering) Get Online Help
Cannot find font '?'.
Has anyone experienced this problem?
We have installed Service Pack 1 for Reporting Services.
We are running SQL Server 2000 Service Pack 3.
IIS 5.0
Windows Server 2000
Thank you.Did you ever resolve this? I'm getting the same error; it happens only on
the one report we have that generates a line chart. We're on SQL Server 2000
SP4 and RS SP2. We've tried copying the fonts from another server where the
problem does not occur, but it still fails.
"Dudi Nissan" wrote:
> Hello,
> After running a report using reporting services, we are receiving the
> following error:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. (rrRenderingError) Get Online Help
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown.
> An error has occurred during rendering of chart chart1. Details: Cannot find
> font '?'. (rsErrorDuringChartRendering) Get Online Help
> Cannot find font '?'.
> Has anyone experienced this problem?
> We have installed Service Pack 1 for Reporting Services.
> We are running SQL Server 2000 Service Pack 3.
> IIS 5.0
> Windows Server 2000
> Thank you.

reporting service

While generating the matrix report Reporting services giveing below
problem.
An error has occurred during report processing Exception of type
'System.OutOfMemoryException' was thrown
If anybody boddy face the same problem pls tell me the sol.It might be the problem such that you have extended the no of columns
in the matrix it can show. I am not sure about the exact count. but
try to run the query on analyser first, check the No of columns and
Rows.second, Create a table in the layout ,drag and drop the values.
Run the preview,Next use matrix and try to Pivot your requiement
(Columns into Rows and Rows into columns) .finally your requirement.
Debug at each and every stage
Thanks
Raj Deep.A
On Apr 2, 5:59=A0pm, nannuri.sr...@.gmail.com wrote:
> While generating the matrix report Reporting services giveing below
> problem.
> An error has occurred during report processing Exception of type
> 'System.OutOfMemoryException' was thrown
> If anybody boddy face the same problem pls tell me the sol.

reporting server failing....System outof memory exception

Hi :

We have a setup reporting services for reporting...and our reports are working fine for 100-200 thousand records which is basically 1 year worth of data.

The reporting server fails when it starts processing beyond 200 thousand records...when I check the reporting log I see System outof memory exception. The reporting server has 8GB of ram and its a blade server. I dont know how to solve this issue.

Please let me know where I am doing wrong....

Thanks,

Pramod

Are you sure that SQL Server has not been restricted in how much memory is available for it to use?

Also as a general rule, I try to return as little data in the dataset for RS to process as possible. So it's better to do some GROUP BY clases in your query rather than returning all records and letting RS do the Sums.

|||You'll want to make sure SQL Server is actually "seeing" all 8 gig of ram ... I've seen a lot of admins forget to configure AWE.|||Yep sql server is made available all 7 gb of 8 gb ram...by setting /7gb in boot.ini.|||Yes adam...the RS is after group by of all fields....other wise i would get a million records without group by....

Reporting instsallion-problem, initialize RS and security exception

Hi all RS professinal,
I am deploying RS on SQL 2000/sp4 on win2003 sp1.
after we install RS on it. it is running well until the last moment. It said
" setup could not initialize the report server. You must manually initialize
the report server before using it for the first time. For more information,
see the Reporting Services setup documentation"
Then we uninstall it, and then install again, which have the same result.
Then we manually activate it by issuing " rsactivate -c"D:\Program
Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\RSReportServer.config" -t "
it shows the following error
Failure starting the web service:
System.Exception: The Report Server Web service has not generated a public
key.
The service may not have started successfully. Check the log files for
more in
formation.
at
Microsoft.ReportingServices.RSActivate.RSActivate.RpcActivateService(Int32
clientType)
at Microsoft.ReportingServices.RSActivate.RSActivate.InstanceMain()
at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
Bas
eCmdLine instance)
when we open http://localhost/reports . it shows the error as attached
Security Exception:
Description: The application attempted to perform an operation not allowed
by the security policy. To gran this applicatino the rqiured permission ,
please contact your system administrator or change the applications trust
level in the configuration file.
we have granted admin right the IUSR_localhost account.
Any Expert can give us opinions on it?
Thanks for millions
PatrickHi Patrick,
I am having an exact same problem as you.
I have Windows Server 2003 SP1, SQL 2000 Standard SP4, no SSL, got the same
error message.
Do you have any luck?
BTW, I have another Windows server 2003 (No SP1), SQL Server SP3, with
Visual Studio .NET install. It worked.
Thanks
Skip
"Patrick Lam" wrote:
> Hi all RS professinal,
> I am deploying RS on SQL 2000/sp4 on win2003 sp1.
> after we install RS on it. it is running well until the last moment. It said
> " setup could not initialize the report server. You must manually initialize
> the report server before using it for the first time. For more information,
> see the Reporting Services setup documentation"
> Then we uninstall it, and then install again, which have the same result.
> Then we manually activate it by issuing " rsactivate -c"D:\Program
> Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer\RSReportServer.config" -t "
> it shows the following error
> Failure starting the web service:
> System.Exception: The Report Server Web service has not generated a public
> key.
> The service may not have started successfully. Check the log files for
> more in
> formation.
> at
> Microsoft.ReportingServices.RSActivate.RSActivate.RpcActivateService(Int32
> clientType)
> at Microsoft.ReportingServices.RSActivate.RSActivate.InstanceMain()
> at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
> Bas
> eCmdLine instance)
> when we open http://localhost/reports . it shows the error as attached
> Security Exception:
> Description: The application attempted to perform an operation not allowed
> by the security policy. To gran this applicatino the rqiured permission ,
> please contact your system administrator or change the applications trust
> level in the configuration file.
>
> we have granted admin right the IUSR_localhost account.
> Any Expert can give us opinions on it?
> Thanks for millions
> Patrick
>
>