Subscription Error : Failure Sending Mail: An Error Has Occurred During Report Processing

Nov 16, 2007



Hello,

On the development server, I am trying to work with subscriptions . Report Server is windows authenticated.

When no paramters exist for the report, the sucbscription is successful.
But if there are paramters for the report, email delivery fails.

These are not data driven subscriptions.

Did anyone face the same problem ? Can anyone tell me where to start debugging since logfiles just say failure to send the email.

Thanks,
SqlNew

View 2 Replies


ADVERTISEMENT

Failure Sending Mail: An Error Has Occurred During Report Processing.

Dec 7, 2007



Hello.

Thanks for any help anyone can offer me.

I have SQL Server Reporting services on Windows 2000.

The reports seem to be working well, but I cannot get a subscription to work. The error I get is the one in the subject line.

I look into my log files and see these lines.

ReportingServicesService!emailextension!ab0!12/07/2007-15:02:07:: Error sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.Runtime.InteropServices.COMException (0x80090005): Bad Data.


Can anyone help me out with this one?

Thanks.

deep

View 6 Replies View Related

Failure Sending Mail: Unspecified Error For Excel Rendering

Apr 14, 2008



Hi all

When using a subscription to send mail, I find that the report can be sent in any format apart from Excel, which gives me the error: "Failure sending mail: Unspecified error". As you can imagine, this doesn't give me much to go on!

I want to use Excel format as it retains the drilldown functionality (hiding / unhiding rows). The ExecutionLog has the status as rsSuccess, but Subscription tab for the report shows the error.

Any thoughts would be most welcome!

View 3 Replies View Related

Reporting Services :: SSRS Error - Failure Sending Mail

Jun 4, 2015

I am Getting this error in SSRS Report Subscription. I went to Subscription table Checked the Laststatus. The LastStatus is :Failure sending mail: The specified string is not in the form required for an e-mail address.Mail will not be resent.

View 3 Replies View Related

An Error Has Occurred During Report Processing.

Mar 11, 2008

I have created several reports and deployed them successfully. However, when I return to view the reports some time later I receive the following error message:


An error has occurred during report processing.

Query execution failed for data set 'DataSet1'.

For more information about this error navigate to the report server on the local server machine, or enable remote errors
The only way I have been able to get round the issue is to re-deploy the reports. All reports are executed from Stored Procedures.

Does anyone have any ideas why this is happening?


View 10 Replies View Related

An Error Has Occurred During Report Processing.

Jan 29, 2008

Hi,

I am getting this error, after the report has been deployed to a remote server. When I click on perticular report I am getting this error.


An error has occurred during report processing.

Query execution failed for data set 'GLSQLBIS01_ProductionGLP_Connection'.


For more information about this error navigate to the report server on the local server machine, or enable remote errors






















Thank you
Gish

View 4 Replies View Related

* An Error Has Occurred During Report Processing.

Sep 14, 2007

Created Report using SQL Server Business Intelligence 2005 using Visual studio 2005
MSSQL Server 2005
datasource is a filteredAppointment dbo from MS CRM 3
Shared Datasource
Report runs in visual studio 2005

deployed to ReportServer no errors
Report showing on home page in Report Server
Data source folder also on report server page

go to run report on the report server via internet explorer

getting following message



An error has occurred during report processing.

Cannot create a connection to data source 'FilteredAppointments'.

For more information about this error navigate to the report server on the local server machine, or enable remote errorsPlease can any one help!!!!!!

I am a novice to reporting services, can any one recommend a good basic to intermediate book.
have been on the Microsoft 2030A MSSQL server 2000 reporting services 4 months ago and not had a chance to use it until know

Thank you for all your time
ralph

View 4 Replies View Related

An Error Occurred During Local Report Processing.

Oct 29, 2007

I get this error for all but one of the reports in a solution when trying to preview the reports. The query behind the reports work, and the published side of things works fine. I blew away all the rdl.data files in the directory (found that tip in another forum) -- the working report rebuilds the rdl.data file, but the rest continue to fail with the same error. Everything worked fine before the weekend, and I'm the only one who works on the application. The extracted SQL tables which are input to the reports have had data added to them, but I've not requested reporting that would have hit the new data (except for the one report that still works). Any ideas would be greatly welcome. Thanks in advance.

View 1 Replies View Related

An Error Occurred During Local Report Processing.

Nov 1, 2007

Good Afternoon,

I created a 2005 SSRS SP2 report (.rdl) last week. Today I installed the SQL 2005 SP2 tools on three of my co-workers' computers. Two can access the Solution/Project/Report in BIDS without issue. The last can open the Solution/Project/Report and can run see both the data and layout tabs. When she attempts to click the preview tab, however, the following error occurs:

An error occurred during local report processing.
The definition of the report '/ReportName' is invalid.
An unexpected error occurred in the Report Processing.
Cannot execute a program. The command being executed was "C:WINNTMicrosoft.NETFrameworkv2.0.50727vbc.exe" /noconfig @"C:Documents and SettingsuserLocal SettingsTempwnlnvzev.cmdline".


The portion in blue changes each time we attempt to access the preview pane. I have removed the .data file suggested in other threads, but that did not work. I also ran iisreset.exe as posted in another thread and that did not work either.

All versions of BIDS/SQL were installed from the same media in the same manner. Please help.

Roger

View 3 Replies View Related

An Error Has Occurred During Report Processing. (rsProcessingAborted) The Report Server Installation Is Not Initialized. (rsRep

Jun 10, 2005

I'v reinstalled RS, then I configuret it. But when I want to open a report raise this error

View 5 Replies View Related

Reporting Services :: Error Occurred During Report Processing

Jun 9, 2015

When we are trying to open the reports on share point 2013 site this error came?

View 2 Replies View Related

An Error Occurred During Local Report Processing For Preview

May 2, 2007

My report worked fine for a while, but suddenly I started getting the following errors for Preview:



An error occurred during local report processing.

An error has occurred during report processing.

Index was outside the bounds of the array.



I restarted VS, then rebooted my machine and the problem persists. Everything including the report posted to the server works fine. It is just the Preview of this report does not work any more. Preview of other reports work fine.



Any tip to resolve this problem would be greatly appreciated.

View 4 Replies View Related

An Error Has Occurred During Report Processing. (rsProcessingAborted) Get Online Help

Apr 3, 2007

An error has occurred during report processing. (rsProcessingAborted) Get Online Help

Cannot create a connection to data source 'database03'. (rsErrorOpeningConnection) Get Online Help

Cannot open database requested in login 'database'. Login fails. Login failed for user 'sam'.

View 2 Replies View Related

Sub Report Problem. An Error Has Occurred During Report Processing. (rsErrorExecutingSubreport)

Oct 25, 2006

I have two reports. They both work fine when loaded individually. I am loading them directly from a stream. I am also loading the subreport definition using LoadSubreportDefinitio(). Neither of them have parameters

I receive the following error message when trying to load the sub report.

An error occurred while executing the subreport €˜Subreport€™: An error has occurred during report processing. (rsErrorExecutingSubreport).



any help would be greatly appreciated.

View 2 Replies View Related

An Error Occurred During Local Report Processing. Index Was Outside The Bounds Of The Array.

Oct 29, 2007

I got rid of the .rdl.data files, which apparently has been a successful fix for this problem in the past. Everything worked fine Thursday when I left (I was off Friday - Saturday), but today I get this error for all but one of the reports in the solution when I try to preview the report. BTW, the published stuff works fine. Thanks in advance for any help.

View 6 Replies View Related

An Error Has Occurred During Report Processing. (rsProcessingAborted).. Query Execution Failed For Data Set

Sep 11, 2007

Hi All,

I'm facing a strange problem..
I've developed few reports. they are working fine in develop environment. after successfull testing they were published on web.
in web version, all reports are executing for first time.. if I change any of parameters values or without chaning also..
if I press "View Report" following error occurs..




An error has occurred during report processing. (rsProcessingAborted)

Query execution failed for data set 'dsMLGDB2Odbc'. (rsErrorExecutingCommand)

For more information about this error navigate to the report server on the local server machine, or enable remote errors

please suggest any alternative ways to overcome this issue
thanks in adv.

View 11 Replies View Related

Internal Error: An Unexpected Error Occurred In Analysis Services Processing

Apr 8, 2008



Hi There,

I've got this error coming up while running the sql job for AS processing. I can't find anything about it on google or anywhere else. Has anyone had issues like this?




Code Snippet
Executed as user: xyzsvc_sqlsvr. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 1:21:02 PM Error: 2008-04-04 13:21:07.41 Code: 0xC1000000 Source: Analysis Services Processing Task Analysis Services Execute DDL Task Description: Internal error: An unexpected error occurred (file 'mdprocessdim.cpp', line 3429, function 'MDProcessPropertyJob::OnLaunch'). End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 1:21:02 PM Finished: 1:21:07 PM Elapsed: 5.141 seconds. The package execution failed. The step failed.





Thanks

Vivek

View 5 Replies View Related

SMTP Database Mail Showing Error While Sending Mail

Mar 7, 2007

Lokendra writes "I have configured the Database mail profile and account in Sql Server 2005 but the mail is not sending and showing the following error message:

Error,235,The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2007-03-05T15:16:07). Exception Message: Cannot send mails to mail server. (Mailbox name not allowed. The server response was: Sorry<c/> that domain isn't in my list of allowed rcpthosts.).
),3000,90,,3/5/2007 3:16:07 PM,sa


but while in the same mail set up in previous instance of sql server 2005 the message was sending very well. After installing new instance of sql server 2005 the problem is arising.


Anybody can tell me that what I can do so that i can send mail using the SMTP databasemail account."

View 1 Replies View Related

SSIS Send Mail Task - Failure Sending Mail

Dec 13, 2007

Dear all,
I have switched off the firewall settings on my system and as suggested im entering the minimal information and data to send the mail.
but still the Mail Task is failing..
plz suggest.

View 11 Replies View Related

SSIS Send Mail Task - Failure Sending Mail

Jun 8, 2006

Hi Everyone,

Hopefully someone out there will have an idea as this is driving me nuts.

I've setup a task to email on success/failure and keep receiving the following message when executed:

Progress: The SendMail task is initiated. - 0 percent complete
[Send Mail Task] Error: An error occurred with the following error message: "Failure sending mail.".
Progress: The SendMail task is completed. - 100 percent complete
Task Send Mail Task failed

When I configure Outlook Express on the same machine with the same settings it works.

On the SMTP Connection Manager I have left the default name, tested with both an IP address and Server Name, and no authentication or SSL.

On the Send Mail Task, it uses the above connection. The To: , From: , Subject fields are populated. Message SourceType is DirectInput, MessageSource is Test, Priority is Normal and no attachments or expressions etc.

Nothing useful is logged in the Event Viewer even with full logging turned on.

Any suggestions appreciated,

Thanks.









View 11 Replies View Related

An Internal Error Occurred On The Report Server. See The Error Log For More Details. RsInternal Error)

May 20, 2008

We have reports deployed in the Report Server. While connecting from client, we are getting the error
"An internal error occurred on the report server. See the error log for more details. rsInternal Error)"

Then we went to Report Server, Reporting Service and SQL Server service are all are running fine.

Important thing is some time the reports are working fine, sometimes i am receiving this error. Please help.

We predict whether the services are automatically restarted or transaction logs exceeding the limit or any other parameters to set to avaoid this error?

Please help.

View 1 Replies View Related

Error Sending Mail With Send Mail Task

Feb 6, 2008

I keep getting a generic "Error Sending Mail" error. For testing purposes I am just trying to send using my own email account. What goes in the SMTP Server box in the connection manager? I have tried:

A - the exchange server address (SOMETHING.us.company.com)
B - The SMTP properties I see when I look at the properties of my email address: (my.name@abcd.efgh.company.com)
C - Just the end portion of the SMTP properties: (abcd.efgh.company.com)
D - My email address (my.name@company.com)

I don't know what to enter, or what is giving me such a generic error message.

View 7 Replies View Related

Report Export Failing: An Internal Error Occurred On The Report Server. See The Error Log For More Details.

Feb 14, 2007

I have a pretty complicated report (lots of subreports, tables, etc) that can be well over a few hundred pages long. I can generate the report just fine, but I cannot seem to export it to anything other than an html archive. I need to export to PDF. Every time I try to export it get an error that says:

An internal error occurred on the report server. See the error log for more details.



I don't get any more information than that. Is there a way that I can figure out what the actual error is, or any other way I can go about troubleshooting this? Thanks.



Jeff



View 3 Replies View Related

An Error Has Occurred During Report Processing. A Data Source Instance Has Not Been Supplied For The Data Source DetailDS_get_o

Mar 13, 2008

hi ,

i am trying for a drill through report (rdlc)

ihave written the following code in drill through event of reportviewer, whenever i click on the first report iam getting the error like

An error has occurred during report processing.


A data source instance has no
t been supplied for the data source "DetailDS_get_orderdetail".







the code is



using System;

using System.Data;

using System.Data.SqlClient;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

//using Microsoft.ApplicationBlocks.Data;

using Microsoft.Reporting.WebForms;

using DAC;

public partial class _Default : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

ReportViewer1.Visible = false;

}

protected void Button1_Click(object sender, EventArgs e)

{

DAC.clsReportsWoman obj = new clsReportsWoman();

DataSet ds = new DataSet();

ds = obj.get_order();

ReportViewer1.LocalReport.DataSources.Clear();

ReportDataSource reds = new ReportDataSource("DataSet1_get_order", ds.Tables[0]);



ReportViewer1.LocalReport.DataSources.Add(reds);

ReportViewer1.LocalReport.ReportPath = "C:/Documents and Settings/km63096/My Documents/Visual Studio 2005/WebSites/drillthrurep/Report.rdlc";

ReportViewer1.LocalReport.Refresh();

ReportViewer1.Visible = true;

}

protected void ReportViewer1_Drillthrough(object sender, DrillthroughEventArgs e)

{

DAC.clsReportsWoman obj = new clsReportsWoman();

ReportParameterInfoCollection DrillThroughValues =

e.Report.GetParameters();



foreach (ReportParameterInfo d in DrillThroughValues)

{

Label1.Text = d.Values[0].ToString().Trim();

}

LocalReport localreport = (LocalReport)e.Report;

string order_id = Label1.Text;

DataSet ds = new DataSet();

ds = obj.get_orderdetail(order_id);



ReportViewer1.LocalReport.DataSources.Clear();

ReportDataSource reds = new ReportDataSource("DetailDS_get_orderdetail", ds.Tables[0]);

ReportViewer1.LocalReport.DataSources.Add(reds);

ReportViewer1.LocalReport.ReportPath = Server.MapPath(@"Reportlevel1.rdlc");

ReportViewer1.LocalReport.Refresh();





}



}

the code in method get_orderdetail(order_id) is

public DataSet get_orderdetail(string order_id)
{
SqlCommand cmd = new SqlCommand();
DataSet ds = new DataSet();
cmd.Parameters.Add("@order_id", SqlDbType.VarChar, 50);
cmd.Parameters["@order_id"].Value = order_id;
ds = SQLHelper.ExecuteAdapter(cmd, CommandType.StoredProcedure, "dbo.get_orderdetail");
return (ds);
}pls help me.

View 1 Replies View Related

A Transport-level Error Has Occurred When Sending The Request To The Server.

Sep 27, 2007

Hi,
A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
I am using a direct connection from my Gridview to perform a huge database search. the stored procedure will take 10- 60 seconds to execute the query.

What the problem i am facing is when the sp takes long time (more than 1 minutes), then when i try any other operation like calling another sp frm another page, i am getting the above specified error.

Anybody can tell why is it happening?

here my code snippet goes


<asp:GridView ID="searchGV" runat="server" AllowPaging="True" AllowSorting="True"

BorderColor="#999999" BorderStyle="None" CellPadding="3" Width="100%" AutoGenerateColumns="False" DataSourceID="searchObj" DataKeyNames="Recordnumber" OnDataBound="searchGV_DataBound" OnPageIndexChanged="searchGV_PageIndexChanged">

<RowStyle CssClass="gridRow" />

<PagerStyle HorizontalAlign="Center" BackColor="#999999" ForeColor="Black" />

<HeaderStyle CssClass="gridHeader" />

<AlternatingRowStyle CssClass="gridAlternateRow" />

<Columns>

<asp:TemplateField HeaderText="All">

<HeaderTemplate>

<asp:CheckBox ID="chkid" AutoPostBack="true" OnCheckedChanged ="OnCheckChangedEvent" runat="server" />

</HeaderTemplate>

<EditItemTemplate>

<asp:CheckBox ID="chkSelect" runat="server" />

</EditItemTemplate>

<ItemTemplate>

<asp:CheckBox ID="chkSelect" runat="server"/>

</ItemTemplate>

<ControlStyle Height="18px" Width="15px" />

<ItemStyle Width="5px" />

</asp:TemplateField>

<asp:BoundField DataField="Title" HeaderText="Title" SortExpression="Title">

<ItemStyle Width="150px" />

</asp:BoundField>

<asp:BoundField DataField="Artist" HeaderText="Artist(s)" SortExpression="Artist"/>

<asp:BoundField DataField="Album" HeaderText="Album" SortExpression="Album"/>

<asp:BoundField DataField="Writer" HeaderText="Writer(s)" SortExpression="Writer" ><ItemStyle Width="150px" /></asp:BoundField>

<asp:BoundField DataField="ISRC" HeaderText="ISRC" SortExpression="ISRC" />

<asp:BoundField DataField="UPC" HeaderText="UPC" SortExpression="UPC"/>

<asp:BoundField DataField="PLineLabel" HeaderText="P-Line Label" SortExpression="PLineLabel" ><ItemStyle Width="100px" /></asp:BoundField>

<asp:BoundField DataField="DistLabel" HeaderText="Distribution Label" SortExpression="DistLabel" >

<ItemStyle Width="100px" />

</asp:BoundField>

<asp:BoundField DataField="PublishInfo" HeaderText="Publisher(s)" SortExpression="PublishInfo" />

<asp:BoundField DataField="Recordnumber" HeaderText="Record Number" SortExpression="Recordnumber" />

<%-- <asp:BoundField DataField="UID" HeaderText="UID" Visible="false" />--%>

</Columns>

</asp:GridView>


with adapter

<asp:SqlDataSource ID="searchObj" runat="server" SelectCommand="gsp_titleSearchResult" SelectCommandType="StoredProcedure" ConnectionString="<%$ ConnectionStrings:ConnStr %>">

<SelectParameters>

<asp:ControlParameter ControlID="HuserID" PropertyName="Value" Name="Userid" Type="String" Size="50" DefaultValue="" />

<asp:ControlParameter ControlID="Htitle" PropertyName="Value" Name="title" Type="String" Size="50" DefaultValue=" " />

<asp:ControlParameter ControlID="Hartist" PropertyName="Value" Name="artist" Type="String" Size="50" DefaultValue=" " />

<asp:ControlParameter ControlID="Halbum" PropertyName="Value" Name="album" Type="String" Size="50" DefaultValue=" " />

<asp:ControlParameter ControlID="Hwriter" PropertyName="Value" Name="writer" Type="String" Size="50" DefaultValue=" " />

<asp:ControlParameter ControlID="Hisrc" PropertyName="Value" Name="isrc" Type="String" Size="50" DefaultValue=" " />

<asp:ControlParameter ControlID="Hupc" PropertyName="Value" Name="upc" Type="String" Size="50" DefaultValue=" " />

<asp:ControlParameter ControlID="Hpline" PropertyName="Value" Name="pline" Type="String" Size="50" DefaultValue=" " />

<asp:ControlParameter ControlID="Hdist" PropertyName="Value" Name="distlabel" Type="String" Size="50" DefaultValue=" " />

<asp:ControlParameter ControlID="Hpublish" PropertyName="Value" Name="publisher" Type="String" Size="50" DefaultValue=" " />

<asp:ControlParameter ControlID="ReleaseID" PropertyName="Value" Name="Releaseid" Type="Int32" Size="50" DefaultValue="0" />

<asp:ControlParameter ControlID="RecordLabelID" PropertyName="Value" Name="recordlabelid" Type="Int32" Size="50" DefaultValue="0" />

<asp:ControlParameter ControlID="PublisherID" PropertyName="Value" Name="Publisherid" Type="Int32" Size="50" DefaultValue="0" />

<asp:ControlParameter ControlID="ArtistID" PropertyName="Value" Name="Artistid" Type="Int32" Size="50" DefaultValue="0" />

</SelectParameters>

</asp:SqlDataSource>



Advance thanks

Anvar Sadath

View 1 Replies View Related

A Transport-level Error Has Occurred When Sending The Request To The Server

Apr 7, 2006

Hi all,



I am new to SQL 2005. I have one issue and it is as follows:

I write a simple query and run it; it works fine.

Now I break the network connection and run the query; in this case it runs fine.

But when I reconnect the network and run the query, then I get an error as follows:

"A transport-level error has occurred when sending the request to the server. (provider: Named Pipes Provider, error: 0 - An unexpected network error occurred.) "

Every thing is local here. So how the network issue comes here?







View 14 Replies View Related

A Transport-level Error Has Occurred When Sending The Request To The Server

Oct 16, 2006

I've tried to search on the web for a solution for this error but i didn't find any working solutions for this problem. We have 2 servers. The first one is the server we use to develop our ASP.NET 2 application. On this server we don't have this error. On the other server (use by our client) we have this error sometime and i don't know why. Both servers have the same configuration and both application have the same web.config file.

I've tried to add a try-catch and retry the query when the error occured. This seems to be working but we don't want to have to change all our connections and since we don't have this problem on the other server we want to find the source of the problem.

Any idea ?

Thanks !

View 1 Replies View Related

An Error Occurred While Processing 'BackupMetadata' Metadata For Database

Jul 9, 2007

I have transferred a database from SQL 2000 to SQL 2005 and now I am getting an error when I try to run backup. I get there error "An error occurred while processing 'BackupMetadata' metedata for datase ID..." Does anyone have any suggestions on how to resolve this error?

View 5 Replies View Related

Reporting Services :: Can't View Reports - Error Occurred During Processing

Jun 8, 2015

I got a problem with my project on reporting services. I installed MS SQL Server 2014 (86x version), Report Builder 3.0 (for creating my reports) and Data Tools for my SQL Server.Now I created a report via Report Builder 3.0 with a SAP NetWeaver as a data source. I could create and view it in Report Builder 3.0.

But when I want to view it on my Report Server it doesn't work. I only get this error."An error has occurred during reporting processing. (Processing Aborted) An attempt has been made to use a data extension 'SAPBW' that is either not registered for this report server or is not supported in this edition of Reporting Services. (rsDataExtensionNotFound)" ...

I found on the internet a few solutions. I installed the Data Tools for the 86x version of the SQL Server. Didn't work. And when I want to change some coding in "RSReportDesigner.config" it says that I'm not allowed to save the changes in this directory.

View 12 Replies View Related

Error Sending Mail SQL / Hotmail

Mar 19, 2007

Hi

Using SQL to send e-mail , returns the next error when sending to hotmail user.

Error,53,The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2007-03-16T09:43:38). Exception Message: Cannot send mails to mail server. (Mailbox name not allowed. The server response was: sorry<c/> that domain isn't in my list of allowed rcpthosts (#5.7.1)).
),244,79,,16.03.2007 09:43:38,sa

Any one can help?

Thanks,

Rodrigo Vieira

View 5 Replies View Related

SQL Reporting - An Internal Error Occurred On The Report Server. See The Error Log For More Details. (rsInternalError)

Feb 6, 2006

I have created an RDL file programatically. When I execute the code I get the error as mentioned below:

Error: Sub report cannot be shown.
An internal error occurred on the report server. See the error log for more details. (rsInternalError)

When I copy and paste the code of RDL file into new RDL file and try to preview the output I get correct result.
Note: The new RDL file does not give any error if the output is seen using preview tab but it gives the error only when executed from report viewer or from internet explorer.

Any Suggestion/feedback is highly appreciated.
Thank You.


The code of the sample RDL is shown below:

<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<DataSources>
<DataSource Name="DataSource1">
<DataSourceReference>DataSource1</DataSourceReference>
<rd:DataSourceID>fe4806ee-0358-4a87-b764-ac5de049545e</rd:DataSourceID>
</DataSource>
</DataSources>
<BottomMargin>0.25in</BottomMargin>
<RightMargin>0.25in</RightMargin>
<PageWidth>11in</PageWidth>
<ReportParameters>
<ReportParameter Name="machine_id">
<DataType>String</DataType>
<Prompt>machine_id</Prompt>
</ReportParameter>
<ReportParameter Name="from_date">
<DataType>String</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>From Date</Prompt>
</ReportParameter>
<ReportParameter Name="to_date">
<DataType>String</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>To Date</Prompt>
</ReportParameter>
</ReportParameters>
<rd:DrawGrid>true</rd:DrawGrid>
<InteractiveWidth>8.5in</InteractiveWidth>
<rd:SnapToGrid>true</rd:SnapToGrid>
<Body>
<ReportItems>
<Table Name="table1">
<DataSetName>Main_Report</DataSetName>
<TableGroups>
<TableGroup>
<Header>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox2">
<rd:DefaultName>textbox2</rd:DefaultName>
<ZIndex>1</ZIndex>
<Style>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!syscode.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.25in</Height>
</TableRow>
</TableRows>
<RepeatOnNewPage>true</RepeatOnNewPage>
</Header>
<Grouping Name="table1_Group1">
<PageBreakAtEnd>true</PageBreakAtEnd>
<GroupExpressions>
<GroupExpression>=Fields!syscode.Value</GroupExpression>
</GroupExpressions>
</Grouping>
</TableGroup>
</TableGroups>
<Details>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Subreport Name="subreport1">
<Parameters>
<Parameter Name="machine_id">
<Value>=Fields!machine_ip.Value</Value>
</Parameter>
<Parameter Name="syscode">
<Value>=Fields!syscode.Value</Value>
</Parameter>
<Parameter Name="from_date">
<Value>=Parameters!from_date.Value</Value>
</Parameter>
<Parameter Name="to_date">
<Value>=Parameters!to_date.Value</Value>
</Parameter>
</Parameters>
<ReportName>Holding_Summary_Multi_Period</ReportName>
</Subreport>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.25in</Height>
</TableRow>
</TableRows>
</Details>
<TableColumns>
<TableColumn>
<Width>10.5in</Width>
</TableColumn>
</TableColumns>
<Height>0.5in</Height>
</Table>
</ReportItems>
<Height>0.75in</Height>
</Body>
<rd:ReportID>d0a1293a-e98c-4f75-9597-03426d2e7218</rd:ReportID>
<LeftMargin>0.25in</LeftMargin>
<DataSets>
<DataSet Name="Main_Report">
<Query>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
<CommandText>select account_syscode as syscode , 'display Name' as display_name , * from mars_customer_list
where machine_ip = @machine_id</CommandText>
<QueryParameters>
<QueryParameter Name="@machine_id">
<Value>=Parameters!machine_id.Value</Value>
</QueryParameter>
</QueryParameters>
<DataSourceName>DataSource1</DataSourceName>
</Query>
<Fields>
<Field Name="syscode">
<rd:TypeName>System.Int64</rd:TypeName>
<DataField>syscode</DataField>
</Field>
<Field Name="display_name">
<rd:TypeName>System.String</rd:TypeName>
<DataField>display_name</DataField>
</Field>
<Field Name="customer_syscode">
<rd:TypeName>System.Int64</rd:TypeName>
<DataField>customer_syscode</DataField>
</Field>
<Field Name="account_syscode">
<rd:TypeName>System.Int64</rd:TypeName>
<DataField>account_syscode</DataField>
</Field>
<Field Name="machine_ip">
<rd:TypeName>System.String</rd:TypeName>
<DataField>machine_ip</DataField>
</Field>
</Fields>
</DataSet>
</DataSets>
<Code>Shared offset As Integer

Public Function GetPN(reset As Boolean, pagenumber As Integer) As Integer
If reset
offset = pagenumber - 1
End If
Return pagenumber - offset
End Function

</Code>
<Width>10.5in</Width>
<InteractiveHeight>11in</InteractiveHeight>
<Language>en-US</Language>
<PageFooter>
<ReportItems>
<Image Name="image1">
<Sizing>Fit</Sizing>
<Left>8.875in</Left>
<MIMEType />
<Width>1.5in</Width>
<Source>External</Source>
<Style />
<Value>bottom_right_logo.gif</Value>
</Image>
</ReportItems>
<Height>0.5in</Height>
<PrintOnLastPage>true</PrintOnLastPage>
<PrintOnFirstPage>true</PrintOnFirstPage>
</PageFooter>
<TopMargin>0.5in</TopMargin>
<PageHeight>8.5in</PageHeight>
</Report>

View 8 Replies View Related

An Internal Error Occurred On The Report Server. See The Error Log For More Details. (rsInternalError)

Nov 10, 2006

Hello everybody,

I am trying to use the reporting services on Windows 2003 with SQLServer 2005. Everything works fine in the report manager and I can access and render the reports without any problem. But when I try to access the reports directly with the URL from the ReportServer, I get the following error :
Reporting Services Error



An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

The type Microsoft.ReportingServices.UI.WebControlConnection, ReportingServicesWebUserInterface, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 does not implement IReportServerConnection or could not be found



SQL Server Reporting Services

 

So I went to see the error log, and here is what it says :

 

<Header>
  <Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>
  <Locale>en-US</Locale>
  <TimeZone>GMT Standard Time</TimeZone>
  <Path>C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFilesReportServer__11_10_2006_13_43_22.log</Path>
  <SystemName>VODAFONE</SystemName>
  <OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
  <OSVersion>5.2.3790.65536</OSVersion>
</Header>
w3wp!webserver!5!11/10/2006-13:43:23:: i INFO: Reporting Web Server started
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing ConnectionType to '0'  as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing IsSchedulingService to 'True'  as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing IsNotificationService to 'True'  as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing IsEventService to 'True'  as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False'  as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing IsWebServiceEnabled to 'True'  as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing ProcessRecycleOptions to '0'  as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing WatsonFlags to '1064'  as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException'  as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException'  as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing SecureConnectionLevel to '0'  as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing DisplayErrorLink to 'True'  as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing WebServiceUseFileShareStorage to 'False'  as specified in Configuration file.
w3wp!resourceutilities!5!11/10/2006-13:43:23:: i INFO: Reporting Services starting SKU: Enterprise
w3wp!resourceutilities!5!11/10/2006-13:43:23:: i INFO: Evaluation copy: 0 days left
w3wp!runningjobs!5!11/10/2006-13:43:23:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds.  Cycle: 600 seconds
w3wp!runningjobs!5!11/10/2006-13:43:23:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds.  Cycle: 60 seconds
w3wp!runningjobs!5!11/10/2006-13:43:23:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds.  Cycle: 60 seconds
w3wp!runningjobs!5!11/10/2006-13:43:23:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds.  Cycle: 60 seconds
w3wp!library!5!10/11/2006-13:43:23:: Unhandled exception was caught: Microsoft.Reporting.WebForms.InvalidConfigFileTypeException: The type Microsoft.ReportingServices.UI.WebControlConnection, ReportingServicesWebUserInterface, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 does not implement IReportServerConnection or could not be found
   at Microsoft.Reporting.WebForms.ConfigFilePropertyInterface`1.EnsurePropertyLoaded()
   at Microsoft.Reporting.WebForms.ConfigFilePropertyInterface`1.GetInstance()
   at Microsoft.Reporting.WebForms.ReportViewer.CreateServerReport()
   at Microsoft.Reporting.WebForms.ReportViewer..ctor()
   at Microsoft.ReportingServices.WebServer.ReportViewerHost..ctor()
   at ASP.pages_reportviewer_aspx.__BuildControlReportViewerForm()
   at ASP.pages_reportviewer_aspx.__BuildControlTree(pages_reportviewer_aspx __ctrl)
   at ASP.pages_reportviewer_aspx.FrameworkInitialize()
   at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest()
   at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
   at System.Web.UI.Page.ProcessRequest(HttpContext context)
   at ASP.pages_reportviewer_aspx.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
w3wp!library!5!10/11/2006-13:43:23:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
 Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> Microsoft.Reporting.WebForms.InvalidConfigFileTypeException: The type Microsoft.ReportingServices.UI.WebControlConnection, ReportingServicesWebUserInterface, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 does not implement IReportServerConnection or could not be found
   at Microsoft.Reporting.WebForms.ConfigFilePropertyInterface`1.EnsurePropertyLoaded()
   at Microsoft.Reporting.WebForms.ConfigFilePropertyInterface`1.GetInstance()
   at Microsoft.Reporting.WebForms.ReportViewer.CreateServerReport()
   at Microsoft.Reporting.WebForms.ReportViewer..ctor()
   at Microsoft.ReportingServices.WebServer.ReportViewerHost..ctor()
   at ASP.pages_reportviewer_aspx.__BuildControlReportViewerForm()
   at ASP.pages_reportviewer_aspx.__BuildControlTree(pages_reportviewer_aspx __ctrl)
   at ASP.pages_reportviewer_aspx.FrameworkInitialize()
   at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest()
   at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
   at System.Web.UI.Page.ProcessRequest(HttpContext context)
   at ASP.pages_reportviewer_aspx.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
   --- End of inner exception stack trace ---
w3wp!library!5!10/11/2006-13:43:25:: i INFO: Exception dumped to: C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!5!10/11/2006-13:43:26:: i INFO: Catalog SQL Server Edition = Enterprise
w3wp!webserver!5!11/10/2006-13:43:34:: i INFO: Reporting Web Server stopped

 

Does anyone have any idea about what happends ? Any suggestions maybe about anything I should try ?

Thanks very much in advance.

[edit] I just installed a few minutes ago the service pack 1 for SQL Server 2005 and Reporting services, but obviously it doesn't change anything to my problem. [/edit]

View 4 Replies View Related

An Internal Error Occurred On The Report Server. See The Error Log For More Details. (rsInternalError)

Jun 14, 2007

An internal error occurred on the report server. See the error log for more details. (rsInternalError) - This is the error I get when I try to edit a subcription then click finish.Where do I start in solving this?, heres the log -<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.3042.00</Product>
<Locale>en-US</Locale>
<TimeZone>GMT Daylight Time</TimeZone>
<Path>C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFilesReportServerWebApp__06_14_2007_12_02_20.log</Path>
<SystemName>MCSCITRIX</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing ReportBuilderTrustLevel to '0' as specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing ProcessRecycleOptions to default value of '0' because it was not specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing WatsonFlags to default value of '1064' because it was not specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing WatsonDumpOnExceptions to default value of 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' because it was not specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to default value of 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' because it was not specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing SecureConnectionLevel to default value of '1' because it was not specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.
w3wp!ui!5!14/06/2007-12:06:09:: e ERROR: System.Web.Services.Protocols.SoapException: An internal error occurred on the report server. See the error log for more details. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.Data.SqlClient.SqlException: Only members of sysadmin role are allowed to update or delete jobs owned by a different login.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Library.SqlAgentScheduler.DeleteTask(Guid id)
at Microsoft.ReportingServices.Library.SqlAgentScheduler.UpdateTask(Task task)
at Microsoft.ReportingServices.Library.SchedulingDBInterface.UpdateTaskProperties(Task task, Boolean updateSqlAgentSchedule)
at Microsoft.ReportingServices.Library.TimedSubscriptionHandler.ValidateSubscriptionData(Subscription subscription, String subscriptionData, UserContext userContext)
at Microsoft.ReportingServices.Library.SubscriptionManager.ValidateSubscriptionData(Subscription subscription, String eventType, String subscriptionData)
at Microsoft.ReportingServices.Library.SubscriptionManager.SetSubscriptionProperties(Guid id, String eventType, String matchData, ExtensionSettings extensionSettings, String description, ParameterValueOrFieldReference[] parameters, DataRetrievalPlan dataSettings)
at Microsoft.ReportingServices.Library.SetSubscriptionPropertiesAction.PerformActionNow()
at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.SetSubscriptionProperties(String SubscriptionID, ExtensionSettings ExtensionSettings, Boolean isDataDriven, DataRetrievalPlan DataRetrievalPlan, String Description, String EventType, String MatchData, ParameterValueOrFieldReference[] Parameters)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.SetSubscriptionProperties(String SubscriptionID, ExtensionSettings ExtensionSettings, Boolean isDataDriven, DataRetrievalPlan DataRetrievalPlan, String Description, String EventType, String MatchData, ParameterValueOrFieldReference[] Parameters)
at Microsoft.ReportingServices.WebServer.ReportingService2005.SetDataDrivenSubscriptionProperties(String DataDrivenSubscriptionID, ExtensionSettings ExtensionSettings, DataRetrievalPlan DataRetrievalPlan, String Description, String EventType, String MatchData, ParameterValueOrFieldReference[] Parameters)
w3wp!ui!5!14/06/2007-12:06:09:: e ERROR: HTTP status code --> 200
-------Details--------
System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: An internal error occurred on the report server. See the error log for more details. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.Data.SqlClient.SqlException: Only members of sysadmin role are allowed to update or delete jobs owned by a different login.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Library.SqlAgentScheduler.DeleteTask(Guid id)
at Microsoft.ReportingServices.Library.SqlAgentScheduler.UpdateTask(Task task)
at Microsoft.ReportingServices.Library.SchedulingDBInterface.UpdateTaskProperties(Task task, Boolean updateSqlAgentSchedule)
at Microsoft.ReportingServices.Library.TimedSubscriptionHandler.ValidateSubscriptionData(Subscription subscription, String subscriptionData, UserContext userContext)
at Microsoft.ReportingServices.Library.SubscriptionManager.ValidateSubscriptionData(Subscription subscription, String eventType, String subscriptionData)
at Microsoft.ReportingServices.Library.SubscriptionManager.SetSubscriptionProperties(Guid id, String eventType, String matchData, ExtensionSettings extensionSettings, String description, ParameterValueOrFieldReference[] parameters, DataRetrievalPlan dataSettings)
at Microsoft.ReportingServices.Library.SetSubscriptionPropertiesAction.PerformActionNow()
at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.SetSubscriptionProperties(String SubscriptionID, ExtensionSettings ExtensionSettings, Boolean isDataDriven, DataRetrievalPlan DataRetrievalPlan, String Description, String EventType, String MatchData, ParameterValueOrFieldReference[] Parameters)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.SetSubscriptionProperties(String SubscriptionID, ExtensionSettings ExtensionSettings, Boolean isDataDriven, DataRetrievalPlan DataRetrievalPlan, String Description, String EventType, String MatchData, ParameterValueOrFieldReference[] Parameters)
at Microsoft.ReportingServices.WebServer.ReportingService2005.SetDataDrivenSubscriptionProperties(String DataDrivenSubscriptionID, ExtensionSettings ExtensionSettings, DataRetrievalPlan DataRetrievalPlan, String Description, String EventType, String MatchData, ParameterValueOrFieldReference[] Parameters)

at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)

at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

at Microsoft.SqlServer.ReportingServices2005.ReportingService2005.SetDataDrivenSubscriptionProperties(String DataDrivenSubscriptionID, ExtensionSettings ExtensionSettings, DataRetrievalPlan DataRetrievalPlan, String Description, String EventType, String MatchData, ParameterValueOrFieldReference[] Parameters)

at Microsoft.SqlServer.ReportingServices2005.RSConnection.SetDataDrivenSubscriptionProperties(String DataDrivenSubscriptionID, ExtensionSettings ExtensionSettings, DataRetrievalPlan DataRetrievalPlan, String Description, String EventType, String MatchData, ParameterValueOrFieldReference[] Parameters)

at Microsoft.ReportingServices.UI.DataDrivenSubscription.Save()

at Microsoft.ReportingServices.UI.DataDrivenPropertiesControl.Buttons_FinishClick(Object sender, EventArgs args)

at Microsoft.ReportingServices.UI.WizardButtons.OnFinishedClicked(EventArgs args)

at Microsoft.ReportingServices.UI.WizardButtons.FinishButton_Click(Object sender, EventArgs args)

at System.Web.UI.WebControls.Button.OnClick(EventArgs e)

at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)

at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)

at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)

at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!5!14/06/2007-12:06:09:: 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)
w3wp!ui!b!6/14/2007-12:08:23:: e ERROR: System.Web.Services.Protocols.SoapException: An internal error occurred on the report server. See the error log for more details. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.Data.SqlClient.SqlException: Only members of sysadmin role are allowed to update or delete jobs owned by a different login.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Library.SqlAgentScheduler.DeleteTask(Guid id)
at Microsoft.ReportingServices.Library.SqlAgentScheduler.UpdateTask(Task task)
at Microsoft.ReportingServices.Library.SchedulingDBInterface.UpdateTaskProperties(Task task, Boolean updateSqlAgentSchedule)
at Microsoft.ReportingServices.Library.TimedSubscriptionHandler.ValidateSubscriptionData(Subscription subscription, String subscriptionData, UserContext userContext)
at Microsoft.ReportingServices.Library.SubscriptionManager.ValidateSubscriptionData(Subscription subscription, String eventType, String subscriptionData)
at Microsoft.ReportingServices.Library.SubscriptionManager.SetSubscriptionProperties(Guid id, String eventType, String matchData, ExtensionSettings extensionSettings, String description, ParameterValueOrFieldReference[] parameters, DataRetrievalPlan dataSettings)
at Microsoft.ReportingServices.Library.SetSubscriptionPropertiesAction.PerformActionNow()
at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.SetSubscriptionProperties(String SubscriptionID, ExtensionSettings ExtensionSettings, Boolean isDataDriven, DataRetrievalPlan DataRetrievalPlan, String Description, String EventType, String MatchData, ParameterValueOrFieldReference[] Parameters)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.SetSubscriptionProperties(String SubscriptionID, ExtensionSettings ExtensionSettings, Boolean isDataDriven, DataRetrievalPlan DataRetrievalPlan, String Description, String EventType, String MatchData, ParameterValueOrFieldReference[] Parameters)
at Microsoft.ReportingServices.WebServer.ReportingService2005.SetDataDrivenSubscriptionProperties(String DataDrivenSubscriptionID, ExtensionSettings ExtensionSettings, DataRetrievalPlan DataRetrievalPlan, String Description, String EventType, String MatchData, ParameterValueOrFieldReference[] Parameters)
w3wp!ui!b!6/14/2007-12:08:23:: e ERROR: HTTP status code --> 200
-------Details--------

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved