report parameter order

hi,
after changing the order of my report parameters (in this example test)
in the menue via the up and down arrow I get the following error
message:
an error occured during local processing. an error occured during
report processing. the value expression for the query parameter 'date'
contains an error: the expression referenced a non-existing parameter
in the report parameters collection.
anybody knows how to do this?
thanksIt sounds like you have either:
A) deleted a parameter which was there before, or more likely
B) changed the sequence required for cascading parameters, i.e. parameters
where one value depends on another one previously entered. It is probably
something to do with one of your report parameters' 'available values' or
'default values' definitions.
HTH,
Magendo_man
"florian" wrote:
> hi,
> after changing the order of my report parameters (in this example test)
> in the menue via the up and down arrow I get the following error
> message:
> an error occured during local processing. an error occured during
> report processing. the value expression for the query parameter 'date'
> contains an error: the expression referenced a non-existing parameter
> in the report parameters collection.
> anybody knows how to do this?
> thanks
>|||You're right I got this error msg. with cascading parameters. The
hierachie goes like this: A-->B-->C Originally I only included A and C
in my parameters but B was missing. So I added B but I didn't like it
to occure as the last report parameter so I wanted to change the
position and then I got the error msg. I get the same error when I
modifie the rdl file and swith the Report Parameters.
Any ideas instead of writing the whole report once again?
magendo_man schrieb:
> It sounds like you have either:
> A) deleted a parameter which was there before, or more likely
> B) changed the sequence required for cascading parameters, i.e. parameters
> where one value depends on another one previously entered. It is probably
> something to do with one of your report parameters' 'available values' or
> 'default values' definitions.
> HTH,
> Magendo_man
> "florian" wrote:
> > hi,
> >
> > after changing the order of my report parameters (in this example test)
> > in the menue via the up and down arrow I get the following error
> > message:
> >
> > an error occured during local processing. an error occured during
> > report processing. the value expression for the query parameter 'date'
> > contains an error: the expression referenced a non-existing parameter
> > in the report parameters collection.
> >
> > anybody knows how to do this?
> >
> > thanks
> >
> >|||Just add parameter B back in to Report Parameters in 2nd position.
"florian" wrote:
> You're right I got this error msg. with cascading parameters. The
> hierachie goes like this: A-->B-->C Originally I only included A and C
> in my parameters but B was missing. So I added B but I didn't like it
> to occure as the last report parameter so I wanted to change the
> position and then I got the error msg. I get the same error when I
> modifie the rdl file and swith the Report Parameters.
> Any ideas instead of writing the whole report once again?
>
> magendo_man schrieb:
> > It sounds like you have either:
> > A) deleted a parameter which was there before, or more likely
> > B) changed the sequence required for cascading parameters, i.e. parameters
> > where one value depends on another one previously entered. It is probably
> > something to do with one of your report parameters' 'available values' or
> > 'default values' definitions.
> >
> > HTH,
> > Magendo_man
> >
> > "florian" wrote:
> >
> > > hi,
> > >
> > > after changing the order of my report parameters (in this example test)
> > > in the menue via the up and down arrow I get the following error
> > > message:
> > >
> > > an error occured during local processing. an error occured during
> > > report processing. the value expression for the query parameter 'date'
> > > contains an error: the expression referenced a non-existing parameter
> > > in the report parameters collection.
> > >
> > > anybody knows how to do this?
> > >
> > > thanks
> > >
> > >
>|||do mean at the data view or where?
magendo_man schrieb:
> Just add parameter B back in to Report Parameters in 2nd position.
> "florian" wrote:
> > You're right I got this error msg. with cascading parameters. The
> > hierachie goes like this: A-->B-->C Originally I only included A and C
> > in my parameters but B was missing. So I added B but I didn't like it
> > to occure as the last report parameter so I wanted to change the
> > position and then I got the error msg. I get the same error when I
> > modifie the rdl file and swith the Report Parameters.
> >
> > Any ideas instead of writing the whole report once again?
> >
> >
> > magendo_man schrieb:
> >
> > > It sounds like you have either:
> > > A) deleted a parameter which was there before, or more likely
> > > B) changed the sequence required for cascading parameters, i.e. parameters
> > > where one value depends on another one previously entered. It is probably
> > > something to do with one of your report parameters' 'available values' or
> > > 'default values' definitions.
> > >
> > > HTH,
> > > Magendo_man
> > >
> > > "florian" wrote:
> > >
> > > > hi,
> > > >
> > > > after changing the order of my report parameters (in this example test)
> > > > in the menue via the up and down arrow I get the following error
> > > > message:
> > > >
> > > > an error occured during local processing. an error occured during
> > > > report processing. the value expression for the query parameter 'date'
> > > > contains an error: the expression referenced a non-existing parameter
> > > > in the report parameters collection.
> > > >
> > > > anybody knows how to do this?
> > > >
> > > > thanks
> > > >
> > > >
> >
> >|||In Layout view select from the menu Report> Report Parameters..
You should then be able to add back in your deleted parameter and move it in
to the correct position.
~ Magendo_man
"florian" wrote:
> do mean at the data view or where?
>
> magendo_man schrieb:
> > Just add parameter B back in to Report Parameters in 2nd position.
> >
> > "florian" wrote:
> >
> > > You're right I got this error msg. with cascading parameters. The
> > > hierachie goes like this: A-->B-->C Originally I only included A and C
> > > in my parameters but B was missing. So I added B but I didn't like it
> > > to occure as the last report parameter so I wanted to change the
> > > position and then I got the error msg. I get the same error when I
> > > modifie the rdl file and swith the Report Parameters.
> > >
> > > Any ideas instead of writing the whole report once again?
> > >
> > >
> > > magendo_man schrieb:
> > >
> > > > It sounds like you have either:
> > > > A) deleted a parameter which was there before, or more likely
> > > > B) changed the sequence required for cascading parameters, i.e. parameters
> > > > where one value depends on another one previously entered. It is probably
> > > > something to do with one of your report parameters' 'available values' or
> > > > 'default values' definitions.
> > > >
> > > > HTH,
> > > > Magendo_man
> > > >
> > > > "florian" wrote:
> > > >
> > > > > hi,
> > > > >
> > > > > after changing the order of my report parameters (in this example test)
> > > > > in the menue via the up and down arrow I get the following error
> > > > > message:
> > > > >
> > > > > an error occured during local processing. an error occured during
> > > > > report processing. the value expression for the query parameter 'date'
> > > > > contains an error: the expression referenced a non-existing parameter
> > > > > in the report parameters collection.
> > > > >
> > > > > anybody knows how to do this?
> > > > >
> > > > > thanks
> > > > >
> > > > >
> > >
> > >
>sql

Report parameter - First day of last month/last day of month

can somebody pls. help me with the following report parameter defaults?
for a monthly report I need two dates as parameter defaults:
The first day of the last month
and
the last day of last month
If I run a report on - let's say March 1st, I can get the last day of the
last month with
=Today.AddDays(-1)
and the first day of the last month with
=Today.AddMonths(-1)
However, I need these paramers to work every day. For example, I want to be
able to run the report on March 3rd or March 15th, and the report should also
have February 1st and February 28th as start and end dates.
How can I do this?
Thank you for helping,
MartinHi Martin,
This will work everyday. start and end date of last month.
start date - str(year(today)) + "/" + str(month(today)-1) + "/1"
End Date - dateadd("d",-1, (str(year(today)) + "/" + str(month(today)) +
"/1"))
Now the date format ie dd/mm/yy or mm/dd/yy etc... I hope you can change it.
Amarnath
"Martin" wrote:
> can somebody pls. help me with the following report parameter defaults?
> for a monthly report I need two dates as parameter defaults:
> The first day of the last month
> and
> the last day of last month
> If I run a report on - let's say March 1st, I can get the last day of the
> last month with
> =Today.AddDays(-1)
> and the first day of the last month with
> =Today.AddMonths(-1)
> However, I need these paramers to work every day. For example, I want to be
> able to run the report on March 3rd or March 15th, and the report should also
> have February 1st and February 28th as start and end dates.
> How can I do this?
> Thank you for helping,
> Martin
>

Report Page Width with Dynamic columns through parameters

I found the following paragraph while searching on here:

************************************************************************
You could easily set up a parameter for each column and then display that column conditionally based on the parameter.

For instance, if you have a column that displays First Name, you could have a parameter called DisplayFirstName. Then in design view you'd select the whole FirstName column and in the Visibility-Hidden property set it to :

=iif( Parameters!DisplayFirstName.Value = false, true, false )

This could easily become a big, unwieldy report, though, if you have a great number of dynamic columns. Also, The width of the report is set at design time, and it includes the width of all your columns, not just the visible ones. This could cause you some pagination problems.
************************************************************************

That is exactly my problem. I have lots of dynamic columns which causes the width of the report to be wide. Thus even though at run time the report only shows columns within a page, the report itself consists of a lot of white spaces after the selected columns. Does anyone know a solution to this? If not, I guess creating the rdl with code manually is the only way? Please advise. Thanks in advance.

- Will

I summarize your requirement that I have understood and based on that I given you my comment if my understanding is wrong then let me know.

Your requirement is to design a report in which columns are visible on some condition or dynamically. You have design the report and set the column property visible = ‘TRUE’ OR FALSE based on the condition. Let assume the problem is that when col1 is visible that time col2 is invisible due to this a white space is left in place of col2 and you want to remove that white space.

My comment:

Take the above scenario if col1 is visible and col2 is invisible and vice a versa then place the col2 over col1 so then col2 is visible then col1 will be invisible and if the col1 is visible then col2 is invisible. And you will not see any white pace in the report.

|||Hi mverma,

First let me thank you for replying to me. Let me clarify my requirements just to make sure what you are proposing would solve my problem.

I have a report, which at design time, would span 2 physical pages (17 inches), with each column being the same width.
Now, the columns' visibility is toggled by parameters passed to the report page during run time.

Now the problem.
Lets say for one of the report we pass in parameters to toggle on columns 1,3,5,7, so the total width would be 8.5 inches, which would fit exactly on one page. So when choosing to print, it would print one page with the 4 columns (with no spaces between the columns), and one blank page. The blank page is printed because, during design time, the report is set to be 17 inches wide, thus even only 8.5 inches of the report contains columns, the whole 17 inches are still printed.

You solution seems to solve the problem of white spaces in between columns that are visible and invisible, but my problem is that though all the columns are neatly next to each other, spaces are still accounted for the invisible columns are at the end of the table.

Now, if I misunderstood your solution and it actually does solve my problem, could you please provide more details or a link as to how to "stack" one column on top of another during runtime. Nevertheless, thanks again for your reply.

- Will

|||

I have another option suppose according to the passing parameter report generate value for 1,3,5,7 etc and for next parameter value it will generate report based on 2,4,6,8. Then you can take two table one is design for 1,3,5,7 and next one is designed used by 2,4,6,8 column when parameter passed for 1,3,5,7 then set visibile='true' for this table and set visibile= 'false' for another table that we don't want. Place table one over other so that you need not to worry about the white space.

Does this help you to achive your requirment ?

Regards

Manoj Verma.

|||Hi Manoj Verma,

Thanks for replying. I do not think your suggestion would work because my example was a watered downed one. Our actual need is a 40 columns dynamic report, where users can choose any of the 40 columns. Thanks again for your input.

- Will

Report Page Width with Dynamic columns through parameters

I found the following paragraph while searching on here:

************************************************************************
You could easily set up a parameter for each column and then display that column conditionally based on the parameter.

For instance, if you have a column that displays First Name, you could have a parameter called DisplayFirstName. Then in design view you'd select the whole FirstName column and in the Visibility-Hidden property set it to :

=iif( Parameters!DisplayFirstName.Value = false, true, false )

This could easily become a big, unwieldy report, though, if you have a great number of dynamic columns. Also, The width of the report is set at design time, and it includes the width of all your columns, not just the visible ones. This could cause you some pagination problems.
************************************************************************

That is exactly my problem. I have lots of dynamic columns which causes the width of the report to be wide. Thus even though at run time the report only shows columns within a page, the report itself consists of a lot of white spaces after the selected columns. Does anyone know a solution to this? If not, I guess creating the rdl with code manually is the only way? Please advise. Thanks in advance.

- Will

I summarize your requirement that I have understood and based on that I given you my comment if my understanding is wrong then let me know.

Your requirement is to design a report in which columns are visible on some condition or dynamically. You have design the report and set the column property visible = ‘TRUE’ OR FALSE based on the condition. Let assume the problem is that when col1 is visible that time col2 is invisible due to this a white space is left in place of col2 and you want to remove that white space.

My comment:

Take the above scenario if col1 is visible and col2 is invisible and vice a versa then place the col2 over col1 so then col2 is visible then col1 will be invisible and if the col1 is visible then col2 is invisible. And you will not see any white pace in the report.

|||Hi mverma,

First let me thank you for replying to me. Let me clarify my requirements just to make sure what you are proposing would solve my problem.

I have a report, which at design time, would span 2 physical pages (17 inches), with each column being the same width.
Now, the columns' visibility is toggled by parameters passed to the report page during run time.

Now the problem.
Lets say for one of the report we pass in parameters to toggle on columns 1,3,5,7, so the total width would be 8.5 inches, which would fit exactly on one page. So when choosing to print, it would print one page with the 4 columns (with no spaces between the columns), and one blank page. The blank page is printed because, during design time, the report is set to be 17 inches wide, thus even only 8.5 inches of the report contains columns, the whole 17 inches are still printed.

You solution seems to solve the problem of white spaces in between columns that are visible and invisible, but my problem is that though all the columns are neatly next to each other, spaces are still accounted for the invisible columns are at the end of the table.

Now, if I misunderstood your solution and it actually does solve my problem, could you please provide more details or a link as to how to "stack" one column on top of another during runtime. Nevertheless, thanks again for your reply.

- Will

|||

I have another option suppose according to the passing parameter report generate value for 1,3,5,7 etc and for next parameter value it will generate report based on 2,4,6,8. Then you can take two table one is design for 1,3,5,7 and next one is designed used by 2,4,6,8 column when parameter passed for 1,3,5,7 then set visibile='true' for this table and set visibile= 'false' for another table that we don't want. Place table one over other so that you need not to worry about the white space.

Does this help you to achive your requirment ?

Regards

Manoj Verma.

|||Hi Manoj Verma,

Thanks for replying. I do not think your suggestion would work because my example was a watered downed one. Our actual need is a 40 columns dynamic report, where users can choose any of the 40 columns. Thanks again for your input.

- Will

sql

Report Model Deployment Error

Hi All,
I created a report model and when I tried to deploy I got the following:

The model ID of the submitted model must match that of the current model

I have searched all over for the cause and solution but, have had no luck.

Can someone please help me?

Thanks,

Roy
The SemanticModel ID of the submitted model must match the semantic model id of the existing model, otherwise you'll get this error.

The solution is to delete model from server (using Report Manager or Management Studio)before deploying.|||Yes, I had the same problem. Surely a deploy would be able to deal with this automatically?|||Deploy tries not to override existing model with completely different model.

Report Model Deployment Error

Hi All,
I created a report model and when I tried to deploy I got the following:

The model ID of the submitted model must match that of the current model

I have searched all over for the cause and solution but, have had no luck.

Can someone please help me?

Thanks,

Roy
The SemanticModel ID of the submitted model must match the semantic model id of the existing model, otherwise you'll get this error.

The solution is to delete model from server (using Report Manager or Management Studio)before deploying.|||Yes, I had the same problem. Surely a deploy would be able to deal with this automatically?|||Deploy tries not to override existing model with completely different model.sql

Report Model Deployment : The model ID of the submitted model must match that of the

Running 2005 Beta 3 Refresh. When I first deploy, it works fine. Subsequent deployments yield the following error:

Error 1 The model ID of the submitted model must match that of the
current model. C:\Source\********.smdl 0 0

When I change the name of the smdl, it works fine. (Properties of the .smdl file)

Any ideas?

For existing models Deploy actually means Update

However if Model ID is different, this cannot be considered as Update - the model may be completely different. In this case user must remove model from server before re-deploying it.

|||

Yes, thanks.

The scenario arises when you try to deploy a model in a NEW report project which has the same name as a model designed in a previous report project.

Jean-Pierre

|||

Lev Semenets - MSFT wrote:

For existing models Deploy actually means Update

However if Model ID is different, this cannot be considered as Update - the model may be completely different. In this case user must remove model from server before re-deploying it.

How can i remove a model from the server.?

Thanks !!|||

Programmatically - by calling SOAP API method DeleteItem()

|||

Hi,

no need to do SOAP.

Just go to the reporting web site, go to the models folder and delete the report.

Re-deploy and it's updated version is back in the folder.

Report Model Deployment : The model ID of the submitted model must match that of the

Running 2005 Beta 3 Refresh. When I first deploy, it works fine. Subsequent deployments yield the following error:

Error 1 The model ID of the submitted model must match that of the
current model. C:\Source\********.smdl 0 0

When I change the name of the smdl, it works fine. (Properties of the .smdl file)

Any ideas?

For existing models Deploy actually means Update

However if Model ID is different, this cannot be considered as Update - the model may be completely different. In this case user must remove model from server before re-deploying it.

|||

Yes, thanks.

The scenario arises when you try to deploy a model in a NEW report project which has the same name as a model designed in a previous report project.

Jean-Pierre

|||

Lev Semenets - MSFT wrote:

For existing models Deploy actually means Update

However if Model ID is different, this cannot be considered as Update - the model may be completely different. In this case user must remove model from server before re-deploying it.

How can i remove a model from the server.?

Thanks !!
|||

Programmatically - by calling SOAP API method DeleteItem()

|||

Hi,

no need to do SOAP.

Just go to the reporting web site, go to the models folder and delete the report.

Re-deploy and it's updated version is back in the folder.

Report Model Deployment : The model ID of the submitted model must match that of the

Running 2005 Beta 3 Refresh. When I first deploy, it works fine. Subsequent deployments yield the following error:

Error 1 The model ID of the submitted model must match that of the
current model. C:\Source\********.smdl 0 0

When I change the name of the smdl, it works fine. (Properties of the .smdl file)

Any ideas?

For existing models Deploy actually means Update

However if Model ID is different, this cannot be considered as Update - the model may be completely different. In this case user must remove model from server before re-deploying it.

|||

Yes, thanks.

The scenario arises when you try to deploy a model in a NEW report project which has the same name as a model designed in a previous report project.

Jean-Pierre

|||

Lev Semenets - MSFT wrote:

For existing models Deploy actually means Update

However if Model ID is different, this cannot be considered as Update - the model may be completely different. In this case user must remove model from server before re-deploying it.

How can i remove a model from the server.?

Thanks !!|||

Programmatically - by calling SOAP API method DeleteItem()

|||

Hi,

no need to do SOAP.

Just go to the reporting web site, go to the models folder and delete the report.

Re-deploy and it's updated version is back in the folder.

Report Model Deployment : The model ID of the submitted model must match that of the

Running 2005 Beta 3 Refresh. When I first deploy, it works fine. Subsequent deployments yield the following error:

Error 1 The model ID of the submitted model must match that of the
current model. C:\Source\********.smdl 0 0

When I change the name of the smdl, it works fine. (Properties of the .smdl file)

Any ideas?

For existing models Deploy actually means Update

However if Model ID is different, this cannot be considered as Update - the model may be completely different. In this case user must remove model from server before re-deploying it.

|||

Yes, thanks.

The scenario arises when you try to deploy a model in a NEW report project which has the same name as a model designed in a previous report project.

Jean-Pierre

|||

Lev Semenets - MSFT wrote:

For existing models Deploy actually means Update

However if Model ID is different, this cannot be considered as Update - the model may be completely different. In this case user must remove model from server before re-deploying it.

How can i remove a model from the server.?

Thanks !!|||

Programmatically - by calling SOAP API method DeleteItem()

|||

Hi,

no need to do SOAP.

Just go to the reporting web site, go to the models folder and delete the report.

Re-deploy and it's updated version is back in the folder.

report model and it's datasource

hi everyone,

I created a report model and deployed it. When I open the rpt builder on web I get the following error.

'The selected data source does not have and content available'

Seemed like it would be a easy issue, but I cannot retrieve any data in the rpt model. The datasource I'm using does work for rpts not associated with the rpt model. Any suggestions? It seems like I've missed a step. Thanks, Lisa

If there is no primary key defined, you can build the model, but no contents. Do you have primary key defined?sql

Report manager problem

I am getting the following error when trying to access the Report Manager:

The report server configuration file specifies localhost for the Web server name. The report server requires that the computer name be specified instead.

I have tried:

http://<computername>/reports

http://localhost/reports

I have gone into the report server configuration and tried to change the directory there, but with no affect. Is there something further that I need to be looking at?

Thanks for the information.

In the RSWebApplication.config file you should change the ReportServerUrl to not use localhost.

Report Manager Error - Object reference not set to an instance of an object.

Hi,
I can browse to my ReportServer without a problem. But when I try to
browse to the Report Manager I get the following error - Object
reference not set to an instance of an object.
I checked the log file and I'm seeing the following (snippet)
Object reference not set to an instance of an object
at
Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetReportServerAuthentic= ation()
I'm Running SQL Server 2000 SP4
SQL Reporting Services 2000 SP1 (I know...)
This has been working fine up to know but suddenly seems to have broken
down. I've seen 2 other posts of this nature on google groups but
neither with a resolution.
Can anyone help me out please'
Thanks,
Gear=F3idok, I got it.
It was a default HTTP header in the root folder in IIS that was set
that caused this. Removed this and left it blank and it worked fine
for me.
Gear=F3id
Gear=F3id wrote:
> Hi,
> I can browse to my ReportServer without a problem. But when I try to
> browse to the Report Manager I get the following error - Object
> reference not set to an instance of an object.
> I checked the log file and I'm seeing the following (snippet)
> Object reference not set to an instance of an object
> at
> Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetReportServerAuthent=ication()
> I'm Running SQL Server 2000 SP4
> SQL Reporting Services 2000 SP1 (I know...)
> This has been working fine up to know but suddenly seems to have broken
> down. I've seen 2 other posts of this nature on google groups but
> neither with a resolution.
> > Can anyone help me out please'
> > Thanks,
> Gear=F3id

Report Manager error

When I try to start report manager, I get the following error message. What do I need to do?

Server Error in '/Reports' Application.

---

Parser Error

Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.
Parser Error Message: Could not load type 'Microsoft.ReportingServices.UI.GlobalApp'.
Source Error:

Line 1: <%@. Application Codebehind="Global.asax.cs" Inherits="Microsoft.ReportingServices.UI.GlobalApp" %>

Source File: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\global.asax Line: 1

---

Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300

Open the IIS MMC plug in, go to the reports and report server virtual directories, right-click and select properties. Go to the ASP.Net tab. ensure the ASP.Net version is set to 2.0

-Lukasz

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

|||

Hi - when I do this it comes back with this error message?

Failed to map the path '/Reports/App_GlobalResources/'

|||Use regmon and filemon to check if there are any "access denied" errors on ASPNET user. Grant access if you see any error.|||

You can use the aspnet_regiis.exe tool with the "-ga" parameter to grant access to the Web Service account listed in the report server configuration tool or to the application pool idenity assigned to the report manager/report server virtual directory.

-Lukasz

|||

This was the solution to my problem. If you don't have the ASP.Net tab like me, go to %SYSTEMROOT%\Microsoft.NET\Framework\<Version> and use aspnet_regiis.exe -s <Path to your Reports-VDir>. If everything is default: aspnet_regiis.exe -s W3SVC/1/ROOT/Reports will do it.

Report Manager Error

I have seen this issue in other posts, but I've never seen a way to fix it.

When I try to access the Report Manager, I get the following:

Server Error in '/Reports' Application.

---

Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IO.FileNotFoundException: Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Assembly Load Trace: The following information can be helpful to determine why the assembly 'ReportingServicesWebServer' could not be loaded.

WRN: Assembly binding logging is turned OFF.

To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.

Note: There is some performance penalty associated with assembly bind failure logging.

To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

Stack Trace:

[FileNotFoundException: Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.]

System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection) +0

System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +211

System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +141

System.Reflection.Assembly.Load(String assemblyString) +25

System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +32

[ConfigurationErrorsException: Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.]

System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +596

System.Web.Configuration.CompilationSection.LoadAssembly(AssemblyInfo ai) +70

System.Web.Compilation.BuildManager.GetReferencedAssemblies(CompilationSection compConfig) +177

System.Web.Compilation.BuildProvidersCompiler..ctor(VirtualPath configPath, Boolean supportLocalization, String outputAssemblyName) +180

System.Web.Compilation.ApplicationBuildProvider.GetGlobalAsaxBuildResult(Boolean isPrecompiledApp) +3446629

System.Web.Compilation.BuildManager.CompileGlobalAsax() +51

System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() +462

[HttpException (0x80004005): Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.]

System.Web.Compilation.BuildManager.ReportTopLevelCompilationException() +57

System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() +612

System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters) +456

[HttpException (0x80004005): Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.]

System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +3426855

System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +88

System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +149

---

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

I am using SSE2005 SP2

What can I do to fix this? This is a production server that is very precisely configured, so I can't just format and reinstall everything (this would take DAYS)

Please please help!!! : )

Turn (temporarily) assembly binding logging on with the HKLM\Software\Microsoft\Fusion!EnableLogHKLM\Software\Microsoft\Fusion!EnableLog key as mentioned above, or download this tool which does the same thing:

http://msdn2.microsoft.com/en-us/library/e74a18c4(VS.80).aspx

Cause the error to occur while you are generating the log and you should get a good idea of what's going on...The log will tell you WHAT file it is trying to load and WHERE it is looking for the file...

|||I can not get assembly bind failure logging to work... am I missing something? No matter what settings I set, the error message still says that logging is off.. : (|||So, the tool won't work for you either?|||

Correct. The bind logging works, but the error page still states that it is off, and no errors are logged.. : (

Could this be a problem with my .net 2.0 installation?

|||

Ahhhh... didn't know I had to restart IIS to enable logging ;)

Here is the log :

*** Assembly Binder Log Entry (2/22/2007 @. 2:40:37 PM) ***

The operation failed.

Bind result: hr = 0x80070002. The system cannot find the file specified.

Assembly manager loaded from: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\mscorwks.dll

Running under executable c:\windows\system32\inetsrv\w3wp.exe

A detailed error log follows.

=== Pre-bind state information ===

LOG: User = NT AUTHORITY\NETWORK SERVICE

LOG: DisplayName = ReportingServicesWebServer

(Partial)

LOG: Appbase = file:///C:/Program Files/Microsoft SQL Server/MSSQL.2/Reporting Services/ReportManager/

LOG: Initial PrivatePath = C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportManager\bin

LOG: Dynamic Base = C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\eabd629d

LOG: Cache Base = C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\eabd629d

LOG: AppName = 9e438247

Calling assembly : (Unknown).

===

LOG: This bind starts in default load context.

LOG: Using application configuration file: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportManager\web.config

LOG: Using host configuration file: \\?\C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet.config

LOG: Using machine configuration file from C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\config\machine.config.

LOG: Policy not being applied to reference at this time (private, custom, partial, or location-based assembly bind).

LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/Temporary ASP.NET Files/reports/eabd629d/9e438247/ReportingServicesWebServer.DLL.

LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/Temporary ASP.NET Files/reports/eabd629d/9e438247/ReportingServicesWebServer/ReportingServicesWebServer.DLL.

LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/MSSQL.2/Reporting Services/ReportManager/bin/ReportingServicesWebServer.DLL.

LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/MSSQL.2/Reporting Services/ReportManager/bin/ReportingServicesWebServer/ReportingServicesWebServer.DLL.

LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/Temporary ASP.NET Files/reports/eabd629d/9e438247/ReportingServicesWebServer.EXE.

LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/Temporary ASP.NET Files/reports/eabd629d/9e438247/ReportingServicesWebServer/ReportingServicesWebServer.EXE.

LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/MSSQL.2/Reporting Services/ReportManager/bin/ReportingServicesWebServer.EXE.

LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/MSSQL.2/Reporting Services/ReportManager/bin/ReportingServicesWebServer/ReportingServicesWebServer.EXE.

LOG: All probing URLs attempted and failed.

Let me know if any other information will help.. thanks!!!!!!|||

OK, I see my version of this file in:

C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin

Do you see "your" copy here (the log says it's trying to find it there -- ):

URL file:///C:/Program Files/Microsoft SQL Server/MSSQL.2/Reporting Services/ReportManager/bin/ReportingServicesWebServer.DLL

Also, what users have permissions to get into this folder?

|||Oh yeah, you also might want to try downloading / installing filemon from sysinternals to see if the attempt to grab this file by SSRS is failing due to permissions issues on the folder....|||

I'm using procmon... the problem is really that the file isn't there... but if I put it there, I get this :

Server Error in '/Reports' Application.

---

Parser Error

Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.

Parser Error Message: Could not load type 'Microsoft.ReportingServices.UI.GlobalApp'.

Source Error:

Line 1: <%@. Application Codebehind="Global.asax.cs" Inherits="Microsoft.ReportingServices.UI.GlobalApp" %>

Source File: /Reports/global.asax Line: 1

---

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

I've uninstalled and re-installed several times, but this never changes anything... : (

I did find some other errors in the bind logs though :

*** Assembly Binder Log Entry (2/23/2007 @. 9:05:49 AM) ***

The operation failed.

Bind result: hr = 0x80070002. The system cannot find the file specified.

Assembly manager loaded from: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\mscorwks.dll

Running under executable c:\windows\system32\inetsrv\w3wp.exe

A detailed error log follows.

=== Pre-bind state information ===

LOG: User = NT AUTHORITY\NETWORK SERVICE

LOG: DisplayName = CppCodeProvider, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a

(Fully-specified)

LOG: Appbase = file:///C:/testbed/zip/

LOG: Initial PrivatePath = C:\testbed\zip\bin

LOG: Dynamic Base = C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\zip\44b9f2d0

LOG: Cache Base = C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\zip\44b9f2d0

LOG: AppName = ccff1369

Calling assembly : (Unknown).

===

LOG: This bind starts in default load context.

LOG: Using application configuration file: C:\testbed\zip\web.config

LOG: Using host configuration file: \\?\C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet.config

LOG: Using machine configuration file from C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\config\machine.config.

LOG: Post-policy reference: CppCodeProvider, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a

LOG: GAC Lookup was unsuccessful.

LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/Temporary ASP.NET Files/zip/44b9f2d0/ccff1369/CppCodeProvider.DLL.

LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/Temporary ASP.NET Files/zip/44b9f2d0/ccff1369/CppCodeProvider/CppCodeProvider.DLL.

LOG: Attempting download of new URL file:///C:/testbed/zip/bin/CppCodeProvider.DLL.

LOG: Attempting download of new URL file:///C:/testbed/zip/bin/CppCodeProvider/CppCodeProvider.DLL.

LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/Temporary ASP.NET Files/zip/44b9f2d0/ccff1369/CppCodeProvider.EXE.

LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/Temporary ASP.NET Files/zip/44b9f2d0/ccff1369/CppCodeProvider/CppCodeProvider.EXE.

LOG: Attempting download of new URL file:///C:/testbed/zip/bin/CppCodeProvider.EXE.

LOG: Attempting download of new URL file:///C:/testbed/zip/bin/CppCodeProvider/CppCodeProvider.EXE.

LOG: All probing URLs attempted and failed.

and

*** Assembly Binder Log Entry (2/23/2007 @. 9:05:49 AM) ***

The operation failed.

Bind result: hr = 0x80070002. The system cannot find the file specified.

Assembly manager loaded from: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\mscorwks.dll

Running under executable c:\windows\system32\inetsrv\w3wp.exe

A detailed error log follows.

=== Pre-bind state information ===

LOG: User = NT AUTHORITY\NETWORK SERVICE

LOG: DisplayName = VJSharpCodeProvider, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a

(Fully-specified)

LOG: Appbase = file:///C:/testbed/zip/

LOG: Initial PrivatePath = C:\testbed\zip\bin

LOG: Dynamic Base = C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\zip\44b9f2d0

LOG: Cache Base = C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\zip\44b9f2d0

LOG: AppName = ccff1369

Calling assembly : (Unknown).

===

LOG: This bind starts in default load context.

LOG: Using application configuration file: C:\testbed\zip\web.config

LOG: Using host configuration file: \\?\C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet.config

LOG: Using machine configuration file from C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\config\machine.config.

LOG: Post-policy reference: VJSharpCodeProvider, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a

LOG: GAC Lookup was unsuccessful.

LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/Temporary ASP.NET Files/zip/44b9f2d0/ccff1369/VJSharpCodeProvider.DLL.

LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/Temporary ASP.NET Files/zip/44b9f2d0/ccff1369/VJSharpCodeProvider/VJSharpCodeProvider.DLL.

LOG: Attempting download of new URL file:///C:/testbed/zip/bin/VJSharpCodeProvider.DLL.

LOG: Attempting download of new URL file:///C:/testbed/zip/bin/VJSharpCodeProvider/VJSharpCodeProvider.DLL.

LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/Temporary ASP.NET Files/zip/44b9f2d0/ccff1369/VJSharpCodeProvider.EXE.

LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/Temporary ASP.NET Files/zip/44b9f2d0/ccff1369/VJSharpCodeProvider/VJSharpCodeProvider.EXE.

LOG: Attempting download of new URL file:///C:/testbed/zip/bin/VJSharpCodeProvider.EXE.

LOG: Attempting download of new URL file:///C:/testbed/zip/bin/VJSharpCodeProvider/VJSharpCodeProvider.EXE.

LOG: All probing URLs attempted and failed.

and

*** Assembly Binder Log Entry (2/23/2007 @. 3:38:53 AM) ***

The operation failed.

Bind result: hr = 0x80070002. The system cannot find the file specified.

Assembly manager loaded from: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\mscorwks.dll

Running under executable C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\bin\ReportingServicesService.exe

A detailed error log follows.

=== Pre-bind state information ===

LOG: User = NT AUTHORITY\NETWORK SERVICE

LOG: DisplayName = msvcm80, Version=8.0.50608.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a

(Fully-specified)

LOG: Appbase = file:///C:/Program Files/Microsoft SQL Server/MSSQL.2/Reporting Services/ReportServer/bin/

LOG: Initial PrivatePath = NULL

LOG: Dynamic Base = NULL

LOG: Cache Base = NULL

LOG: AppName = ReportingServicesService.exe

Calling assembly : (Unknown).

===

LOG: This bind starts in default load context.

LOG: Using application configuration file: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\bin\ReportingServicesService.exe.config

LOG: Using machine configuration file from C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\config\machine.config.

LOG: Post-policy reference: msvcm80, Version=8.0.50608.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a

LOG: GAC Lookup was unsuccessful.

LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/MSSQL.2/Reporting Services/ReportServer/bin/msvcm80.DLL.

LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/MSSQL.2/Reporting Services/ReportServer/bin/msvcm80/msvcm80.DLL.

LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/MSSQL.2/Reporting Services/ReportServer/bin/msvcm80.EXE.

LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/MSSQL.2/Reporting Services/ReportServer/bin/msvcm80/msvcm80.EXE.

LOG: All probing URLs attempted and failed.

|||

Hmm...I realize I pasted the wrong string in...you should have your dll in ReportServer/Bin (not ReportManger)

C:/Program Files/Microsoft SQL Server/MSSQL.2/Reporting Services/ReportServer/bin/

I don't know if that will make a difference with the other errors you're seeing, but the dll should be in ReportServer/Bin...

Did you have any problems installing the 2.0 Framework on this machine and/or VS 2005 Sp1?

|||

The DLL is there, for some reason it doesn't seem to be looking in the reportserver folder...

I tried to uninstall .NET 2.0 but it says it won't do it because it will disable applications (duh)

I might HAVE to thrash the server because I have to have this running in the next two weeks!

I'll keep noodling with it... if you think of anything else, let me know..

Report Manager Error

I am getting following error when trying to load the Report Manager:
The underlying connection was closed: Unable to connect to the remote
server.
This appears to be related to using SSL. If I point the config files
(RSReportServer.config & RSWebApplication.config) to http instead https and
set the SecureConnectionLevel to 0 I don't get this error; however, I need
use SSL
Does anyone have any ideas on what the problem could be?
Here is the stack trace from the log file:
w3wp!ui!b14!8/26/2004-06:56:32:: e ERROR: The underlying connection was
closed: Unable to connect to the remote server.
w3wp!ui!b14!8/26/2004-06:56:32:: e ERROR: HTTP status code --> 500
--Details--
System.Net.WebException: The underlying connection was closed: Unable to
connect to the remote server.
at System.Net.HttpWebRequest.CheckFinalStatus()
at System.Net.HttpWebRequest.EndGetRequestStream(IAsyncResult
asyncResult)
at System.Net.HttpWebRequest.GetRequestStream()
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters)
at
Microsoft.SqlServer.ReportingServices.ReportingService.ListSecureMethods()
at Microsoft.SqlServer.ReportingServices.RSConnection.GetSecureMethods()
at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()
at
Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
methodname)
at Microsoft.ReportingServices.UI.Global.SecureAllAPI()
at
Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
level)
at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
sender, EventArgs args)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain()
w3wp!ui!b14!8/26/2004-06:57:19:: e ERROR: Exception in ShowErrorPage:
System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean
preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean
preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg)You may need to put in the full domain name of the server in the url in
RSWebApplication.config.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jason Nissen" <Jason.Nissen@.cunamutual.com> wrote in message
news:OUaZY02iEHA.556@.tk2msftngp13.phx.gbl...
> I am getting following error when trying to load the Report Manager:
> The underlying connection was closed: Unable to connect to the remote
> server.
> This appears to be related to using SSL. If I point the config files
> (RSReportServer.config & RSWebApplication.config) to http instead https
and
> set the SecureConnectionLevel to 0 I don't get this error; however, I need
> use SSL
> Does anyone have any ideas on what the problem could be?
> Here is the stack trace from the log file:
> w3wp!ui!b14!8/26/2004-06:56:32:: e ERROR: The underlying connection was
> closed: Unable to connect to the remote server.
> w3wp!ui!b14!8/26/2004-06:56:32:: e ERROR: HTTP status code --> 500
> --Details--
> System.Net.WebException: The underlying connection was closed: Unable to
> connect to the remote server.
> at System.Net.HttpWebRequest.CheckFinalStatus()
> at System.Net.HttpWebRequest.EndGetRequestStream(IAsyncResult
> asyncResult)
> at System.Net.HttpWebRequest.GetRequestStream()
> at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters)
> at
> Microsoft.SqlServer.ReportingServices.ReportingService.ListSecureMethods()
> at
Microsoft.SqlServer.ReportingServices.RSConnection.GetSecureMethods()
> at
Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()
> at
> Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
> methodname)
> at Microsoft.ReportingServices.UI.Global.SecureAllAPI()
> at
> Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
> level)
> at
Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
> sender, EventArgs args)
> at System.EventHandler.Invoke(Object sender, EventArgs e)
> at System.Web.UI.Control.OnInit(EventArgs e)
> at System.Web.UI.Control.InitRecursive(Control namingContainer)
> at System.Web.UI.Page.ProcessRequestMain()
> w3wp!ui!b14!8/26/2004-06:57:19:: e ERROR: Exception in ShowErrorPage:
> System.Threading.ThreadAbortException: Thread was being aborted.
> at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean
> preserveForm)
> at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> errMsg) at at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean
> preserveForm)
> at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> errMsg)
>

Report Manager error

When I try to start report manager, I get the following error message. What do I need to do?

Server Error in '/Reports' Application.

---

Parser Error

Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.
Parser Error Message: Could not load type 'Microsoft.ReportingServices.UI.GlobalApp'.
Source Error:

Line 1: <%@. Application Codebehind="Global.asax.cs" Inherits="Microsoft.ReportingServices.UI.GlobalApp" %>

Source File: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\global.asax Line: 1

---

Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300

Open the IIS MMC plug in, go to the reports and report server virtual directories, right-click and select properties. Go to the ASP.Net tab. ensure the ASP.Net version is set to 2.0

-Lukasz

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

|||

Hi - when I do this it comes back with this error message?

Failed to map the path '/Reports/App_GlobalResources/'

|||Use regmon and filemon to check if there are any "access denied" errors on ASPNET user. Grant access if you see any error.|||

You can use the aspnet_regiis.exe tool with the "-ga" parameter to grant access to the Web Service account listed in the report server configuration tool or to the application pool idenity assigned to the report manager/report server virtual directory.

-Lukasz

|||

This was the solution to my problem. If you don't have the ASP.Net tab like me, go to %SYSTEMROOT%\Microsoft.NET\Framework\<Version> and use aspnet_regiis.exe -s <Path to your Reports-VDir>. If everything is default: aspnet_regiis.exe -s W3SVC/1/ROOT/Reports will do it.

Report Manager error

When I try to start report manager, I get the following error message. What do I need to do?

Server Error in '/Reports' Application.

---

Parser Error

Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.
Parser Error Message: Could not load type 'Microsoft.ReportingServices.UI.GlobalApp'.
Source Error:

Line 1: <%@. Application Codebehind="Global.asax.cs" Inherits="Microsoft.ReportingServices.UI.GlobalApp" %>

Source File: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\global.asax Line: 1

---

Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300

Open the IIS MMC plug in, go to the reports and report server virtual directories, right-click and select properties. Go to the ASP.Net tab. ensure the ASP.Net version is set to 2.0

-Lukasz

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

|||

Hi - when I do this it comes back with this error message?

Failed to map the path '/Reports/App_GlobalResources/'

|||Use regmon and filemon to check if there are any "access denied" errors on ASPNET user. Grant access if you see any error.|||

You can use the aspnet_regiis.exe tool with the "-ga" parameter to grant access to the Web Service account listed in the report server configuration tool or to the application pool idenity assigned to the report manager/report server virtual directory.

-Lukasz

|||

This was the solution to my problem. If you don't have the ASP.Net tab like me, go to %SYSTEMROOT%\Microsoft.NET\Framework\<Version> and use aspnet_regiis.exe -s <Path to your Reports-VDir>. If everything is default: aspnet_regiis.exe -s W3SVC/1/ROOT/Reports will do it.

Report Manager error

I am able to view reports by navigating directly to /ReportServer however the
report manager (/Reports/Home.aspx) gives the following:
ERROR.
Object reference not set to an instance of an object.
No other info is provided. I'm using SSL and RS SP2 is installed, SQL has
SP4. I've looked in the Reporting Services Log files but I don't see
anything there to help trap this error.
What "object" might this be? Any ideas about how to debug this?
Thanks,
Jeff Munson
University of WashingtonMaybe this will help someone?
When I hit https://localhost/SQLReports/Pages/Folder.aspx from the web
server itself and view source here is what's displayed in the HEAD tag:
(Note that the virtual directories are actually SQLReports and
SQLReportServer - this wasn't how I labelled them in my first post)
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD> <script language="JScript" type="text/Javascript"
src="/SQLReports/js/ReportingServices.js"></script>
<TITLE>Report Manager</TITLE>
<link href="http://links.10026.com/?link=/SQLReports/styles/ReportingServices.css"type="text/css"
rel="stylesheet">
<META Name='Generator' CONTENT='Microsoft SQL Server Report Manager
8.00.1038.00'>
<META Name='Report Server' CONTENT='http://MYDOMAIN/SQLReportServer'>
<META Name='StackTrace' CONTENT='System.NullReferenceException: Object
reference not set to an instance of an object.
at
Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetReportServerAuthentication()
at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetWebRequest(Uri
uri)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters)
at
Microsoft.SqlServer.ReportingServices.ReportingService.ListSecureMethods()
at Microsoft.SqlServer.ReportingServices.RSConnection.GetSecureMethods()
at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()
at
Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
methodname)
at Microsoft.ReportingServices.UI.Global.SecureAllAPI()
at
Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
level)
at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
sender, EventArgs args)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain()'>
"JMunson" wrote:
> I am able to view reports by navigating directly to /ReportServer however the
> report manager (/Reports/Home.aspx) gives the following:
> ERROR.
> Object reference not set to an instance of an object.
> No other info is provided. I'm using SSL and RS SP2 is installed, SQL has
> SP4. I've looked in the Reporting Services Log files but I don't see
> anything there to help trap this error.
> What "object" might this be? Any ideas about how to debug this?
> Thanks,
> Jeff Munson
> University of Washington

Report Manager Config Error

Hi;
I just installed RS and it seemed to go ok. But when I try to access the Report Manager at localhost\reports, I get the following error:
Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message: The XML file c:\winnt\microsoft.net\framework\v1.1.4322\Config\machine.config could not be loaded. Attempted to access an unloaded AppDomain.
Source Error:
[No relevant source lines]
Source File: c:\winnt\microsoft.net\framework\v1.1.4322\Config\machine.config Line: 0
----
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
I've tried to run the rsconfig utility several times, but nothing has helped so far.
Thanks for helping!This is an issue with your .net installation. Not sure what specifically is
causing this but searching google on the error should lead you in the right
direction.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Patrick_McD" <PatrickMcD@.discussions.microsoft.com> wrote in message
news:A5E49FA1-A934-47B6-891F-F4A321C3CA17@.microsoft.com...
> Hi;
> I just installed RS and it seemed to go ok. But when I try to access the
Report Manager at localhost\reports, I get the following error:
> Configuration Error
> Description: An error occurred during the processing of a configuration
file required to service this request. Please review the specific error
details below and modify your configuration file appropriately.
> Parser Error Message: The XML file
c:\winnt\microsoft.net\framework\v1.1.4322\Config\machine.config could not
be loaded. Attempted to access an unloaded AppDomain.
> Source Error:
> [No relevant source lines]
> Source File:
c:\winnt\microsoft.net\framework\v1.1.4322\Config\machine.config Line: 0
> ----
--
> Version Information: Microsoft .NET Framework Version:1.1.4322.573;
ASP.NET Version:1.1.4322.573
> I've tried to run the rsconfig utility several times, but nothing has
helped so far.
> Thanks for helping!