Attach additional files to data driven report

Is it possible to attach a file to a data driven report?
Thanks,
TimI don't believe you can do that. However, you can have a varbinary field
within a table on your MSSQL server, and create a small ASP page that will
return that file. Then all you need is a hyperlink on your report that will
point to that ASP page. I wouldn't recommend it for large files however. I
read somewhere that you shouldn't store anything larger than 256kb in a
varbinary field. MSSQL 2008 will address this issue with the filestream data
type.
If you need the C# code example for the ASP page, I can post it here. I got
it from someone on the ASP NG.
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Tim Kelley" <tkelley@.company.com> wrote in message
news:%23mvZVXalIHA.2304@.TK2MSFTNGP05.phx.gbl...
> Is it possible to attach a file to a data driven report?
> Thanks,
> Tim
>

Asterix not showing in report details

I have a report that shows a header, details and a footer

The detail line never prints lines with asterixes in them, e.g.

"**blah blah**"

As soon as I delete the asterix from the database, the line appears on the report

Any ideas anyone?

to clarify

are you saying:

you have a value in the database that contains the text "** blah blah **"

when you run the report, only "blah blah" is rendered in the row and not "** blah blah **"

?|||

It does not print the line at all, also additionally the problem seems to be caused only by the asterix at the start of the line

so when I would expect the report to show:

Header

detail1

detail2

*blah blah

detai*l4

Footer

The report actually omits the line "*blah blah" and prints this instead:

Header

detail1

detail2

detai*l4

Footer

|||

Interesting... but I am not able to repro this in a simple case (ie an expression such as ="****" prints fine).

So here are some questions:

* -- does the disappearing line occur in all output targets? Or only some (such as HTML versus Excel)?

* -- what does the expression for your detail column look like?

>L<

|||

To reproduce this you will have to query an sql database

The detail row of the table contains:

=Last(Fields!Case_SolutionNote.Value)

|||

no, I still can't repro it. I tried a simple version (without the Last) and also one with a Last() function. I could see it fine.

What else do I have to know about your Case_SolutionNote field? What type is it? How long are the typical values? Can you post some example values (with and without * character)?

>L<

|||

Interestingly, I also get a problem with the report's group footer section, it sometimes does not print at all either, I have not worked out why yet, but I suspect it is the presence of non alphanumeric characters in the relevant database field (which is an ntext data type)

I copied the contents of the field to notepad, deleted the contents of the field from the database, then used the 'update' statement (due to bug that prevents editing of ntext cells sometimes in microsoft sql server management studio) to repopulate it with a copy of the original text from notepad, it then shows on the report

I think there is a weakness somewhere in ntext data types in sql or reporting services relating to non alphanumeric characters

|||

Oh, also...

When I delete the report's group header/footer, leaving just a basic report with detail lines, the original problem dissappears - lines with asterixes at the beginning of them appear!!

ie the report prints correctly, e.g:

detail1

detail2

*blah blah

detai*l4

also...

if i have a group header/footer present, the group footer will print lines starting with asterixes but the detail lines do not

|||

When you copy the value of the field to Notepad and back, and then using the UPDATE statement you may not be preserving the Unicode characteristics of the string. It's hard to tell, because the clipboard buffer, the way you've stated the UPDATE, and the way the interactive query-handling facility in Studio would all be involved in interpreting that data <s>.

Point is, it is not a fair test...

>L<

|||

I wish I could be absolutely sure that your report logic isn't doing something to influence is -- forgive me, I don't mean to doubt you -- it's just that you have the Last() function in there....

IOW, I can't tell whether the lines you're expecting are missing because of what you've pinpointed (the asterisk) or some other factor, such as the sort/group/whatever changing what Last() decides should come up.

Without repro'ing more of your exact scenario I can't debug, reproduce your error.. or otherwise offer advice... sorry

>L<

|||

Hi thanks for you help

Regarding the second problem where the group footer was not displaying sometimes, I have worked around this by adding a space to the beginning of the data on the fly in the select statement in the report - note this only works in testing on sql server 2005 (unfortunately varchar(max) does not work in sql server 2000 where my database lives! )

ie i changed this:

select....., CaseProgress.Case_SolutionNote, .......

to

select....., (cast(' ' as varchar(max)) + cast(CaseProgress.Case_SolutionNote as varchar(max))) as Case_SolutionNote, .......

What this does is to populate the field if it was null in any rows - bear in mind i am using Last!(CaseProgress.Case_SolutionNote) and the last row is usually not empty but was not printing if prior rows had a 'null' in the field - wierd

The original problem with the aterix still stands

My hunch about alphanumeric characters was a red-herring i think

|||

Actually a slightly better workaround for the second problem is:

select..,isnull(CaseProgress.Case_SolutionNote, ' ') Case_SolutionNote,...

|||

>>The original problem with the aterix still stands

Unfortunately I think I can't go any further to help without being able to repro.

I created a table with an ntext column. I replaced the data in each even-numbered row with "*" + the data. I used the Last() function. I tried it on a details level and a group level. Still worked.

I'd be willing to look at your report, if you thought it would do any good... but I still think it may be something data related, even though I don't know why or how...

>> My hunch about alphanumeric characters was a red-herring i think

Yes, I'm sure of that...

>L<

|||

Fixed:

The filter on the detail line of the report was causing the problem, I changed the filter on the detail line to this:

=len(trim(Fields!Case_ProgressNote.Value)) > =0

(i.e. ignore blank entries)

note Case_ProgressNote.Value is ntext in the database, but by the time it gets to the layout it has been converted to text (the fact that it was ntext is irrelevant at this point)

Asterix not showing in report details

I have a report that shows a header, details and a footer

The detail line never prints lines with asterixes in them, e.g.

"**blah blah**"

As soon as I delete the asterix from the database, the line appears on the report

Any ideas anyone?

to clarify

are you saying:

you have a value in the database that contains the text "** blah blah **"

when you run the report, only "blah blah" is rendered in the row and not "** blah blah **"

?|||

It does not print the line at all, also additionally the problem seems to be caused only by the asterix at the start of the line

so when I would expect the report to show:

Header

detail1

detail2

*blah blah

detai*l4

Footer

The report actually omits the line "*blah blah" and prints this instead:

Header

detail1

detail2

detai*l4

Footer

|||

Interesting... but I am not able to repro this in a simple case (ie an expression such as ="****" prints fine).

So here are some questions:

* -- does the disappearing line occur in all output targets? Or only some (such as HTML versus Excel)?

* -- what does the expression for your detail column look like?

>L<

|||

To reproduce this you will have to query an sql database

The detail row of the table contains:

=Last(Fields!Case_SolutionNote.Value)

|||

no, I still can't repro it. I tried a simple version (without the Last) and also one with a Last() function. I could see it fine.

What else do I have to know about your Case_SolutionNote field? What type is it? How long are the typical values? Can you post some example values (with and without * character)?

>L<

|||

Interestingly, I also get a problem with the report's group footer section, it sometimes does not print at all either, I have not worked out why yet, but I suspect it is the presence of non alphanumeric characters in the relevant database field (which is an ntext data type)

I copied the contents of the field to notepad, deleted the contents of the field from the database, then used the 'update' statement (due to bug that prevents editing of ntext cells sometimes in microsoft sql server management studio) to repopulate it with a copy of the original text from notepad, it then shows on the report

I think there is a weakness somewhere in ntext data types in sql or reporting services relating to non alphanumeric characters

|||

Oh, also...

When I delete the report's group header/footer, leaving just a basic report with detail lines, the original problem dissappears - lines with asterixes at the beginning of them appear!!

ie the report prints correctly, e.g:

detail1

detail2

*blah blah

detai*l4

also...

if i have a group header/footer present, the group footer will print lines starting with asterixes but the detail lines do not

|||

When you copy the value of the field to Notepad and back, and then using the UPDATE statement you may not be preserving the Unicode characteristics of the string. It's hard to tell, because the clipboard buffer, the way you've stated the UPDATE, and the way the interactive query-handling facility in Studio would all be involved in interpreting that data <s>.

Point is, it is not a fair test...

>L<

|||

I wish I could be absolutely sure that your report logic isn't doing something to influence is -- forgive me, I don't mean to doubt you -- it's just that you have the Last() function in there....

IOW, I can't tell whether the lines you're expecting are missing because of what you've pinpointed (the asterisk) or some other factor, such as the sort/group/whatever changing what Last() decides should come up.

Without repro'ing more of your exact scenario I can't debug, reproduce your error.. or otherwise offer advice... sorry

>L<

|||

Hi thanks for you help

Regarding the second problem where the group footer was not displaying sometimes, I have worked around this by adding a space to the beginning of the data on the fly in the select statement in the report - note this only works in testing on sql server 2005 (unfortunately varchar(max) does not work in sql server 2000 where my database lives! )

ie i changed this:

select....., CaseProgress.Case_SolutionNote, .......

to

select....., (cast(' ' as varchar(max)) + cast(CaseProgress.Case_SolutionNote as varchar(max))) as Case_SolutionNote, .......

What this does is to populate the field if it was null in any rows - bear in mind i am using Last!(CaseProgress.Case_SolutionNote) and the last row is usually not empty but was not printing if prior rows had a 'null' in the field - wierd

The original problem with the aterix still stands

My hunch about alphanumeric characters was a red-herring i think

|||

Actually a slightly better workaround for the second problem is:

select..,isnull(CaseProgress.Case_SolutionNote,' ') Case_SolutionNote,...

|||

>>The original problem with the aterix still stands

Unfortunately I think I can't go any further to help without being able to repro.

I created a table with an ntext column. I replaced the data in each even-numbered row with "*" + the data. I used the Last() function. I tried it on a details level and a group level. Still worked.

I'd be willing to look at your report, if you thought it would do any good... but I still think it may be something data related, even though I don't know why or how...

>> My hunch about alphanumeric characters was a red-herring i think

Yes, I'm sure of that...

>L<

|||

Fixed:

The filter on the detail line of the report was causing the problem, I changed the filter on the detail line to this:

=len(trim(Fields!Case_ProgressNote.Value)) > =0

(i.e. ignore blank entries)

note Case_ProgressNote.Value is ntext in the database, but by the time it gets to the layout it has been converted to text (the fact that it was ntext is irrelevant at this point)

Asterix not showing in report details

I have a report that shows a header, details and a footer

The detail line never prints lines with asterixes in them, e.g.

"**blah blah**"

As soon as I delete the asterix from the database, the line appears on the report

Any ideas anyone?

to clarify

are you saying:

you have a value in the database that contains the text "** blah blah **"

when you run the report, only "blah blah" is rendered in the row and not "** blah blah **"

?|||

It does not print the line at all, also additionally the problem seems to be caused only by the asterix at the start of the line

so when I would expect the report to show:

Header

detail1

detail2

*blah blah

detai*l4

Footer

The report actually omits the line "*blah blah" and prints this instead:

Header

detail1

detail2

detai*l4

Footer

|||

Interesting... but I am not able to repro this in a simple case (ie an expression such as ="****" prints fine).

So here are some questions:

* -- does the disappearing line occur in all output targets? Or only some (such as HTML versus Excel)?

* -- what does the expression for your detail column look like?

>L<

|||

To reproduce this you will have to query an sql database

The detail row of the table contains:

=Last(Fields!Case_SolutionNote.Value)

|||

no, I still can't repro it. I tried a simple version (without the Last) and also one with a Last() function. I could see it fine.

What else do I have to know about your Case_SolutionNote field? What type is it? How long are the typical values? Can you post some example values (with and without * character)?

>L<

|||

Interestingly, I also get a problem with the report's group footer section, it sometimes does not print at all either, I have not worked out why yet, but I suspect it is the presence of non alphanumeric characters in the relevant database field (which is an ntext data type)

I copied the contents of the field to notepad, deleted the contents of the field from the database, then used the 'update' statement (due to bug that prevents editing of ntext cells sometimes in microsoft sql server management studio) to repopulate it with a copy of the original text from notepad, it then shows on the report

I think there is a weakness somewhere in ntext data types in sql or reporting services relating to non alphanumeric characters

|||

Oh, also...

When I delete the report's group header/footer, leaving just a basic report with detail lines, the original problem dissappears - lines with asterixes at the beginning of them appear!!

ie the report prints correctly, e.g:

detail1

detail2

*blah blah

detai*l4

also...

if i have a group header/footer present, the group footer will print lines starting with asterixes but the detail lines do not

|||

When you copy the value of the field to Notepad and back, and then using the UPDATE statement you may not be preserving the Unicode characteristics of the string. It's hard to tell, because the clipboard buffer, the way you've stated the UPDATE, and the way the interactive query-handling facility in Studio would all be involved in interpreting that data <s>.

Point is, it is not a fair test...

>L<

|||

I wish I could be absolutely sure that your report logic isn't doing something to influence is -- forgive me, I don't mean to doubt you -- it's just that you have the Last() function in there....

IOW, I can't tell whether the lines you're expecting are missing because of what you've pinpointed (the asterisk) or some other factor, such as the sort/group/whatever changing what Last() decides should come up.

Without repro'ing more of your exact scenario I can't debug, reproduce your error.. or otherwise offer advice... sorry

>L<

|||

Hi thanks for you help

Regarding the second problem where the group footer was not displaying sometimes, I have worked around this by adding a space to the beginning of the data on the fly in the select statement in the report - note this only works in testing on sql server 2005 (unfortunately varchar(max) does not work in sql server 2000 where my database lives! )

ie i changed this:

select....., CaseProgress.Case_SolutionNote, .......

to

select....., (cast(' ' as varchar(max)) + cast(CaseProgress.Case_SolutionNote as varchar(max))) as Case_SolutionNote, .......

What this does is to populate the field if it was null in any rows - bear in mind i am using Last!(CaseProgress.Case_SolutionNote) and the last row is usually not empty but was not printing if prior rows had a 'null' in the field - wierd

The original problem with the aterix still stands

My hunch about alphanumeric characters was a red-herring i think

|||

Actually a slightly better workaround for the second problem is:

select..,isnull(CaseProgress.Case_SolutionNote,' ') Case_SolutionNote,...

|||

>>The original problem with the aterix still stands

Unfortunately I think I can't go any further to help without being able to repro.

I created a table with an ntext column. I replaced the data in each even-numbered row with "*" + the data. I used the Last() function. I tried it on a details level and a group level. Still worked.

I'd be willing to look at your report, if you thought it would do any good... but I still think it may be something data related, even though I don't know why or how...

>> My hunch about alphanumeric characters was a red-herring i think

Yes, I'm sure of that...

>L<

|||

Fixed:

The filter on the detail line of the report was causing the problem, I changed the filter on the detail line to this:

=len(trim(Fields!Case_ProgressNote.Value)) > =0

(i.e. ignore blank entries)

note Case_ProgressNote.Value is ntext in the database, but by the time it gets to the layout it has been converted to text (the fact that it was ntext is irrelevant at this point)

sql

Associating Report Viewer (without UI) with Data Set

Hello all - I am looking to use the ReportViewer Control to automatically print out some client based reports.

I started with the "Print a report from a console app" sample from http://www.gotreportviewer.com/.

I have managed to convert an existing server based report from an RDL to an RDLC, and added it to my Console Project with VB.NET. In addition, I created a new Data Set within this project that returns the data from the original stored procedure that was used for the RDL file. I believe I have also successfully passed in the correct parameters to the sproc, but now I need to associate this new Data Set with the RDLC report. The RDLC has a simple table control that has a few fields from the new Data Set. When the report is rendered, I receive an exception indicating the following:

{"A data source instance has not been supplied for the data source "Production_stpProductionByDay"."}

It would seem that I need to programmatically associate my Data Set with the report, but I cannot seem to figure out the correct syntax.

Here is my Run method:

m_PhaseID = 1

m_ShiftID = 1

m_DateTime = Now()

Dim report As LocalReport = New LocalReport()

Dim parReport(2) As ReportParameter

Dim parDay As New ReportParameter("Day", m_DateTime)

Dim parPhaseID As New ReportParameter("PhaseID", m_PhaseID)

Dim parShiftID As New ReportParameter("ShiftID", m_ShiftID)

parReport(0) = parDay

parReport(1) = parPhaseID

parReport(2) = parShiftID

report.ReportPath = "C:\Documents and Settings\Kruse\My Documents\Visual Studio 2005\Projects\ShellyReportPrint\ShellyReportPrint\Production.rdlc"

report.SetParameters(parReport)

Export(report)

m_currentPageIndex = 0

Print()

Any help would be greatly appreciated! Thanks..

I have yet to find a solution for this issue... has anyone else implemented something similar?

If not, I guess I will have to wait until TechEd 2K6!

Assing Report Parameters

Can you evaluate and assign a new value to a parameter in an expression for a textbox?

Did you just curse?

I'm not even sure what you're asking. It's too general. What are you trying to do?

|||

Basically you want to assign a new value to the Parameter after the user selects his option. is that correct?

If yes, you will not be able to reassign this parameter but what you can do is

1. create another hidden parameter

2. Make sure that this is placed next tothe first parameter

3. Now, you can use the expression to assign the value to this hidden parameter based on what is selected in the first parameter.

Hope this answers your question...or another option is to take it back to SQL and then use the expression in SQL to reassign the values.

Assigning values based on InitialToggleState of a control in SSRS

Hi,

I need to assign the value for a field in a report based on Expand/Collapse state of another field.

Eg. If Collapsed, the value should be "AA" else if Expanded "BB".

Is there any way to get the value of InitialToggleState for any field in SSRS.

Thanks in advance.

Sathya

Use True for Collapsed and False for Expanded.

As explained at the following link

http://www.manning-sandbox.com/thread.jspa?threadID=14881&tstart=60

Assigning values based on InitialToggleState of a control in SSRS

Hi,

I need to assign the value for a field in a report based on Expand/Collapse state of another field.

Eg. If Collapsed, the value should be "AA" else if Expanded "BB".

Is there any way to get the value of InitialToggleState for any field in SSRS.

Thanks in advance.

Sathya

Use True for Collapsed and False for Expanded.

As explained at the following link

http://www.manning-sandbox.com/thread.jspa?threadID=14881&tstart=60

assigning datasetname dynamically to a report ?

Hi friends
am new to reports in VS2005.
how can i assign a datasource dynamically to a report.
i know how to do add datasource in desgin mode to a report.(i.e i create a new datasource and drag and drop it on to report).

but in my case i need to take some parameters from users and create a dataset with relavant data and show it in a report.
i cant find any documentation or samples for it.
Thanks for your help.
BTW its winform application and i want to show that report in report viwer control.
Thanks for your helpFinally i found a way to do this.
first i created typed dataset and bound it to my report. and in my screen i populate this typed dataset with data and load the report in report viewer control.
my sample code

reportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Local;
reportViewer1.LocalReport.ReportEmbeddedResource = "WindowsApplication1.samplereport.rdlc";
reportViewer1.LocalReport.DataSources.Add(
new ReportDataSource("MyTable", GetData()));
this.reportViewer1.RefreshReport();

in getdate() method i loop thru my data reader and populated the typed dataset .

is this right approach i.e. using typed dataset and is there any better approach of doing it.
Thanks for your ideas.

Assigning a Dataset to a Rectangle

Hello,
I've created a Rectangle within a SQL Report, and i'd like to tie it
back to a Dataset. Within the Rectangle Properties it lists Data
Region, but none of my Datasets are appearing in the dropdown.
I found the following article on Microsoft's site -
http://technet.microsoft.com/en-us/library/ms159224.aspx - but the
first step is throwing me - "In Layout view, right-click the data
region and then click Properties." Data Region is an option within
the Rectangle Properties and not an object in of itself, so I'm not
sure what "Data Region" it's saying to right-click on.
Can someone point me in the right direction?
Thanks,
AlexOn Feb 14, 9:35=A0am, Alex <sama...@.gmail.com> wrote:
> Hello,
> I've created a Rectangle within a SQL Report, and i'd like to tie it
> back to a Dataset. =A0Within the Rectangle Properties it lists Data
> Region, but none of my Datasets are appearing in the dropdown.
> I found the following article on Microsoft's site -http://technet.microsof=
t.com/en-us/library/ms159224.aspx- but the
> first step is throwing me - "In Layout view, right-click the data
> region and then click Properties." =A0Data Region is an option within
> the Rectangle Properties and not an object in of itself, so I'm not
> sure what "Data Region" it's saying to right-click on.
> Can someone point me in the right direction?
> Thanks,
> Alex
Alex,
First thing to know, a rectangle is not a data region, it is a
graphical "report item" that's more like a container to keep report
items together.
Data regions are table, matrix, chart and list. They can be
associated with a dataset, rectangles cannot.
I'd suggest you try using the list data region as it will give you the
flexibility of freeform layout while still letting you tie back to a
dataset.
Also, take a look at this TechNet article for more info on Data
Regions:
http://technet.microsoft.com/en-us/library/ms157134.aspx
And this one for report items:
http://technet.microsoft.com/en-us/library/ms159268.aspx
HTH
toolman

assigning a data source

Is there any other way to a assign a data source to a report other than
through the Report Manager. The reason I ask is because when I try to
browse for data sources in Report Manager, I get "Object reference not set
to an instance of an object". Microsoft tech support seems unable to help
with this error message so I'm wondering if assigning a data source can be
done outside of the Manager.
--Will you send the Report Manager log file that contains the object reference
exception? The file name should be ReportServerWebApp_<current date>.log
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Richard Cranium" <mgreco40@.hotmail.com> wrote in message
news:%23lOzEIpmEHA.2096@.TK2MSFTNGP15.phx.gbl...
> Is there any other way to a assign a data source to a report other than
> through the Report Manager. The reason I ask is because when I try to
> browse for data sources in Report Manager, I get "Object reference not set
> to an instance of an object". Microsoft tech support seems unable to help
> with this error message so I'm wondering if assigning a data source can be
> done outside of the Manager.
> --
>
>|||I received the strack trace from the PSS engineer you were working with. I
believe you have view state disabled on your machine. In the web.config
file in the Report Manager directory, add the attribute
enableViewState="true" to the system.web/pages tag:
<system.web>
<pages enableViewState="true" />
</system.web>
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Richard Cranium" <mgreco40@.hotmail.com> wrote in message
news:%23lOzEIpmEHA.2096@.TK2MSFTNGP15.phx.gbl...
> Is there any other way to a assign a data source to a report other than
> through the Report Manager. The reason I ask is because when I try to
> browse for data sources in Report Manager, I get "Object reference not set
> to an instance of an object". Microsoft tech support seems unable to help
> with this error message so I'm wondering if assigning a data source can be
> done outside of the Manager.
> --
>
>

ASSERT: Assertion failed!

Dear ALL,
I have this problem during view report in Report Manager (I m using CTP Sept
Cut for my SQL 2005 now). And, i can't find out what is this error about.
w3wp!processing!1!10/26/2005-12:01:48:: a ASSERT: Assertion failed! Call
stack
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+PageSectionContext.GetTableCellProperties(Int32 cellIndex)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+PageSectionContext.IsParentVisible()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.AddPageTextbox(ProcessingContext
processingContext, TextBox textbox, TextBoxInstance textboxInstance,
TextBoxInstanceInfo textboxInstanceInfo, Object value)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateTextBoxInstance(TextBox
textBox, ProcessingContext processingContext, Int32 index, IScope
containingScope)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstance(ReportItem
reportItem, Boolean setupEnvironment, Int32 index)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstances(ReportItemColInstance
collectionInstance, ReportItemCollection reportItemsDef)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableDetailObj.CreateInstance()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.CreateInstances()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.Microsoft.ReportingServices.ReportProcessing.ReportProcessing.IHierarchyObj.Traverse(ProcessingStages operation)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNodeTuple.Traverse(ProcessingStages operation, Boolean ascending)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNode.Traverse(ProcessingStages operation, Boolean ascending)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupingObj.Traverse(ProcessingStages operation, Boolean ascending)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.CreateInstances()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.Microsoft.ReportingServices.ReportProcessing.ReportProcessing.IHierarchyObj.Traverse(ProcessingStages operation)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNodeTuple.Traverse(ProcessingStages operation, Boolean ascending)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNode.Traverse(ProcessingStages operation, Boolean ascending)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupingObj.Traverse(ProcessingStages operation, Boolean ascending)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.CreateInstances()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.Microsoft.ReportingServices.ReportProcessing.ReportProcessing.IHierarchyObj.Traverse(ProcessingStages operation)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNodeTuple.Traverse(ProcessingStages operation, Boolean ascending)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNode.Traverse(ProcessingStages operation, Boolean ascending)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupingObj.Traverse(ProcessingStages operation, Boolean ascending)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeDetailObj.CreateInstances(ReportItemInstance
riInstance, IList instanceList, RenderingPagesRangesList pagesList)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableDetailObj.CreateInstances(ReportItemInstance
riInstance, IList instanceList, RenderingPagesRangesList pagesList)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableGroupLeafObj.CreateInstance()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupLeafObj.Traverse(ProcessingStages operation)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupLeafObj.TraverseAllLeafNodes(ProcessingStages operation)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupingObj.Traverse(ProcessingStages operation, Boolean ascending)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupRootObj.CreateInstances(ReportItemInstance
riInstance, IList instanceList, RenderingPagesRangesList pagesList)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableGroupLeafObj.CreateInstance()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupLeafObj.Traverse(ProcessingStages operation)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupLeafObj.TraverseAllLeafNodes(ProcessingStages operation)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupingObj.Traverse(ProcessingStages operation, Boolean ascending)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupRootObj.CreateInstances(ReportItemInstance
riInstance, IList instanceList, RenderingPagesRangesList pagesList)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableObj.CreateInstances(ReportItemInstance
riInstance, IList instanceList, RenderingPagesRangesList pagesList)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstance(ReportItem
reportItem, Boolean setupEnvironment, Int32 index)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstances(ReportItemColInstance
collectionInstance, ReportItemCollection reportItemsDef)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstances(ReportItemColInstance
collectionInstance, Boolean ignorePageBreaks, Boolean ignoreInstances)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableObj.CreateRowInstances(ProcessingContext
processingContext, RuntimeRICollectionList rowRICols, TableRowInstance[]
rowInstances, Boolean repeatOnNewPages, Boolean enterGrouping)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableGroupLeafObj.CreateInstance()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupLeafObj.Traverse(ProcessingStages operation)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupLeafObj.TraverseAllLeafNodes(ProcessingStages operation)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.CreateInstances()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.Microsoft.ReportingServices.ReportProcessing.ReportProcessing.IHierarchyObj.Traverse(ProcessingStages operation)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNodeTuple.Traverse(ProcessingStages operation, Boolean ascending)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNode.Traverse(ProcessingStages operation, Boolean ascending)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupingObj.Traverse(ProcessingStages operation, Boolean ascending)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupRootObj.CreateInstances(ReportItemInstance
riInstance, IList instanceList, RenderingPagesRangesList pagesList)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableObj.CreateInstances(ReportItemInstance
riInstance, IList instanceList, RenderingPagesRangesList pagesList)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstance(ReportItem
reportItem, Boolean setupEnvironment, Int32 index)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstances(ReportItemColInstance
collectionInstance, ReportItemCollection reportItemsDef)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+Merge.CreateInstances(ParameterInfoCollection parameters, Boolean noRows)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+Merge.Process(ParameterInfoCollection parameters, Boolean mergeTran)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessReport(Report report, ProcessingContext pc, ProcessingContext context)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessReport(Report
report, ProcessingContext pc, Boolean snapshotProcessing, Boolean
processWithCachedData, GetReportChunk getChunkCallback, ErrorContext
errorContext, DateTime executionTime, CreateReportChunk cacheDataCallback,
ProcessingContext& context)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension
renderer, DateTime executionTimeStamp, GetReportChunk
getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc,
CreateReportChunk cacheDataCallback, Boolean& dataCached)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime
executionTimeStamp, GetReportChunk getCompiledDefinitionCallback,
ProcessingContext pc, RenderingContext rc)
Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext
reportContext, ItemProperties properties, ParameterInfoCollection
effectiveParameters, Guid reportId, ClientRequest session, String
description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection
thisReportDataSources, Boolean cachingRequested, Warning[]& warnings,
ReportSnapshot& resultSnapshotData, DateTime& executionDateTime,
RuntimeDataSourceInfoCollection& alldataSources, UserProfileState&
usedUserProfile)
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
rs, CatalogItemContext reportContext, ClientRequest session, JobType type,
Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]&
secondaryStreamNames)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.ProcessRequest(HttpContext context)
System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously)
System.Web.HttpApplication.ResumeSteps(Exception error)
System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
w3wp!library!1!10/26/2005-12:01:48:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., un-named assertion fired for component processing;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details.
Please help
NickyThis is a known issue in CTP September. Your report has a table with another
table inside that has table detail rows. The detail rows of that inner table
are causing the issue. The fix is available in SQL Server 2005 RTM.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Nicky" <Nicky@.discussions.microsoft.com> wrote in message
news:5A957A04-9D69-4C9D-9D5F-CB95FA802D2C@.microsoft.com...
> Dear ALL,
> I have this problem during view report in Report Manager (I m using CTP
> Sept
> Cut for my SQL 2005 now). And, i can't find out what is this error about.
> w3wp!processing!1!10/26/2005-12:01:48:: a ASSERT: Assertion failed! Call
> stack:
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+PageSectionContext.GetTableCellProperties(Int32
> cellIndex)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+PageSectionContext.IsParentVisible()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.AddPageTextbox(ProcessingContext
> processingContext, TextBox textbox, TextBoxInstance textboxInstance,
> TextBoxInstanceInfo textboxInstanceInfo, Object value)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateTextBoxInstance(TextBox
> textBox, ProcessingContext processingContext, Int32 index, IScope
> containingScope)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstance(ReportItem
> reportItem, Boolean setupEnvironment, Int32 index)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstances(ReportItemColInstance
> collectionInstance, ReportItemCollection reportItemsDef)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableDetailObj.CreateInstance()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.CreateInstances()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.Microsoft.ReportingServices.ReportProcessing.ReportProcessing.IHierarchyObj.Traverse(ProcessingStages
> operation)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNodeTuple.Traverse(ProcessingStages
> operation, Boolean ascending)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNode.Traverse(ProcessingStages
> operation, Boolean ascending)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupingObj.Traverse(ProcessingStages
> operation, Boolean ascending)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.CreateInstances()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.Microsoft.ReportingServices.ReportProcessing.ReportProcessing.IHierarchyObj.Traverse(ProcessingStages
> operation)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNodeTuple.Traverse(ProcessingStages
> operation, Boolean ascending)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNode.Traverse(ProcessingStages
> operation, Boolean ascending)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupingObj.Traverse(ProcessingStages
> operation, Boolean ascending)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.CreateInstances()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.Microsoft.ReportingServices.ReportProcessing.ReportProcessing.IHierarchyObj.Traverse(ProcessingStages
> operation)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNodeTuple.Traverse(ProcessingStages
> operation, Boolean ascending)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNode.Traverse(ProcessingStages
> operation, Boolean ascending)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupingObj.Traverse(ProcessingStages
> operation, Boolean ascending)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeDetailObj.CreateInstances(ReportItemInstance
> riInstance, IList instanceList, RenderingPagesRangesList pagesList)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableDetailObj.CreateInstances(ReportItemInstance
> riInstance, IList instanceList, RenderingPagesRangesList pagesList)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableGroupLeafObj.CreateInstance()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupLeafObj.Traverse(ProcessingStages
> operation)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupLeafObj.TraverseAllLeafNodes(ProcessingStages
> operation)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupingObj.Traverse(ProcessingStages
> operation, Boolean ascending)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupRootObj.CreateInstances(ReportItemInstance
> riInstance, IList instanceList, RenderingPagesRangesList pagesList)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableGroupLeafObj.CreateInstance()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupLeafObj.Traverse(ProcessingStages
> operation)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupLeafObj.TraverseAllLeafNodes(ProcessingStages
> operation)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupingObj.Traverse(ProcessingStages
> operation, Boolean ascending)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupRootObj.CreateInstances(ReportItemInstance
> riInstance, IList instanceList, RenderingPagesRangesList pagesList)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableObj.CreateInstances(ReportItemInstance
> riInstance, IList instanceList, RenderingPagesRangesList pagesList)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstance(ReportItem
> reportItem, Boolean setupEnvironment, Int32 index)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstances(ReportItemColInstance
> collectionInstance, ReportItemCollection reportItemsDef)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstances(ReportItemColInstance
> collectionInstance, Boolean ignorePageBreaks, Boolean ignoreInstances)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableObj.CreateRowInstances(ProcessingContext
> processingContext, RuntimeRICollectionList rowRICols, TableRowInstance[]
> rowInstances, Boolean repeatOnNewPages, Boolean enterGrouping)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableGroupLeafObj.CreateInstance()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupLeafObj.Traverse(ProcessingStages
> operation)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupLeafObj.TraverseAllLeafNodes(ProcessingStages
> operation)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.CreateInstances()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.Microsoft.ReportingServices.ReportProcessing.ReportProcessing.IHierarchyObj.Traverse(ProcessingStages
> operation)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNodeTuple.Traverse(ProcessingStages
> operation, Boolean ascending)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNode.Traverse(ProcessingStages
> operation, Boolean ascending)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupingObj.Traverse(ProcessingStages
> operation, Boolean ascending)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupRootObj.CreateInstances(ReportItemInstance
> riInstance, IList instanceList, RenderingPagesRangesList pagesList)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableObj.CreateInstances(ReportItemInstance
> riInstance, IList instanceList, RenderingPagesRangesList pagesList)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstance(ReportItem
> reportItem, Boolean setupEnvironment, Int32 index)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstances(ReportItemColInstance
> collectionInstance, ReportItemCollection reportItemsDef)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+Merge.CreateInstances(ParameterInfoCollection
> parameters, Boolean noRows)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+Merge.Process(ParameterInfoCollection
> parameters, Boolean mergeTran)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessReport(Report
> report, ProcessingContext pc, ProcessingContext context)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessReport(Report
> report, ProcessingContext pc, Boolean snapshotProcessing, Boolean
> processWithCachedData, GetReportChunk getChunkCallback, ErrorContext
> errorContext, DateTime executionTime, CreateReportChunk cacheDataCallback,
> ProcessingContext& context)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension
> renderer, DateTime executionTimeStamp, GetReportChunk
> getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc,
> CreateReportChunk cacheDataCallback, Boolean& dataCached)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime
> executionTimeStamp, GetReportChunk getCompiledDefinitionCallback,
> ProcessingContext pc, RenderingContext rc)
> Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext
> reportContext, ItemProperties properties, ParameterInfoCollection
> effectiveParameters, Guid reportId, ClientRequest session, String
> description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection
> thisReportDataSources, Boolean cachingRequested, Warning[]& warnings,
> ReportSnapshot& resultSnapshotData, DateTime& executionDateTime,
> RuntimeDataSourceInfoCollection& alldataSources, UserProfileState&
> usedUserProfile)
> Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters)
> Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters, String[]&
> secondaryStreamNames)
> Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
> Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
> Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
> rs, CatalogItemContext reportContext, ClientRequest session, JobType type,
> Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
> String[]&
> secondaryStreamNames)
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory
> streamFactory)
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation
> operation)
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType
> itemType)
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.ProcessRequest(HttpContext
> context)
> System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
> System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
> completedSynchronously)
> System.Web.HttpApplication.ResumeSteps(Exception error)
> System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext
> context, AsyncCallback cb, Object extraData)
> System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
> System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
> System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
> w3wp!library!1!10/26/2005-12:01:48:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more
> details., un-named assertion fired for component processing;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more
> details.
> Please help
> Nicky
>

Assert Permission - ISSUE.

Hi All,
I am using a .net dll in my RDL, I have done all the steps to implement the
custom assembly in the report.
--
Message posted via http://www.sqlmonster.comLook at this thread, you have to get Reporting Services trust your DLL.
http://groups.google.de/groups?hl=de&lr=&threadm=OAxg3EQRFHA.4028%40tk2msftngp13.phx.gbl&rnum=1&prev=/groups%3Fq%3Dreporting%2Bservices%2Bassembly%2Bgac%26hl%3Dde%26lr%3D%26scoring%3Dd%26selm%3DOAxg3EQRFHA.4028%2540tk2msftngp13.phx.gbl%26rnum%3D1
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"BALAJI KRISHNAN via SQLMonster.com" <forum@.nospam.SQLMonster.com> schrieb
im Newsbeitrag news:25b6837f5aaf4a7589ef4ac1bd3cd615@.SQLMonster.com...
> Hi All,
> I am using a .net dll in my RDL, I have done all the steps to implement
> the
> custom assembly in the report.
> --
> Message posted via http://www.sqlmonster.com|||Sorry hit the Post Message button... Remaining Message...
I have done all the steps...
Step 1) Copying the dll to the C:\Program Files\Microsoft SQL Server\MSSQL\
Reporting Services\ReportServer\bin\
and
C:\Program Files\Microsoft SQL Server\80\Tools\Report Designer\ - Folders
Step 2) Create Permission Set and Code Group and changing the
rssrvpolicy.config file...
See my Permission Set and Code Group added to the file
<PermissionSet class="NamedPermissionSet"
version="1"
Name="CCPermissionSet">
<IPermission class="SecurityPermission"
version="1"
Flags="Assertion, Execution"/>
</PermissionSet>
<CodeGroup class="UnionCodeGroup"
version="1"
PermissionSetName="CCPermissionSet"
Name="CCCodeGroup"
Description="">
<IMembershipCondition class="UrlMembershipCondition"
version="1"
Url="file://C:/Program
Files/Microsoft SQL Server/MSSQL/Reporting
Services/ReportServer/bin/CreditCardDecrypt.dll"/>
</CodeGroup>
Step 3) Refering the dll in the RDL (Properties - Reference - map dll)
Step 4) This is the Important step...Where I am missing...I need to give
the Assert permission to my code..I dont know what Assert Permission I need
to give for my dll...(As we give for SqlClientPermission...)
See my dll code...
public static string DecryptCardInfo(string cc,string subjectName,string
storeName)
{
string sCreditCard = "";
try
{
SecurityPermission secPerm = new SecurityPermission
(PermissionState.Unrestricted);
secPerm.Assert();
WSEX509.X509CertificateStore.StoreLocation location =WSEX509.X509CertificateStore.StoreLocation.CurrentUser;
WSEX509.X509CertificateStore.StoreProvider provider =WSEX509.X509CertificateStore.StoreProvider.System;
WSEX509.X509CertificateStore store = new WSEX509.X509CertificateStore
(provider, location, storeName);
bool fopen = store.OpenRead();
if(fopen)
{
WSEX509.X509CertificateCollection certs =store.FindCertificateBySubjectString(subjectName);
if (certs.Count > 0)
{
WSEX509.X509Certificate cer = certs[0];
WSECRY.RSACryptoServiceProvider rsaCsp =(WSECRY.RSACryptoServiceProvider)cer.Key;
byte[] cipherData = Convert.FromBase64String(cc);
byte[] plainData = rsaCsp.Decrypt(cipherData, false);
sCreditCard = Encoding.UTF8.GetString(plainData);
}
}
if (store != null)
store.Close();
return sCreditCard;
//return cc;
}
catch(Exception ex)
{
return ex.ToString();
}
}
}
I am in Need your help Immediately..because I am stuck with this for the
past days..and have no clue for this...
If you need any more information please send a note I can give u
immediately...
Thanks in advance...
balaji.
--
Message posted via http://www.sqlmonster.com|||Try to place you DLL in the GAC to identify wheter it is a security problem.
"BALAJI KRISHNAN via SQLMonster.com" <forum@.SQLMonster.com> schrieb im
Newsbeitrag news:7f6dadd296e74d5a9a51a62bac995613@.SQLMonster.com...
> Sorry hit the Post Message button... Remaining Message...
> I have done all the steps...
> Step 1) Copying the dll to the C:\Program Files\Microsoft SQL
> Server\MSSQL\
> Reporting Services\ReportServer\bin\
> and
> C:\Program Files\Microsoft SQL Server\80\Tools\Report Designer\ - Folders
> Step 2) Create Permission Set and Code Group and changing the
> rssrvpolicy.config file...
> See my Permission Set and Code Group added to the file
> <PermissionSet class="NamedPermissionSet"
> version="1"
> Name="CCPermissionSet">
> <IPermission class="SecurityPermission"
> version="1"
> Flags="Assertion, Execution"/>
> </PermissionSet>
> <CodeGroup class="UnionCodeGroup"
> version="1"
> PermissionSetName="CCPermissionSet"
> Name="CCCodeGroup"
> Description="">
> <IMembershipCondition class="UrlMembershipCondition"
> version="1"
> Url="file://C:/Program
> Files/Microsoft SQL Server/MSSQL/Reporting
> Services/ReportServer/bin/CreditCardDecrypt.dll"/>
> </CodeGroup>
>
> Step 3) Refering the dll in the RDL (Properties - Reference - map dll)
> Step 4) This is the Important step...Where I am missing...I need to give
> the Assert permission to my code..I dont know what Assert Permission I
> need
> to give for my dll...(As we give for SqlClientPermission...)
>
> See my dll code...
> public static string DecryptCardInfo(string cc,string subjectName,string
> storeName)
> {
> string sCreditCard = "";
> try
> {
> SecurityPermission secPerm = new SecurityPermission
> (PermissionState.Unrestricted);
> secPerm.Assert();
> WSEX509.X509CertificateStore.StoreLocation location => WSEX509.X509CertificateStore.StoreLocation.CurrentUser;
> WSEX509.X509CertificateStore.StoreProvider provider => WSEX509.X509CertificateStore.StoreProvider.System;
> WSEX509.X509CertificateStore store = new WSEX509.X509CertificateStore
> (provider, location, storeName);
> bool fopen = store.OpenRead();
> if(fopen)
> {
> WSEX509.X509CertificateCollection certs => store.FindCertificateBySubjectString(subjectName);
> if (certs.Count > 0)
> {
> WSEX509.X509Certificate cer = certs[0];
> WSECRY.RSACryptoServiceProvider rsaCsp => (WSECRY.RSACryptoServiceProvider)cer.Key;
> byte[] cipherData = Convert.FromBase64String(cc);
> byte[] plainData = rsaCsp.Decrypt(cipherData, false);
> sCreditCard = Encoding.UTF8.GetString(plainData);
> }
> }
> if (store != null)
> store.Close();
> return sCreditCard;
> //return cc;
> }
> catch(Exception ex)
> {
> return ex.ToString();
> }
> }
> }
>
> I am in Need your help Immediately..because I am stuck with this for the
> past days..and have no clue for this...
> If you need any more information please send a note I can give u
> immediately...
> Thanks in advance...
> balaji.
> --
> Message posted via http://www.sqlmonster.com|||Hi Jens,
I have placed the dll in the GAC sucessfully.
But still I got #Error...
Balaji
--
Message posted via http://www.sqlmonster.com|||CAN MICROSOFT FOLKS HELP ON THIS....
STILL FACING THE ISSSUE..
THANKS IN ADVANCE
BALAJI
--
Message posted via http://www.sqlmonster.com|||Hi Balaji,
Is your problem is solve of acessing .net dll in reporting service.
I am also having the same problem where my .Net dll reads the config file to
get another file URL which has stored another file URL and using this new URL
(XML file) i am accessing the result through XMldocument and returing the
result back. But the security issue is the main issue which i am not able to
solve. If you can help me out i'll be helpful to you.
Thanks
Jasvinder
"BALAJI KRISHNAN via SQLMonster.com" wrote:
> Hi All,
> I am using a .net dll in my RDL, I have done all the steps to implement the
> custom assembly in the report.
> --
> Message posted via http://www.sqlmonster.com
>

Assembly: returning "Globals!ReportName" but letting RS see it as code, not text?

I'm trying to make a reusable header function. In it, there is the report name and a couple other bits of info. The problem is making RS use the real report name

If I return "Globals!ReportName" in an assembly function, then call that function, I get that exact text - but what I really want is the report name. I understand what it's doing, but how to I trick it:

Is there some way to make RS aware of the fact that this is meant to be seen as something it needs to evaluate rather than just displaying the actual text?

How about passing the report name to your function as a parameter and then return the name in the return value?|||

that might be an option.

It's very similar to what i have in place - just appending the report name to the return value.

|||You probably tried this, but would it work to set a variable = Globals!ReportName.Value and then concatenate the variable with your other strings?
|||If you mean in the .net assembly, I just tried it and no luck, but thanks. It seems any text returned is taken to be literal, not code. I even tried something like {Globals!ReportName} - hoping to get lucky, but didn't.

Assembly ReportingServicesWebServer problem

I did a fresh install of Reporting Services (Standard Edition Final).
From the service manager the report service is running, but i get the following error on http://localhost/ReportServer/

Server Error in '/ReportServer' Application.

---

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: Could not load file or assembly 'ReportingServicesWebServer, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Access is denied.

Source Error:

Line 27: <assemblies>
Line 28: <clear />
Line 29: <add assembly="ReportingServicesWebServer" />
Line 30: </assemblies>
Line 31: </compilation>

Source File: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config Line: 29

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

=== Pre-bind state information ===
LOG: User = Unknown
LOG: DisplayName = ReportingServicesWebServer
(Partial)
LOG: Appbase = file:///C:/Program Files/Microsoft SQL Server/MSSQL.3/Reporting Services/ReportServer/
LOG: Initial PrivatePath = C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin
Calling assembly : (Unknown).
===
LOG: This bind starts in default load context.
LOG: Using application configuration file: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\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/reportserver/b7e1529c/70d36ced/ReportingServicesWebServer.DLL.
LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/Temporary ASP.NET Files/reportserver/b7e1529c/70d36ced/ReportingServicesWebServer/ReportingServicesWebServer.DLL.
LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/MSSQL.3/Reporting Services/ReportServer/bin/ReportingServicesWebServer.DLL.
LOG: Using application configuration file: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\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: ReportingServicesWebServer, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
ERR: Failed to complete setup of assembly (hr = 0x80070005). Probing terminated.

Hi!

I'm having the same problem, can someone help me?

Thank you!

|||I have the same problem ,can someone help me..|||

xian_ve

xian_ve,

Can you verify the version SQL reporting services is .NET version 2.0, and that your application pool for reporting service is using "Network" logon?

Ham

|||

That is so on my computer.

What is the solution?

Assembly ReportingServicesWebServer problem

I did a fresh install of Reporting Services (Standard Edition Final).
From the service manager the report service is running, but i get the following error on http://localhost/ReportServer/

Server Error in '/ReportServer' Application.

---

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: Could not load file or assembly 'ReportingServicesWebServer, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Access is denied.

Source Error:

Line 27: <assemblies>
Line 28: <clear />
Line 29: <add assembly="ReportingServicesWebServer" />
Line 30: </assemblies>
Line 31: </compilation>

Source File: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config Line: 29

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

=== Pre-bind state information ===
LOG: User = Unknown
LOG: DisplayName = ReportingServicesWebServer
(Partial)
LOG: Appbase = file:///C:/Program Files/Microsoft SQL Server/MSSQL.3/Reporting Services/ReportServer/
LOG: Initial PrivatePath = C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin
Calling assembly : (Unknown).
===
LOG: This bind starts in default load context.
LOG: Using application configuration file: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\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/reportserver/b7e1529c/70d36ced/ReportingServicesWebServer.DLL.
LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/Temporary ASP.NET Files/reportserver/b7e1529c/70d36ced/ReportingServicesWebServer/ReportingServicesWebServer.DLL.
LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/MSSQL.3/Reporting Services/ReportServer/bin/ReportingServicesWebServer.DLL.
LOG: Using application configuration file: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\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: ReportingServicesWebServer, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
ERR: Failed to complete setup of assembly (hr = 0x80070005). Probing terminated.

Hi!

I'm having the same problem, can someone help me?

Thank you!

|||I have the same problem ,can someone help me..|||

xian_ve

xian_ve,

Can you verify the version SQL reporting services is .NET version 2.0, and that your application pool for reporting service is using "Network" logon?

Ham

|||

That is so on my computer.

What is the solution?

|||I also have d same problem..can anybody tell me how to fix it?????

Assembly ReportingServicesWebServer problem

I did a fresh install of Reporting Services (Standard Edition Final).
From the service manager the report service is running, but i get the following error on http://localhost/ReportServer/

Server Error in '/ReportServer' Application.

---

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: Could not load file or assembly 'ReportingServicesWebServer, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Access is denied.

Source Error:

Line 27: <assemblies>
Line 28: <clear />
Line 29: <add assembly="ReportingServicesWebServer" />
Line 30: </assemblies>
Line 31: </compilation>

Source File: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config Line: 29

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

=== Pre-bind state information ===
LOG: User = Unknown
LOG: DisplayName = ReportingServicesWebServer
(Partial)
LOG: Appbase = file:///C:/Program Files/Microsoft SQL Server/MSSQL.3/Reporting Services/ReportServer/
LOG: Initial PrivatePath = C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin
Calling assembly : (Unknown).
===
LOG: This bind starts in default load context.
LOG: Using application configuration file: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\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/reportserver/b7e1529c/70d36ced/ReportingServicesWebServer.DLL.
LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/Temporary ASP.NET Files/reportserver/b7e1529c/70d36ced/ReportingServicesWebServer/ReportingServicesWebServer.DLL.
LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/MSSQL.3/Reporting Services/ReportServer/bin/ReportingServicesWebServer.DLL.
LOG: Using application configuration file: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\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: ReportingServicesWebServer, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
ERR: Failed to complete setup of assembly (hr = 0x80070005). Probing terminated.

Hi!

I'm having the same problem, can someone help me?

Thank you!

|||I have the same problem ,can someone help me..|||

xian_ve

xian_ve,

Can you verify the version SQL reporting services is .NET version 2.0, and that your application pool for reporting service is using "Network" logon?

Ham

|||

That is so on my computer.

What is the solution?

Assembly ReportingServicesWebServer problem

I did a fresh install of Reporting Services (Standard Edition Final).
From the service manager the report service is running, but i get the following error on http://localhost/ReportServer/

Server Error in '/ReportServer' Application.

---

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: Could not load file or assembly 'ReportingServicesWebServer, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Access is denied.

Source Error:

Line 27: <assemblies>
Line 28: <clear />
Line 29: <add assembly="ReportingServicesWebServer" />
Line 30: </assemblies>
Line 31: </compilation>

Source File: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config Line: 29

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

=== Pre-bind state information ===
LOG: User = Unknown
LOG: DisplayName = ReportingServicesWebServer
(Partial)
LOG: Appbase = file:///C:/Program Files/Microsoft SQL Server/MSSQL.3/Reporting Services/ReportServer/
LOG: Initial PrivatePath = C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin
Calling assembly : (Unknown).
===
LOG: This bind starts in default load context.
LOG: Using application configuration file: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\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/reportserver/b7e1529c/70d36ced/ReportingServicesWebServer.DLL.
LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/Temporary ASP.NET Files/reportserver/b7e1529c/70d36ced/ReportingServicesWebServer/ReportingServicesWebServer.DLL.
LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/MSSQL.3/Reporting Services/ReportServer/bin/ReportingServicesWebServer.DLL.
LOG: Using application configuration file: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\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: ReportingServicesWebServer, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
ERR: Failed to complete setup of assembly (hr = 0x80070005). Probing terminated.

Hi!

I'm having the same problem, can someone help me?

Thank you!

|||I have the same problem ,can someone help me..|||

xian_ve

xian_ve,

Can you verify the version SQL reporting services is .NET version 2.0, and that your application pool for reporting service is using "Network" logon?

Ham

|||

That is so on my computer.

What is the solution?

|||

I had a similar error, and it was some problems in c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\rssrvpolicy.config, so check that that one looks correct.

AspNetSessionExpiredException - Your results may vary?

I have a custom reporting application that displays Sql Server Reporting Services reports on an ASP.NET page using Microsoft's report viewer control. The SSRS reports are local reports (they have an rdlc extension).

When a report is left inactive for a lengthy period of time it generates anAspNetSessionExpiredException when the user attempts to move to a new page. The thing that is surprising is that the formatted exception display is contained within the report viewer. The report document map remains visible as does the report toolbar. In the right pane where the report normally appears I see a standard, raw, ASP.NET exception display.

I'm surprised that the report viewer is "catching" the exception and displaying it within the report viewer. Standard events in the page that hosts the report viewer (PreInit, Init, PageLoad) are never invoked.

I have graceful error handling defined in a base page class but it does me no good because the exception never reaches the page code-behind. Puzzling.

Do any of you ASP.NET developers know if it is possible to catch theAspNetSessionExpiredExceptionso that I can handle it in my application code rather than having SSRS display a very ugly, very raw exception message.

I've included the exception message below.

Thanks.

BlackCatBone

...

Server Error in '/templatedemo' Application.

------------------------

ASP.NET session has expired

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: Microsoft.Reporting.WebForms.AspNetSessionExpiredException: ASP.NET session has expired

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.

Stack Trace:

[AspNetSessionExpiredException: ASP.NET session has expired]

Microsoft.Reporting.WebForms.ReportDataOperation..ctor() +683

Microsoft.Reporting.WebForms.HttpHandler.GetHandler() +553

Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) +10

System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +154

System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

------------------------

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

I am having exactly the same problem. If anyone knows the solution to this it would be fabulous to here from you.

|||

I had the same problem and I found the solution in this posthttp://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=170875&SiteID=1. See Brian Hartman's post regarding sessionState. I used his suggestion of using the out-of-process session state as StateServer mode and it fixed the issue for me. Good luck.

aspnet_wp.exe could not be started.

When I launch the reporting services report server on my sql server, I
recieve the following error:
"Server Application Unavailable
The web application you are attempting to access on this web server is
currently unavailable. Please hit the "Refresh" button in your web browser
to retry your request.
Administrator Note: An error message detailing the cause of this specific
request failure can be found in the application event log of the web server.
Please review this log entry to discover what caused this error to occur."
In the event log, the details are...
"aspnet_wp.exe could not be started. The error code for the failure is
80004005. This error can be caused when the worker process account has
insufficient rights to read the .NET Framework files. Please ensure that the
.NET Framework is correctly installed and that the ACLs on the installation
directory allow access to the configured account. "
I have validated that ASPNET user account does have the appropriate
permissions.
I have ran "aspnet_regiis -i".
I have validated that ASPNET user account is not locked out.
Are there any other solutions that I can try to get my report server
functioning?Hi Rhonda,
Make sure 'ASP.Net Machine Account' has Full Control permissions to the
following folder:
"C:\WINNT\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET Files"
Eshoo
"Helpme Rhonda" <Helpme Rhonda@.discussions.microsoft.com> wrote in message
news:7AA4DA9E-232E-420D-A5A3-47F213B54975@.microsoft.com...
> When I launch the reporting services report server on my sql server, I
> recieve the following error:
> "Server Application Unavailable
> The web application you are attempting to access on this web server is
> currently unavailable. Please hit the "Refresh" button in your web
browser
> to retry your request.
> Administrator Note: An error message detailing the cause of this specific
> request failure can be found in the application event log of the web
server.
> Please review this log entry to discover what caused this error to occur."
> In the event log, the details are...
> "aspnet_wp.exe could not be started. The error code for the failure is
> 80004005. This error can be caused when the worker process account has
> insufficient rights to read the .NET Framework files. Please ensure that
the
> .NET Framework is correctly installed and that the ACLs on the
installation
> directory allow access to the configured account. "
> I have validated that ASPNET user account does have the appropriate
> permissions.
> I have ran "aspnet_regiis -i".
> I have validated that ASPNET user account is not locked out.
> Are there any other solutions that I can try to get my report server
> functioning?|||My 'ASP.Net Machine Account' does have full control of the directory
mentioned below. I also have a folder of
"C:\WINNT\Microsoft.NET\Framework\v1.0.3705\" from the original installation.
Could there be some conflict with that being there?
If not, are there any other suggestions? Thank you in advance.
"Eshoo" wrote:
> Hi Rhonda,
> Make sure 'ASP.Net Machine Account' has Full Control permissions to the
> following folder:
> "C:\WINNT\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET Files"
>
> Eshoo
> "Helpme Rhonda" <Helpme Rhonda@.discussions.microsoft.com> wrote in message
> news:7AA4DA9E-232E-420D-A5A3-47F213B54975@.microsoft.com...
> > When I launch the reporting services report server on my sql server, I
> > recieve the following error:
> >
> > "Server Application Unavailable
> > The web application you are attempting to access on this web server is
> > currently unavailable. Please hit the "Refresh" button in your web
> browser
> > to retry your request.
> >
> > Administrator Note: An error message detailing the cause of this specific
> > request failure can be found in the application event log of the web
> server.
> > Please review this log entry to discover what caused this error to occur."
> >
> > In the event log, the details are...
> >
> > "aspnet_wp.exe could not be started. The error code for the failure is
> > 80004005. This error can be caused when the worker process account has
> > insufficient rights to read the .NET Framework files. Please ensure that
> the
> > .NET Framework is correctly installed and that the ACLs on the
> installation
> > directory allow access to the configured account. "
> >
> > I have validated that ASPNET user account does have the appropriate
> > permissions.
> > I have ran "aspnet_regiis -i".
> > I have validated that ASPNET user account is not locked out.
> >
> > Are there any other solutions that I can try to get my report server
> > functioning?
>
>|||My agency is have this problem as well... I am exhaused from troubleshooting
SQL Reporting Services. Here are details of the problem:
I've been having a little trouble with an installation of SQL Reporting
Services. The installation is truly vanilla, but I can't seem to find a
resolution for the below noted problem. I have tried all of the fixes I can
find on MSDN and TechNet in the Knowledge Base that address the error
message. If you can help at all, I would greatly appreciate.
From Browser Requesting Reporting Services (http://{hostname}/Reports/ or
http://{hostname}/reportserver):
Server Application Unavailable
The web application you are attempting to access on this web server is
currently unavailable. Please hit the "Refresh" button in your web browser to
retry your request.
Administrator Note: An error message detailing the cause of this specific
request failure can be found in the application event log of the web server.
Please review this log entry to discover what caused this error to occur.
Event Log Detail:
aspnet_wp.exe could not be started. The error code for the failure is
80070545. This error can be caused when the worker process account has
insufficient rights to read the .NET Framework files. Please ensure that the
.NET Framework is correctly installed and that the ACLs on the installation
directory allow access to the configured account.
Knowledge Base/MSDN/TechNet Attempted Fixes:
317012, 315158, 323292, 833444, 811320
In one situation there were errors in the security log regarding access,
this was resolved on that installation and now works. The only errors
produced in the event log is the one noted above.
"Eshoo" wrote:
> Hi Rhonda,
> Make sure 'ASP.Net Machine Account' has Full Control permissions to the
> following folder:
> "C:\WINNT\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET Files"
>
> Eshoo
> "Helpme Rhonda" <Helpme Rhonda@.discussions.microsoft.com> wrote in message
> news:7AA4DA9E-232E-420D-A5A3-47F213B54975@.microsoft.com...
> > When I launch the reporting services report server on my sql server, I
> > recieve the following error:
> >
> > "Server Application Unavailable
> > The web application you are attempting to access on this web server is
> > currently unavailable. Please hit the "Refresh" button in your web
> browser
> > to retry your request.
> >
> > Administrator Note: An error message detailing the cause of this specific
> > request failure can be found in the application event log of the web
> server.
> > Please review this log entry to discover what caused this error to occur."
> >
> > In the event log, the details are...
> >
> > "aspnet_wp.exe could not be started. The error code for the failure is
> > 80004005. This error can be caused when the worker process account has
> > insufficient rights to read the .NET Framework files. Please ensure that
> the
> > .NET Framework is correctly installed and that the ACLs on the
> installation
> > directory allow access to the configured account. "
> >
> > I have validated that ASPNET user account does have the appropriate
> > permissions.
> > I have ran "aspnet_regiis -i".
> > I have validated that ASPNET user account is not locked out.
> >
> > Are there any other solutions that I can try to get my report server
> > functioning?
>
>|||Me too. This is frustrating. Is this a bug? I had a perfectly operational
install of SQLRS SP1 until I installed SP2. Anyone with ideas?
"Helpme Rhonda" wrote:
> When I launch the reporting services report server on my sql server, I
> recieve the following error:
> "Server Application Unavailable
> The web application you are attempting to access on this web server is
> currently unavailable. Please hit the "Refresh" button in your web browser
> to retry your request.
> Administrator Note: An error message detailing the cause of this specific
> request failure can be found in the application event log of the web server.
> Please review this log entry to discover what caused this error to occur."
> In the event log, the details are...
> "aspnet_wp.exe could not be started. The error code for the failure is
> 80004005. This error can be caused when the worker process account has
> insufficient rights to read the .NET Framework files. Please ensure that the
> .NET Framework is correctly installed and that the ACLs on the installation
> directory allow access to the configured account. "
> I have validated that ASPNET user account does have the appropriate
> permissions.
> I have ran "aspnet_regiis -i".
> I have validated that ASPNET user account is not locked out.
> Are there any other solutions that I can try to get my report server
> functioning?|||Just as an FYI, as a work around, I added the ASP.NET user account to the
local server's Administrators group and it started working again:
NOTE: This completely defeats the purpose of having the ASP.NET account so
we still need to find a solution to why this "just happens".
"Helpme Rhonda" wrote:
> When I launch the reporting services report server on my sql server, I
> recieve the following error:
> "Server Application Unavailable
> The web application you are attempting to access on this web server is
> currently unavailable. Please hit the "Refresh" button in your web browser
> to retry your request.
> Administrator Note: An error message detailing the cause of this specific
> request failure can be found in the application event log of the web server.
> Please review this log entry to discover what caused this error to occur."
> In the event log, the details are...
> "aspnet_wp.exe could not be started. The error code for the failure is
> 80004005. This error can be caused when the worker process account has
> insufficient rights to read the .NET Framework files. Please ensure that the
> .NET Framework is correctly installed and that the ACLs on the installation
> directory allow access to the configured account. "
> I have validated that ASPNET user account does have the appropriate
> permissions.
> I have ran "aspnet_regiis -i".
> I have validated that ASPNET user account is not locked out.
> Are there any other solutions that I can try to get my report server
> functioning?