Sql Report protection: fails

Showing posts with label fails. Show all posts

Friday, March 30, 2012

ReportBuilder & FQDN

Anyone run into this?

ReportBuilder fails to load when using a FQDN (fully qualified domain name) URL.
ie: http://servername.xyz.company.com/Reports/Pages/Folder.aspx

ReportBuilder loads with no issue when using the shortname URL.
ie: http://servername/Reports/Pages/Folder.aspx

details:

ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later in the log.
* Activation of http://servername.xyz.company.com/ReportServer/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected:
+ Downloading http://servername.xyz.company.com/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
+ The remote server returned an error: (403) Forbidden.

COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.

WARNINGS
There were no warnings during this operation.

Nevermind Figured it out -

Modify RSWebApplication.config for Hard IP.

<ReportServerUrl>http://<Site IP Address>/ReportServer</ReportServerURL>

Works - just recycle the application pools in IIS. By the way if you are configuring the manager for a non-default IP address be carefull. For some reason the report manager does not like a <ReportServerVirtualDirectory> value if <ReportServerURL> is supplied.

Report works fine stand alone, but fails when used as subreport

I have a report which I have tested and works fine. now I'm trying to use it as a subreport. the "outer" or main report is very simple: it just has a company standard banner and some header/footer information, and then a single subreport. there is no passing of parameters between main report and sub report. the subreport does have its own parameter to govern its dataset, and provides its own default for that.

The error that I'm getting is this:

[rsErrorExecutingSubreport] An error occurred while executing the subreport ‘subreport1’: An error has occurred during report processing.

[rsMissingFieldInDataSet] The data set ‘WarrantMasterCube’ contains a definition for the Field ‘Year’. This field is missing from the returned result set from the data source.

[rsErrorReadingDataSetField] The data set ‘WarrantMasterCube’ contains a definition for the Field ‘Year’. The data extension returned an error during reading the field.

[rsMissingFieldInDataSet] The data set ‘WarrantMasterCube’ contains a definition for the Field ‘Month’. This field is missing from the returned result set from the data source.

[rsErrorReadingDataSetField] The data set ‘WarrantMasterCube’ contains a definition for the Field ‘Month’. The data extension returned an error during reading the field.

[rsMissingFieldInDataSet] The data set ‘WarrantMasterCube’ contains a definition for the Field ‘Date’. This field is missing from the returned result set from the data source.

[rsErrorReadingDataSetField] The data set ‘WarrantMasterCube’ contains a definition for the Field ‘Date’. The data extension returned an error during reading the field.

[rsMissingFieldInDataSet] The data set ‘WarrantMasterCube’ contains a definition for the Field ‘Wt_TO_MTD’. This field is missing from the returned result set from the data source.

[rsErrorReadingDataSetField] The data set ‘WarrantMasterCube’ contains a definition for the Field ‘Wt_TO_MTD’. The data extension returned an error during reading the field.

[rsNone] An error has occurred during report processing.

Of course, this doesn't happen when I execute the subreport by itself. What kinds of things should I be looking at to get to the bottom of this. Thanks!

Try by giving default value for your subreport.

Thanks

Raj Deep.A

|||

As noted above, the report being used as a subreport does have its own default parameter.

The error actually went away without me changing anything in my reports. What I did was leave teh subreport open in preview mode, tehn preview the main report. this seemed to fix the "fields not found" error.

I then edited the parameters property of the subreport object embedded in the main report, so that the user chosen parameter value in the outer report passes through to the subreport, and it all works fine.

Basically there must be some flakiness in some internal component that was causing the error.

Monday, March 12, 2012

Report Snapshot creation fails on large result set

Hello world,
I have some reports that run fine when I use the "Render this report with the
most recent data" selected, but when I want to create a Snapshot it fails to
produce a snapshot. It also depends on how much data I select via the
parameters. If I want a small result set it works, but if I select a large
set it displayes several (3) times the windows login popup (asking my
password each time) and in the end it shows a "You are not authorized to view
this page" error.
The large selection runs for about 7 minutes, the smaller about 2 and does
NOT show the login popup.
The server is in another domain than my login but it is in the "Local
Intranet" in the IE security setup and uses "Automatic logon with current
user credentials"
I suspect it is a recource problem, but I have no idea what causes this
problem.
Can you please help me?
Regards, JanHi,
to answer my own question after wasting a lot of time chasing wrong
leads ;-)
It was the IIS connection-timeout of the report manager; default 120
sec. If the query ran longer than that, it failed. I set it to 15
minutes and now all snapshots are created just fine.
Regards,
Jan Lubbers via SQLMonster.com schreef:
> Hello world,
> I have some reports that run fine when I use the "Render this report with the
> most recent data" selected, but when I want to create a Snapshot it fails to
> produce a snapshot. It also depends on how much data I select via the
> parameters. If I want a small result set it works, but if I select a large
> set it displayes several (3) times the windows login popup (asking my
> password each time) and in the end it shows a "You are not authorized to view
> this page" error.
> The large selection runs for about 7 minutes, the smaller about 2 and does
> NOT show the login popup.
> The server is in another domain than my login but it is in the "Local
> Intranet" in the IE security setup and uses "Automatic logon with current
> user credentials"
> I suspect it is a recource problem, but I have no idea what causes this
> problem.
> Can you please help me?
> Regards, Jan|||Hi,
to answer my own question after wasting a lot of time chasing wrong
leads ;-)
It was the IIS connection-timeout of the report manager; default 120
sec. If the query ran longer than that, it failed. I set it to 15
minutes and now all snapshots are created just fine.
Regards,
Jan Lubbers via SQLMonster.com schreef:
> Hello world,
> I have some reports that run fine when I use the "Render this report with the
> most recent data" selected, but when I want to create a Snapshot it fails to
> produce a snapshot. It also depends on how much data I select via the
> parameters. If I want a small result set it works, but if I select a large
> set it displayes several (3) times the windows login popup (asking my
> password each time) and in the end it shows a "You are not authorized to view
> this page" error.
> The large selection runs for about 7 minutes, the smaller about 2 and does
> NOT show the login popup.
> The server is in another domain than my login but it is in the "Local
> Intranet" in the IE security setup and uses "Automatic logon with current
> user credentials"
> I suspect it is a recource problem, but I have no idea what causes this
> problem.
> Can you please help me?
> Regards, Jan

Friday, March 9, 2012

Report Service failed to start

New install of the June SQL 05 Standard CTP bits, the Report Service fails to start with the following errors.

Service cannot be started. Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'LocalSystem' is not recognized.
at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer(Boolean firstTime)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.Start(Boolean firstTime)
at Microsoft.ReportingServices.NTService.ReportService.OnStart(String[] args)
at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)

The service (and SQL server) is configured to use Local System as the account.

In RsReportServer.config change your WebServiceAccount to be the actual account the web service runs as, for instance ASPNET or Network Service. If you empty it, we will use a default for the OS.

Thanks
Tudor|||Dear Tudor,
I have similar problem. I've just installed the final version of sql 2005 (reporting services as well, side by side with the original sql 2000 + reporting services pair) and the Reporting Services (the old one) service doesn't start after the boot process. My error message is the following:

Service cannot be started. Microsoft.ReportingServices.Diagnostics.Utilities.EventLogSourceNotFound: Event source Schedule and Delivery Processor does not exist.

at Microsoft.ReportingServices.Diagnostics.Utilities.RSEventLog.Init()

at Microsoft.ReportingServices.Diagnostics.Globals.Init(RSConfigurationManager configManager, RunningApplication app)

at Microsoft.ReportingServices.Library.ServiceAppDomainController.Start()

at Microsoft.ReportingServices.NTService.ReportService.OnStart(String[] args)

at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)

In my browser I got the following message instead of my report folders:
Unable to communicate with report server. Please verify that the report server is operational.

The RS'2005 service works fine but all my reports are on the old installation and I really need them. Each service uses Local system account except server-agents which use a domain account.
Please help me!
Thanks in advance,
marcell|||

Tudor,

Many thanks. Your pointer solved my problem also.

Regards,

Arun Philip

|||

anyone please help.... Im unable to start report server...Im not sure if this is similar with the problem posted by Dillon.....Thanks

Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'ORACLE-01\ASPNET' is not recognized., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'ORACLE-01\ASPNET' is not recognized.
ReportingServicesService!servicecontroller!4!4/26/2007-09:40:01:: e ERROR: Exception caught starting RPC server: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'ORACLE-01\ASPNET' is not recognized.
at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer(Boolean firstTime)

|||I get the Same Error RE LocalSystem account. Funny thing is, when i open the report server config file, there is NO NODE in the XML for the WebServiceIdentity. I treid to add it myself with NT AUTHORITY\System as per the MS KB Article but it is still not working... any ideas ?|||

This node doesnt exist in case you are woking on SQL 2000 Reporting services.

Hope This helps.